From 0925c3682cb79206c8b6b911b2ee42bb3bc1012a Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期日, 12 十一月 2023 20:33:49 +0800
Subject: [PATCH] 完善mapper.xml中的枚举类型处理handler
---
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDistrictMapper.xml | 16 ++++++++--------
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml | 8 ++++----
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml | 16 ++++++++--------
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaRoleMapper.xml | 4 ++--
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaPrivilegeMapper.xml | 3 +--
5 files changed, 23 insertions(+), 24 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml
index 3b87acc..89576a3 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml
@@ -88,7 +88,7 @@
#{phone,jdbcType=VARCHAR},
#{area,jdbcType=INTEGER},
#{color,jdbcType=VARCHAR},
- #{deleted,jdbcType=TINYINT})
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT})
</insert>
<insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoBa.BaBlock">
<!--@mbg.generated-->
@@ -136,7 +136,7 @@
#{color,jdbcType=VARCHAR},
</if>
<if test="deleted != null">
- #{deleted,jdbcType=TINYINT},
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</trim>
</insert>
@@ -160,7 +160,7 @@
color = #{color,jdbcType=VARCHAR},
</if>
<if test="deleted != null">
- color = #{deleted,jdbcType=TINYINT},
+ color = #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</set>
where id = #{id,jdbcType=BIGINT}
@@ -173,7 +173,7 @@
phone = #{phone,jdbcType=VARCHAR},
area = #{area,jdbcType=INTEGER},
color = #{color,jdbcType=VARCHAR},
- deleted = #{deleted,jdbcType=TINYINT}
+ deleted = #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT}
where id = #{id,jdbcType=BIGINT}
</update>
</mapper>
\ No newline at end of file
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDistrictMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDistrictMapper.xml
index 356b51d..2455532 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDistrictMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaDistrictMapper.xml
@@ -41,8 +41,8 @@
values (#{id,jdbcType=BIGINT},
#{supperId,jdbcType=BIGINT},
#{name,jdbcType=VARCHAR},
- #{level,jdbcType=TINYINT},
- #{deleted,jdbcType=TINYINT}
+ #{level,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT}
)
</insert>
<insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoBa.BaDistrict">
@@ -76,10 +76,10 @@
#{name,jdbcType=VARCHAR},
</if>
<if test="level != null">
- #{level,jdbcType=TINYINT},
+ #{level,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
<if test="deleted != null">
- #{deleted,jdbcType=TINYINT},
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</trim>
</insert>
@@ -94,10 +94,10 @@
supperId = #{supperId,jdbcType=BIGINT},
</if>
<if test="level != null">
- `level` = #{level,jdbcType=TINYINT},
+ `level` = #{level,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
<if test="deleted != null">
- deleted = #{deleted,jdbcType=TINYINT},
+ deleted = #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</set>
where id = #{id,jdbcType=BIGINT}
@@ -107,8 +107,8 @@
update ba_district
set supperId = #{supperId,jdbcType=BIGINT},
`name` = #{name,jdbcType=VARCHAR},
- `level` = #{level,jdbcType=TINYINT},
- deleted = #{deleted,jdbcType=TINYINT}
+ `level` = #{level,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
+ deleted = #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT}
where id = #{id,jdbcType=BIGINT}
</update>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaPrivilegeMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaPrivilegeMapper.xml
index f7cef6d..3fcaf3b 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaPrivilegeMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaPrivilegeMapper.xml
@@ -45,8 +45,7 @@
<insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoBa.BaPrivilege">
<!--@mbg.generated-->
- insert into ba_privilege (id, num, name, type
- )
+ insert into ba_privilege (<include refid="Base_Column_List" />)
values (#{id,jdbcType=BIGINT},
#{num,jdbcType=INTEGER},
#{name,jdbcType=VARCHAR},
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaRoleMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaRoleMapper.xml
index bf3f4a3..660cf0d 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaRoleMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaRoleMapper.xml
@@ -38,7 +38,7 @@
</select>
<insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoBa.BaRole">
- insert into ba_role (id, `name`, deleted)
+ insert into ba_role (<include refid="Base_Column_List" />)
values (#{id,jdbcType=BIGINT},
#{name,jdbcType=VARCHAR},
#{deleted, typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT}
@@ -66,7 +66,7 @@
#{name,jdbcType=VARCHAR},
</if>
<if test="deleted != null">
- #{deleted,jdbcType=TINYINT},
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</trim>
</insert>
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml
index 6ed6777..8ea8f06 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml
@@ -98,8 +98,8 @@
#{password,jdbcType=VARCHAR},
#{orgTag,jdbcType=VARCHAR},
#{supperAdmin,jdbcType=TINYINT},
- #{disabled,jdbcType=TINYINT},
- #{deleted,jdbcType=TINYINT}
+ #{disabled,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT}
)
</insert>
<insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoBa.BaUser">
@@ -150,10 +150,10 @@
#{supperAdmin,jdbcType=TINYINT},
</if>
<if test="disabled != null">
- #{disabled,jdbcType=TINYINT},
+ #{disabled,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
<if test="deleted != null">
- #{deleted,jdbcType=TINYINT},
+ #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</trim>
</insert>
@@ -171,10 +171,10 @@
password = #{password,jdbcType=VARCHAR},
</if>
<if test="disabled != null">
- disabled = #{disabled,jdbcType=TINYINT},
+ disabled = #{disabled,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
<if test="deleted != null">
- deleted = #{deleted,jdbcType=TINYINT},
+ deleted = #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
</if>
</set>
where id = #{id,jdbcType=BIGINT}
@@ -184,8 +184,8 @@
set `name` = #{name,jdbcType=VARCHAR},
phone = #{phone,jdbcType=VARCHAR},
password = #{password,jdbcType=VARCHAR},
- disabled = #{disabled,jdbcType=TINYINT},
- deleted = #{deleted,jdbcType=TINYINT}
+ disabled = #{disabled,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT},
+ deleted = #{deleted,typeHandler=com.dy.common.mybatis.envm.EnumCodeTypeHandler, jdbcType=TINYINT}
where id = #{id,jdbcType=BIGINT}
</update>
<update id="changePassword" >
--
Gitblit v1.8.0