孙向锦 / SunvoteEducation

Blame view

resources/ftl/createSoCode/mapperMysqlTemplate.ftl 2.79 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
23
 
  		${faobject}_ID
  	</sql>
  	
  	<!-- 字段值 -->
  	<sql id="FieldValue">
  	<#list fieldList as var>
  		${r"#{"}${var[0]}${r"}"},	
  	</#list>
b980d59d   孙向锦   修改模板 
24
 
  		${r"#{"}$ID${r"}"},
ad5081d3   孙向锦   初始化项目 
25
26
27
28
29
30
31
32
 
  		${r"#{"}${faobject}_ID${r"}"}
  	</sql>
  	
  	<!-- 新增-->
  	<insert id="save" parameterType="pd">
  		insert into 
  	<include refid="tableName"></include>
  		(
7db3ebeb   孙向锦   添加一些模块 
33
34
35
36
 
  		<#list fieldList as var>
  			${var[0]},	
  		</#list>
  			${faobject}_ID
ad5081d3   孙向锦   初始化项目 
37
 
  		) values (
7db3ebeb   孙向锦   添加一些模块 
38
39
40
41
 
  		<#list fieldList as var>
  			${r"#{"}${var[0]}${r"}"},	
  		</#list>
  		${r"#{"}${faobject}_ID${r"}"}
ad5081d3   孙向锦   初始化项目 
42
43
44
45
46
47
48
49
 
  		)
  	</insert>
  	
  	<!-- 删除-->
  	<delete id="delete" parameterType="pd">
  		delete from
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
50
 
  			$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
51
52
53
54
55
56
57
58
59
60
61
62
 
  	</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   孙向锦   修改模板 
63
 
  		$ID = $ID
ad5081d3   孙向锦   初始化项目 
64
 
  		where
b980d59d   孙向锦   修改模板 
65
 
  		$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
66
67
68
69
70
71
72
73
74
 
  	</update>
  	
  	<!-- 通过ID获取数据 -->
  	<select id="findById" parameterType="pd" resultType="pd">
  		select 
  		<include refid="Field"></include>
  		from 
  		<include refid="tableName"></include>
  		where
b980d59d   孙向锦   修改模板 
75
 
  			$ID = ${r"#{"}$ID${r"}"}
ad5081d3   孙向锦   初始化项目 
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
106
107
108
109
110
 
  	</select>
  	
  	<!-- 列表 -->
  	<select id="datalistPage" parameterType="page" resultType="pd">
  		select
  		<include refid="Field"></include>
  		from 
  		<include refid="tableName"></include>
  		where 
  		${faobject}_ID = ${r"#{pd."}${faobject}_ID${r"}"}
  		<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   孙向锦   修改模板 
111
 
  			$ID in
ad5081d3   孙向锦   初始化项目 
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
 
  		<foreach item="item" index="index" collection="array" open="(" separator="," close=")">
                   ${r"#{item}"}
  		</foreach>
  	</delete>
  	
  	<!-- 查询明细总数 -->
  	<select id="findCount" parameterType="pd" resultType="pd">
  		select
  			count(*) zs
  		from 
  			<include refid="tableName"></include>
  		where
  			${faobject}_ID = ${r"#{"}${faobject}_ID${r"}"}
  	</select>
  	
  	<!-- fh313596790qq(青苔) -->
  </mapper>