步驟1:實(shí)現(xiàn)TypeHandler接口
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.MappedJdbcTypes;
import org.apache.ibatis.type.MappedTypes;
import org.apache.ibatis.type.TypeHandler;
/**
* @author
* java中的boolean和jdbc中的char之間轉(zhuǎn)換;true-Y;false-N
*/
//方式一：
@MappedJdbcTypes(JdbcType.CHAR)
@MappedTypes(Boolean.class)
public class BooleanTypeHandler implements TypeHandler {
/* (non-Javadoc)
* @see org.apache.ibatis.type.TypeHandler#getResult(java.sql.ResultSet, java.lang.String)
*/
@Override
public Object getResult(ResultSet resultSet, String columnLabel) throws SQLException {
String str = resultSet.getString(columnLabel);
Boolean rt = Boolean.FALSE;
if (str.equalsIgnoreCase("Y")){
rt = Boolean.TRUE;
}
return rt;
}
@Override
public Object getResult(ResultSet resultSet, int columnIndex) throws SQLException {
String str = resultSet.getString(columnIndex);
Boolean rt = Boolean.FALSE;
if (str.equalsIgnoreCase("Y")){
rt = Boolean.TRUE;
}
return rt;
}
/* (non-Javadoc)
* @see org.apache.ibatis.type.TypeHandler#getResult(java.sql.CallableStatement, int)
*/
@Override
public Object getResult(CallableStatement arg0, int arg1)
throws SQLException {
Boolean b = arg0.getBoolean(arg1);
return b == true ? "Y" : "N";
}
/* (non-Javadoc)
* @see org.apache.ibatis.type.TypeHandler#setParameter(java.sql.PreparedStatement, int, java.lang.Object, org.apache.ibatis.type.JdbcType)
*/
@Override
public void setParameter(PreparedStatement arg0, int arg1, Object arg2,
JdbcType arg3) throws SQLException {
Boolean b = (Boolean) arg2;
String value = (Boolean) b == true ? "Y" : "N";
arg0.setString(arg1, value);
}
}
步驟2:在Mybatis配置中注冊(cè)該TypeHandler
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:dao/mapper/*.xml"></property>
<property name="typeHandlers" >
<array>
<bean class="com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler" />
</array>
</property>
<property name="plugins">
<array>
<bean class="com.sankuai.travel.csc.test.dao.interceptor.SqlMonitorInterceptor" />
</array>
</property>
</bean>
步驟3:在映射配置文件中使用該TypeHander（如果第一步使用了注解，此處可以省略）
3.1在resultMap的定義中對(duì)對(duì)應(yīng)列定義typeHandler
<resultMap id="BaseResultMap" type="com.sankuai.travel.csc.test.dao.domain.CategoryDO" >
<id column="id" property="id" jdbcType="INTEGER" />
<result column="category_type" property="categoryType" jdbcType="INTEGER" />
<result column="category_name" property="categoryName" jdbcType="VARCHAR" />
<result column="allocate_time" property="allocateTime" jdbcType="INTEGER" />
<result column="promise_time" property="promiseTime" jdbcType="INTEGER" />
<result column="last_operator" property="lastOperator" jdbcType="VARCHAR" />
<result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
<!--寫(xiě)在這里豺裆，僅對(duì)select語(yǔ)句有效斧蜕，typeHandler="com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler" -->
<result column="is_cancel" property="isCancel" jdbcType="CHAR" typeHandler="com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler"/>
<result column="status1" property="status1" jdbcType="CHAR" />
<result column="status2" property="status2" jdbcType="CHAR" />
<result column="phone_list" property="phoneList" jdbcType="VARCHAR" />
<result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
</resultMap>
這里只能是在select的時(shí)候才會(huì)使用自定義的TypeHandler處理對(duì)應(yīng)的映射關(guān)系，如果要在insert或者update時(shí)使用則需要在sql定義中添加相應(yīng)的內(nèi)容
3.2在resultMap的定義中對(duì)對(duì)應(yīng)列定義typeHandler
<insert id="insert" parameterType="com.sankuai.travel.csc.test.dao.domain.CategoryDO" >
<selectKey resultType="java.lang.Integer" keyProperty="id" order="AFTER" >
SELECT LAST_INSERT_ID()
</selectKey>
insert into hotel_order_category (category_type, category_name, allocate_time,
promise_time, last_operator, update_time,
is_cancel, status1, status2,
phone_list, create_time)
values (#{categoryType,jdbcType=INTEGER}, #{categoryName,jdbcType=VARCHAR}, #{allocateTime,jdbcType=INTEGER},
#{promiseTime,jdbcType=INTEGER}, #{lastOperator,jdbcType=VARCHAR}, #{updateTime,jdbcType=TIMESTAMP},
<!--寫(xiě)在這里蛇数，僅對(duì)insert有效挪钓，注意，沒(méi)有雙引號(hào)： typeHandler=com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler -->
#{isCancel,jdbcType=CHAR,typeHandler=com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler},
#{status1,jdbcType=CHAR}, #{status2,jdbcType=CHAR},
#{phoneList,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP})
</insert>
＃mybatis-enumtypehandler和enumordinaltypehandler的區(qū)別
mybatis對(duì)枚舉類(lèi)型提供了兩種類(lèi)型支持：EnumTypeHandler和EnumOrdinalTypeHandler耳舅。
- EnumTypeHandler是mybatis默認(rèn)的枚舉類(lèi)型轉(zhuǎn)換器碌上，如果pojo類(lèi)中使用了枚舉類(lèi)型，而配置文件沒(méi)有指定類(lèi)型轉(zhuǎn)換類(lèi)，mybatis將使用EnumTypeHandler處理枚舉屬性馏予。EnumTypeHandler的將把枚舉類(lèi)的name進(jìn)行存儲(chǔ)天梧，枚舉類(lèi)的name即枚舉類(lèi)名。參考：http://mybatis.github.io/mybatis-3/zh/configuration.html
- EnumOrdinalTypeHandler是mybatis提供的另一種轉(zhuǎn)換器吗蚌，顧名思義這個(gè)轉(zhuǎn)換類(lèi)使用了枚舉類(lèi)的ordinal屬性作為數(shù)據(jù)庫(kù)存儲(chǔ)信息腿倚，由于ordinal屬性是int類(lèi)型的，按照官網(wǎng)的說(shuō)明數(shù)據(jù)庫(kù)中對(duì)應(yīng)資源應(yīng)該是int或double類(lèi)型的蚯妇，但是個(gè)人測(cè)試過(guò)程中MYSQL的varchar字段也可以存儲(chǔ)敷燎。
- 總結(jié)：EnumTypeHandler和EnumOrdinalTypeHandler的區(qū)別主要是數(shù)據(jù)庫(kù)中存儲(chǔ)字段的類(lèi)型差別，由于EnumOrdinalTypeHandler使用枚舉類(lèi)型的ordinal作為存儲(chǔ)箩言，所以必須使用數(shù)字類(lèi)型字段存儲(chǔ)硬贯。
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:dao/mapper/*.xml"></property>
<property name="typeHandlers" >
<array>
<bean class="com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler" />
<bean class="com.sankuai.travel.csc.test.dao.typehandler.StringArrayTypeHandler" />
<!--不需要EnumTypeHandler，默認(rèn)包含 -->
<bean class="org.apache.ibatis.type.EnumTypeHandler" >
<constructor-arg name="type" value="com.sankuai.travel.csc.test.enums.SimpleStatusEnum" />
</bean>
<!--需要EnumOrdinalTypeHandler陨收，默認(rèn)包含 -->
<bean class="org.apache.ibatis.type.EnumOrdinalTypeHandler" >
<constructor-arg name="type" value="com.sankuai.travel.csc.test.enums.SimpleStatusEnum" />
</bean>
</array>
</property>
<property name="plugins">
<array>
<bean class="com.sankuai.travel.csc.test.dao.interceptor.SqlMonitorInterceptor" />
</array>
</property>
</bean>
<resultMap id="BaseResultMap" type="com.sankuai.travel.csc.test.dao.domain.CategoryDO" >
<id column="id" property="id" jdbcType="INTEGER" />
<result column="category_type" property="categoryType" jdbcType="INTEGER" />
<result column="category_name" property="categoryName" jdbcType="VARCHAR" />
<result column="allocate_time" property="allocateTime" jdbcType="INTEGER" />
<result column="promise_time" property="promiseTime" jdbcType="INTEGER" />
<result column="last_operator" property="lastOperator" jdbcType="VARCHAR" />
<result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
<!--方式二：寫(xiě)在這里饭豹，僅對(duì)select語(yǔ)句有效，typeHandler="com.sankuai.travel.csc.test.dao.typehandler.BooleanTypeHandler" -->
<result column="is_cancel" property="isCancel" jdbcType="CHAR" />
<!--EnumTypeHandler默認(rèn)處理類(lèi)务漩，不需要配置 -->
<result column="status1" property="status1" jdbcType="CHAR" />
<!--EnumOrdinalTypeHandler需要單獨(dú)配置 -->
<result column="status2" property="status2" jdbcType="CHAR" typeHandler="org.apache.ibatis.type.EnumOrdinalTypeHandler" />
<result column="phone_list" property="phoneList" jdbcType="VARCHAR" />
<result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
</resultMap>
參考文章
https://my.oschina.net/amoshuang/blog/134199
mybatis-enumtypehandler和enumordinaltypehandler的區(qū)別
