package com.xc.util.typehandler;

import com.xc.enumerate.SexEnum;

import org.apache.ibatis.type.JdbcType;

import org.apache.ibatis.type.MappedJdbcTypes;

import org.apache.ibatis.type.MappedTypes;

import org.apache.ibatis.type.TypeHandler;

import java.sql.CallableStatement;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

@MappedTypes(SexEnum.class)

@MappedJdbcTypes(JdbcType.INTEGER)

public class SexEnumTypeHandler implements TypeHandler<SexEnum> {

    @Override

    public void setParameter(PreparedStatement ps, int i, SexEnum parameter, JdbcType jdbcType) throws SQLException {

        ps.setInt(i, parameter.getId());

    }

    @Override

    public SexEnum getResult(ResultSet rs, String columnName) throws SQLException {

        int id = rs.getInt(columnName);

        return SexEnum.getSexById(id);

    }

    @Override

    public SexEnum getResult(ResultSet rs, int columnIndex) throws SQLException {

        int id = rs.getInt(columnIndex);

        return SexEnum.getSexById(id);

    }

    @Override

    public SexEnum getResult(CallableStatement cs, int columnIndex) throws SQLException {

        int id = cs.getInt(columnIndex);

        return SexEnum.getSexById(id);

    }

}

package com.xc.enumerate;

public enum SexEnum {

    MALE(1, "男"), FEMALE(0, "女");

    private int id;

    private String name;

    SexEnum(int id, String name) {

        this.id = id;

        this.name = name;

    }

    public static SexEnum getSexById(int id) {

        for (SexEnum sex : SexEnum.values()) {

            if (sex.getId() == id) {

                return sex;

            }

        }

        return null;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

}