From b92caa380bb6242ae11a3606ea908c7029aaeeb6 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期一, 06 一月 2025 09:57:53 +0800
Subject: [PATCH] Handler
---
pms-parent/pms-common/src/main/java/com/dy/common/mybatis/JsonTypeHandler.java | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/pms-parent/pms-common/src/main/java/com/dy/common/mybatis/JsonTypeHandler.java b/pms-parent/pms-common/src/main/java/com/dy/common/mybatis/JsonTypeHandler.java
new file mode 100644
index 0000000..5ad5811
--- /dev/null
+++ b/pms-parent/pms-common/src/main/java/com/dy/common/mybatis/JsonTypeHandler.java
@@ -0,0 +1,35 @@
+package com.dy.common.mybatis;
+
+import cn.hutool.json.JSONObject;
+import cn.hutool.json.JSONUtil;
+import org.apache.ibatis.type.BaseTypeHandler;
+import org.apache.ibatis.type.JdbcType;
+
+import java.sql.CallableStatement;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+public class JsonTypeHandler extends BaseTypeHandler<JSONObject> {
+ @Override
+ public void setNonNullParameter(PreparedStatement ps, int i, JSONObject parameter, JdbcType jdbcType) throws SQLException {
+ ps.setString(i, parameter.toString());
+ }
+
+ @Override
+ public JSONObject getNullableResult(ResultSet rs, String columnName) throws SQLException {
+ String json = rs.getString(columnName);
+ return JSONUtil.parseObj(json);
+ }
+
+ @Override
+ public JSONObject getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
+ String json = rs.getString(columnIndex);
+ return JSONUtil.parseObj(json);
+ }
+
+ @Override
+ public JSONObject getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
+ String json = cs.getString(columnIndex);
+ return JSONUtil.parseObj(json);
+ }
+}
\ No newline at end of file
--
Gitblit v1.8.0