package com.moral.mapper.type;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.MappedJdbcTypes;
import org.apache.ibatis.type.MappedTypes;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.TypeReference;

/**
 * @author fengxiang
 * @Time：2017年11月29日 上午9:38:51
 * @version 1.0
 */
@MappedJdbcTypes({JdbcType.OTHER})
@MappedTypes({Map.class})
public class AdjustValueTypeHandle extends BaseTypeHandler<Map> {

	@Override
	public void setNonNullParameter(PreparedStatement preparedStatement, int i, Map map, JdbcType jdbcType) throws SQLException {
		preparedStatement.setString(i,JSON.toJSONString(map));
	}

	@Override
	public Map getNullableResult(ResultSet resultSet, String s) throws SQLException {
		return JSON.parseObject(resultSet.getString(s),new TypeReference<Map<String,String>>(){});
	}

	@Override
	public Map getNullableResult(ResultSet resultSet, int i) throws SQLException {
		return JSON.parseObject(resultSet.getString(i),new TypeReference<Map<String,String>>(){});
	}

	@Override
	public Map getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
		return JSON.parseObject(callableStatement.getString(i),new TypeReference<Map<String,String>>(){});
	}
}