From bf06b8dea3474f7975349570a8ed4f35f582367c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 28 九月 2022 11:08:29 +0800
Subject: [PATCH] 1
---
src/main/resources/mybatis.xml | 22 ++++++++++++++++++++++
src/main/resources/mapper/data/DictMapper.xml | 12 ++++++------
src/main/resources/application.yml | 3 ++-
3 files changed, 30 insertions(+), 7 deletions(-)
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 7fff0f5..06fe812 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -42,7 +42,8 @@
date-format: yyyy-MM-dd HH:mm:ss
mybatis:
- type-aliases-package: com.terra.land.mapper
+ type-aliases-package: com.lf.server.mapper
+ config-location: classpath:mybatis.xml
mapper-locations: classpath:mapper/**/*.xml
logging:
diff --git a/src/main/resources/mapper/data/DictMapper.xml b/src/main/resources/mapper/data/DictMapper.xml
index 6705921..96406e5 100644
--- a/src/main/resources/mapper/data/DictMapper.xml
+++ b/src/main/resources/mapper/data/DictMapper.xml
@@ -1,7 +1,7 @@
<?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.lf.server.mapper.data.DictMapper">
- <resultMap id="resultMap" type="com.lf.server.entity.data.DictEntity">
+ <!--<resultMap id="resultMap" type="com.lf.server.entity.data.DictEntity">
<id property="id" column="id"></id>
<result property="tabDesc" column="tab_desc"></result>
<result property="orderNum" column="order_num"></result>
@@ -9,7 +9,7 @@
<result property="createTime" column="create_time"></result>
<result property="updateUser" column="update_user"></result>
<result property="updateTime" column="update_time"></result>
- </resultMap>
+ </resultMap>-->
<!-- 缁熻琛屾暟 -->
<select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String">
@@ -22,7 +22,7 @@
</select>
<!-- 鍒嗛〉鏌ヨ -->
- <select id="selectByPage" resultMap="resultMap" resultType="com.lf.server.entity.data.DictEntity">
+ <select id="selectByPage" resultType="com.lf.server.entity.data.DictEntity">
select * from lf.sys_dict
<where>
<if test="tab != null">
@@ -33,15 +33,15 @@
limit #{limit} offset #{offset}
</select>
- <select id="selectDictTab" resultMap="resultMap" resultType="com.lf.server.entity.data.DictEntity">
+ <select id="selectDictTab" resultType="com.lf.server.entity.data.DictEntity">
select Distinct tab,tab_desc from lf.sys_dict;
</select>
- <select id="selectDictAll" resultMap="resultMap" resultType="com.lf.server.entity.data.DictEntity">
+ <select id="selectDictAll" resultType="com.lf.server.entity.data.DictEntity">
select * from lf.sys_dict
</select>
- <select id="selectDict" resultMap="resultMap" resultType="com.lf.server.entity.data.DictEntity">
+ <select id="selectDict" resultType="com.lf.server.entity.data.DictEntity">
select * from lf.sys_dict where id = #{id}
</select>
diff --git a/src/main/resources/mybatis.xml b/src/main/resources/mybatis.xml
new file mode 100644
index 0000000..be8d857
--- /dev/null
+++ b/src/main/resources/mybatis.xml
@@ -0,0 +1,22 @@
+<?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>
+ <settings>
+ <!-- 鍏佽 JDBC 鏀寔鑷姩鐢熸垚涓婚敭 -->
+ <setting name="useGeneratedKeys" value="false"/>
+ <!-- 鎵撳嵃sql鏃ュ織 LOG4J -->
+ <setting name="logImpl" value="STDOUT_LOGGING" />
+ <!-- 涓虹┖鐨勫瓧娈垫槸鍚﹁緭鍑哄埌Map -->
+ <setting name="callSettersOnNulls" value="true"/>
+ <!-- 浼犲叆null绌哄�兼椂 -->
+ <setting name="jdbcTypeForNull" value="NULL"/>
+ <!-- 鏄惁寮�鍚嚜鍔ㄩ┘宄板懡鍚嶈鍒欙紙camel case锛夋槧灏勶紝鍗充粠缁忓吀鏁版嵁搴撳垪鍚� A_COLUMN 鍒扮粡鍏�
+Java 灞炴�у悕 aColumn 鐨勭被浼兼槧灏勩�� -->
+ <setting name="mapUnderscoreToCamelCase" value="true"/>
+ </settings>
+ <typeAliases>
+ <package name="com.lf.server.entity"/>
+ </typeAliases>
+</configuration>
\ No newline at end of file
--
Gitblit v1.9.3