孙向锦 / SunvoteEducation

Blame view

resources/ftl_backups/createFaCode/mapperMysqlTemplate.ftl 2.37 KB
Edit Raw Normal View History
ad5081d3   孙向锦   初始化项目 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
  <?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="${objectName}Mapper">
  	
  	<!--表名 -->
  	<sql id="tableName">
  		${tabletop}${objectNameUpper}
  	</sql>
  	
  	<!-- 字段 -->
  	<sql id="Field">
  	<#list fieldList as var>
  		${var[0]},	
  	</#list>
b980d59d   孙向锦   修改模板 
15
 
  		$ID
ad5081d3   孙向锦   初始化项目 
16
17
18
19
20
21
22
 
  	</sql>
  	
  	<!-- 字段值 -->
  	<sql id="FieldValue">
  	<#list fieldList as var>
  		${r"#{"}${var[0]}${r"}"},	
  	</#list>
b980d59d   孙向锦   修改模板 
23
 
  		${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
  	</sql>
  	
  	<!-- 新增-->
  	<insert id="save" parameterType="pd">
  		insert into 
  	<include refid="tableName"></include>
  		(
  	<include refid="Field"></include>
  		) values (
  	<include refid="FieldValue"></include>
  		)
  	</insert>
  	
  	<!-- 删除-->
  	<delete id="delete" parameterType="pd">
  		delete from
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
42
 
  			$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
43
44
45
46
47
48
49
50
51
52
53
54
 
  	</delete>
  	
  	<!-- 修改 -->
  	<update id="edit" parameterType="pd">
  		update
  		<include refid="tableName"></include>
  		set 
  	<#list fieldList as var>
  		<#if var[3] == "是">
  			${var[0]} = ${r"#{"}${var[0]}${r"}"},
  		</#if>
  	</#list>
b980d59d   孙向锦   修改模板 
55
 
  		$ID = $ID
ad5081d3   孙向锦   初始化项目 
56
 
  		where
b980d59d   孙向锦   修改模板 
57
 
  		$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
58
59
60
61
62
63
64
65
66
 
  	</update>
  	
  	<!-- 通过ID获取数据 -->
  	<select id="findById" parameterType="pd" resultType="pd">
  		select 
  		<include refid="Field"></include>
  		from 
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
67
 
  			$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
  	</select>
  	
  	<!-- 列表 -->
  	<select id="datalistPage" parameterType="page" resultType="pd">
  		select
  		<include refid="Field"></include>
  		from 
  		<include refid="tableName"></include>
  		where 1=1
  		<if test="pd.keywords!= null and pd.keywords != ''"><!-- 关键词检索 -->
  			and
  				(
  				<!--	根据需求自己加检索条件
  					字段1 LIKE CONCAT(CONCAT('%', ${r"#{pd.keywords})"},'%')
  					 or 
  					字段2 LIKE CONCAT(CONCAT('%', ${r"#{pd.keywords})"},'%') 
  				-->
  				)
  		</if>
  	</select>
  	
  	<!-- 列表(全部) -->
  	<select id="listAll" parameterType="pd" resultType="pd">
  		select
  		<include refid="Field"></include>
  		from 
  		<include refid="tableName"></include>
  	</select>
  	
  	<!-- 批量删除 -->
  	<delete id="deleteAll" parameterType="String">
  		delete from
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
102
 
  			$ID in
ad5081d3   孙向锦   初始化项目 
103
104
105
106
107
108
109
 
  		<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
                   ${r"#{item}"}
  		</foreach>
  	</delete>
  	
  	<!-- fh313596790qq(青苔) -->
  </mapper>