mybatis 自定义类型处理器

package tk.mybatis.simple.type;

public enum Enabled {
   tow(2),//测试
   enabled(1), //启用
   disabled(0);//禁用
   
   private final int value;

   private Enabled(int value) {
      this.value = value;
   }

   public int getValue() {
      return value;
   }
}

 

 

 

package tk.mybatis.simple.type;

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

import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;

/**
 * Enabled 类型处理器
 */
public class EnabledTypeHandler implements TypeHandler<Enabled> {


   private final Map<Integer, Enabled> enabledMap = new HashMap<Integer, Enabled>();

   public EnabledTypeHandler() {
      for(Enabled enabled : Enabled.values()){
         enabledMap.put(enabled.getValue(), enabled);
      }
   }

   public EnabledTypeHandler(Class<?> type) {
      this();
   }

   @Override
   public void setParameter(PreparedStatement ps, int i, Enabled parameter, JdbcType jdbcType) throws SQLException {
      ps.setInt(i, parameter.getValue());
   }

   @Override
   public Enabled getResult(ResultSet rs, String columnName) throws SQLException {
      Integer value = rs.getInt(columnName);
      return enabledMap.get(value);
   }

   @Override
   public Enabled getResult(ResultSet rs, int columnIndex) throws SQLException {
      Integer value = rs.getInt(columnIndex);
      return enabledMap.get(value);
   }

   @Override
   public Enabled getResult(CallableStatement cs, int columnIndex) throws SQLException {
      Integer value = cs.getInt(columnIndex);
      return enabledMap.get(value);
   }
}