mybatis hashmap으로 값 가져오기.

한개의 필드의 값을 hashmap으로 가져오려고 한다.

DB 내용
key1:value1,key2:value2,key3:value3

List<String> 으로 가져온 것과 마찬가지로 typeHandler를 사용하여 처리하였다.

 

DTO

HashMap<String, Object> extraProperties;public HashMap<String, Object> getExtraProperties() {	return extraProperties;}public void setExtraProperties(HashMap<String, Object> extraProperties) {	this.extraProperties = extraProperties;}

 

mybatis resultmap

<result property="extraProperties" column="extraProperties" typeHandler="com.my.handler.StringSplitMapTypeHandler" />

 

handler

import java.sql.CallableStatement;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.HashMap;import org.apache.ibatis.type.JdbcType;import org.apache.ibatis.type.TypeHandler;import com.my.util.CommonUtil;public class StringSplitMapTypeHandler implements TypeHandler<HashMap<String,Object>> {    @Override    public void setParameter(PreparedStatement ps, int i, HashMap<String,Object> parameter, JdbcType jdbcType) throws SQLException {        if (parameter != null) {            ps.setString(i, parameter.toString());        }    }    @Override    public HashMap<String,Object> getResult(ResultSet rs, String columnName) throws SQLException {        String columnValueStr = rs.getString(columnName);        return CommonUtil.getStringSplitHashMap(columnValueStr, ",", ":");            }    @Override    public HashMap<String,Object> getResult(ResultSet rs, int columnIndex) throws SQLException {        String columnValueStr = rs.getString(columnIndex);        return CommonUtil.getStringSplitHashMap(columnValueStr, ",", ":");    }    @Override    public HashMap<String,Object> getResult(CallableStatement cs, int columnIndex) throws SQLException {        String columnValueStr = cs.getString(columnIndex);    	return CommonUtil.getStringSplitHashMap(columnValueStr, ",", ":");    }}

 

getStringSplitHashMap 코드

	public static HashMap<String,Object> getStringSplitHashMap(String targetStr, String fieldSeparator, String mapSeparator){        if (targetStr == null) return null;        String[] fields = targetStr.split(fieldSeparator);        HashMap<String,Object> returnData = new HashMap<String,Object>();         for(String str : fields){        	String[] splitStr = str.split(mapSeparator);        	if(splitStr.length < 2) continue;        	String key = splitStr[0];        	String value = splitStr[1];        	returnData.put(key, value);        }    	return returnData;	}