ToB企服应用市场:ToB评测及商务社交产业平台

标题: MyBatis笔记 [打印本页]

---

作者: 不到断气不罢休    时间: 2022-9-23 22:09
标题: MyBatis笔记
MyBatis

MyBatis特性

• MyBatis 是支持定制化 SQL、存储过程以及高级映射的优秀的持久层框架
  
• MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集
  
• MyBatis可以使用简单的XML或注解用于配置和原始映射，将接口和Java的POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录
  
• MyBatis 是一个 半自动的ORM（Object Relation Mapping）框架
  

下载

下载地址


持久化层技术对比

• JDBC
  
  
  
  • SQL 夹杂在Java代码中耦合度高
    
  • 维护不易且实际开发需求中 SQL 有变化，频繁修改的情况多见
    
  • 代码冗长，开发效率低
    
  
  
• Hibernate 和 JPA
  
  
  
  • 操作简便，开发效率高
    
  • 程序中的长难复杂 SQL 需要绕过框架
    
  • 内部自动生产的 SQL，不容易做特殊优化
    
  • 基于全映射的全自动框架，大量字段的 POJO 进行部分映射时比较困难
    
  • 反射操作太多，导致数据库性能下降
    
  
  
• MyBatis
  
  
  
  • 轻量级，性能出色
    
  • SQL 和 Java 编码分开，功能边界清晰。Java代码专注业务、SQL语句专注数据
    
  • 开发效率稍逊于HIbernate，但是完全能够接受
    
  
  

开发环境

idea:2019.3.5
MySQL:8.0
MyBatis:3.5.10
Maven:3.6.1
开始写代码


1.创建Maven工程

2.配置打包方式为jar

3.引入依赖

pom.xml

1. <dependencies>
2.        
3.         <dependency>
4.                 <groupId>org.mybatis</groupId>
5.                 <artifactId>mybatis</artifactId>
6.                 <version>3.5.10</version>
7.         </dependency>
8.        
9.         <dependency>
10.                 <groupId>junit</groupId>
11.                 <artifactId>junit</artifactId>
12.                 <version>4.12</version>
13.                 <scope>test</scope>
14.         </dependency>
15.        
16.         <dependency>
17.                 <groupId>mysql</groupId>
18.                 <artifactId>mysql-connector-java</artifactId>
19.                 <version>8.0.30</version>
20.                 </dependency>
21. </dependencies>

复制代码

4.mybatis配置文件

mybatis-config.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration
3. <settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings>PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11. <settings>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
18. </settings>"http://mybatis.org/dtd/mybatis-3-config.dtd">
19. <configuration>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><environments default="development">
26. <settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><environment id="development">
34. <settings>
35. <plugins>
36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
37. </plugins>
38. <plugins>
39.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
40. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
41. </settings><plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins><transactionManager type="JDBC"/>
44. <settings>
45. <plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
51. </settings><plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><dataSource type="POOLED">
54. <settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings><settings>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins>
65. <plugins>
66.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
67. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
68. </settings><property name="driver" value="com.mysql.cj.jdbc.Driver"/>
69. <settings>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>
73. <plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
76. </settings><settings>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
83. </settings><property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
84. <settings>
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>
88. <plugins>
89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
91. </settings><settings>
92. <plugins>
93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
94. </plugins>
95. <plugins>
96.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
97. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
98. </settings><property name="username" value="root"/>
99. <settings>
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>
103. <plugins>
104.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
105. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
106. </settings><settings>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins>
110. <plugins>
111.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
112. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
113. </settings><property name="password" value="xxxxxxxxx"/>
114. <settings>
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins>
118. <plugins>
119.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
120. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
121. </settings><plugins>
122.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
123. </plugins></dataSource>
124. <settings>
125. <plugins>
126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
127. </plugins>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
131. </settings></environment>
132. <plugins>
133.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
134. </plugins></environments>
135. <plugins>
136.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
137. </plugins>
138. <plugins>
139.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
140. </plugins><mappers>
141. <settings>
142. <plugins>
143.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
144. </plugins>
145. <plugins>
146.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
147. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
148. </settings><mapper resource="mappers/UserMapper.xml"/>
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins></mappers>
152. </configuration>

复制代码

5.创建数据库建表（略）并在Java代码中创建对应实体类

Users.java

1. package com.xust.mybatis.pojo;
3. public class Users {
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>private Integer id;
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins>private String username;
10. <plugins>
11.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
12. </plugins>private String password;
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>private Integer age;
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>private String sex;
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins>private String email;
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>public Users() {
26. <plugins>
27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
28. </plugins>}
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins>public Users(Integer id, String username, String password, Integer age, String sex, String email) {
33. <settings>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
40. </settings>this.id = id;
41. <settings>
42. <plugins>
43.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
44. </plugins>
45. <plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
48. </settings>this.username = username;
49. <settings>
50. <plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
56. </settings>this.password = password;
57. <settings>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins>
61. <plugins>
62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
63. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
64. </settings>this.age = age;
65. <settings>
66. <plugins>
67.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
68. </plugins>
69. <plugins>
70.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
71. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
72. </settings>this.sex = sex;
73. <settings>
74. <plugins>
75.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
76. </plugins>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
80. </settings>this.email = email;
81. <plugins>
82.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
83. </plugins>}
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>public Integer getId() {
88. <settings>
89. <plugins>
90.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
91. </plugins>
92. <plugins>
93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
94. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
95. </settings>return id;
96. <plugins>
97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
98. </plugins>}
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>public void setId(Integer id) {
103. <settings>
104. <plugins>
105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
106. </plugins>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
110. </settings>this.id = id;
111. <plugins>
112.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
113. </plugins>}
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins>public String getUsername() {
118. <settings>
119. <plugins>
120.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
121. </plugins>
122. <plugins>
123.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
124. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
125. </settings>return username;
126. <plugins>
127.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
128. </plugins>}
130. <plugins>
131.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
132. </plugins>public void setUsername(String username) {
133. <settings>
134. <plugins>
135.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
136. </plugins>
137. <plugins>
138.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
139. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
140. </settings>this.username = username;
141. <plugins>
142.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
143. </plugins>}
145. <plugins>
146.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
147. </plugins>public String getPassword() {
148. <settings>
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins>
152. <plugins>
153.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
154. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
155. </settings>return password;
156. <plugins>
157.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
158. </plugins>}
160. <plugins>
161.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
162. </plugins>public void setPassword(String password) {
163. <settings>
164. <plugins>
165.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
166. </plugins>
167. <plugins>
168.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
169. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
170. </settings>this.password = password;
171. <plugins>
172.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
173. </plugins>}
175. <plugins>
176.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
177. </plugins>public Integer getAge() {
178. <settings>
179. <plugins>
180.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
181. </plugins>
182. <plugins>
183.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
184. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
185. </settings>return age;
186. <plugins>
187.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
188. </plugins>}
190. <plugins>
191.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
192. </plugins>public void setAge(Integer age) {
193. <settings>
194. <plugins>
195.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
196. </plugins>
197. <plugins>
198.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
199. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
200. </settings>this.age = age;
201. <plugins>
202.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
203. </plugins>}
205. <plugins>
206.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
207. </plugins>public String getSex() {
208. <settings>
209. <plugins>
210.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
211. </plugins>
212. <plugins>
213.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
214. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
215. </settings>return sex;
216. <plugins>
217.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
218. </plugins>}
220. <plugins>
221.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
222. </plugins>public void setSex(String sex) {
223. <settings>
224. <plugins>
225.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
226. </plugins>
227. <plugins>
228.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
229. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
230. </settings>this.sex = sex;
231. <plugins>
232.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
233. </plugins>}
235. <plugins>
236.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
237. </plugins>public String getEmail() {
238. <settings>
239. <plugins>
240.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
241. </plugins>
242. <plugins>
243.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
244. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
245. </settings>return email;
246. <plugins>
247.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
248. </plugins>}
250. <plugins>
251.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
252. </plugins>public void setEmail(String email) {
253. <settings>
254. <plugins>
255.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
256. </plugins>
257. <plugins>
258.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
259. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
260. </settings>this.email = email;
261. <plugins>
262.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
263. </plugins>}
265. <plugins>
266.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
267. </plugins>@Override
268. <plugins>
269.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
270. </plugins>public String toString() {
271. <settings>
272. <plugins>
273.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
274. </plugins>
275. <plugins>
276.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
277. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
278. </settings>return "Users{" +
279. <settings>
280. <plugins>
281.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
282. </plugins>
283. <plugins>
284.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
285. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
286. </settings><settings>
287. <plugins>
288.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
289. </plugins>
290. <plugins>
291.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
292. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
293. </settings>"id=" + id +
294. <settings>
295. <plugins>
296.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
297. </plugins>
298. <plugins>
299.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
300. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
301. </settings><settings>
302. <plugins>
303.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
304. </plugins>
305. <plugins>
306.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
307. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
308. </settings>", username='" + username + '\'' +
309. <settings>
310. <plugins>
311.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
312. </plugins>
313. <plugins>
314.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
315. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
316. </settings><settings>
317. <plugins>
318.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
319. </plugins>
320. <plugins>
321.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
322. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
323. </settings>", password='" + password + '\'' +
324. <settings>
325. <plugins>
326.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
327. </plugins>
328. <plugins>
329.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
330. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
331. </settings><settings>
332. <plugins>
333.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
334. </plugins>
335. <plugins>
336.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
337. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
338. </settings>", age=" + age +
339. <settings>
340. <plugins>
341.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
342. </plugins>
343. <plugins>
344.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
345. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
346. </settings><settings>
347. <plugins>
348.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
349. </plugins>
350. <plugins>
351.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
352. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
353. </settings>", sex='" + sex + '\'' +
354. <settings>
355. <plugins>
356.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
357. </plugins>
358. <plugins>
359.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
360. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
361. </settings><settings>
362. <plugins>
363.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
364. </plugins>
365. <plugins>
366.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
367. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
368. </settings>", email='" + email + '\'' +
369. <settings>
370. <plugins>
371.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
372. </plugins>
373. <plugins>
374.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
375. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
376. </settings><settings>
377. <plugins>
378.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
379. </plugins>
380. <plugins>
381.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
382. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
383. </settings>'}';
384. <plugins>
385.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
386. </plugins>}
387. }

