From 50240b4e393f0792609e3843c98735fbe5fce82c Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期二, 30 五月 2023 10:32:08 +0800
Subject: [PATCH] 移除手动配置mybatis下划线转驼峰
---
src/main/java/com/genersoft/iot/vmp/conf/MybatisConfig.java | 36 ++++++++++++++++++++++++++++++++++++
doc/_content/introduction/config.md | 8 ++------
src/main/java/com/genersoft/iot/vmp/conf/UserSetting.java | 9 +++++++++
src/main/resources/all-application.yml | 2 ++
4 files changed, 49 insertions(+), 6 deletions(-)
diff --git a/doc/_content/introduction/config.md b/doc/_content/introduction/config.md
index 26fa80c..9e8ac0f 100644
--- a/doc/_content/introduction/config.md
+++ b/doc/_content/introduction/config.md
@@ -58,9 +58,7 @@
url: jdbc:postgresql://127.0.0.1:3306/wvp?useUnicode=true&characterEncoding=UTF8&rewriteBatchedStatements=true&serverTimezone=PRC&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true
username: root
password: 12345678
-mybatis:
- configuration:
- map-underscore-to-camel-case: true
+
pagehelper:
helper-dialect: postgresql
```
@@ -74,9 +72,7 @@
url: jdbc:kingbase8://127.0.0.1:3306/wvp?useUnicode=true&characterEncoding=utf8
username: root
password: 12345678
-mybatis:
- configuration:
- map-underscore-to-camel-case: true
+
pagehelper:
helper-dialect: postgresql
```
diff --git a/src/main/java/com/genersoft/iot/vmp/conf/MybatisConfig.java b/src/main/java/com/genersoft/iot/vmp/conf/MybatisConfig.java
new file mode 100644
index 0000000..03ef099
--- /dev/null
+++ b/src/main/java/com/genersoft/iot/vmp/conf/MybatisConfig.java
@@ -0,0 +1,36 @@
+package com.genersoft.iot.vmp.conf;
+
+import org.apache.ibatis.logging.stdout.StdOutImpl;
+import org.apache.ibatis.session.SqlSessionFactory;
+import org.mybatis.spring.SqlSessionFactoryBean;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.core.annotation.Order;
+
+import javax.sql.DataSource;
+
+/**
+ * 閰嶇疆mybatis
+ */
+@Configuration
+@Order(value=1)
+public class MybatisConfig {
+
+ @Autowired
+ private UserSetting userSetting;
+
+ @Bean
+ public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
+ final SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
+ sqlSessionFactory.setDataSource(dataSource);
+ org.apache.ibatis.session.Configuration config = new org.apache.ibatis.session.Configuration();
+ if (userSetting.getSqlLog()){
+ config.setLogImpl(StdOutImpl.class);
+ }
+ config.setMapUnderscoreToCamelCase(true);
+ sqlSessionFactory.setConfiguration(config);
+ return sqlSessionFactory.getObject();
+ }
+
+}
diff --git a/src/main/java/com/genersoft/iot/vmp/conf/UserSetting.java b/src/main/java/com/genersoft/iot/vmp/conf/UserSetting.java
index 64610a6..0b35a9d 100644
--- a/src/main/java/com/genersoft/iot/vmp/conf/UserSetting.java
+++ b/src/main/java/com/genersoft/iot/vmp/conf/UserSetting.java
@@ -48,6 +48,7 @@
private Boolean syncChannelOnDeviceOnline = Boolean.FALSE;
private Boolean sipLog = Boolean.FALSE;
+ private Boolean sqlLog = Boolean.FALSE;
private Boolean sendToPlatformsWhenIdLost = Boolean.FALSE;
private Boolean refuseChannelStatusChannelFormNotify = Boolean.FALSE;
@@ -286,4 +287,12 @@
public void setUseCustomSsrcForParentInvite(Boolean useCustomSsrcForParentInvite) {
this.useCustomSsrcForParentInvite = useCustomSsrcForParentInvite;
}
+
+ public Boolean getSqlLog() {
+ return sqlLog;
+ }
+
+ public void setSqlLog(Boolean sqlLog) {
+ this.sqlLog = sqlLog;
+ }
}
diff --git a/src/main/resources/all-application.yml b/src/main/resources/all-application.yml
index 2d20edd..def2a3c 100644
--- a/src/main/resources/all-application.yml
+++ b/src/main/resources/all-application.yml
@@ -194,6 +194,8 @@
sip-use-source-ip-as-remote-address: false
# 鏄惁寮�鍚痵ip鏃ュ織
sip-log: true
+ # 鏄惁寮�鍚痵ql鏃ュ織
+ sql-log: true
# 娑堟伅閫氶亾鍔熻兘-缂哄皯鍥芥爣ID鏄惁缁欐墍鏈変笂绾у彂閫佹秷鎭�
send-to-platforms-when-id-lost: true
# 淇濇寔閫氶亾鐘舵�侊紝涓嶆帴鍙梟otify閫氶亾鐘舵�佸彉鍖栵紝 鍏煎娴峰悍骞冲彴鍙戦�侀敊璇秷鎭�
--
Gitblit v1.8.0