孙向锦 / SunvoteEducation

Blame view

resources/ftl/createFaCode/mapperMysqlTemplate.ftl 2.41 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
 
  	</sql>
  	
  	<!-- 新增-->
  	<insert id="save" parameterType="pd">
  		insert into 
  	<include refid="tableName"></include>
  		(
7db3ebeb   孙向锦   添加一些模块 
31
32
33
 
  	<#list fieldList as var>
  		${var[0]},	
  	</#list>
ad5081d3   孙向锦   初始化项目 
34
 
  		) values (
7db3ebeb   孙向锦   添加一些模块 
35
36
37
 
  	<#list fieldList as var>
  		${r"#{"}${var[0]}${r"}"},	
  	</#list>
ad5081d3   孙向锦   初始化项目 
38
39
40
41
42
43
44
45
 
  		)
  	</insert>
  	
  	<!-- 删除-->
  	<delete id="delete" parameterType="pd">
  		delete from
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
46
 
  			$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
47
48
49
50
51
52
53
54
55
56
57
58
 
  	</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   孙向锦   修改模板 
59
 
  		$ID = $ID
ad5081d3   孙向锦   初始化项目 
60
 
  		where
b980d59d   孙向锦   修改模板 
61
 
  		$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
62
63
64
65
66
67
68
69
70
 
  	</update>
  	
  	<!-- 通过ID获取数据 -->
  	<select id="findById" parameterType="pd" resultType="pd">
  		select 
  		<include refid="Field"></include>
  		from 
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
71
 
  			$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
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
102
103
104
105
 
  	</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   孙向锦   修改模板 
106
 
  			$ID in
ad5081d3   孙向锦   初始化项目 
107
108
109
110
111
112
113
 
  		<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
                   ${r"#{item}"}
  		</foreach>
  	</delete>
  	
  	<!-- fh313596790qq(青苔) -->
  </mapper>