复制代码

6.创建mapper接口（不需要实现类）

UserMapper.java

1. package com.xust.mybatis.mapper;
3. /**
4. * mybatis面向接口编程两个一致
5. * 1.映射文件的namespace要和mapper的全类名保持一致
6. * 2.映射文件中SQL语句的id要和mapper接口中的方法名一致
7. */
8. public interface UserMapper {
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>/**
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins> * 添加用户信息
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins> */
18. <plugins>
19.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
20. </plugins>int insertUser();
21. }

复制代码

7.创建MyBatis映射文件

• 映射文件的namespace要和mapper的全类名保持一致
  
• 映射文件中SQL语句的id要和mapper接口中的方法名一致
  

UserMapper.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE mapper
3. <settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings>PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
11. <settings>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
18. </settings>"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
19. <mapper namespace="com.xust.mybatis.mapper.UserMapper">
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><insert id="insertUser">
26.                 insert into t_user values(null,'张三','123',23,'女','123456@qq.com')
27.         </insert>
28. </mapper>

复制代码

8.junit测试

SqlSession:代表Java程序和数据库之间的会话。HttpSession是Java程序和浏览器之间的会话
SqlSessionFactory:是生产SqlSession的工厂

MyBatisTest.java

1. package com.xust.mybatis.test;
3. import com.xust.mybatis.mapper.UserMapper;
4. import org.apache.ibatis.io.Resources;
5. import org.apache.ibatis.session.SqlSession;
6. import org.apache.ibatis.session.SqlSessionFactory;
7. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
8. import org.junit.Test;
10. import java.io.IOException;
11. import java.io.InputStream;
13. public class MyBatisTest {
14. <plugins>
15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
16. </plugins>@Test
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>public void testMyBatis() throws IOException {
20. <settings>
21. <plugins>
22.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
23. </plugins>
24. <plugins>
25.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
26. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
27. </settings>//加载核心配置文件
28. <settings>
29. <plugins>
30.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
31. </plugins>
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
35. </settings>InputStream is= Resources.getResourceAsStream("mybatis-config.xml");
36. <settings>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins>
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
43. </settings>//获取SqlSessionFactoryBuilder
44. <settings>
45. <plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
51. </settings>SqlSessionFactoryBuilder sqlSessionFactoryBuilder=new SqlSessionFactoryBuilder();
52. <settings>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins>
56. <plugins>
57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
58. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
59. </settings>//获取SqlSessionFactory
60. <settings>
61. <plugins>
62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
63. </plugins>
64. <plugins>
65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
66. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
67. </settings>SqlSessionFactory sqlSessionFactory=sqlSessionFactoryBuilder.build(is);
68. <settings>
69. <plugins>
70.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
71. </plugins>
72. <plugins>
73.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
74. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
75. </settings>//获取SqlSession
76. <settings>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
83. </settings>SqlSession sqlSession=sqlSessionFactory.openSession();
84. <settings>
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>
88. <plugins>
89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
91. </settings>//获取mapper接口对象
92. <settings>
93. <plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins>
96. <plugins>
97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
98. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
99. </settings>UserMapper mapper=sqlSession.getMapper(UserMapper.class);
100. <settings>
101. <plugins>
102.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
103. </plugins>
104. <plugins>
105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
106. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
107. </settings>//测试功能
108. <settings>
109. <plugins>
110.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
111. </plugins>
112. <plugins>
113.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
114. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
115. </settings>int result=mapper.insertUser();
116. <settings>
117. <plugins>
118.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
119. </plugins>
120. <plugins>
121.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
122. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
123. </settings>//提交事务
124. <settings>
125. <plugins>
126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
127. </plugins>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
131. </settings>sqlSession.commit();
132. <settings>
133. <plugins>
134.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
135. </plugins>
136. <plugins>
137.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
138. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
139. </settings>System.out.println("result:"+result);
140. <plugins>
141.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
142. </plugins>}
143. }

复制代码

上面是手动提交事务，SqlSession默认不自动提交事务，自动提交可以在获取sqlSession对象时，使用SqlSession sqlSession = sqlSessionFactory.openSession(true)，传入一个Boolean类型的参数，值为true，这样就可以自动提交。
9.加入log4j日志功能

引入依赖

1. <dependency>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins><groupId>log4j</groupId>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><artifactId>log4j</artifactId>
8. <plugins>
9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
10. </plugins><version>1.2.17</version>
11. </dependency>

复制代码

log4j.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
3. <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins><appender name="STDOUT" >
7. <settings>
8. <plugins>
9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
10. </plugins>
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
14. </settings><param name="Encoding" value="UTF-8" />
15. <settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings><layout >
23.                         <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m (%F:%L) \n" />
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings></layout>
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins></appender>
35. <plugins>
36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
37. </plugins><logger name="java.sql">
38. <settings>
39. <plugins>
40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
41. </plugins>
42. <plugins>
43.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
44. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
45. </settings><level value="debug" />
46. <plugins>
47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
48. </plugins></logger>
49. <plugins>
50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
51. </plugins><logger name="org.apache.ibatis">
52. <settings>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins>
56. <plugins>
57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
58. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
59. </settings><level value="info" />
60. <plugins>
61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
62. </plugins></logger>
63. <plugins>
64.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
65. </plugins><root>
66. <settings>
67. <plugins>
68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
69. </plugins>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
73. </settings><level value="debug" />
74. <settings>
75. <plugins>
76.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
77. </plugins>
78. <plugins>
79.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
80. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
81. </settings><appender-ref ref="STDOUT" />
82. <plugins>
83.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
84. </plugins></root>
85. </log4j:configuration>

复制代码

日志的级别：FATAL(致命)>ERROR(错误)>WARN(警告)>INFO(信息)>DEBUG(调试)
日志级别越低，打印越详细

增删改查

查询功能必须指定resultType或resultMap
resultType:设置默认映射（字段名和属性名一致）
resultMap:设置自定义映射（一对多，多对一，字段名和属性名不一致）

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE mapper
3. <settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings>PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
11. <settings>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
18. </settings>"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
19. <mapper namespace="com.xust.mybatis.mapper.UserMapper">
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><insert id="insertUser">
26.                 insert into t_user values(null,'张三','123',23,'女','123456@qq.com')
27.         </insert>
28. </mapper><settings>
29. <plugins>
30.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
31. </plugins>
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
35. </settings><settings>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins>
39. <plugins>
40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
41. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
42. </settings>update t_user set username='李四' where id=1<settings>
43. <plugins>
44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
45. </plugins>
46. <plugins>
47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
48. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
49. </settings><settings>
50. <plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
56. </settings><plugins>
57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
58. </plugins>delete from t_user where id=2<settings>
59. <plugins>
60.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
61. </plugins>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
65. </settings><settings>
66. <plugins>
67.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
68. </plugins>
69. <plugins>
70.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
71. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
72. </settings><plugins>
73.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
74. </plugins><select id="getAllUser" resultType="users">
75. <select id="getAllUserToMap" resultType="map">
76. <select id="getAllUserToMap1" resultType="map">
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins>select * from t_user
80. </select>
81. </select>
82. </select> where id=3<settings>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins>
86. <plugins>
87.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
88. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
89. </settings><settings>
90. <plugins>
91.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
92. </plugins>
93. <plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
96. </settings><select id="getAllUser" resultType="users">
97. <select id="getAllUserToMap" resultType="map">
98. <select id="getAllUserToMap1" resultType="map">
99. <plugins>
100.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
101. </plugins>select * from t_user
102. </select>
103. </select>
104. </select><plugins>
105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
106. </plugins>

