From f3cd78cd0355259a7f08cab33df69e0ac3a6850d Mon Sep 17 00:00:00 2001
From: chenjiahe <763432473@qq.com>
Date: 星期四, 26 五月 2022 18:12:27 +0800
Subject: [PATCH] mybatis时间转化文件
---
src/main/java/com/hx/mybatis/date/handler/GenericDateHandler.java | 38 ++++++++++++++++++++++++++++++++++++++
1 files changed, 38 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/hx/mybatis/date/handler/GenericDateHandler.java b/src/main/java/com/hx/mybatis/date/handler/GenericDateHandler.java
new file mode 100644
index 0000000..187ea91
--- /dev/null
+++ b/src/main/java/com/hx/mybatis/date/handler/GenericDateHandler.java
@@ -0,0 +1,38 @@
+package com.hx.mybatis.date.handler;
+
+import org.apache.ibatis.type.BaseTypeHandler;
+import org.apache.ibatis.type.JdbcType;
+import org.apache.ibatis.type.MappedJdbcTypes;
+import org.apache.ibatis.type.MappedTypes;
+
+import java.sql.*;
+import java.time.LocalDateTime;
+
+/**
+ * @author CJH
+ * @Date 2021-01-02
+ * // @MappedTypes娉ㄨВ涓殑绫讳唬琛ㄦ杞崲鍣ㄥ彲浠ヨ嚜鍔ㄨ浆鎹负鐨刯ava瀵硅薄锛孈MappedJdbcTypes娉ㄨВ涓缃殑鏄搴旂殑jdbctype锛宮ysql鐨刯son瀵硅薄瀵瑰簲鐨刯dbctype涓篤ARCHAR銆�
+ */
+@MappedTypes(value = {LocalDateTime.class})
+@MappedJdbcTypes(value = {JdbcType.TIMESTAMP}, includeNullJdbcType = true)
+public class GenericDateHandler extends BaseTypeHandler<Timestamp> {
+
+ public GenericDateHandler() {
+ }
+
+ public void setNonNullParameter(PreparedStatement ps, int i, Timestamp parameter, JdbcType jdbcType) throws SQLException {
+ ps.setTimestamp(i, parameter);
+ }
+
+ public Timestamp getNullableResult(ResultSet rs, String columnName) throws SQLException {
+ return rs.getTimestamp(columnName);
+ }
+
+ public Timestamp getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
+ return rs.getTimestamp(columnIndex);
+ }
+
+ public Timestamp getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
+ return cs.getTimestamp(columnIndex);
+ }
+}
--
Gitblit v1.8.0