mybatis 枚举类型处理器

1、在mybatis-config.xml核心文件中配置，EnumOrdinalTypeHandler将会把枚举的序号存入数据库，EnumTypeHandler将会把枚举名存入数据库，按己所需配置

<typeHandlers>
       <typeHandler handler="org.apache.ibatis.type.EnumOrdinalTypeHandler" javaType="org.jgs1904.enums.SexEnum" />
</typeHandlers>

2、实体

package org.jgs1904.entity;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.jgs1904.enums.SexEnum;

import java.io.Serializable;
import java.util.Date;

/**
 * @ClassName org.jgs1904.entity.Student
 * @Description 学生实体类
 * @Author RenYuWen
 * @Since 2020/4/9 10:50
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class Student implements Serializable {

    private Long id;

    private String name;

	// 性别枚举
    private SexEnum sex;

    private Date birthday;

    private Date createTime;

    private Classes classes;
}

3、性别枚举

package org.jgs1904.enums;

/**
 * @ClassName SexEnum
 * @Description 性别枚举
 * @Author RenYuWen
 * @Since 2020/4/10 11:14
 */
public enum SexEnum {

    OTHER,MAIL,FEMAIL;

}

4、将实体数据存入数据库

 @Test
    public void insertTest() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();

        Student student = Student.builder().name("ccc").sex(SexEnum.FEMAIL).birthday(new Date()).createTime(new Date()).build();

        int result = sqlSession.getMapper(StudentMapper.class).insert(student);

        sqlSession.commit();

        if (result != 0) {
            System.out.println("插入成功！返回的id为：" + student.getId());
        } else {
            System.out.println("插入失败！");
        }

        sqlSession.close();
    }

5.数据库截图