复制代码

MyBatis核心配置文件

标签顺序

properties、settings、typeAliases、typeHandlers、objectFactory、objectWrapperFactory、reflectorFactory、plugins、environments、databaseIdProvider、mappers

mybatis-config.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration
3. <settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings>PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11. <settings>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
18. </settings>"http://mybatis.org/dtd/mybatis-3-config.dtd">
19. <configuration>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><environments default="development">
26. <settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><environment id="development">
34. <settings>
35. <plugins>
36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
37. </plugins>
38. <plugins>
39.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
40. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
41. </settings><plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins><transactionManager type="JDBC"/>
44. <settings>
45. <plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
51. </settings><plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><dataSource type="POOLED">
54. <settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings><settings>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins>
65. <plugins>
66.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
67. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
68. </settings><property name="driver" value="com.mysql.cj.jdbc.Driver"/>
69. <settings>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>
73. <plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
76. </settings><settings>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
83. </settings><property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
84. <settings>
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>
88. <plugins>
89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
91. </settings><settings>
92. <plugins>
93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
94. </plugins>
95. <plugins>
96.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
97. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
98. </settings><property name="username" value="root"/>
99. <settings>
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>
103. <plugins>
104.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
105. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
106. </settings><settings>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins>
110. <plugins>
111.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
112. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
113. </settings><property name="password" value="xxxxxxxxx"/>
114. <settings>
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins>
118. <plugins>
119.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
120. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
121. </settings><plugins>
122.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
123. </plugins></dataSource>
124. <settings>
125. <plugins>
126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
127. </plugins>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
131. </settings></environment>
132. <plugins>
133.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
134. </plugins></environments>
135. <plugins>
136.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
137. </plugins>
138. <plugins>
139.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
140. </plugins><mappers>
141. <settings>
142. <plugins>
143.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
144. </plugins>
145. <plugins>
146.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
147. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
148. </settings><mapper resource="mappers/UserMapper.xml"/>
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins></mappers>
152. </configuration><settings>
153. <plugins>
154.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
155. </plugins>
156. <plugins>
157.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
158. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
159. </settings><settings>
160. <plugins>
161.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
162. </plugins>
163. <plugins>
164.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
165. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
166. </settings><settings>
167. <plugins>
168.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
169. </plugins>
170. <plugins>
171.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
172. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
173. </settings><settings>
174. <plugins>
175.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
176. </plugins>
177. <plugins>
178.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
179. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
180. </settings><settings>
181. <plugins>
182.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
183. </plugins>
184. <plugins>
185.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
186. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
187. </settings><settings>
188. <plugins>
189.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
190. </plugins>
191. <plugins>
192.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
193. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
194. </settings><settings>
195. <plugins>
196.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
197. </plugins>
198. <plugins>
199.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
200. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
201. </settings><settings>
202. <plugins>
203.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
204. </plugins>
205. <plugins>
206.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
207. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
208. </settings><settings>
209. <plugins>
210.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
211. </plugins>
212. <plugins>
213.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
214. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
215. </settings><settings>
216. <plugins>
217.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
218. </plugins>
219. <plugins>
220.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
221. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
222. </settings><settings>
223. <plugins>
224.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
225. </plugins>
226. <plugins>
227.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
228. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
229. </settings><settings>
230. <plugins>
231.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
232. </plugins>
233. <plugins>
234.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
235. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
236. </settings>

复制代码

jdbc.properties

1. jdbc.driver=com.mysql.cj.jdbc.Driver
2. jdbc.url=jdbc:mysql://localhost:3306/mybatis
3. jdbc.username=root
4. jdbc.password=xxxxxxx

复制代码

idea中设置核心配置文件模板


MyBatis中mapper获取参数值的两种方式

${}:字符串拼接的方式拼接sql，若为字符串类型或日期类型的字段进行赋值时，需要手动加单引号
{}:使用占位符赋值的方式拼接sql，此时为字符串类型或日期类型的字段进行赋值时，可以自动添加单引号

单个字面量类型的参数

{}中username可替换为任意值，${}要手动添加''

Test.java

1. public class ParameterTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetUserByUsername(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>Users user=mapper.GetUserByUsername("李四");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(user);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

#{}

1. <select id="GetUserByUsername" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where username=#{username}
11. </select>

复制代码

${}

1. <select id="GetUserByUsername" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where username='${username}'
11. </select>

复制代码

多个字面量类型的参数

若mapper接口中的方法参数为多个时，此时MyBatis会自动将这些参数放在一个map集合中

• 以arg0,arg1…为键，以参数为值；
  
• 以param1,param2…为键，以参数为值；
  

{}中必须按照上面的参数写

Test.java

1. public class ParameterTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testCheckLogin(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>Users user=mapper.checkLogin("李四","123");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(user);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

#{}

1. <select id="checkLogin" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where username=#{arg0} and password=#{arg1}
11. </select>

复制代码

${}

1. <select id="checkLogin" resultType="User">
2.         select * from t_user where username ='${param1}' and password ='${param2}'
3. </select>

复制代码

map集合类型的参数

mapper接口中的方法需要的参数为多个时，此时可以手动创建map集合，将这些数据放在map中只需要通过${}和#{}访问map集合的键就可以获取相对应的值

Test.java

1. public class ParameterTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testCheckLoginByMap(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>Map<String,Object> map=new HashMap<>();
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>map.put("username","李四");
40. <settings>
41. <plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
47. </settings>map.put("password","123");
48. <settings>
49. <plugins>
50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
51. </plugins>
52. <plugins>
53.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
54. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
55. </settings>Users user=mapper.checkUserByMap(map);
56. <settings>
57. <plugins>
58.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
59. </plugins>
60. <plugins>
61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
62. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
63. </settings>System.out.println(user);
64. <plugins>
65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
66. </plugins>}
67. }

复制代码

#{}

1. <select id="GetUserByUsername" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where username=#{username}
11. </select> and password=#{password}

复制代码

${}略
实体类类型的参数

通过访问实体类对象中的属性名获取属性值

Test.java

1. public class ParameterTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testInsertUser(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>int result=mapper.insertUser(new Users(null,"王五","123",23,"男","123@q.com"));
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(result);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

#{}

1. <insert id="insertUser">
2. <insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
3. <plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>insert into t_user values(null,#{username},#{password},#{age},#{sex},#{email})
6. </insert>
7. </insert>

复制代码

${}略
使用@Param注解命名参数

可以通过@Param注解标识mapper接口中的方法参数，此时，会将这些参数放在map集合中

• 以@Param注解的value属性值为键，以参数为值
  
• 以param1,param2…为键，以参数为值
  

Test.java

1. public class ParameterTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testChesckLoginByParam(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>Users user=mapper.checkLoginByParam("李四","123");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(user);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

mapper.java

1. Users checkLogdinByParam(@Param("username") String username,@Param("password") String password);

复制代码

mapper.xml

1. <select id="GetUserByUsername" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where username=#{username}
11. </select> and password=#{password}

复制代码

MyBatis查询功能

查询一个实体类对象

1. Users getUserById(@Param("id") Integer id);

复制代码

1. <select id="getUserById" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where id=#{id}
11. </select>

复制代码

1. public class SelectMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void getUsereById(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>System.out.println(mapper.getUserById(3));
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>}
35. }

复制代码

查询List集合

1. List<Users> getAllUser();

复制代码

1. <select id="getAllUser" resultType="users">
2. <select id="getAllUserToMap" resultType="map">
3. <select id="getAllUserToMap1" resultType="map">
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>select * from t_user
7. </select>
8. </select>
9. </select>

复制代码

1. public class SelectMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void getAllUsers(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>System.out.println(mapper.getAllUser());
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>}
35. }

复制代码

查询单个数据

1. Integer getCount();

复制代码

1. <select id="getCount" resultType="java.lang.Integer">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select count(*) from t_user
5. </select>

复制代码

1. public class SelectMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetCount(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>System.out.println(mapper.getCount());
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>}
35. }

复制代码

查询一条数据为map集合

1. Map<String,Object> getUserByIdToMap(@Param("id") Integer id);

复制代码

1. <select id="getUserById" resultType="users">
2. <select id="getAllUser" resultType="users">
3. <select id="getAllUserToMap" resultType="map">
4. <select id="getAllUserToMap1" resultType="map">
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>select * from t_user
8. </select>
9. </select>
10. </select> where id=#{id}
11. </select>

复制代码

1. public class SelectMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetUserByIdToMap(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>System.out.println(mapper.getUserByIdToMap(3));
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>}
35. }

复制代码

查询多条数据为map集合

法一：

1. List<Map<String,Object>> getAllUserToMap();

复制代码

