mybatis编写自定义类型转化器

1.导入相关的jar包坐标

  <dependencies>
        <!--mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <!---connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.25</version>
        </dependency>

    </dependencies>

2.编写相关的domain及接口类

public interface UserMapper {
    List<User> findAll();
    User find(int id);
    int add(User user);
}



import java.util.Date;

public class User {
    private Integer id;
    private String name;
    private String pwd;
    private Date birthday;

    public User(Integer id, String name, String pwd, Date birthday) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
        this.birthday = birthday;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                ", birthday=" + birthday +
                '}';
    }
}

3.编写映射文件

<?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.Dao.UserMapper">
    <sql id="base">
        select * from user
    </sql>
    <select id="findAll" resultType="user">
        <include refid="base"></include>
            where 1=1
    </select>
    <select id="find" resultType="user" parameterType="int">
        <include refid="base"></include>
        where id=#{id}
    </select>
    <insert id="add" useGeneratedKeys="true" parameterType="user" keyProperty="id">
        insert into user values(#{id},#{name},#{pwd},#{birthday})
    </insert>
</mapper>

4.自定义类型转换器

public class MyTypeHandler extends BaseTypeHandler<Date> {
    @Override
    public void setNonNullParameter(PreparedStatement preparedStatement, int i, Date date, JdbcType jdbcType) throws SQLException {
        long time=date.getTime();
        preparedStatement.setLong(i,time);
    }

    @Override
    public Date getNullableResult(ResultSet resultSet, String s) throws SQLException {
        long time=resultSet.getLong(s);
        Date date=null;
        if(time!=0) {
            date = new Date(time);
        }
        return date;
    }

    @Override
    public Date getNullableResult(ResultSet resultSet, int i) throws SQLException {
        long time=resultSet.getLong(i);
        Date date=null;
        if(time!=0) {
            date = new Date(time);
        }
        return date;
    }

    @Override
    public Date getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
       long time= callableStatement.getLong(i);
        Date date=null;
        if(time!=0) {
            date = new Date(time);
        }
       return date;
    }
}

5.编写核心文件并注册自定义类型转换器

<?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="jdbc.properties"/>
    <typeAliases>
        <typeAlias type="com.domain.User" alias="user"/>
    </typeAliases>
    <typeHandlers>
        <typeHandler handler="com.MyTypeHandler" />
    </typeHandlers>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.user}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

6.编写测试类

public class Test {
    public static void main(String[] args) throws IOException {
        InputStream stream= Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(stream);
        SqlSession sqlSession=factory.openSession(true);
        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        Date date=new Date();
        User user=new User(null,"陈","123456",date);
        boolean flag=mapper.add(user)==1;
        System.out.println("flag:"+flag);
        List<User> userList=mapper.findAll();
        for (User use:userList){
            System.out.println(use);
        }
        user=mapper.find(5);
        System.out.println(user);
        sqlSession.close();
    }
}