新版父类
查看 | 历史 | 提交 | 提交对比
fwq
2024-10-08 489682e2d163e104e621ce77a62925f6ce4e8a11
提交 | 用户 | age
826b66 1 <?xml version="1.0" encoding="UTF-8" ?>
C 2 <!DOCTYPE mapper
3 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
4 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
5 <!-- namespace:该mapper.xml映射文件的 唯一标识 -->
6 <mapper namespace="${DAOPackageName}.${entityName}Mapper">
7
8     <!-- 整个实体类修改，表字段=实体类字段-->
9     <sql id="Update_Column_All">
10         <trim prefixOverrides=",">
11             <#list fieldData.fields as item>,${item.tableName} = ${item.mybatisName}</#list>
12         </trim>
13     </sql>
14      
15     <!--  后续通过  namespace.id-->
16     <!--parameterType:输入参数的类型
17     resultType：查询返回结果值的类型  ，返回类型  -->
18     <insert id="insert" parameterType="${packageEntityName}.${entityName}">
19         <selectKey keyProperty="id" resultType="String" order="BEFORE">
20                select replace(uuid(),'-','') from dual
21         </selectKey>
22         insert into ${fieldData.tableName} (${fieldData.tableIdName}<#list fieldData.fields as item>,${item.tableName}</#list>)  values (${fieldData.entityIdData}<#list fieldData.fields as item>,${item.mybatisName}</#list>)
23     </insert>
24
25     <insert id="insertById" parameterType="${packageEntityName}.${entityName}">
26         insert into ${fieldData.tableName} (${fieldData.tableIdName}<#list fieldData.fields as item>,${item.tableName}</#list>)  values (${fieldData.entityIdData}<#list fieldData.fields as item>,${item.mybatisName}</#list>)
27     </insert>
28
29     <select id="selectList" resultType="${packageEntityName}.${entityName}" parameterType="com.hx.mybatisTool.SqlSentence" >
30         ${sqlSentence}
31     </select>
32
33     <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" >
34             ${sqlSentence}
35     </select>
36
37     <select id="selectOne" resultType="${packageEntityName}.${entityName}" parameterType="com.hx.mybatisTool.SqlSentence" >
38         ${sqlSentence}
39     </select>
40
41     <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" >
42             ${sqlSentence}
43     </select>
44
45     <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" >
46             select
47                 COUNT(*)
48             from ${fieldData.tableName}
49                 WHERE ${sqlSentence}
50     </select>
51
52     <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" >
53             ${sqlSentence}
54      </select>
55
56     <select id="selectOneByKey" resultType="${packageEntityName}.${entityName}" parameterType="java.lang.Object" >
57         select 
58             ${fieldData.tableIdName}<#list fieldData.fields as item>,${item.tableName}</#list>
59         from ${fieldData.tableName}
60         WHERE ${fieldData.tableIdName} = ${fieldData.valueData}
61     </select>
62
63     <select id="selectOneByKeyBlob" resultType="${packageEntityName}.${entityName}" parameterType="java.lang.Object" >
64         select 
65             ${fieldData.tableIdName}<#list fieldData.fields as item>,${item.tableName}</#list>
66         from ${fieldData.tableName}
67         WHERE ${fieldData.tableIdName} = ${fieldData.valueData}
68     </select>
69
70     <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence">
71         update
72             ${fieldData.tableName}
73         SET ${sqlSentence}
74     </update>
75
76     <update id="updateAll" parameterType="${packageEntityName}.${entityName}">
77         update ${fieldData.tableName}
78             SET <include refid="Update_Column_All"/>
79         WHERE ${fieldData.tableIdName} = ${fieldData.entityIdData}
80     </update>
81
82     <delete id="deleteWhere"  parameterType="com.hx.mybatisTool.SqlSentence">
83         delete from ${fieldData.tableName} WHERE ${sqlSentence}
84     </delete>
85
86     <delete id="deleteById"  parameterType="java.lang.Object">
87         delete from ${fieldData.tableName} WHERE ${fieldData.tableIdName} = ${fieldData.valueData}
88     </delete>
89     ${customData}
90 </mapper>