1. <select id="getAllUser" resultType="users">
2. <select id="getAllUserToMap" resultType="map">
3. <select id="getAllUserToMap1" resultType="map">
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>select * from t_user
7. </select>
8. </select>
9. </select>

复制代码

1. public class SelectMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetAllUserToMap(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>System.out.println(mapper.getAllUserToMap());
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>}
35. }

复制代码

法二：

1. @MapKey("id")
2. Map<String,Object> getAllUserToMap1();

复制代码

1. <select id="getAllUser" resultType="users">
2. <select id="getAllUserToMap" resultType="map">
3. <select id="getAllUserToMap1" resultType="map">
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>select * from t_user
7. </select>
8. </select>
9. </select>

复制代码

1. public class SelectMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetAllUserToMap1(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>System.out.println(mapper.getAllUserToMap1());
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>}
35. }

复制代码

特殊SQL的执行

模糊查询

第三种方法最常用

1. List<Users> getUserByLike(@Param("username") String username);

复制代码

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><select id="getAllUser" resultType="users">
9. <select id="getAllUserToMap" resultType="map">
10. <select id="getAllUserToMap1" resultType="map">
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins>select * from t_user
14. </select>
15. </select>
16. </select> where username like "%"#{username}"%"

复制代码

1. public class SQLMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetUserByLike(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>List<Users> list=mapper.getUserByLike("a");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(list);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

批量删除

1. int deleteMore(@Param("ids") String ids);

复制代码

1. <delete id="deleteMore">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>delete from t_user where id in (${ids})
5. </delete>

复制代码

1. public class SQLMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testDeleteMore(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>int result=mapper.deleteMore("1,2,3");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(result);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

动态设置表名

1. List<Users> getUserByTableName(@Param("tableName") String tableName);

复制代码

1. <select id="getUserByTableName" resultType="users">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from ${tableName}
5. </select>

复制代码

1. public class SQLMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetUserByTableName(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>List<Users> list=mapper.getUserByTableName("t_user");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>System.out.println(list);
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

添加功能获取自增的主键

在插入一条数据的同时就可以获得对应的id，不需要插入后再去查询对应数据的id

• useGeneratedKeys：设置使用自增的主键
  
• keyProperty：因为增删改有统一的返回值是受影响的行数，因此只能将获取的自增的主键放在传输的参数user对象的某个属性中
  

1. void insertUser(Users user);

复制代码

1. <insert id="insertUser">
2. <insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
3. <plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>insert into t_user values(null,#{username},#{password},#{age},#{sex},#{email})
6. </insert>
7. </insert>

复制代码

1. public class SQLMapperTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testInsertUser(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>Users user=new Users(null,"赵六","123",23,"男","123@qq.com");
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>mapper.insertUser(user);
40. <settings>
41. <plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
47. </settings>System.out.println(user);
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins>}
51. }

复制代码

自定义映射resultMap

字段名与属性名不一致

数据库

Emp.java

1. package com.xust.mybatis.pojo;
3. public class Emp {
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>private Integer eid;
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins>private String empName;
10. <plugins>
11.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
12. </plugins>private Integer age;
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>private String sex;
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>private String email;
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>public Emp() {
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>}
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>public Emp(Integer eid, String empName, Integer age, String sex, String email) {
30. <settings>
31. <plugins>
32.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
33. </plugins>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
37. </settings>this.eid = eid;
38. <settings>
39. <plugins>
40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
41. </plugins>
42. <plugins>
43.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
44. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
45. </settings>this.empName = empName;
46. <settings>
47. <plugins>
48.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
49. </plugins>
50. <plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
53. </settings>this.age = age;
54. <settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings>this.sex = sex;
62. <settings>
63. <plugins>
64.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
65. </plugins>
66. <plugins>
67.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
68. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
69. </settings>this.email = email;
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>}
74. <plugins>
75.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
76. </plugins>public Integer getEid() {
77. <settings>
78. <plugins>
79.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
80. </plugins>
81. <plugins>
82.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
83. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
84. </settings>return eid;
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>}
89. <plugins>
90.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
91. </plugins>public void setEid(Integer eid) {
92. <settings>
93. <plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins>
96. <plugins>
97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
98. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
99. </settings>this.eid = eid;
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>}
104. <plugins>
105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
106. </plugins>public String getEmpName() {
107. <settings>
108. <plugins>
109.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
110. </plugins>
111. <plugins>
112.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
113. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
114. </settings>return empName;
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins>}
119. <plugins>
120.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
121. </plugins>public void setEmpName(String empName) {
122. <settings>
123. <plugins>
124.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
125. </plugins>
126. <plugins>
127.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
128. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
129. </settings>this.empName = empName;
130. <plugins>
131.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
132. </plugins>}
134. <plugins>
135.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
136. </plugins>public Integer getAge() {
137. <settings>
138. <plugins>
139.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
140. </plugins>
141. <plugins>
142.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
143. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
144. </settings>return age;
145. <plugins>
146.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
147. </plugins>}
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins>public void setAge(Integer age) {
152. <settings>
153. <plugins>
154.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
155. </plugins>
156. <plugins>
157.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
158. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
159. </settings>this.age = age;
160. <plugins>
161.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
162. </plugins>}
164. <plugins>
165.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
166. </plugins>public String getSex() {
167. <settings>
168. <plugins>
169.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
170. </plugins>
171. <plugins>
172.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
173. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
174. </settings>return sex;
175. <plugins>
176.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
177. </plugins>}
179. <plugins>
180.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
181. </plugins>public void setSex(String sex) {
182. <settings>
183. <plugins>
184.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
185. </plugins>
186. <plugins>
187.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
188. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
189. </settings>this.sex = sex;
190. <plugins>
191.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
192. </plugins>}
194. <plugins>
195.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
196. </plugins>public String getEmail() {
197. <settings>
198. <plugins>
199.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
200. </plugins>
201. <plugins>
202.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
203. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
204. </settings>return email;
205. <plugins>
206.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
207. </plugins>}
209. <plugins>
210.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
211. </plugins>public void setEmail(String email) {
212. <settings>
213. <plugins>
214.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
215. </plugins>
216. <plugins>
217.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
218. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
219. </settings>this.email = email;
220. <plugins>
221.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
222. </plugins>}
224. <plugins>
225.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
226. </plugins>@Override
227. <plugins>
228.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
229. </plugins>public String toString() {
230. <settings>
231. <plugins>
232.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
233. </plugins>
234. <plugins>
235.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
236. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
237. </settings>return "Emp{" +
238. <settings>
239. <plugins>
240.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
241. </plugins>
242. <plugins>
243.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
244. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
245. </settings><settings>
246. <plugins>
247.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
248. </plugins>
249. <plugins>
250.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
251. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
252. </settings>"eid=" + eid +
253. <settings>
254. <plugins>
255.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
256. </plugins>
257. <plugins>
258.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
259. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
260. </settings><settings>
261. <plugins>
262.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
263. </plugins>
264. <plugins>
265.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
266. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
267. </settings>", empName='" + empName + '\'' +
268. <settings>
269. <plugins>
270.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
271. </plugins>
272. <plugins>
273.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
274. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
275. </settings><settings>
276. <plugins>
277.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
278. </plugins>
279. <plugins>
280.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
281. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
282. </settings>", age=" + age +
283. <settings>
284. <plugins>
285.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
286. </plugins>
287. <plugins>
288.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
289. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
290. </settings><settings>
291. <plugins>
292.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
293. </plugins>
294. <plugins>
295.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
296. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
297. </settings>", sex='" + sex + '\'' +
298. <settings>
299. <plugins>
300.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
301. </plugins>
302. <plugins>
303.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
304. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
305. </settings><settings>
306. <plugins>
307.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
308. </plugins>
309. <plugins>
310.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
311. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
312. </settings>", email='" + email + '\'' +
313. <settings>
314. <plugins>
315.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
316. </plugins>
317. <plugins>
318.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
319. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
320. </settings><settings>
321. <plugins>
322.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
323. </plugins>
324. <plugins>
325.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
326. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
327. </settings>'}';
328. <plugins>
329.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
330. </plugins>}
331. }

复制代码

1. public class ResultMapTest {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>@Test
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>public void testGetAllEmp(){
8. <settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();
16. <settings>
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
23. </settings>EmpMapper mapper=sqlSessaion.getMapper(EmpMapper.class);
24. <settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings>List<Emp> list=mapper.getAllEmp();
32. <settings>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
39. </settings>list.forEach(emp-> System.out.println(emp));
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>}
43. }

复制代码

方法一：为字段起别名，使之与属性名称相同

EmpMapper.xml

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select eid,emp_name empNaem,age,sex,email from t_emp
5. </select>

复制代码

方法二：配置映射

在mybatis-config.xml中添加配置后自动将下划线映射为驼峰

mybatis-config.xml

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings>

复制代码

EmpMapper.xml

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_emp
5. </select>

复制代码

方法三：自定义映射resultMap

所有属性都要列出来

EmpMapper.xml

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings><settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings><select id="getAllEmp" resultType="emp">
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>select * from t_emp
26. </select>

复制代码

多对一映射

方法一：级联操作

Emp.java

1. public class Emp {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>private Integer eid;
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>private String empName;
8. <plugins>
9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
10. </plugins>private Integer age;
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins>private String sex;
14. <plugins>
15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
16. </plugins>private String email;
17. <plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>private Dept dept;
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>......
23. }

复制代码

Dept.java

1. package com.xust.mybatis.pojo;
3. public class Dept {
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>private Integer did;
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins>private String deptName;
10. <plugins>
11.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
12. </plugins>......
13. }

复制代码

EmpMapper.xml

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings><settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings><settings>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>
26. <plugins>
27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
29. </settings>select * from t_emp left join t_dept on t_emp.did=t_dept.did where t_emp.eid=#{eid}

复制代码

方法二：association

association用来处理多对一的映射关系
javaType中是类型名

EmpMapper.xml

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings><settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings><settings>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>
26. <plugins>
27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
29. </settings><settings>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
36. </settings><plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins>

复制代码

方法三：分步查询

EmpMapper.xml

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings><settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings><settings>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>
26. <plugins>
27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
29. </settings>select * from t_emp where eid=#{eid}

复制代码

DeptMapper.xml

1. <select id="getEmpAndDeptByStepTwo" resultType="Dept">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_dept where did=#{did}
5. </select>

复制代码

1. public class ResultMapTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testGetEmpAndDeptByStep(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings>EmpMapper mapper=sqlSessaion.getMapper(EmpMapper.class);<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>Emp emp=mapper.getEmpAndDeptByStepOne(1);<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings>System.out.println(emp);<plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>}}

复制代码

一对多映射

Dept.java

1. public class Dept {
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>private Integer did;
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins>private String deptName;
8. <plugins>
9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
10. </plugins>private List<Emp> emps;
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins>......
14. }

复制代码

方法一：collection

collection：用来处理一对多的映射关系
ofType：表示该属性对饮的集合中存储的数据的类型

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings><settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings><settings>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>
26. <plugins>
27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
29. </settings><settings>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
36. </settings><settings>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins>
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
43. </settings><settings>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins>
47. <plugins>
48.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
49. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
50. </settings><plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins>select * from t_dept left join t_emp on t_dept.did=t_emp.did where t_dept.did=#{did}

复制代码

1. public class ResultMapTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testGetDeptAndEmp(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings>DeptMapper mapper=sqlSessaion.getMapper(DeptMapper.class);<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>Dept dept=mapper.getDeptAndEmp(1);<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings>System.out.println(dept);<plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>}}

复制代码

方法二：分步查询

DeptMapper.xml

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>select * from t_dept where did=#{did}

复制代码

EmpMapper.xml

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_emp
5. </select> where did=#{did}

复制代码

1. public class ResultMapTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testGetDeptAndEmpByStep(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings>DeptMapper mapper=sqlSessaion.getMapper(DeptMapper.class);<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>Dept dept=mapper.getDeptAndEmpByStepOne(1);<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings>System.out.println(dept);<plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>}}

