【MyBatis】typeHandler处理枚举

CREATE TABLE tbl_employee (
	id INT (11) PRIMARY KEY AUTO_INCREMENT,
	last_name VARCHAR (255),
	gender CHAR (1),
	email VARCHAR (255),
  empStatus VARCHAR(11)
);

public class Employee {
	
	private Integer id;
	private String lastName;
	private String email;
	private String gender;
	//枚举类型
	private EmpStatus empStatus=EmpStatus.LOGOUT;

public enum EmpStatus {
	LOGIN,LOGOUT,REMOVE
}

public interface EmployeeMapper {
	public Long addEmp(Employee employee);
}
 

public class MyBatisTest {
	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}
	
	
	
	@Test
	public void testEnumUse(){//【测试枚举】
		EmpStatus login = EmpStatus.LOGIN; 
		System.out.println("枚举的索引："+login.ordinal());
		System.out.println("枚举的名字："+login.name());
		

	}
	
	@Test
	public void testEnum() throws IOException{
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession openSession = sqlSessionFactory.openSession();
		try{
			EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
			Employee employee = new Employee("test_enum", "enum@atguigu.com","1");
			mapper.addEmp(employee);
			System.out.println("保存成功"+employee.getId());
			openSession.commit();
			
			
		}finally{
			openSession.close();
		}
	}
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.mybatis.dao.EmployeeMapper">
		<!--public Long addEmp(Employee employee);  -->
	<insert id="addEmp" useGeneratedKeys="true" keyProperty="id">
		insert into tbl_employee(last_name,email,gender,empStatus) 
		values(#{lastName},#{email},#{gender},#{empStatus})
	</insert>
</mapper>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
 PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>


	
	<properties resource="dbconfig.properties"></properties>
	
		<typeHandlers>
		<typeHandler handler="org.apache.ibatis.type.EnumOrdinalTypeHandler" 
		javaType="com.atguigu.mybatis.bean.EmpStatus"/>
	</typeHandlers>
	
	<environments default="dev_mysql">
		<environment id="dev_mysql">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${jdbc.driver}" />
				<property name="url" value="${jdbc.url}" />
				<property name="username" value="${jdbc.username}" />
				<property name="password" value="${jdbc.password}" />
			</dataSource>
		</environment>
		
		<environment id="dev_oracle">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${orcl.driver}" />
				<property name="url" value="${orcl.url}" />
				<property name="username" value="${orcl.username}" />
				<property name="password" value="${orcl.password}" />
			</dataSource>
		</environment>
	</environments>
	
	<databaseIdProvider type="DB_VENDOR">
		<property name="MySQL" value="mysql"/>
		<property name="Oracle" value="oracle"/>
	</databaseIdProvider>
	<mappers>
		<mapper resource="EmployeeMapper.xml" />
	</mappers>
</configuration>