Mybatis自定义类型处理器

package zhang.mybatis.entities;

import com.mysql.jdbc.jdbc2.optional.CallableStatementWrapper;

/**

• 实际的开发过程中向数据库保存的是枚举的状态码
• 因此要自定义类型处理器
• @author Administrator

*/
public enum CustomerStatus {
LOGN(100,“登入”),LOGOUT(200,“登出”);

private Integer code;
private String msg;
private CustomerStatus(Integer code,String msg){
	this.code=code;
	this.msg=msg;
}
public Integer getCode() {
	return code;
}
public void setCode(Integer code) {
	this.code = code;
}
public String getMsg() {
	return msg;
}
public void setMsg(String msg) {
	this.msg = msg;
}
@SuppressWarnings("unused")
public static CustomerStatus getStatusByCode(Integer code){
	switch (code) {
	case 100:
		return CustomerStatus.LOGN;
	case 200:
		return CustomerStatus.LOGOUT;
	default:
		return CustomerStatus.LOGOUT;			
	}
}

}

<?xml version="1.0" encoding="UTF-8" ?>

<!-- 开启驼峰命名 -->
<settings>
	<setting name="mapUnderscoreToCamelCase" value="true" />
	<setting name="lazyLoadingEnabled" value="true" />
	<!-- 启用延迟加载查询的策略,在分部查询的基础上才能起作用 -->
	<setting name="mapUnderscoreToCamelCase" value="true" />
	<setting name="aggressiveLazyLoading" value="false" />

</settings>
<!--指定类型处理器在处理customerstatus的时候 -->
<typeHandlers >
	<typeHandler handler="zhang.mybatis.typehanders.MyCustomerStatusTypeHander" javaType="zhang.mybatis.entities.CustomerStatus"/>
</typeHandlers>
<plugins>
	<!-- 使用分页的插件 -->
	<plugin interceptor="com.github.pagehelper.PageHelper">
		<!-- 使用下面的方式配置参数，后面会有所有的参数介绍 -->
		<property name="dialect" value="mysql" />
	</plugin>
	<!-- 
	<plugin interceptor="zhang.mybatis.Interceptors.MyFirsterInterceptor">
		<property name="username" value="zhangyukang" />
		<property name="password" value="123456" />
	</plugin>
	 -->
</plugins>
<!-- 配置坏境 -->
<environments default="dev_mysql">
	<environment id="dev_mysql">
		<!-- 配置事务管理器 -->
		<transactionManager type="JDBC"></transactionManager>
		<!-- 配置数据源 -->
		<dataSource type="POOLED">
			<property name="driver" value="${jdbc.driverclass}" />
			<property name="url" value="${jdbc.url}" />
			<property name="username" value="${jdbc.username}" />
			<property name="password" value="${jdbc.password}" />
		</dataSource>
	</environment>
	<environment id="dev_orcle">
		<!-- 配置事务管理器 -->
		<transactionManager type="JDBC"></transactionManager>
		<!-- 配置数据源 -->
		<dataSource type="POOLED">
			<property name="driver" value="${oracle.driverclass}" />
			<property name="url" value="${oracle.url}" />
			<property name="username" value="${oracle.username}" />
			<property name="password" value="${oracle.password}" />
		</dataSource>
	</environment>
</environments>
<!-- 配置连接多种数据库 -->
<databaseIdProvider type="DB_VENDOR">
	<!-- 注意此处容易出错:原因将MySQL写成了Mysql -->
	<property name="MySQL" value="mysql" />
	<property name="SQL Server" value="sqlserver" />
	<property name="DB2" value="db2" />
	<property name="Oracle" value="oracle" />
</databaseIdProvider>

<!-- 映sql映射文件 -->
<mappers>
	<!-- 批量注册sql映射文件 -->
	<package name="zhang.mybatis.dao" />
</mappers>

在这里插入代码片