复制代码

动态SQL

Mybatis框架的动态SQL技术是一种根据特定条件动态拼装SQL语句的功能，它存在的意义是为了解决拼接SQL语句字符串时的痛点问题

if标签

if标签可以对test中接收到的属性值进行判断，为true则拼接if标签下的内容
where后加1=1为了更好实现拼接效果，防止出现拼接错误

1. List<Emp> getEmpByCondition(Emp emp);

复制代码

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_emp
5. </select> where 1=1<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings><plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>and emp_name=#{empName}<settings>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins>
18. <plugins>
19.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
20. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
21. </settings><settings>
22. <plugins>
23.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
24. </plugins>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
28. </settings>and age=#{age}<settings>
29. <plugins>
30.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
31. </plugins>
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
35. </settings><settings>
36. <plugins>
37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
38. </plugins>
39. <plugins>
40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
41. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
42. </settings>and sex=#{sex}<settings>
43. <plugins>
44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
45. </plugins>
46. <plugins>
47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
48. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
49. </settings><settings>
50. <plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
56. </settings>and email=#{email}<plugins>
57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
58. </plugins>

复制代码

1. public class DynamicSQLMapperTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testGetEmpByCondition(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings>DynamicSQLMapper mapper=sqlSessaion.getMapper(DynamicSQLMapper.class);<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>List list=mapper.getEmpByCondition(new Emp(null,"张三",12,"男","123@qq.com"));<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings>System.out.println(list);<plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>}}

复制代码

where标签

相比直接使用if标签，where标签会自动清除多余的and和or,条件全不满足时where不起作用，不会出现拼接错误
但是where标签只能将内容之前多余的and和or清除，如果and和or放在拼接的语句之后，则不能清除

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_emp
5. </select><settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings><settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings><settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>emp_name=#{empName}<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><settings>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
40. </settings><settings>
41. <plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
47. </settings><plugins>
48.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
49. </plugins>and age=#{age}<settings>
50. <plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
56. </settings><settings>
57. <plugins>
58.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
59. </plugins>
60. <plugins>
61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
62. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
63. </settings><settings>
64. <plugins>
65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
66. </plugins>
67. <plugins>
68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
69. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
70. </settings><plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>and sex=#{sex}<settings>
73. <plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins>
76. <plugins>
77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
78. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
79. </settings><settings>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
86. </settings><settings>
87. <plugins>
88.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
89. </plugins>
90. <plugins>
91.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
92. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
93. </settings><plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins>and email=#{email}<settings>
96. <plugins>
97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
98. </plugins>
99. <plugins>
100.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
101. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
102. </settings><plugins>
103.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
104. </plugins>

复制代码

trim标签

prefix/suffix：将trim标签中内容前面/后面添加指定内容
prefixOverrides/suffixOverrides：将trim标签中内容前面/后面去掉指定内容

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_emp
5. </select><settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings><settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings><settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>emp_name = #{empName} and<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><settings>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
40. </settings><settings>
41. <plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
47. </settings><plugins>
48.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
49. </plugins>age = #{age} and<settings>
50. <plugins>
51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
52. </plugins>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
56. </settings><settings>
57. <plugins>
58.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
59. </plugins>
60. <plugins>
61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
62. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
63. </settings><settings>
64. <plugins>
65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
66. </plugins>
67. <plugins>
68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
69. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
70. </settings><plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>sex = #{sex} or<settings>
73. <plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins>
76. <plugins>
77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
78. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
79. </settings><settings>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
86. </settings><settings>
87. <plugins>
88.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
89. </plugins>
90. <plugins>
91.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
92. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
93. </settings><plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins>email = #{email}<settings>
96. <plugins>
97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
98. </plugins>
99. <plugins>
100.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
101. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
102. </settings><plugins>
103.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
104. </plugins>

复制代码

choose,when,otherwise标签

相当于if...else if...else，只会执行一个
when至少要有一个，otherwise至多只有一个

1. <select id="getAllEmp" resultType="emp">
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>select * from t_emp
5. </select><settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings><settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings><settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings><settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><settings>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
40. </settings>emp_name=#{empName}<settings>
41. <plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
47. </settings><settings>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins>
51. <plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
54. </settings><settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings><settings>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins>
65. <plugins>
66.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
67. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
68. </settings><settings>
69. <plugins>
70.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
71. </plugins>
72. <plugins>
73.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
74. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
75. </settings>age=#{age}<settings>
76. <plugins>
77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
78. </plugins>
79. <plugins>
80.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
81. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
82. </settings><settings>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins>
86. <plugins>
87.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
88. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
89. </settings><settings>
90. <plugins>
91.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
92. </plugins>
93. <plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
96. </settings><settings>
97. <plugins>
98.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
99. </plugins>
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
103. </settings><settings>
104. <plugins>
105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
106. </plugins>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
110. </settings>sex=#{sex}<settings>
111. <plugins>
112.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
113. </plugins>
114. <plugins>
115.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
116. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
117. </settings><settings>
118. <plugins>
119.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
120. </plugins>
121. <plugins>
122.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
123. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
124. </settings><settings>
125. <plugins>
126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
127. </plugins>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
131. </settings><settings>
132. <plugins>
133.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
134. </plugins>
135. <plugins>
136.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
137. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
138. </settings><settings>
139. <plugins>
140.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
141. </plugins>
142. <plugins>
143.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
144. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
145. </settings>email=#{email}<settings>
146. <plugins>
147.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
148. </plugins>
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
152. </settings><settings>
153. <plugins>
154.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
155. </plugins>
156. <plugins>
157.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
158. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
159. </settings><settings>
160. <plugins>
161.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
162. </plugins>
163. <plugins>
164.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
165. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
166. </settings><settings>
167. <plugins>
168.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
169. </plugins>
170. <plugins>
171.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
172. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
173. </settings><settings>
174. <plugins>
175.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
176. </plugins>
177. <plugins>
178.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
179. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
180. </settings>did=1<settings>
181. <plugins>
182.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
183. </plugins>
184. <plugins>
185.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
186. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
187. </settings><settings>
188. <plugins>
189.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
190. </plugins>
191. <plugins>
192.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
193. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
194. </settings><settings>
195. <plugins>
196.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
197. </plugins>
198. <plugins>
199.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
200. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
201. </settings>

