CREATE TABLE `customer` (
 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
 `customer_name` varchar(255) DEFAULT NULL COMMENT '顧客名稱',
 `gender` varchar(255) DEFAULT NULL COMMENT '性別',
 `telephone` varchar(255) DEFAULT NULL COMMENT '電話號碼',
 `register_time` timestamp NULL DEFAULT NULL COMMENT '注冊時間',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='顧客表';

public class Customer {
  // 主鍵
  private Long id;
  // 客戶姓名
  private String customer_name;
  // 性別
  private String gender;
  // 電話
  private String telephone;
  // 注冊時間
  private Long register_time;
  // 省略 set get
 } 

/**
 * @Author lsc
 * <p> 一個無聊的業務邏輯 輸入的是時間戳，到數據庫中的是 timestamp 格式 輸出的又是時間戳 </p>
 */
@MappedJdbcTypes(JdbcType.TIMESTAMP)
@MappedTypes(Long.class)
public class TimeStringHandler<T> extends BaseTypeHandler<T> {


  public void setNonNullParameter(PreparedStatement preparedStatement, int i, T t, JdbcType jdbcType) throws SQLException {
    // 將 時間戳轉為 LocalDateTime
    LocalDateTime localDateTime = LocalDateTime.ofInstant(Instant.ofEpochSecond((java.lang.Long) t), ZoneOffset.ofHours(8));
    // 參數設置
    System.out.println("業務邏輯1");
    preparedStatement.setString(i,localDateTime.toString());
  }

  public T getNullableResult(ResultSet resultSet, String s) throws SQLException {
    System.out.println("業務邏輯2");
    String time = resultSet.getString(s);
    LocalDateTime localDateTime = LocalDateTime.parse(time, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
    Long second = localDateTime.toEpochSecond(ZoneOffset.ofHours(8));
    return (T) second;
  }

  public T getNullableResult(ResultSet resultSet, int i) throws SQLException {
    System.out.println("業務邏輯3");
    String time = resultSet.getString(i);
    LocalDateTime localDateTime = LocalDateTime.parse(time, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
    Long second = localDateTime.toEpochSecond(ZoneOffset.ofHours(8));
    return (T) second;
  }

  public T getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
    System.out.println("業務邏輯4");
    String time = callableStatement.getString(i);
    LocalDateTime localDateTime = LocalDateTime.parse(time, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
    Long second = localDateTime.toEpochSecond(ZoneOffset.ofHours(8));
    return (T) second;
  }
}

public interface CustomerMapper {

  // 添加客戶
  int addCustomer(Customer customer);
  // 查詢客戶
  List<Customer> getCustomer();
}

<&#63;xml version="1.0" encoding="UTF-8" &#63;>
<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.zszxz.typehandler.mapper.CustomerMapper">

  <resultMap id="customerMap" type="customer" autoMapping="true">
    <result column="register_time" property="register_time" typeHandler="com.zszxz.typehandler.handler.TimeStringHandler"></result>
  </resultMap>

  <select id="getCustomer" resultMap="customerMap" >
    select * from `customer`
  </select>

  <insert id="addCustomer" parameterType="customer">
     insert into `customer`(
      `customer_name`,
      `gender`,
      `telephone`,
      `register_time`
     )values (
      #{customer_name},
      #{gender},
      #{telephone},
      #{register_time,javaType=Long,jdbcType=TIMESTAMP,typeHandler=com.zszxz.typehandler.handler.TimeStringHandler}
     )
  </insert>
</mapper>

/**
 * @Author lsc
 * <p> </p>
 */
@RunWith(JUnit4.class)
public class TypeHandlerTest {

  SqlSession sqlSession = null;

  // @Before 會在執行測試類之前執行該方法
  @Before
  public void before() throws IOException {
    // 資源路徑 resource目錄下
    String resource = "mybatis-config.xml";
    // 配置mybatis獲得輸入流
    InputStream inputStream = Resources.getResourceAsStream(resource);
    // 創建 SqlSessionFactory
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    //從 SqlSessionFactory 中獲取 SqlSession
    sqlSession= sqlSessionFactory.openSession();
  }

  @Test
  public void testInsert(){
    // 獲得mapper的形式
    CustomerMapper mapper = sqlSession.getMapper(CustomerMapper.class);
    Customer customer = new Customer();
    customer.setCustomer_name("知識追尋者");
    customer.setRegister_time(1580739214L);
    customer.setGender("男");
    customer.setTelephone("999");
    // 添加客戶
    mapper.addCustomer(customer);
    sqlSession.commit();
    sqlSession.close();
  }

  @Test
  public void testSelect(){
    // 獲得mapper的形式
    CustomerMapper mapper = sqlSession.getMapper(CustomerMapper.class);
    List<Customer> customerList = mapper.getCustomer();
    for (Customer customer :customerList){
      System.out.println(customer.getCustomer_name());
      System.out.println(customer.getRegister_time());
    }
    sqlSession.commit();
    sqlSession.close();
  }
}