Question

mybatis 枚举 EnumTypeHandler如何使用

Answer 1

<result property="app_ver_current" column="APP_VER_CURRENT"
typeHandler="com.andson.kb.server.enums.handler.YesNoEnumHandler" />

public class YesNoEnumHandler implements TypeHandler<YesNoEnum> {
@Override
public YesNoEnum getResult(ResultSet rs, String columnLabel) throws SQLException {
// TODO Auto-generated method stub
return YesNoEnum.valueOf(rs.getInt(columnLabel));
}
@Override
public YesNoEnum getResult(ResultSet rs, int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return YesNoEnum.valueOf(rs.getInt(columnIndex));
}
@Override
public YesNoEnum getResult(CallableStatement cs, int parameterIndex) throws SQLException {
// TODO Auto-generated method stub
return YesNoEnum.valueOf(cs.getInt(parameterIndex));
}
@Override
public void setParameter(PreparedStatement ps, int columnIndex, YesNoEnum yesNoEnum, JdbcType jdbcType)
throws SQLException {
// TODO Auto-generated method stub
ps.setInt(columnIndex, yesNoEnum.getValue());
}
}