复制代码

foreach标签

collection：设置要循环的数组或集合
item：表示集合或数组中的每一个数据
separator：设置循环体之间的分隔符，分隔符前后默认有一个空格
open：开始符
close：结束符

1. int deleteMoreByArray(@Param("eids") Integer[] eids);

复制代码

1. <plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>delete from t_emp where eid in<settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings><settings>
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins>
14. <plugins>
15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
16. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
17. </settings><plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>#{eid}<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>

复制代码

1. public class DynamicSQLMapperTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testDeleteMoreByArray(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings>DynamicSQLMapper mapper=sqlSessaion.getMapper(DynamicSQLMapper.class);<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>int result=mapper.deleteMoreByArray(new Integer[]{6,7,8});<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings>System.out.println(result);<plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins>}}

复制代码

批量删除

,换成or

1. <plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>delete from t_emp where eid in<settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings><settings>
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins>
14. <plugins>
15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
16. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
17. </settings><plugins>
18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
19. </plugins>#{eid}<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>

复制代码

批量添加

1. int insertMoreByList(@Param("emps") List<Emp> emps);

复制代码

1. <plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>insert into t_emp values<settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings><plugins>
11.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
12. </plugins>(null,#{emp.empName},#{emp.age},#{emp.sex},#{emp.email},null)<plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>

复制代码

1. public class DynamicSQLMapperTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void insertMoreByList() {<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>SqlSession sqlSession = SqlSessionUtils.getSqlSession();<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings>DynamicSQLMapper mapper = sqlSession.getMapper(DynamicSQLMapper.class);<settings>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
26. </settings>Emp emp1 = new Emp(null,"a",1,"男","123@qq.com");<settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings>Emp emp2 = new Emp(null,"b",1,"男","123@321.com");<settings>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
40. </settings>Emp emp3 = new Emp(null,"c",1,"男","123@321.com");<settings>
41. <plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins>
44. <plugins>
45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
47. </settings>List emps = Arrays.asList(emp1, emp2, emp3);<settings>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins>
51. <plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
54. </settings>mapper.insertMoreByList(emps);<settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings>System.out.println(emps);<plugins>
62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
63. </plugins>}}

复制代码

SQL标签

sql片段，可以记录一段公共sql片段，在使用的地方通过include标签进行引入

1. <sql id="empColumns">eid,emp_name,age,sex,email</sql>
3. <select id="getEmpByCondition" resultType="Emp">
4.         select <include refid="empColumns"></include> from t_emp
5. </select>

复制代码

MyBatis缓存

MyBatis一级缓存

一级缓存是SqlSession级别的，通过同一个SqlSession查询的数据会被缓存，下次查询相同的数据，就会从缓存中直接获取，不会从数据库重新访问
使一级缓存失效的四种情况：

• 不同的SqlSession对应不同的一级缓存
  
• 同一个SqlSession但是查询条件不同
  
• 同一个SqlSession两次查询期间执行了任何一次增删改操作
  
• 同一个SqlSession两次查询期间手动清空了缓存
  

MyBatis二级缓存

二级缓存是SqlSessionFactory级别，通过同一个SqlSessionFactory创建的SqlSession查询的结果会被缓存；此后若再次执行相同的查询语句，结果就会从缓存中获取
二级缓存开启的条件:

• 在核心配置文件中，设置全局配置属性cacheEnabled=“true”，默认为true，不需要设置
  
• 在xml映射文件中设置标签
  
• 二级缓存必须在SqlSession关闭或提交之后有效
  
• 查询的数据所转换的实体类类型必须实现序列化的接口
  
• 使二级缓存失效的情况：两次查询之间执行了任意的增删改，会使一级和二级缓存同时失效
  

二级缓存相关配置

在mapper配置文件中添加的cache标签可以设置一些属性:
eviction属性：缓存回收策略

• LRU（Least Recently Used） – 最近最少使用的：移除最长时间不被使用的对象。
  
• FIFO（First in First out） – 先进先出：按对象进入缓存的顺序来移除它们。
  
• SOFT – 软引用：移除基于垃圾回收器状态和软引用规则的对象。
  
• WEAK – 弱引用：更积极地移除基于垃圾收集器状态和弱引用规则的对象。
  
• 默认的是 LRU
  

flushInterval属性：刷新间隔，单位毫秒

• 默认情况是不设置，也就是没有刷新间隔，缓存仅仅调用语句（增删改）时刷新
  

size属性：引用数目，正整数

• 代表缓存最多可以存储多少个对象，太大容易导致内存溢出
  

readOnly属性：只读，true/false

• true：只读缓存；会给所有调用者返回缓存对象的相同实例。因此这些对象不能被修改。这提供了很重要的性能优势。
  
• false：读写缓存；会返回缓存对象的拷贝（通过序列化）。这会慢一些，但是安全，因此默认是false
  

MyBatis缓存查询顺序

• 先查询二级缓存，因为二级缓存中可能会有其他程序已经查出来的数据，可以拿来直接使用
  
• 如果二级缓存没有命中，再查询一级缓存
  
• 如果一级缓存也没有命中，则查询数据库
  
• SqlSession关闭之后，一级缓存中的数据会写入二级缓存
  

整合第三方缓存

向pom.xml中添加依赖

1. <dependency>
2.         <groupId>org.mybatis.caches</groupId>
3.         <artifactId>mybatis-ehcache</artifactId>
4.         <version>1.2.1</version>
5. </dependency>
7. <dependency>
8.         <groupId>ch.qos.logback</groupId>
9.         <artifactId>logback-classic</artifactId>
10.         <version>1.2.3</version>
11. </dependency>

复制代码

resources下创建ehcache.xml文件

1. <settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>

复制代码

设置二级缓存类型

mapper.xml的cache标签中

1. [/code][size=3]加入logback日志[/size]
3. [code]<settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings><settings>
11. <plugins>
12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
13. </plugins>
14. <plugins>
15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
16. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
17. </settings><settings>
18. <plugins>
19.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
20. </plugins>
21. <plugins>
22.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
23. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
24. </settings><settings>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins>
28. <plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
31. </settings><settings>
32. <plugins>
33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
34. </plugins>
35. <plugins>
36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
37. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
38. </settings><settings>
39. <plugins>
40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
41. </plugins>
42. <plugins>
43.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
44. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
45. </settings><plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins>[%d{HH:mm:ss.SSS}] [%-5level] [%thread] [%logger] [%msg]%n<settings>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins>
51. <plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
54. </settings><settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings><settings>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins>
65. <plugins>
66.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
67. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
68. </settings><settings>
69. <plugins>
70.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
71. </plugins>
72. <plugins>
73.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
74. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
75. </settings><settings>
76. <plugins>
77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
78. </plugins>
79. <plugins>
80.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
81. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
82. </settings><settings>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins>
86. <plugins>
87.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
88. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
89. </settings><plugins>
90.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
91. </plugins>

复制代码

MyBatis逆向工程

正向工程：先创建Java实体类，由框架负责根据实体类生成数据库表。Hibernate是支持正向工程的。
逆向工程：先创建数据库表，由框架负责根据数据库表，反向生成Java实体类，Mapper接口，Mapper映射文件。

创建逆向工程的步骤

1.添加依赖和插件

pom.xml

1. jar<settings>
2. <plugins>
3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
4. </plugins>
5. <plugins>
6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
8. </settings><settings>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
15. </settings>org.mybatis<settings>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins>
19. <plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
22. </settings>mybatis<settings>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins>
26. <plugins>
27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
29. </settings>3.5.10<settings>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins>
33. <plugins>
34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
35. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
36. </settings><settings>
37. <plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins>
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
43. </settings><plugins>
44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
45. </plugins>junit<settings>
46. <plugins>
47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
48. </plugins>
49. <plugins>
50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
51. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
52. </settings>junit<settings>
53. <plugins>
54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
55. </plugins>
56. <plugins>
57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
58. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
59. </settings>4.12<settings>
60. <plugins>
61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
62. </plugins>
63. <plugins>
64.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
65. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
66. </settings>test<settings>
67. <plugins>
68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
69. </plugins>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
73. </settings><settings>
74. <plugins>
75.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
76. </plugins>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
80. </settings><plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins>mysql<settings>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins>
86. <plugins>
87.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
88. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
89. </settings>mysql-connector-java<settings>
90. <plugins>
91.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
92. </plugins>
93. <plugins>
94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
95. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
96. </settings>8.0.30<settings>
97. <plugins>
98.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
99. </plugins>
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
103. </settings><settings>
104. <plugins>
105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
106. </plugins>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
110. </settings><plugins>
111.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
112. </plugins>log4j<settings>
113. <plugins>
114.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
115. </plugins>
116. <plugins>
117.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
118. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
119. </settings>log4j<settings>
120. <plugins>
121.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
122. </plugins>
123. <plugins>
124.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
125. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
126. </settings>1.2.17<settings>
127. <plugins>
128.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
129. </plugins>
130. <plugins>
131.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
132. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
133. </settings><settings>
134. <plugins>
135.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
136. </plugins>
137. <plugins>
138.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
139. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
140. </settings><settings>
141. <plugins>
142.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
143. </plugins>
144. <plugins>
145.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
146. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
147. </settings><settings>
148. <plugins>
149.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
150. </plugins>
151. <plugins>
152.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
153. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
154. </settings><settings>
155. <plugins>
156.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
157. </plugins>
158. <plugins>
159.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
160. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
161. </settings>org.mybatis.generator<settings>
162. <plugins>
163.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
164. </plugins>
165. <plugins>
166.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
167. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
168. </settings><plugins>
169.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
170. </plugins>mybatis-generator-maven-plugin<settings>
171. <plugins>
172.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
173. </plugins>
174. <plugins>
175.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
176. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
177. </settings><plugins>
178.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
179. </plugins>1.3.0<settings>
180. <plugins>
181.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
182. </plugins>
183. <plugins>
184.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
185. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
186. </settings><settings>
187. <plugins>
188.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
189. </plugins>
190. <plugins>
191.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
192. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
193. </settings><settings>
194. <plugins>
195.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
196. </plugins>
197. <plugins>
198.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
199. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
200. </settings><settings>
201. <plugins>
202.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
203. </plugins>
204. <plugins>
205.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
206. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
207. </settings><settings>
208. <plugins>
209.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
210. </plugins>
211. <plugins>
212.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
213. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
214. </settings><settings>
215. <plugins>
216.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
217. </plugins>
218. <plugins>
219.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
220. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
221. </settings><settings>
222. <plugins>
223.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
224. </plugins>
225. <plugins>
226.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
227. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
228. </settings><settings>
229. <plugins>
230.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
231. </plugins>
232. <plugins>
233.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
234. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
235. </settings><settings>
236. <plugins>
237.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
238. </plugins>
239. <plugins>
240.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
241. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
242. </settings><plugins>
243.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
244. </plugins>org.mybatis.generator<settings>
245. <plugins>
246.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
247. </plugins>
248. <plugins>
249.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
250. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
251. </settings><settings>
252. <plugins>
253.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
254. </plugins>
255. <plugins>
256.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
257. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
258. </settings><plugins>
259.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
260. </plugins>mybatis-generator-core<settings>
261. <plugins>
262.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
263. </plugins>
264. <plugins>
265.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
266. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
267. </settings><settings>
268. <plugins>
269.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
270. </plugins>
271. <plugins>
272.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
273. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
274. </settings><plugins>
275.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
276. </plugins>1.3.2<settings>
277. <plugins>
278.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
279. </plugins>
280. <plugins>
281.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
282. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
283. </settings><settings>
284. <plugins>
285.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
286. </plugins>
287. <plugins>
288.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
289. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
290. </settings><settings>
291. <plugins>
292.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
293. </plugins>
294. <plugins>
295.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
296. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
297. </settings><settings>
298. <plugins>
299.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
300. </plugins>
301. <plugins>
302.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
303. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
304. </settings><settings>
305. <plugins>
306.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
307. </plugins>
308. <plugins>
309.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
310. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
311. </settings><settings>
312. <plugins>
313.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
314. </plugins>
315. <plugins>
316.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
317. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
318. </settings><settings>
319. <plugins>
320.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
321. </plugins>
322. <plugins>
323.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
324. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
325. </settings><settings>
326. <plugins>
327.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
328. </plugins>
329. <plugins>
330.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
331. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
332. </settings><plugins>
333.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
334. </plugins>com.mchange<settings>
335. <plugins>
336.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
337. </plugins>
338. <plugins>
339.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
340. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
341. </settings><settings>
342. <plugins>
343.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
344. </plugins>
345. <plugins>
346.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
347. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
348. </settings><plugins>
349.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
350. </plugins>c3p0<settings>
351. <plugins>
352.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
353. </plugins>
354. <plugins>
355.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
356. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
357. </settings><settings>
358. <plugins>
359.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
360. </plugins>
361. <plugins>
362.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
363. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
364. </settings><plugins>
365.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
366. </plugins>0.9.2<settings>
367. <plugins>
368.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
369. </plugins>
370. <plugins>
371.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
372. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
373. </settings><settings>
374. <plugins>
375.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
376. </plugins>
377. <plugins>
378.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
379. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
380. </settings><settings>
381. <plugins>
382.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
383. </plugins>
384. <plugins>
385.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
386. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
387. </settings><settings>
388. <plugins>
389.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
390. </plugins>
391. <plugins>
392.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
393. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
394. </settings><settings>
395. <plugins>
396.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
397. </plugins>
398. <plugins>
399.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
400. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
401. </settings><settings>
402. <plugins>
403.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
404. </plugins>
405. <plugins>
406.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
407. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
408. </settings><settings>
409. <plugins>
410.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
411. </plugins>
412. <plugins>
413.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
414. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
415. </settings><settings>
416. <plugins>
417.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
418. </plugins>
419. <plugins>
420.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
421. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
422. </settings><plugins>
423.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
424. </plugins>mysql<settings>
425. <plugins>
426.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
427. </plugins>
428. <plugins>
429.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
430. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
431. </settings><settings>
432. <plugins>
433.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
434. </plugins>
435. <plugins>
436.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
437. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
438. </settings><plugins>
439.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
440. </plugins>mysql-connector-java<settings>
441. <plugins>
442.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
443. </plugins>
444. <plugins>
445.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
446. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
447. </settings><settings>
448. <plugins>
449.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
450. </plugins>
451. <plugins>
452.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
453. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
454. </settings><plugins>
455.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
456. </plugins>8.0.27<settings>
457. <plugins>
458.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
459. </plugins>
460. <plugins>
461.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
462. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
463. </settings><settings>
464. <plugins>
465.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
466. </plugins>
467. <plugins>
468.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
469. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
470. </settings><settings>
471. <plugins>
472.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
473. </plugins>
474. <plugins>
475.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
476. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
477. </settings><settings>
478. <plugins>
479.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
480. </plugins>
481. <plugins>
482.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
483. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
484. </settings><settings>
485. <plugins>
486.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
487. </plugins>
488. <plugins>
489.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
490. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
491. </settings>

复制代码

2.创建MyBatis核心配置文件

Mybatis.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration
3. <settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings>PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11. <settings>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
18. </settings>"http://mybatis.org/dtd/mybatis-3-config.dtd">
19. <configuration>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><environments default="development">
26. <settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><environment id="development">
34. <settings>
35. <plugins>
36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
37. </plugins>
38. <plugins>
39.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
40. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
41. </settings><plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins><transactionManager type="JDBC"/>
44. <settings>
45. <plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
51. </settings><plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><dataSource type="POOLED">
54. <settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings><settings>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins>
65. <plugins>
66.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
67. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
68. </settings><property name="driver" value="com.mysql.cj.jdbc.Driver"/>
69. <settings>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>
73. <plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
76. </settings><settings>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
83. </settings><property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
84. <settings>
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>
88. <plugins>
89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
91. </settings><settings>
92. <plugins>
93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
94. </plugins>
95. <plugins>
96.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
97. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
98. </settings><property name="username" value="root"/>
99. <settings>
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>
103. <plugins>
104.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
105. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
106. </settings><settings>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins>
110. <plugins>
111.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
112. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
113. </settings><property name="password" value="xxxxxxxxx"/>
114. <settings>
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins>
118. <plugins>
119.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
120. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
121. </settings><plugins>
122.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
123. </plugins></dataSource>
124. <settings>
125. <plugins>
126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
127. </plugins>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
131. </settings></environment>
132. <plugins>
133.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
134. </plugins></environments>
135. <plugins>
136.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
137. </plugins>
138. <plugins>
139.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
140. </plugins><mappers>
141. <settings>
142. <plugins>
143.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
144. </plugins>
145. <plugins>
146.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
147. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
148. </settings><mapper resource="mappers/UserMapper.xml"/>
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins></mappers>
152. </configuration><settings>
153. <plugins>
154.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
155. </plugins>
156. <plugins>
157.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
158. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
159. </settings><plugins>
160.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
161. </plugins>

复制代码

3.将log4j.xml和jdbc.properties复制过来

4.创建逆向工程配置文件

文件名必须是generatorConfig.xml
MyBatis3Simple: 生成基本的CRUD
MyBatis3: 生成带条件的CRUD（使用最多）

generatorConfig.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
2. <!DOCTYPE configuration
3. <settings>
4. <plugins>
5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
6. </plugins>
7. <plugins>
8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
10. </settings>PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
11. <settings>
12. <plugins>
13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
14. </plugins>
15. <plugins>
16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
18. </settings>"http://mybatis.org/dtd/mybatis-3-config.dtd">
19. <configuration>
20. <plugins>
21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
22. </plugins>
23. <plugins>
24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
25. </plugins><environments default="development">
26. <settings>
27. <plugins>
28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
29. </plugins>
30. <plugins>
31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
33. </settings><environment id="development">
34. <settings>
35. <plugins>
36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
37. </plugins>
38. <plugins>
39.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
40. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
41. </settings><plugins>
42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
43. </plugins><transactionManager type="JDBC"/>
44. <settings>
45. <plugins>
46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
47. </plugins>
48. <plugins>
49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
50. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
51. </settings><plugins>
52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
53. </plugins><dataSource type="POOLED">
54. <settings>
55. <plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
61. </settings><settings>
62. <plugins>
63.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
64. </plugins>
65. <plugins>
66.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
67. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
68. </settings><property name="driver" value="com.mysql.cj.jdbc.Driver"/>
69. <settings>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins>
73. <plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
76. </settings><settings>
77. <plugins>
78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
79. </plugins>
80. <plugins>
81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
82. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
83. </settings><property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
84. <settings>
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>
88. <plugins>
89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
91. </settings><settings>
92. <plugins>
93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
94. </plugins>
95. <plugins>
96.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
97. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
98. </settings><property name="username" value="root"/>
99. <settings>
100. <plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>
103. <plugins>
104.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
105. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
106. </settings><settings>
107. <plugins>
108.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
109. </plugins>
110. <plugins>
111.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
112. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
113. </settings><property name="password" value="xxxxxxxxx"/>
114. <settings>
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins>
118. <plugins>
119.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
120. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
121. </settings><plugins>
122.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
123. </plugins></dataSource>
124. <settings>
125. <plugins>
126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
127. </plugins>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
131. </settings></environment>
132. <plugins>
133.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
134. </plugins></environments>
135. <plugins>
136.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
137. </plugins>
138. <plugins>
139.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
140. </plugins><mappers>
141. <settings>
142. <plugins>
143.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
144. </plugins>
145. <plugins>
146.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
147. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
148. </settings><mapper resource="mappers/UserMapper.xml"/>
149. <plugins>
150.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
151. </plugins></mappers>
152. </configuration><settings>
153. <plugins>
154.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
155. </plugins>
156. <plugins>
157.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
158. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
159. </settings><settings>
160. <plugins>
161.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
162. </plugins>
163. <plugins>
164.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
165. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
166. </settings><settings>
167. <plugins>
168.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
169. </plugins>
170. <plugins>
171.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
172. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
173. </settings><settings>
174. <plugins>
175.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
176. </plugins>
177. <plugins>
178.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
179. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
180. </settings><settings>
181. <plugins>
182.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
183. </plugins>
184. <plugins>
185.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
186. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
187. </settings><settings>
188. <plugins>
189.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
190. </plugins>
191. <plugins>
192.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
193. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
194. </settings><settings>
195. <plugins>
196.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
197. </plugins>
198. <plugins>
199.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
200. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
201. </settings><plugins>
202.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
203. </plugins>[table]<settings>
204. <plugins>
205.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
206. </plugins>
207. <plugins>
208.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
209. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
210. </settings>[table]<plugins>
211.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
212. </plugins>

复制代码

5.执行MBG插件的generate目标

双击mybatis-generator:generate

6.通过Example进行查询演示

1. public class MBGTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testMBG(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>try {<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings><plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins>InputStream is= Resources.getResourceAsStream("mybatis-config.xml");<settings>
22. <plugins>
23.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
24. </plugins>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
28. </settings><plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins>SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);<settings>
31. <plugins>
32.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
33. </plugins>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
37. </settings><plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins>SqlSession sqlSession=sqlSessionFactory.openSession(true);<settings>
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>
43. <plugins>
44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
45. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
46. </settings><plugins>
47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
48. </plugins>EmpMapper mapper=sqlSession.getMapper(EmpMapper.class);<settings>
49. <plugins>
50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
51. </plugins>
52. <plugins>
53.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
54. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
55. </settings><plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>//查询所有//<settings>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins>
61. <plugins>
62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
63. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
64. </settings><plugins>
65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
66. </plugins>List list=mapper.selectByExample(null);//<settings>
67. <plugins>
68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
69. </plugins>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
73. </settings><plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins>list.forEach(emp-> System.out.println(emp));<settings>
76. <plugins>
77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
78. </plugins>
79. <plugins>
80.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
81. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
82. </settings><plugins>
83.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
84. </plugins>//条件查询<settings>
85. <plugins>
86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
87. </plugins>
88. <plugins>
89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
91. </settings><plugins>
92.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
93. </plugins>EmpExample example=new EmpExample();<settings>
94. <plugins>
95.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
96. </plugins>
97. <plugins>
98.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
99. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
100. </settings><plugins>
101.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
102. </plugins>example.createCriteria().andEmpNameEqualTo("张三").andAgeGreaterThanOrEqualTo(11);<settings>
103. <plugins>
104.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
105. </plugins>
106. <plugins>
107.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
108. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
109. </settings><plugins>
110.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
111. </plugins>List list=mapper.selectByExample(example);<settings>
112. <plugins>
113.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
114. </plugins>
115. <plugins>
116.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
117. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
118. </settings><plugins>
119.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
120. </plugins>list.forEach(emp-> System.out.println(emp));<settings>
121. <plugins>
122.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
123. </plugins>
124. <plugins>
125.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
126. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
127. </settings>} catch (IOException e) {<settings>
128. <plugins>
129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
130. </plugins>
131. <plugins>
132.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
133. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
134. </settings><plugins>
135.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
136. </plugins>e.printStackTrace();<settings>
137. <plugins>
138.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
139. </plugins>
140. <plugins>
141.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
142. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
143. </settings>}<plugins>
144.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
145. </plugins>}}

复制代码

分页插件

步骤

添加依赖

1. <dependency>
2.         <groupId>com.github.pagehelper</groupId>
3.         <artifactId>pagehelper</artifactId>
4.         <version>5.2.0</version>
5. </dependency>

复制代码

配置插件

1. <plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>

复制代码

开启分页功能

1. public class PageHelperTest {<plugins>
2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
3. </plugins>@Test<plugins>
4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
5. </plugins>public void testPageHelper(){<settings>
6. <plugins>
7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
8. </plugins>
9. <plugins>
10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
12. </settings>try {<settings>
13. <plugins>
14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
15. </plugins>
16. <plugins>
17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
19. </settings><plugins>
20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
21. </plugins>InputStream is= Resources.getResourceAsStream("mybatis-config.xml");<settings>
22. <plugins>
23.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
24. </plugins>
25. <plugins>
26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
27. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
28. </settings><plugins>
29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
30. </plugins>SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);<settings>
31. <plugins>
32.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
33. </plugins>
34. <plugins>
35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
36. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
37. </settings><plugins>
38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
39. </plugins>SqlSession sqlSession=sqlSessionFactory.openSession(true);<settings>
40. <plugins>
41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
42. </plugins>
43. <plugins>
44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
45. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
46. </settings><plugins>
47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
48. </plugins>EmpMapper mapper=sqlSession.getMapper(EmpMapper.class);<settings>
49. <plugins>
50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
51. </plugins>
52. <plugins>
53.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
54. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
55. </settings><plugins>
56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
57. </plugins>PageHelper.startPage(1,4);<settings>
58. <plugins>
59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
60. </plugins>
61. <plugins>
62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
63. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
64. </settings><plugins>
65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
66. </plugins>List list = mapper.selectByExample(null);<settings>
67. <plugins>
68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
69. </plugins>
70. <plugins>
71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
72. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
73. </settings><plugins>
74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
75. </plugins>list.forEach(emp-> System.out.println(emp));<settings>
76. <plugins>
77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
78. </plugins>
79. <plugins>
80.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
81. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
82. </settings>} catch (IOException e) {<settings>
83. <plugins>
84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
85. </plugins>
86. <plugins>
87.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
88. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
89. </settings><plugins>
90.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
91. </plugins>e.printStackTrace();<settings>
92. <plugins>
93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
94. </plugins>
95. <plugins>
96.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
97. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
98. </settings>}<plugins>
99.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
100. </plugins>}}

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！

---

欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/)

Powered by Discuz! X3.4