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

标题: mybatis学习笔记 [打印本页]

---

作者: 惊落一身雪    时间: 2022-10-16 20:56
标题: mybatis学习笔记
1、简介

1.1、什么是 MyBatis？

MyBatis 是一款优秀的持久层框架，它支持自定义 SQL、存储过程以及高级映射。MyBatis 免除了几乎所有的 JDBC 代码以及设置参数和获取结果集的工作。MyBatis 可以通过简单的 XML 或注解来配置和映射原始类型、接口和 Java POJO（Plain Old Java Objects，普通老式 Java 对象）为数据库中的记录。
MyBatis本是apache的一个开源项目iBatis，2010年这个项目由apache software foundation迁移到了google code，并且改名为MyBatis。2013年11月迁移到Github。
1.2、持久化

数据持久化

• 持久化就是将程序的数据在持久状态和瞬时状态转化的过程
  
• 内存:断电即失
  
• 数据库(Jdbc), io文件持久化。
  
• 生活:冷藏.罐头。
  

为什么需要需要持久化?

• 有一些对象，不能让他丢掉。
  
• 内存太贵了
  

1.3、持久层

Dao层，Service层，Controller层...

• 完成持久化工作的代码块
  
• 层界限十分明显。
  

1.4、为什么需要Mybatis

• 帮助程序猿将数据存入到数据库中。
  
• 方便
  
• 传统的JDBC代码太复杂了。简化。框架。自动化。
  
• 不用Mybatis也可以。 更容易上手。技术没有高低之分
  
• 优点:简单
  
  
  
  • 易学
    
  • 灵活
    
  • sq|和代码的分离,提高了可维护性。
    
  • 提供映射标签，支持对象与数据库的orm字段关系映射
    
  • 提供对象关系映射标签，支持对象关系组建维护
    
  • 提供xml标签,支持编写动态sql。
    
  
  

重要的一点:使用的人多!
2、第一个Mybatis程序

思路：搭建环境-->导入Mybatis-->编写代码-->测试
2.1、搭建环境

创建SQL表：

1. CREATE TABLE `user`<typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>(
6. <typeAliases>
7. <mappers>
8.   <package name="org.mybatis.builder"/>
9. </mappers><package name="domain.blog"/>
10. </typeAliases>`id` int(0) NOT NULL AUTO_INCREMENT,
11. <typeAliases>
12. <mappers>
13.   <package name="org.mybatis.builder"/>
14. </mappers><package name="domain.blog"/>
15. </typeAliases>`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'null',
16. <typeAliases>
17. <mappers>
18.   <package name="org.mybatis.builder"/>
19. </mappers><package name="domain.blog"/>
20. </typeAliases>`pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
21. <typeAliases>
22. <mappers>
23.   <package name="org.mybatis.builder"/>
24. </mappers><package name="domain.blog"/>
25. </typeAliases>PRIMARY KEY (`id`) USING BTREE
26. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
29. INSERT INTO `user` VALUES (1, '老大', '123456');
30. INSERT INTO `user` VALUES (2, '李二', '123456');
31. INSERT INTO `user` VALUES (3, '张三', '123456');
32. INSERT INTO `user` VALUES (4, '李四', '123456');

复制代码

新建一个maven项目
导入依赖

1. <dependencies><typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. <properties resource="org/mybatis/example/config.properties">
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="username" value="dev_user"/>
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
17. </properties><dependency><properties resource="org/mybatis/example/config.properties">
18. <typeAliases>
19. <mappers>
20.   <package name="org.mybatis.builder"/>
21. </mappers><package name="domain.blog"/>
22. </typeAliases><property name="username" value="dev_user"/>
23. <typeAliases>
24. <mappers>
25.   <package name="org.mybatis.builder"/>
26. </mappers><package name="domain.blog"/>
27. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
28. </properties><properties resource="org/mybatis/example/config.properties">
29. <typeAliases>
30. <mappers>
31.   <package name="org.mybatis.builder"/>
32. </mappers><package name="domain.blog"/>
33. </typeAliases><property name="username" value="dev_user"/>
34. <typeAliases>
35. <mappers>
36.   <package name="org.mybatis.builder"/>
37. </mappers><package name="domain.blog"/>
38. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
39. </properties>
40.         <properties resource="org/mybatis/example/config.properties">
41. <typeAliases>
42. <mappers>
43.   <package name="org.mybatis.builder"/>
44. </mappers><package name="domain.blog"/>
45. </typeAliases><property name="username" value="dev_user"/>
46. <typeAliases>
47. <mappers>
48.   <package name="org.mybatis.builder"/>
49. </mappers><package name="domain.blog"/>
50. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
51. </properties><groupId>mysql</groupId><typeAliases>
52. <mappers>
53.   <package name="org.mybatis.builder"/>
54. </mappers><package name="domain.blog"/>
55. </typeAliases>
56.         <properties resource="org/mybatis/example/config.properties">
57. <typeAliases>
58. <mappers>
59.   <package name="org.mybatis.builder"/>
60. </mappers><package name="domain.blog"/>
61. </typeAliases><property name="username" value="dev_user"/>
62. <typeAliases>
63. <mappers>
64.   <package name="org.mybatis.builder"/>
65. </mappers><package name="domain.blog"/>
66. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
67. </properties><artifactId>mysql-connector-java</artifactId><typeAliases>
68. <mappers>
69.   <package name="org.mybatis.builder"/>
70. </mappers><package name="domain.blog"/>
71. </typeAliases>
72.         <properties resource="org/mybatis/example/config.properties">
73. <typeAliases>
74. <mappers>
75.   <package name="org.mybatis.builder"/>
76. </mappers><package name="domain.blog"/>
77. </typeAliases><property name="username" value="dev_user"/>
78. <typeAliases>
79. <mappers>
80.   <package name="org.mybatis.builder"/>
81. </mappers><package name="domain.blog"/>
82. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
83. </properties><version>8.0.29</version><typeAliases>
84. <mappers>
85.   <package name="org.mybatis.builder"/>
86. </mappers><package name="domain.blog"/>
87. </typeAliases>
88. <properties resource="org/mybatis/example/config.properties">
89. <typeAliases>
90. <mappers>
91.   <package name="org.mybatis.builder"/>
92. </mappers><package name="domain.blog"/>
93. </typeAliases><property name="username" value="dev_user"/>
94. <typeAliases>
95. <mappers>
96.   <package name="org.mybatis.builder"/>
97. </mappers><package name="domain.blog"/>
98. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
99. </properties></dependency><typeAliases>
100. <mappers>
101.   <package name="org.mybatis.builder"/>
102. </mappers><package name="domain.blog"/>
103. </typeAliases>
104. <properties resource="org/mybatis/example/config.properties">
105. <typeAliases>
106. <mappers>
107.   <package name="org.mybatis.builder"/>
108. </mappers><package name="domain.blog"/>
109. </typeAliases><property name="username" value="dev_user"/>
110. <typeAliases>
111. <mappers>
112.   <package name="org.mybatis.builder"/>
113. </mappers><package name="domain.blog"/>
114. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
115. </properties><typeAliases>
116. <mappers>
117.   <package name="org.mybatis.builder"/>
118. </mappers><package name="domain.blog"/>
119. </typeAliases>
120. <properties resource="org/mybatis/example/config.properties">
121. <typeAliases>
122. <mappers>
123.   <package name="org.mybatis.builder"/>
124. </mappers><package name="domain.blog"/>
125. </typeAliases><property name="username" value="dev_user"/>
126. <typeAliases>
127. <mappers>
128.   <package name="org.mybatis.builder"/>
129. </mappers><package name="domain.blog"/>
130. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
131. </properties><dependency><typeAliases>
132. <mappers>
133.   <package name="org.mybatis.builder"/>
134. </mappers><package name="domain.blog"/>
135. </typeAliases>
136. <properties resource="org/mybatis/example/config.properties">
137. <typeAliases>
138. <mappers>
139.   <package name="org.mybatis.builder"/>
140. </mappers><package name="domain.blog"/>
141. </typeAliases><property name="username" value="dev_user"/>
142. <typeAliases>
143. <mappers>
144.   <package name="org.mybatis.builder"/>
145. </mappers><package name="domain.blog"/>
146. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
147. </properties><properties resource="org/mybatis/example/config.properties">
148. <typeAliases>
149. <mappers>
150.   <package name="org.mybatis.builder"/>
151. </mappers><package name="domain.blog"/>
152. </typeAliases><property name="username" value="dev_user"/>
153. <typeAliases>
154. <mappers>
155.   <package name="org.mybatis.builder"/>
156. </mappers><package name="domain.blog"/>
157. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
158. </properties><groupId>org.mybatis</groupId><typeAliases>
159. <mappers>
160.   <package name="org.mybatis.builder"/>
161. </mappers><package name="domain.blog"/>
162. </typeAliases>
163. <properties resource="org/mybatis/example/config.properties">
164. <typeAliases>
165. <mappers>
166.   <package name="org.mybatis.builder"/>
167. </mappers><package name="domain.blog"/>
168. </typeAliases><property name="username" value="dev_user"/>
169. <typeAliases>
170. <mappers>
171.   <package name="org.mybatis.builder"/>
172. </mappers><package name="domain.blog"/>
173. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
174. </properties><properties resource="org/mybatis/example/config.properties">
175. <typeAliases>
176. <mappers>
177.   <package name="org.mybatis.builder"/>
178. </mappers><package name="domain.blog"/>
179. </typeAliases><property name="username" value="dev_user"/>
180. <typeAliases>
181. <mappers>
182.   <package name="org.mybatis.builder"/>
183. </mappers><package name="domain.blog"/>
184. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
185. </properties><artifactId>mybatis</artifactId><typeAliases>
186. <mappers>
187.   <package name="org.mybatis.builder"/>
188. </mappers><package name="domain.blog"/>
189. </typeAliases>
190. <properties resource="org/mybatis/example/config.properties">
191. <typeAliases>
192. <mappers>
193.   <package name="org.mybatis.builder"/>
194. </mappers><package name="domain.blog"/>
195. </typeAliases><property name="username" value="dev_user"/>
196. <typeAliases>
197. <mappers>
198.   <package name="org.mybatis.builder"/>
199. </mappers><package name="domain.blog"/>
200. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
201. </properties><properties resource="org/mybatis/example/config.properties">
202. <typeAliases>
203. <mappers>
204.   <package name="org.mybatis.builder"/>
205. </mappers><package name="domain.blog"/>
206. </typeAliases><property name="username" value="dev_user"/>
207. <typeAliases>
208. <mappers>
209.   <package name="org.mybatis.builder"/>
210. </mappers><package name="domain.blog"/>
211. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
212. </properties><version>3.5.10</version><typeAliases>
213. <mappers>
214.   <package name="org.mybatis.builder"/>
215. </mappers><package name="domain.blog"/>
216. </typeAliases>
217. <properties resource="org/mybatis/example/config.properties">
218. <typeAliases>
219. <mappers>
220.   <package name="org.mybatis.builder"/>
221. </mappers><package name="domain.blog"/>
222. </typeAliases><property name="username" value="dev_user"/>
223. <typeAliases>
224. <mappers>
225.   <package name="org.mybatis.builder"/>
226. </mappers><package name="domain.blog"/>
227. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
228. </properties></dependency><typeAliases>
229. <mappers>
230.   <package name="org.mybatis.builder"/>
231. </mappers><package name="domain.blog"/>
232. </typeAliases>
233. <properties resource="org/mybatis/example/config.properties">
234. <typeAliases>
235. <mappers>
236.   <package name="org.mybatis.builder"/>
237. </mappers><package name="domain.blog"/>
238. </typeAliases><property name="username" value="dev_user"/>
239. <typeAliases>
240. <mappers>
241.   <package name="org.mybatis.builder"/>
242. </mappers><package name="domain.blog"/>
243. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
244. </properties><dependency><properties resource="org/mybatis/example/config.properties">
245. <typeAliases>
246. <mappers>
247.   <package name="org.mybatis.builder"/>
248. </mappers><package name="domain.blog"/>
249. </typeAliases><property name="username" value="dev_user"/>
250. <typeAliases>
251. <mappers>
252.   <package name="org.mybatis.builder"/>
253. </mappers><package name="domain.blog"/>
254. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
255. </properties><properties resource="org/mybatis/example/config.properties">
256. <typeAliases>
257. <mappers>
258.   <package name="org.mybatis.builder"/>
259. </mappers><package name="domain.blog"/>
260. </typeAliases><property name="username" value="dev_user"/>
261. <typeAliases>
262. <mappers>
263.   <package name="org.mybatis.builder"/>
264. </mappers><package name="domain.blog"/>
265. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
266. </properties>
267.         <properties resource="org/mybatis/example/config.properties">
268. <typeAliases>
269. <mappers>
270.   <package name="org.mybatis.builder"/>
271. </mappers><package name="domain.blog"/>
272. </typeAliases><property name="username" value="dev_user"/>
273. <typeAliases>
274. <mappers>
275.   <package name="org.mybatis.builder"/>
276. </mappers><package name="domain.blog"/>
277. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
278. </properties><groupId>junit</groupId><typeAliases>
279. <mappers>
280.   <package name="org.mybatis.builder"/>
281. </mappers><package name="domain.blog"/>
282. </typeAliases>
283. <properties resource="org/mybatis/example/config.properties">
284. <typeAliases>
285. <mappers>
286.   <package name="org.mybatis.builder"/>
287. </mappers><package name="domain.blog"/>
288. </typeAliases><property name="username" value="dev_user"/>
289. <typeAliases>
290. <mappers>
291.   <package name="org.mybatis.builder"/>
292. </mappers><package name="domain.blog"/>
293. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
294. </properties><properties resource="org/mybatis/example/config.properties">
295. <typeAliases>
296. <mappers>
297.   <package name="org.mybatis.builder"/>
298. </mappers><package name="domain.blog"/>
299. </typeAliases><property name="username" value="dev_user"/>
300. <typeAliases>
301. <mappers>
302.   <package name="org.mybatis.builder"/>
303. </mappers><package name="domain.blog"/>
304. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
305. </properties><artifactId>junit</artifactId><typeAliases>
306. <mappers>
307.   <package name="org.mybatis.builder"/>
308. </mappers><package name="domain.blog"/>
309. </typeAliases>
310. <properties resource="org/mybatis/example/config.properties">
311. <typeAliases>
312. <mappers>
313.   <package name="org.mybatis.builder"/>
314. </mappers><package name="domain.blog"/>
315. </typeAliases><property name="username" value="dev_user"/>
316. <typeAliases>
317. <mappers>
318.   <package name="org.mybatis.builder"/>
319. </mappers><package name="domain.blog"/>
320. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
321. </properties><properties resource="org/mybatis/example/config.properties">
322. <typeAliases>
323. <mappers>
324.   <package name="org.mybatis.builder"/>
325. </mappers><package name="domain.blog"/>
326. </typeAliases><property name="username" value="dev_user"/>
327. <typeAliases>
328. <mappers>
329.   <package name="org.mybatis.builder"/>
330. </mappers><package name="domain.blog"/>
331. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
332. </properties><version>3.8.1</version><typeAliases>
333. <mappers>
334.   <package name="org.mybatis.builder"/>
335. </mappers><package name="domain.blog"/>
336. </typeAliases>
337. <properties resource="org/mybatis/example/config.properties">
338. <typeAliases>
339. <mappers>
340.   <package name="org.mybatis.builder"/>
341. </mappers><package name="domain.blog"/>
342. </typeAliases><property name="username" value="dev_user"/>
343. <typeAliases>
344. <mappers>
345.   <package name="org.mybatis.builder"/>
346. </mappers><package name="domain.blog"/>
347. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
348. </properties></dependency><typeAliases>
349. <mappers>
350.   <package name="org.mybatis.builder"/>
351. </mappers><package name="domain.blog"/>
352. </typeAliases>
353. </dependencies>

复制代码

编写Mybatis的核心配置文件

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

复制代码

2.2、第一个mybati程序

编写Mybatis工具类

1. public class MybatisUtil {<typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. <properties resource="org/mybatis/example/config.properties">
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="username" value="dev_user"/>
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
17. </properties>private static SqlSessionFactory sqlSessionFactory;<typeAliases>
18. <mappers>
19.   <package name="org.mybatis.builder"/>
20. </mappers><package name="domain.blog"/>
21. </typeAliases>
22. <properties resource="org/mybatis/example/config.properties">
23. <typeAliases>
24. <mappers>
25.   <package name="org.mybatis.builder"/>
26. </mappers><package name="domain.blog"/>
27. </typeAliases><property name="username" value="dev_user"/>
28. <typeAliases>
29. <mappers>
30.   <package name="org.mybatis.builder"/>
31. </mappers><package name="domain.blog"/>
32. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
33. </properties>static {<typeAliases>
34. <mappers>
35.   <package name="org.mybatis.builder"/>
36. </mappers><package name="domain.blog"/>
37. </typeAliases>
38. <properties resource="org/mybatis/example/config.properties">
39. <typeAliases>
40. <mappers>
41.   <package name="org.mybatis.builder"/>
42. </mappers><package name="domain.blog"/>
43. </typeAliases><property name="username" value="dev_user"/>
44. <typeAliases>
45. <mappers>
46.   <package name="org.mybatis.builder"/>
47. </mappers><package name="domain.blog"/>
48. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
49. </properties><properties resource="org/mybatis/example/config.properties">
50. <typeAliases>
51. <mappers>
52.   <package name="org.mybatis.builder"/>
53. </mappers><package name="domain.blog"/>
54. </typeAliases><property name="username" value="dev_user"/>
55. <typeAliases>
56. <mappers>
57.   <package name="org.mybatis.builder"/>
58. </mappers><package name="domain.blog"/>
59. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
60. </properties>try{<typeAliases>
61. <mappers>
62.   <package name="org.mybatis.builder"/>
63. </mappers><package name="domain.blog"/>
64. </typeAliases>
65. <properties resource="org/mybatis/example/config.properties">
66. <typeAliases>
67. <mappers>
68.   <package name="org.mybatis.builder"/>
69. </mappers><package name="domain.blog"/>
70. </typeAliases><property name="username" value="dev_user"/>
71. <typeAliases>
72. <mappers>
73.   <package name="org.mybatis.builder"/>
74. </mappers><package name="domain.blog"/>
75. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
76. </properties><properties resource="org/mybatis/example/config.properties">
77. <typeAliases>
78. <mappers>
79.   <package name="org.mybatis.builder"/>
80. </mappers><package name="domain.blog"/>
81. </typeAliases><property name="username" value="dev_user"/>
82. <typeAliases>
83. <mappers>
84.   <package name="org.mybatis.builder"/>
85. </mappers><package name="domain.blog"/>
86. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
87. </properties><properties resource="org/mybatis/example/config.properties">
88. <typeAliases>
89. <mappers>
90.   <package name="org.mybatis.builder"/>
91. </mappers><package name="domain.blog"/>
92. </typeAliases><property name="username" value="dev_user"/>
93. <typeAliases>
94. <mappers>
95.   <package name="org.mybatis.builder"/>
96. </mappers><package name="domain.blog"/>
97. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
98. </properties>String resource = "mybatis-config.xml";<typeAliases>
99. <mappers>
100.   <package name="org.mybatis.builder"/>
101. </mappers><package name="domain.blog"/>
102. </typeAliases>
103. <properties resource="org/mybatis/example/config.properties">
104. <typeAliases>
105. <mappers>
106.   <package name="org.mybatis.builder"/>
107. </mappers><package name="domain.blog"/>
108. </typeAliases><property name="username" value="dev_user"/>
109. <typeAliases>
110. <mappers>
111.   <package name="org.mybatis.builder"/>
112. </mappers><package name="domain.blog"/>
113. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
114. </properties><properties resource="org/mybatis/example/config.properties">
115. <typeAliases>
116. <mappers>
117.   <package name="org.mybatis.builder"/>
118. </mappers><package name="domain.blog"/>
119. </typeAliases><property name="username" value="dev_user"/>
120. <typeAliases>
121. <mappers>
122.   <package name="org.mybatis.builder"/>
123. </mappers><package name="domain.blog"/>
124. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
125. </properties><properties resource="org/mybatis/example/config.properties">
126. <typeAliases>
127. <mappers>
128.   <package name="org.mybatis.builder"/>
129. </mappers><package name="domain.blog"/>
130. </typeAliases><property name="username" value="dev_user"/>
131. <typeAliases>
132. <mappers>
133.   <package name="org.mybatis.builder"/>
134. </mappers><package name="domain.blog"/>
135. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
136. </properties>InputStream inputStream = Resources.getResourceAsStream(resource);<typeAliases>
137. <mappers>
138.   <package name="org.mybatis.builder"/>
139. </mappers><package name="domain.blog"/>
140. </typeAliases>
141. <properties resource="org/mybatis/example/config.properties">
142. <typeAliases>
143. <mappers>
144.   <package name="org.mybatis.builder"/>
145. </mappers><package name="domain.blog"/>
146. </typeAliases><property name="username" value="dev_user"/>
147. <typeAliases>
148. <mappers>
149.   <package name="org.mybatis.builder"/>
150. </mappers><package name="domain.blog"/>
151. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
152. </properties><properties resource="org/mybatis/example/config.properties">
153. <typeAliases>
154. <mappers>
155.   <package name="org.mybatis.builder"/>
156. </mappers><package name="domain.blog"/>
157. </typeAliases><property name="username" value="dev_user"/>
158. <typeAliases>
159. <mappers>
160.   <package name="org.mybatis.builder"/>
161. </mappers><package name="domain.blog"/>
162. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
163. </properties><properties resource="org/mybatis/example/config.properties">
164. <typeAliases>
165. <mappers>
166.   <package name="org.mybatis.builder"/>
167. </mappers><package name="domain.blog"/>
168. </typeAliases><property name="username" value="dev_user"/>
169. <typeAliases>
170. <mappers>
171.   <package name="org.mybatis.builder"/>
172. </mappers><package name="domain.blog"/>
173. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
174. </properties>sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);<typeAliases>
175. <mappers>
176.   <package name="org.mybatis.builder"/>
177. </mappers><package name="domain.blog"/>
178. </typeAliases>
179. <properties resource="org/mybatis/example/config.properties">
180. <typeAliases>
181. <mappers>
182.   <package name="org.mybatis.builder"/>
183. </mappers><package name="domain.blog"/>
184. </typeAliases><property name="username" value="dev_user"/>
185. <typeAliases>
186. <mappers>
187.   <package name="org.mybatis.builder"/>
188. </mappers><package name="domain.blog"/>
189. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
190. </properties><properties resource="org/mybatis/example/config.properties">
191. <typeAliases>
192. <mappers>
193.   <package name="org.mybatis.builder"/>
194. </mappers><package name="domain.blog"/>
195. </typeAliases><property name="username" value="dev_user"/>
196. <typeAliases>
197. <mappers>
198.   <package name="org.mybatis.builder"/>
199. </mappers><package name="domain.blog"/>
200. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
201. </properties>}catch (IOException e){<typeAliases>
202. <mappers>
203.   <package name="org.mybatis.builder"/>
204. </mappers><package name="domain.blog"/>
205. </typeAliases>
206. <properties resource="org/mybatis/example/config.properties">
207. <typeAliases>
208. <mappers>
209.   <package name="org.mybatis.builder"/>
210. </mappers><package name="domain.blog"/>
211. </typeAliases><property name="username" value="dev_user"/>
212. <typeAliases>
213. <mappers>
214.   <package name="org.mybatis.builder"/>
215. </mappers><package name="domain.blog"/>
216. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
217. </properties><properties resource="org/mybatis/example/config.properties">
218. <typeAliases>
219. <mappers>
220.   <package name="org.mybatis.builder"/>
221. </mappers><package name="domain.blog"/>
222. </typeAliases><property name="username" value="dev_user"/>
223. <typeAliases>
224. <mappers>
225.   <package name="org.mybatis.builder"/>
226. </mappers><package name="domain.blog"/>
227. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
228. </properties><properties resource="org/mybatis/example/config.properties">
229. <typeAliases>
230. <mappers>
231.   <package name="org.mybatis.builder"/>
232. </mappers><package name="domain.blog"/>
233. </typeAliases><property name="username" value="dev_user"/>
234. <typeAliases>
235. <mappers>
236.   <package name="org.mybatis.builder"/>
237. </mappers><package name="domain.blog"/>
238. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
239. </properties>e.printStackTrace();<typeAliases>
240. <mappers>
241.   <package name="org.mybatis.builder"/>
242. </mappers><package name="domain.blog"/>
243. </typeAliases>
244. <properties resource="org/mybatis/example/config.properties">
245. <typeAliases>
246. <mappers>
247.   <package name="org.mybatis.builder"/>
248. </mappers><package name="domain.blog"/>
249. </typeAliases><property name="username" value="dev_user"/>
250. <typeAliases>
251. <mappers>
252.   <package name="org.mybatis.builder"/>
253. </mappers><package name="domain.blog"/>
254. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
255. </properties><properties resource="org/mybatis/example/config.properties">
256. <typeAliases>
257. <mappers>
258.   <package name="org.mybatis.builder"/>
259. </mappers><package name="domain.blog"/>
260. </typeAliases><property name="username" value="dev_user"/>
261. <typeAliases>
262. <mappers>
263.   <package name="org.mybatis.builder"/>
264. </mappers><package name="domain.blog"/>
265. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
266. </properties>}<typeAliases>
267. <mappers>
268.   <package name="org.mybatis.builder"/>
269. </mappers><package name="domain.blog"/>
270. </typeAliases>
271. <properties resource="org/mybatis/example/config.properties">
272. <typeAliases>
273. <mappers>
274.   <package name="org.mybatis.builder"/>
275. </mappers><package name="domain.blog"/>
276. </typeAliases><property name="username" value="dev_user"/>
277. <typeAliases>
278. <mappers>
279.   <package name="org.mybatis.builder"/>
280. </mappers><package name="domain.blog"/>
281. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
282. </properties>}<typeAliases>
283. <mappers>
284.   <package name="org.mybatis.builder"/>
285. </mappers><package name="domain.blog"/>
286. </typeAliases>
287. <properties resource="org/mybatis/example/config.properties">
288. <typeAliases>
289. <mappers>
290.   <package name="org.mybatis.builder"/>
291. </mappers><package name="domain.blog"/>
292. </typeAliases><property name="username" value="dev_user"/>
293. <typeAliases>
294. <mappers>
295.   <package name="org.mybatis.builder"/>
296. </mappers><package name="domain.blog"/>
297. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
298. </properties><typeAliases>
299. <mappers>
300.   <package name="org.mybatis.builder"/>
301. </mappers><package name="domain.blog"/>
302. </typeAliases>
303. <properties resource="org/mybatis/example/config.properties">
304. <typeAliases>
305. <mappers>
306.   <package name="org.mybatis.builder"/>
307. </mappers><package name="domain.blog"/>
308. </typeAliases><property name="username" value="dev_user"/>
309. <typeAliases>
310. <mappers>
311.   <package name="org.mybatis.builder"/>
312. </mappers><package name="domain.blog"/>
313. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
314. </properties>public SqlSession getSqlSession(){<typeAliases>
315. <mappers>
316.   <package name="org.mybatis.builder"/>
317. </mappers><package name="domain.blog"/>
318. </typeAliases>
319. <properties resource="org/mybatis/example/config.properties">
320. <typeAliases>
321. <mappers>
322.   <package name="org.mybatis.builder"/>
323. </mappers><package name="domain.blog"/>
324. </typeAliases><property name="username" value="dev_user"/>
325. <typeAliases>
326. <mappers>
327.   <package name="org.mybatis.builder"/>
328. </mappers><package name="domain.blog"/>
329. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
330. </properties><properties resource="org/mybatis/example/config.properties">
331. <typeAliases>
332. <mappers>
333.   <package name="org.mybatis.builder"/>
334. </mappers><package name="domain.blog"/>
335. </typeAliases><property name="username" value="dev_user"/>
336. <typeAliases>
337. <mappers>
338.   <package name="org.mybatis.builder"/>
339. </mappers><package name="domain.blog"/>
340. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
341. </properties>return sqlSessionFactory.openSession();<typeAliases>
342. <mappers>
343.   <package name="org.mybatis.builder"/>
344. </mappers><package name="domain.blog"/>
345. </typeAliases>
346. <properties resource="org/mybatis/example/config.properties">
347. <typeAliases>
348. <mappers>
349.   <package name="org.mybatis.builder"/>
350. </mappers><package name="domain.blog"/>
351. </typeAliases><property name="username" value="dev_user"/>
352. <typeAliases>
353. <mappers>
354.   <package name="org.mybatis.builder"/>
355. </mappers><package name="domain.blog"/>
356. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
357. </properties>}<typeAliases>
358. <mappers>
359.   <package name="org.mybatis.builder"/>
360. </mappers><package name="domain.blog"/>
361. </typeAliases>
362. }

复制代码

编写代码

1. @Test<typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. public void t(){<typeAliases>
7. <mappers>
8.   <package name="org.mybatis.builder"/>
9. </mappers><package name="domain.blog"/>
10. </typeAliases>
11. <properties resource="org/mybatis/example/config.properties">
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="username" value="dev_user"/>
17. <typeAliases>
18. <mappers>
19.   <package name="org.mybatis.builder"/>
20. </mappers><package name="domain.blog"/>
21. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
22. </properties>SqlSession sqlSession = MybatisUtil.getSqlSession();<typeAliases>
23. <mappers>
24.   <package name="org.mybatis.builder"/>
25. </mappers><package name="domain.blog"/>
26. </typeAliases>
27. <properties resource="org/mybatis/example/config.properties">
28. <typeAliases>
29. <mappers>
30.   <package name="org.mybatis.builder"/>
31. </mappers><package name="domain.blog"/>
32. </typeAliases><property name="username" value="dev_user"/>
33. <typeAliases>
34. <mappers>
35.   <package name="org.mybatis.builder"/>
36. </mappers><package name="domain.blog"/>
37. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
38. </properties>UserMapper mapper = sqlSession.getMapper(UserMapper.class);<typeAliases>
39. <mappers>
40.   <package name="org.mybatis.builder"/>
41. </mappers><package name="domain.blog"/>
42. </typeAliases>
43. <properties resource="org/mybatis/example/config.properties">
44. <typeAliases>
45. <mappers>
46.   <package name="org.mybatis.builder"/>
47. </mappers><package name="domain.blog"/>
48. </typeAliases><property name="username" value="dev_user"/>
49. <typeAliases>
50. <mappers>
51.   <package name="org.mybatis.builder"/>
52. </mappers><package name="domain.blog"/>
53. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
54. </properties>List<User> userList = mapper.getUserList();<typeAliases>
55. <mappers>
56.   <package name="org.mybatis.builder"/>
57. </mappers><package name="domain.blog"/>
58. </typeAliases>
59. <properties resource="org/mybatis/example/config.properties">
60. <typeAliases>
61. <mappers>
62.   <package name="org.mybatis.builder"/>
63. </mappers><package name="domain.blog"/>
64. </typeAliases><property name="username" value="dev_user"/>
65. <typeAliases>
66. <mappers>
67.   <package name="org.mybatis.builder"/>
68. </mappers><package name="domain.blog"/>
69. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
70. </properties>for (User user : userList) {<typeAliases>
71. <mappers>
72.   <package name="org.mybatis.builder"/>
73. </mappers><package name="domain.blog"/>
74. </typeAliases>
75. <properties resource="org/mybatis/example/config.properties">
76. <typeAliases>
77. <mappers>
78.   <package name="org.mybatis.builder"/>
79. </mappers><package name="domain.blog"/>
80. </typeAliases><property name="username" value="dev_user"/>
81. <typeAliases>
82. <mappers>
83.   <package name="org.mybatis.builder"/>
84. </mappers><package name="domain.blog"/>
85. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
86. </properties><properties resource="org/mybatis/example/config.properties">
87. <typeAliases>
88. <mappers>
89.   <package name="org.mybatis.builder"/>
90. </mappers><package name="domain.blog"/>
91. </typeAliases><property name="username" value="dev_user"/>
92. <typeAliases>
93. <mappers>
94.   <package name="org.mybatis.builder"/>
95. </mappers><package name="domain.blog"/>
96. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
97. </properties>System.out.println(user);<typeAliases>
98. <mappers>
99.   <package name="org.mybatis.builder"/>
100. </mappers><package name="domain.blog"/>
101. </typeAliases>
102. <properties resource="org/mybatis/example/config.properties">
103. <typeAliases>
104. <mappers>
105.   <package name="org.mybatis.builder"/>
106. </mappers><package name="domain.blog"/>
107. </typeAliases><property name="username" value="dev_user"/>
108. <typeAliases>
109. <mappers>
110.   <package name="org.mybatis.builder"/>
111. </mappers><package name="domain.blog"/>
112. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
113. </properties>}<typeAliases>
114. <mappers>
115.   <package name="org.mybatis.builder"/>
116. </mappers><package name="domain.blog"/>
117. </typeAliases>
118. <properties resource="org/mybatis/example/config.properties">
119. <typeAliases>
120. <mappers>
121.   <package name="org.mybatis.builder"/>
122. </mappers><package name="domain.blog"/>
123. </typeAliases><property name="username" value="dev_user"/>
124. <typeAliases>
125. <mappers>
126.   <package name="org.mybatis.builder"/>
127. </mappers><package name="domain.blog"/>
128. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
129. </properties>sqlSession.close();<typeAliases>
130. <mappers>
131.   <package name="org.mybatis.builder"/>
132. </mappers><package name="domain.blog"/>
133. </typeAliases>
134. }

复制代码

2.3、比较容易出现的问题

1、全局配置文件没有注册mapper，mapper配置路径要用 / 隔开

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

复制代码

2、mapper映射文件

1. <?xml version="1.0" encoding="UTF-8" ?><typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. <!DOCTYPE mapper<typeAliases>
7. <mappers>
8.   <package name="org.mybatis.builder"/>
9. </mappers><package name="domain.blog"/>
10. </typeAliases>
11. <properties resource="org/mybatis/example/config.properties">
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="username" value="dev_user"/>
17. <typeAliases>
18. <mappers>
19.   <package name="org.mybatis.builder"/>
20. </mappers><package name="domain.blog"/>
21. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
22. </properties><properties resource="org/mybatis/example/config.properties">
23. <typeAliases>
24. <mappers>
25.   <package name="org.mybatis.builder"/>
26. </mappers><package name="domain.blog"/>
27. </typeAliases><property name="username" value="dev_user"/>
28. <typeAliases>
29. <mappers>
30.   <package name="org.mybatis.builder"/>
31. </mappers><package name="domain.blog"/>
32. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
33. </properties>PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"<typeAliases>
34. <mappers>
35.   <package name="org.mybatis.builder"/>
36. </mappers><package name="domain.blog"/>
37. </typeAliases>
38. <properties resource="org/mybatis/example/config.properties">
39. <typeAliases>
40. <mappers>
41.   <package name="org.mybatis.builder"/>
42. </mappers><package name="domain.blog"/>
43. </typeAliases><property name="username" value="dev_user"/>
44. <typeAliases>
45. <mappers>
46.   <package name="org.mybatis.builder"/>
47. </mappers><package name="domain.blog"/>
48. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
49. </properties><properties resource="org/mybatis/example/config.properties">
50. <typeAliases>
51. <mappers>
52.   <package name="org.mybatis.builder"/>
53. </mappers><package name="domain.blog"/>
54. </typeAliases><property name="username" value="dev_user"/>
55. <typeAliases>
56. <mappers>
57.   <package name="org.mybatis.builder"/>
58. </mappers><package name="domain.blog"/>
59. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
60. </properties>"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><typeAliases>
61. <mappers>
62.   <package name="org.mybatis.builder"/>
63. </mappers><package name="domain.blog"/>
64. </typeAliases>
65. <mapper namespace="com.zh.mapper.UserMapper"><typeAliases>
66. <mappers>
67.   <package name="org.mybatis.builder"/>
68. </mappers><package name="domain.blog"/>
69. </typeAliases>一个命名空间对应一个dao类
70. <properties resource="org/mybatis/example/config.properties">
71. <typeAliases>
72. <mappers>
73.   <package name="org.mybatis.builder"/>
74. </mappers><package name="domain.blog"/>
75. </typeAliases><property name="username" value="dev_user"/>
76. <typeAliases>
77. <mappers>
78.   <package name="org.mybatis.builder"/>
79. </mappers><package name="domain.blog"/>
80. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
81. </properties><select id="getUserList" resultType="com.zh.pojo.User"><typeAliases>
82. <mappers>
83.   <package name="org.mybatis.builder"/>
84. </mappers><package name="domain.blog"/>
85. </typeAliases>//id对应方法。返回结果对实体类对象
86. <properties resource="org/mybatis/example/config.properties">
87. <typeAliases>
88. <mappers>
89.   <package name="org.mybatis.builder"/>
90. </mappers><package name="domain.blog"/>
91. </typeAliases><property name="username" value="dev_user"/>
92. <typeAliases>
93. <mappers>
94.   <package name="org.mybatis.builder"/>
95. </mappers><package name="domain.blog"/>
96. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
97. </properties><properties resource="org/mybatis/example/config.properties">
98. <typeAliases>
99. <mappers>
100.   <package name="org.mybatis.builder"/>
101. </mappers><package name="domain.blog"/>
102. </typeAliases><property name="username" value="dev_user"/>
103. <typeAliases>
104. <mappers>
105.   <package name="org.mybatis.builder"/>
106. </mappers><package name="domain.blog"/>
107. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
108. </properties>select * from mybatis.user<typeAliases>
109. <mappers>
110.   <package name="org.mybatis.builder"/>
111. </mappers><package name="domain.blog"/>
112. </typeAliases>
113. <properties resource="org/mybatis/example/config.properties">
114. <typeAliases>
115. <mappers>
116.   <package name="org.mybatis.builder"/>
117. </mappers><package name="domain.blog"/>
118. </typeAliases><property name="username" value="dev_user"/>
119. <typeAliases>
120. <mappers>
121.   <package name="org.mybatis.builder"/>
122. </mappers><package name="domain.blog"/>
123. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
124. </properties></select><typeAliases>
125. <mappers>
126.   <package name="org.mybatis.builder"/>
127. </mappers><package name="domain.blog"/>
128. </typeAliases>
129. </mapper>

复制代码

3、资源文件导出问题，由于maven项目的约定大于配置，默认只会导出resources目录的文件，但是在mybatis项目中，mapper推荐把映射配置文件放在和dao类同一级目录，会导致加载不到配置文件，所以要进行设置

1. <build><typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. <properties resource="org/mybatis/example/config.properties">
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="username" value="dev_user"/>
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
17. </properties><resources>
18.                 <resource>
19.                         <directory>src/main/resources</directory><typeAliases>
20. <mappers>
21.   <package name="org.mybatis.builder"/>
22. </mappers><package name="domain.blog"/>
23. </typeAliases>
24. <properties resource="org/mybatis/example/config.properties">
25. <typeAliases>
26. <mappers>
27.   <package name="org.mybatis.builder"/>
28. </mappers><package name="domain.blog"/>
29. </typeAliases><property name="username" value="dev_user"/>
30. <typeAliases>
31. <mappers>
32.   <package name="org.mybatis.builder"/>
33. </mappers><package name="domain.blog"/>
34. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
35. </properties><properties resource="org/mybatis/example/config.properties">
36. <typeAliases>
37. <mappers>
38.   <package name="org.mybatis.builder"/>
39. </mappers><package name="domain.blog"/>
40. </typeAliases><property name="username" value="dev_user"/>
41. <typeAliases>
42. <mappers>
43.   <package name="org.mybatis.builder"/>
44. </mappers><package name="domain.blog"/>
45. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
46. </properties><properties resource="org/mybatis/example/config.properties">
47. <typeAliases>
48. <mappers>
49.   <package name="org.mybatis.builder"/>
50. </mappers><package name="domain.blog"/>
51. </typeAliases><property name="username" value="dev_user"/>
52. <typeAliases>
53. <mappers>
54.   <package name="org.mybatis.builder"/>
55. </mappers><package name="domain.blog"/>
56. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
57. </properties><includes><properties resource="org/mybatis/example/config.properties">
58. <typeAliases>
59. <mappers>
60.   <package name="org.mybatis.builder"/>
61. </mappers><package name="domain.blog"/>
62. </typeAliases><property name="username" value="dev_user"/>
63. <typeAliases>
64. <mappers>
65.   <package name="org.mybatis.builder"/>
66. </mappers><package name="domain.blog"/>
67. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
68. </properties><properties resource="org/mybatis/example/config.properties">
69. <typeAliases>
70. <mappers>
71.   <package name="org.mybatis.builder"/>
72. </mappers><package name="domain.blog"/>
73. </typeAliases><property name="username" value="dev_user"/>
74. <typeAliases>
75. <mappers>
76.   <package name="org.mybatis.builder"/>
77. </mappers><package name="domain.blog"/>
78. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
79. </properties><properties resource="org/mybatis/example/config.properties">
80. <typeAliases>
81. <mappers>
82.   <package name="org.mybatis.builder"/>
83. </mappers><package name="domain.blog"/>
84. </typeAliases><property name="username" value="dev_user"/>
85. <typeAliases>
86. <mappers>
87.   <package name="org.mybatis.builder"/>
88. </mappers><package name="domain.blog"/>
89. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
90. </properties><properties resource="org/mybatis/example/config.properties">
91. <typeAliases>
92. <mappers>
93.   <package name="org.mybatis.builder"/>
94. </mappers><package name="domain.blog"/>
95. </typeAliases><property name="username" value="dev_user"/>
96. <typeAliases>
97. <mappers>
98.   <package name="org.mybatis.builder"/>
99. </mappers><package name="domain.blog"/>
100. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
101. </properties>
102.         <properties resource="org/mybatis/example/config.properties">
103. <typeAliases>
104. <mappers>
105.   <package name="org.mybatis.builder"/>
106. </mappers><package name="domain.blog"/>
107. </typeAliases><property name="username" value="dev_user"/>
108. <typeAliases>
109. <mappers>
110.   <package name="org.mybatis.builder"/>
111. </mappers><package name="domain.blog"/>
112. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
113. </properties><properties resource="org/mybatis/example/config.properties">
114. <typeAliases>
115. <mappers>
116.   <package name="org.mybatis.builder"/>
117. </mappers><package name="domain.blog"/>
118. </typeAliases><property name="username" value="dev_user"/>
119. <typeAliases>
120. <mappers>
121.   <package name="org.mybatis.builder"/>
122. </mappers><package name="domain.blog"/>
123. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
124. </properties><properties resource="org/mybatis/example/config.properties">
125. <typeAliases>
126. <mappers>
127.   <package name="org.mybatis.builder"/>
128. </mappers><package name="domain.blog"/>
129. </typeAliases><property name="username" value="dev_user"/>
130. <typeAliases>
131. <mappers>
132.   <package name="org.mybatis.builder"/>
133. </mappers><package name="domain.blog"/>
134. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
135. </properties><include>**/*.properties</include><typeAliases>
136. <mappers>
137.   <package name="org.mybatis.builder"/>
138. </mappers><package name="domain.blog"/>
139. </typeAliases>
140. <properties resource="org/mybatis/example/config.properties">
141. <typeAliases>
142. <mappers>
143.   <package name="org.mybatis.builder"/>
144. </mappers><package name="domain.blog"/>
145. </typeAliases><property name="username" value="dev_user"/>
146. <typeAliases>
147. <mappers>
148.   <package name="org.mybatis.builder"/>
149. </mappers><package name="domain.blog"/>
150. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
151. </properties><properties resource="org/mybatis/example/config.properties">
152. <typeAliases>
153. <mappers>
154.   <package name="org.mybatis.builder"/>
155. </mappers><package name="domain.blog"/>
156. </typeAliases><property name="username" value="dev_user"/>
157. <typeAliases>
158. <mappers>
159.   <package name="org.mybatis.builder"/>
160. </mappers><package name="domain.blog"/>
161. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
162. </properties><properties resource="org/mybatis/example/config.properties">
163. <typeAliases>
164. <mappers>
165.   <package name="org.mybatis.builder"/>
166. </mappers><package name="domain.blog"/>
167. </typeAliases><property name="username" value="dev_user"/>
168. <typeAliases>
169. <mappers>
170.   <package name="org.mybatis.builder"/>
171. </mappers><package name="domain.blog"/>
172. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
173. </properties><properties resource="org/mybatis/example/config.properties">
174. <typeAliases>
175. <mappers>
176.   <package name="org.mybatis.builder"/>
177. </mappers><package name="domain.blog"/>
178. </typeAliases><property name="username" value="dev_user"/>
179. <typeAliases>
180. <mappers>
181.   <package name="org.mybatis.builder"/>
182. </mappers><package name="domain.blog"/>
183. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
184. </properties><include>**/*.xml</include><typeAliases>
185. <mappers>
186.   <package name="org.mybatis.builder"/>
187. </mappers><package name="domain.blog"/>
188. </typeAliases>
189. <properties resource="org/mybatis/example/config.properties">
190. <typeAliases>
191. <mappers>
192.   <package name="org.mybatis.builder"/>
193. </mappers><package name="domain.blog"/>
194. </typeAliases><property name="username" value="dev_user"/>
195. <typeAliases>
196. <mappers>
197.   <package name="org.mybatis.builder"/>
198. </mappers><package name="domain.blog"/>
199. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
200. </properties><properties resource="org/mybatis/example/config.properties">
201. <typeAliases>
202. <mappers>
203.   <package name="org.mybatis.builder"/>
204. </mappers><package name="domain.blog"/>
205. </typeAliases><property name="username" value="dev_user"/>
206. <typeAliases>
207. <mappers>
208.   <package name="org.mybatis.builder"/>
209. </mappers><package name="domain.blog"/>
210. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
211. </properties><properties resource="org/mybatis/example/config.properties">
212. <typeAliases>
213. <mappers>
214.   <package name="org.mybatis.builder"/>
215. </mappers><package name="domain.blog"/>
216. </typeAliases><property name="username" value="dev_user"/>
217. <typeAliases>
218. <mappers>
219.   <package name="org.mybatis.builder"/>
220. </mappers><package name="domain.blog"/>
221. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
222. </properties></includes><properties resource="org/mybatis/example/config.properties">
223. <typeAliases>
224. <mappers>
225.   <package name="org.mybatis.builder"/>
226. </mappers><package name="domain.blog"/>
227. </typeAliases><property name="username" value="dev_user"/>
228. <typeAliases>
229. <mappers>
230.   <package name="org.mybatis.builder"/>
231. </mappers><package name="domain.blog"/>
232. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
233. </properties><properties resource="org/mybatis/example/config.properties">
234. <typeAliases>
235. <mappers>
236.   <package name="org.mybatis.builder"/>
237. </mappers><package name="domain.blog"/>
238. </typeAliases><property name="username" value="dev_user"/>
239. <typeAliases>
240. <mappers>
241.   <package name="org.mybatis.builder"/>
242. </mappers><package name="domain.blog"/>
243. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
244. </properties><typeAliases>
245. <mappers>
246.   <package name="org.mybatis.builder"/>
247. </mappers><package name="domain.blog"/>
248. </typeAliases>
249. <properties resource="org/mybatis/example/config.properties">
250. <typeAliases>
251. <mappers>
252.   <package name="org.mybatis.builder"/>
253. </mappers><package name="domain.blog"/>
254. </typeAliases><property name="username" value="dev_user"/>
255. <typeAliases>
256. <mappers>
257.   <package name="org.mybatis.builder"/>
258. </mappers><package name="domain.blog"/>
259. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
260. </properties><properties resource="org/mybatis/example/config.properties">
261. <typeAliases>
262. <mappers>
263.   <package name="org.mybatis.builder"/>
264. </mappers><package name="domain.blog"/>
265. </typeAliases><property name="username" value="dev_user"/>
266. <typeAliases>
267. <mappers>
268.   <package name="org.mybatis.builder"/>
269. </mappers><package name="domain.blog"/>
270. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
271. </properties><properties resource="org/mybatis/example/config.properties">
272. <typeAliases>
273. <mappers>
274.   <package name="org.mybatis.builder"/>
275. </mappers><package name="domain.blog"/>
276. </typeAliases><property name="username" value="dev_user"/>
277. <typeAliases>
278. <mappers>
279.   <package name="org.mybatis.builder"/>
280. </mappers><package name="domain.blog"/>
281. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
282. </properties><filtering>true</filtering><typeAliases>
283. <mappers>
284.   <package name="org.mybatis.builder"/>
285. </mappers><package name="domain.blog"/>
286. </typeAliases>
287. <properties resource="org/mybatis/example/config.properties">
288. <typeAliases>
289. <mappers>
290.   <package name="org.mybatis.builder"/>
291. </mappers><package name="domain.blog"/>
292. </typeAliases><property name="username" value="dev_user"/>
293. <typeAliases>
294. <mappers>
295.   <package name="org.mybatis.builder"/>
296. </mappers><package name="domain.blog"/>
297. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
298. </properties><properties resource="org/mybatis/example/config.properties">
299. <typeAliases>
300. <mappers>
301.   <package name="org.mybatis.builder"/>
302. </mappers><package name="domain.blog"/>
303. </typeAliases><property name="username" value="dev_user"/>
304. <typeAliases>
305. <mappers>
306.   <package name="org.mybatis.builder"/>
307. </mappers><package name="domain.blog"/>
308. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
309. </properties></resource>
310. <properties resource="org/mybatis/example/config.properties">
311. <typeAliases>
312. <mappers>
313.   <package name="org.mybatis.builder"/>
314. </mappers><package name="domain.blog"/>
315. </typeAliases><property name="username" value="dev_user"/>
316. <typeAliases>
317. <mappers>
318.   <package name="org.mybatis.builder"/>
319. </mappers><package name="domain.blog"/>
320. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
321. </properties><properties resource="org/mybatis/example/config.properties">
322. <typeAliases>
323. <mappers>
324.   <package name="org.mybatis.builder"/>
325. </mappers><package name="domain.blog"/>
326. </typeAliases><property name="username" value="dev_user"/>
327. <typeAliases>
328. <mappers>
329.   <package name="org.mybatis.builder"/>
330. </mappers><package name="domain.blog"/>
331. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
332. </properties>
333. <properties resource="org/mybatis/example/config.properties">
334. <typeAliases>
335. <mappers>
336.   <package name="org.mybatis.builder"/>
337. </mappers><package name="domain.blog"/>
338. </typeAliases><property name="username" value="dev_user"/>
339. <typeAliases>
340. <mappers>
341.   <package name="org.mybatis.builder"/>
342. </mappers><package name="domain.blog"/>
343. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
344. </properties><properties resource="org/mybatis/example/config.properties">
345. <typeAliases>
346. <mappers>
347.   <package name="org.mybatis.builder"/>
348. </mappers><package name="domain.blog"/>
349. </typeAliases><property name="username" value="dev_user"/>
350. <typeAliases>
351. <mappers>
352.   <package name="org.mybatis.builder"/>
353. </mappers><package name="domain.blog"/>
354. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
355. </properties><resource>
356. <properties resource="org/mybatis/example/config.properties">
357. <typeAliases>
358. <mappers>
359.   <package name="org.mybatis.builder"/>
360. </mappers><package name="domain.blog"/>
361. </typeAliases><property name="username" value="dev_user"/>
362. <typeAliases>
363. <mappers>
364.   <package name="org.mybatis.builder"/>
365. </mappers><package name="domain.blog"/>
366. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
367. </properties><properties resource="org/mybatis/example/config.properties">
368. <typeAliases>
369. <mappers>
370.   <package name="org.mybatis.builder"/>
371. </mappers><package name="domain.blog"/>
372. </typeAliases><property name="username" value="dev_user"/>
373. <typeAliases>
374. <mappers>
375.   <package name="org.mybatis.builder"/>
376. </mappers><package name="domain.blog"/>
377. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
378. </properties><properties resource="org/mybatis/example/config.properties">
379. <typeAliases>
380. <mappers>
381.   <package name="org.mybatis.builder"/>
382. </mappers><package name="domain.blog"/>
383. </typeAliases><property name="username" value="dev_user"/>
384. <typeAliases>
385. <mappers>
386.   <package name="org.mybatis.builder"/>
387. </mappers><package name="domain.blog"/>
388. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
389. </properties><directory>src/main/java</directory><typeAliases>
390. <mappers>
391.   <package name="org.mybatis.builder"/>
392. </mappers><package name="domain.blog"/>
393. </typeAliases>
394. <properties resource="org/mybatis/example/config.properties">
395. <typeAliases>
396. <mappers>
397.   <package name="org.mybatis.builder"/>
398. </mappers><package name="domain.blog"/>
399. </typeAliases><property name="username" value="dev_user"/>
400. <typeAliases>
401. <mappers>
402.   <package name="org.mybatis.builder"/>
403. </mappers><package name="domain.blog"/>
404. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
405. </properties><properties resource="org/mybatis/example/config.properties">
406. <typeAliases>
407. <mappers>
408.   <package name="org.mybatis.builder"/>
409. </mappers><package name="domain.blog"/>
410. </typeAliases><property name="username" value="dev_user"/>
411. <typeAliases>
412. <mappers>
413.   <package name="org.mybatis.builder"/>
414. </mappers><package name="domain.blog"/>
415. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
416. </properties><properties resource="org/mybatis/example/config.properties">
417. <typeAliases>
418. <mappers>
419.   <package name="org.mybatis.builder"/>
420. </mappers><package name="domain.blog"/>
421. </typeAliases><property name="username" value="dev_user"/>
422. <typeAliases>
423. <mappers>
424.   <package name="org.mybatis.builder"/>
425. </mappers><package name="domain.blog"/>
426. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
427. </properties><includes><properties resource="org/mybatis/example/config.properties">
428. <typeAliases>
429. <mappers>
430.   <package name="org.mybatis.builder"/>
431. </mappers><package name="domain.blog"/>
432. </typeAliases><property name="username" value="dev_user"/>
433. <typeAliases>
434. <mappers>
435.   <package name="org.mybatis.builder"/>
436. </mappers><package name="domain.blog"/>
437. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
438. </properties><properties resource="org/mybatis/example/config.properties">
439. <typeAliases>
440. <mappers>
441.   <package name="org.mybatis.builder"/>
442. </mappers><package name="domain.blog"/>
443. </typeAliases><property name="username" value="dev_user"/>
444. <typeAliases>
445. <mappers>
446.   <package name="org.mybatis.builder"/>
447. </mappers><package name="domain.blog"/>
448. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
449. </properties><properties resource="org/mybatis/example/config.properties">
450. <typeAliases>
451. <mappers>
452.   <package name="org.mybatis.builder"/>
453. </mappers><package name="domain.blog"/>
454. </typeAliases><property name="username" value="dev_user"/>
455. <typeAliases>
456. <mappers>
457.   <package name="org.mybatis.builder"/>
458. </mappers><package name="domain.blog"/>
459. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
460. </properties><typeAliases>
461. <mappers>
462.   <package name="org.mybatis.builder"/>
463. </mappers><package name="domain.blog"/>
464. </typeAliases>
465.         <properties resource="org/mybatis/example/config.properties">
466. <typeAliases>
467. <mappers>
468.   <package name="org.mybatis.builder"/>
469. </mappers><package name="domain.blog"/>
470. </typeAliases><property name="username" value="dev_user"/>
471. <typeAliases>
472. <mappers>
473.   <package name="org.mybatis.builder"/>
474. </mappers><package name="domain.blog"/>
475. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
476. </properties><properties resource="org/mybatis/example/config.properties">
477. <typeAliases>
478. <mappers>
479.   <package name="org.mybatis.builder"/>
480. </mappers><package name="domain.blog"/>
481. </typeAliases><property name="username" value="dev_user"/>
482. <typeAliases>
483. <mappers>
484.   <package name="org.mybatis.builder"/>
485. </mappers><package name="domain.blog"/>
486. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
487. </properties><properties resource="org/mybatis/example/config.properties">
488. <typeAliases>
489. <mappers>
490.   <package name="org.mybatis.builder"/>
491. </mappers><package name="domain.blog"/>
492. </typeAliases><property name="username" value="dev_user"/>
493. <typeAliases>
494. <mappers>
495.   <package name="org.mybatis.builder"/>
496. </mappers><package name="domain.blog"/>
497. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
498. </properties> <include>**/*.properties</include><typeAliases>
499. <mappers>
500.   <package name="org.mybatis.builder"/>
501. </mappers><package name="domain.blog"/>
502. </typeAliases>
503. <properties resource="org/mybatis/example/config.properties">
504. <typeAliases>
505. <mappers>
506.   <package name="org.mybatis.builder"/>
507. </mappers><package name="domain.blog"/>
508. </typeAliases><property name="username" value="dev_user"/>
509. <typeAliases>
510. <mappers>
511.   <package name="org.mybatis.builder"/>
512. </mappers><package name="domain.blog"/>
513. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
514. </properties><properties resource="org/mybatis/example/config.properties">
515. <typeAliases>
516. <mappers>
517.   <package name="org.mybatis.builder"/>
518. </mappers><package name="domain.blog"/>
519. </typeAliases><property name="username" value="dev_user"/>
520. <typeAliases>
521. <mappers>
522.   <package name="org.mybatis.builder"/>
523. </mappers><package name="domain.blog"/>
524. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
525. </properties><properties resource="org/mybatis/example/config.properties">
526. <typeAliases>
527. <mappers>
528.   <package name="org.mybatis.builder"/>
529. </mappers><package name="domain.blog"/>
530. </typeAliases><property name="username" value="dev_user"/>
531. <typeAliases>
532. <mappers>
533.   <package name="org.mybatis.builder"/>
534. </mappers><package name="domain.blog"/>
535. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
536. </properties><properties resource="org/mybatis/example/config.properties">
537. <typeAliases>
538. <mappers>
539.   <package name="org.mybatis.builder"/>
540. </mappers><package name="domain.blog"/>
541. </typeAliases><property name="username" value="dev_user"/>
542. <typeAliases>
543. <mappers>
544.   <package name="org.mybatis.builder"/>
545. </mappers><package name="domain.blog"/>
546. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
547. </properties> <include>**/*.xml</include><typeAliases>
548. <mappers>
549.   <package name="org.mybatis.builder"/>
550. </mappers><package name="domain.blog"/>
551. </typeAliases>
552. <properties resource="org/mybatis/example/config.properties">
553. <typeAliases>
554. <mappers>
555.   <package name="org.mybatis.builder"/>
556. </mappers><package name="domain.blog"/>
557. </typeAliases><property name="username" value="dev_user"/>
558. <typeAliases>
559. <mappers>
560.   <package name="org.mybatis.builder"/>
561. </mappers><package name="domain.blog"/>
562. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
563. </properties><properties resource="org/mybatis/example/config.properties">
564. <typeAliases>
565. <mappers>
566.   <package name="org.mybatis.builder"/>
567. </mappers><package name="domain.blog"/>
568. </typeAliases><property name="username" value="dev_user"/>
569. <typeAliases>
570. <mappers>
571.   <package name="org.mybatis.builder"/>
572. </mappers><package name="domain.blog"/>
573. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
574. </properties><properties resource="org/mybatis/example/config.properties">
575. <typeAliases>
576. <mappers>
577.   <package name="org.mybatis.builder"/>
578. </mappers><package name="domain.blog"/>
579. </typeAliases><property name="username" value="dev_user"/>
580. <typeAliases>
581. <mappers>
582.   <package name="org.mybatis.builder"/>
583. </mappers><package name="domain.blog"/>
584. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
585. </properties></includes><properties resource="org/mybatis/example/config.properties">
586. <typeAliases>
587. <mappers>
588.   <package name="org.mybatis.builder"/>
589. </mappers><package name="domain.blog"/>
590. </typeAliases><property name="username" value="dev_user"/>
591. <typeAliases>
592. <mappers>
593.   <package name="org.mybatis.builder"/>
594. </mappers><package name="domain.blog"/>
595. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
596. </properties><properties resource="org/mybatis/example/config.properties">
597. <typeAliases>
598. <mappers>
599.   <package name="org.mybatis.builder"/>
600. </mappers><package name="domain.blog"/>
601. </typeAliases><property name="username" value="dev_user"/>
602. <typeAliases>
603. <mappers>
604.   <package name="org.mybatis.builder"/>
605. </mappers><package name="domain.blog"/>
606. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
607. </properties><properties resource="org/mybatis/example/config.properties">
608. <typeAliases>
609. <mappers>
610.   <package name="org.mybatis.builder"/>
611. </mappers><package name="domain.blog"/>
612. </typeAliases><property name="username" value="dev_user"/>
613. <typeAliases>
614. <mappers>
615.   <package name="org.mybatis.builder"/>
616. </mappers><package name="domain.blog"/>
617. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
618. </properties>
619. <properties resource="org/mybatis/example/config.properties">
620. <typeAliases>
621. <mappers>
622.   <package name="org.mybatis.builder"/>
623. </mappers><package name="domain.blog"/>
624. </typeAliases><property name="username" value="dev_user"/>
625. <typeAliases>
626. <mappers>
627.   <package name="org.mybatis.builder"/>
628. </mappers><package name="domain.blog"/>
629. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
630. </properties><properties resource="org/mybatis/example/config.properties">
631. <typeAliases>
632. <mappers>
633.   <package name="org.mybatis.builder"/>
634. </mappers><package name="domain.blog"/>
635. </typeAliases><property name="username" value="dev_user"/>
636. <typeAliases>
637. <mappers>
638.   <package name="org.mybatis.builder"/>
639. </mappers><package name="domain.blog"/>
640. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
641. </properties><properties resource="org/mybatis/example/config.properties">
642. <typeAliases>
643. <mappers>
644.   <package name="org.mybatis.builder"/>
645. </mappers><package name="domain.blog"/>
646. </typeAliases><property name="username" value="dev_user"/>
647. <typeAliases>
648. <mappers>
649.   <package name="org.mybatis.builder"/>
650. </mappers><package name="domain.blog"/>
651. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
652. </properties><filtering>true</filtering><typeAliases>
653. <mappers>
654.   <package name="org.mybatis.builder"/>
655. </mappers><package name="domain.blog"/>
656. </typeAliases>
657.                 </resource><properties resource="org/mybatis/example/config.properties">
658. <typeAliases>
659. <mappers>
660.   <package name="org.mybatis.builder"/>
661. </mappers><package name="domain.blog"/>
662. </typeAliases><property name="username" value="dev_user"/>
663. <typeAliases>
664. <mappers>
665.   <package name="org.mybatis.builder"/>
666. </mappers><package name="domain.blog"/>
667. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
668. </properties>
669.         </resources>
670. </build>

复制代码

3、CRUD

namespace：namespace中的包名要和Dao/mapper接口的包名一致!
数据的增删改需要手动提交数据！！！

• **#{}是预编译处理，mybatis在处理#{}时，会将其替换成"?"，再调用PreparedStatement的set方法来赋值。
  
• ${}是拼接字符串，将接收到的参数的内容不加任何修饰的拼接在SQL语句中，会引发SQL注入问题
  

select

• id:就是对应的namespace中的方法名;
  
• resultType: Sq|语句执行的返回值
  
• parameterType :参数类型（可以是对象）
  1.编写接口
  

1. User getUserById(int id);

复制代码

2.编写对应的mapper中的sq|语，属性可以直接调用

1. <select id="getUserById" resultType="com.zh.pojo.User"><typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. <properties resource="org/mybatis/example/config.properties">
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="username" value="dev_user"/>
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
17. </properties>select * from user where id=#{id}<typeAliases>
18. <mappers>
19.   <package name="org.mybatis.builder"/>
20. </mappers><package name="domain.blog"/>
21. </typeAliases>
22. </select>

复制代码

3.测试

1. public void t2(){<typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>
6. <properties resource="org/mybatis/example/config.properties">
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="username" value="dev_user"/>
12. <typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
17. </properties>SqlSession sqlSession = MybatisUtil.getSqlSession();<typeAliases>
18. <mappers>
19.   <package name="org.mybatis.builder"/>
20. </mappers><package name="domain.blog"/>
21. </typeAliases>
22. <properties resource="org/mybatis/example/config.properties">
23. <typeAliases>
24. <mappers>
25.   <package name="org.mybatis.builder"/>
26. </mappers><package name="domain.blog"/>
27. </typeAliases><property name="username" value="dev_user"/>
28. <typeAliases>
29. <mappers>
30.   <package name="org.mybatis.builder"/>
31. </mappers><package name="domain.blog"/>
32. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
33. </properties>UserMapper mapper = sqlSession.getMapper(UserMapper.class);<typeAliases>
34. <mappers>
35.   <package name="org.mybatis.builder"/>
36. </mappers><package name="domain.blog"/>
37. </typeAliases>
38. <properties resource="org/mybatis/example/config.properties">
39. <typeAliases>
40. <mappers>
41.   <package name="org.mybatis.builder"/>
42. </mappers><package name="domain.blog"/>
43. </typeAliases><property name="username" value="dev_user"/>
44. <typeAliases>
45. <mappers>
46.   <package name="org.mybatis.builder"/>
47. </mappers><package name="domain.blog"/>
48. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
49. </properties>User user = mapper.getUserById(1);<typeAliases>
50. <mappers>
51.   <package name="org.mybatis.builder"/>
52. </mappers><package name="domain.blog"/>
53. </typeAliases>
54. <properties resource="org/mybatis/example/config.properties">
55. <typeAliases>
56. <mappers>
57.   <package name="org.mybatis.builder"/>
58. </mappers><package name="domain.blog"/>
59. </typeAliases><property name="username" value="dev_user"/>
60. <typeAliases>
61. <mappers>
62.   <package name="org.mybatis.builder"/>
63. </mappers><package name="domain.blog"/>
64. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
65. </properties>System.out.println(user);<typeAliases>
66. <mappers>
67.   <package name="org.mybatis.builder"/>
68. </mappers><package name="domain.blog"/>
69. </typeAliases>
70. <properties resource="org/mybatis/example/config.properties">
71. <typeAliases>
72. <mappers>
73.   <package name="org.mybatis.builder"/>
74. </mappers><package name="domain.blog"/>
75. </typeAliases><property name="username" value="dev_user"/>
76. <typeAliases>
77. <mappers>
78.   <package name="org.mybatis.builder"/>
79. </mappers><package name="domain.blog"/>
80. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
81. </properties>sqlSession.commit();<typeAliases>
82. <mappers>
83.   <package name="org.mybatis.builder"/>
84. </mappers><package name="domain.blog"/>
85. </typeAliases>
86. <properties resource="org/mybatis/example/config.properties">
87. <typeAliases>
88. <mappers>
89.   <package name="org.mybatis.builder"/>
90. </mappers><package name="domain.blog"/>
91. </typeAliases><property name="username" value="dev_user"/>
92. <typeAliases>
93. <mappers>
94.   <package name="org.mybatis.builder"/>
95. </mappers><package name="domain.blog"/>
96. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
97. </properties>sqlSession.close();<typeAliases>
98. <mappers>
99.   <package name="org.mybatis.builder"/>
100. </mappers><package name="domain.blog"/>
101. </typeAliases>
102. }

复制代码

Insert

1. int addUser(User user);
3. <insert id="addUser" parameterType="com.zh.pojo.User" ><typeAliases>
4. <mappers>
5.   <package name="org.mybatis.builder"/>
6. </mappers><package name="domain.blog"/>
7. </typeAliases>
8. <properties resource="org/mybatis/example/config.properties">
9. <typeAliases>
10. <mappers>
11.   <package name="org.mybatis.builder"/>
12. </mappers><package name="domain.blog"/>
13. </typeAliases><property name="username" value="dev_user"/>
14. <typeAliases>
15. <mappers>
16.   <package name="org.mybatis.builder"/>
17. </mappers><package name="domain.blog"/>
18. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
19. </properties>insert into user(id,name,pwd) value (#{id},#{name},#{pwd})<typeAliases>
20. <mappers>
21.   <package name="org.mybatis.builder"/>
22. </mappers><package name="domain.blog"/>
23. </typeAliases>
24. </insert>
27. @Test<typeAliases>
28. <mappers>
29.   <package name="org.mybatis.builder"/>
30. </mappers><package name="domain.blog"/>
31. </typeAliases>
32. public void t3(){<typeAliases>
33. <mappers>
34.   <package name="org.mybatis.builder"/>
35. </mappers><package name="domain.blog"/>
36. </typeAliases>
37. <properties resource="org/mybatis/example/config.properties">
38. <typeAliases>
39. <mappers>
40.   <package name="org.mybatis.builder"/>
41. </mappers><package name="domain.blog"/>
42. </typeAliases><property name="username" value="dev_user"/>
43. <typeAliases>
44. <mappers>
45.   <package name="org.mybatis.builder"/>
46. </mappers><package name="domain.blog"/>
47. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
48. </properties>SqlSession sqlSession = MybatisUtil.getSqlSession();<typeAliases>
49. <mappers>
50.   <package name="org.mybatis.builder"/>
51. </mappers><package name="domain.blog"/>
52. </typeAliases>
53. <properties resource="org/mybatis/example/config.properties">
54. <typeAliases>
55. <mappers>
56.   <package name="org.mybatis.builder"/>
57. </mappers><package name="domain.blog"/>
58. </typeAliases><property name="username" value="dev_user"/>
59. <typeAliases>
60. <mappers>
61.   <package name="org.mybatis.builder"/>
62. </mappers><package name="domain.blog"/>
63. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
64. </properties>UserMapper mapper = sqlSession.getMapper(UserMapper.class);<typeAliases>
65. <mappers>
66.   <package name="org.mybatis.builder"/>
67. </mappers><package name="domain.blog"/>
68. </typeAliases>
69. <properties resource="org/mybatis/example/config.properties">
70. <typeAliases>
71. <mappers>
72.   <package name="org.mybatis.builder"/>
73. </mappers><package name="domain.blog"/>
74. </typeAliases><property name="username" value="dev_user"/>
75. <typeAliases>
76. <mappers>
77.   <package name="org.mybatis.builder"/>
78. </mappers><package name="domain.blog"/>
79. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
80. </properties>int num = mapper.addUser(new User(5, "张三", "123321"));<typeAliases>
81. <mappers>
82.   <package name="org.mybatis.builder"/>
83. </mappers><package name="domain.blog"/>
84. </typeAliases>
85. <properties resource="org/mybatis/example/config.properties">
86. <typeAliases>
87. <mappers>
88.   <package name="org.mybatis.builder"/>
89. </mappers><package name="domain.blog"/>
90. </typeAliases><property name="username" value="dev_user"/>
91. <typeAliases>
92. <mappers>
93.   <package name="org.mybatis.builder"/>
94. </mappers><package name="domain.blog"/>
95. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
96. </properties>System.out.println(num);<typeAliases>
97. <mappers>
98.   <package name="org.mybatis.builder"/>
99. </mappers><package name="domain.blog"/>
100. </typeAliases>
101. <properties resource="org/mybatis/example/config.properties">
102. <typeAliases>
103. <mappers>
104.   <package name="org.mybatis.builder"/>
105. </mappers><package name="domain.blog"/>
106. </typeAliases><property name="username" value="dev_user"/>
107. <typeAliases>
108. <mappers>
109.   <package name="org.mybatis.builder"/>
110. </mappers><package name="domain.blog"/>
111. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
112. </properties>sqlSession.commit();<typeAliases>
113. <mappers>
114.   <package name="org.mybatis.builder"/>
115. </mappers><package name="domain.blog"/>
116. </typeAliases>
117. <properties resource="org/mybatis/example/config.properties">
118. <typeAliases>
119. <mappers>
120.   <package name="org.mybatis.builder"/>
121. </mappers><package name="domain.blog"/>
122. </typeAliases><property name="username" value="dev_user"/>
123. <typeAliases>
124. <mappers>
125.   <package name="org.mybatis.builder"/>
126. </mappers><package name="domain.blog"/>
127. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
128. </properties>sqlSession.close();<typeAliases>
129. <mappers>
130.   <package name="org.mybatis.builder"/>
131. </mappers><package name="domain.blog"/>
132. </typeAliases>
133. }

复制代码

update

1. int updateUser(User user);
4. <update id="updateUser" parameterType="com.zh.pojo.User"><typeAliases>
5. <mappers>
6.   <package name="org.mybatis.builder"/>
7. </mappers><package name="domain.blog"/>
8. </typeAliases>
9. <properties resource="org/mybatis/example/config.properties">
10. <typeAliases>
11. <mappers>
12.   <package name="org.mybatis.builder"/>
13. </mappers><package name="domain.blog"/>
14. </typeAliases><property name="username" value="dev_user"/>
15. <typeAliases>
16. <mappers>
17.   <package name="org.mybatis.builder"/>
18. </mappers><package name="domain.blog"/>
19. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
20. </properties>update user set name = #{name},pwd=#{pwd}where id=#{id};<typeAliases>
21. <mappers>
22.   <package name="org.mybatis.builder"/>
23. </mappers><package name="domain.blog"/>
24. </typeAliases>
25. </update>
28. @Test<typeAliases>
29. <mappers>
30.   <package name="org.mybatis.builder"/>
31. </mappers><package name="domain.blog"/>
32. </typeAliases>
33. public void t4(){<typeAliases>
34. <mappers>
35.   <package name="org.mybatis.builder"/>
36. </mappers><package name="domain.blog"/>
37. </typeAliases>
38. <properties resource="org/mybatis/example/config.properties">
39. <typeAliases>
40. <mappers>
41.   <package name="org.mybatis.builder"/>
42. </mappers><package name="domain.blog"/>
43. </typeAliases><property name="username" value="dev_user"/>
44. <typeAliases>
45. <mappers>
46.   <package name="org.mybatis.builder"/>
47. </mappers><package name="domain.blog"/>
48. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
49. </properties>SqlSession sqlSession = MybatisUtil.getSqlSession();<typeAliases>
50. <mappers>
51.   <package name="org.mybatis.builder"/>
52. </mappers><package name="domain.blog"/>
53. </typeAliases>
54. <properties resource="org/mybatis/example/config.properties">
55. <typeAliases>
56. <mappers>
57.   <package name="org.mybatis.builder"/>
58. </mappers><package name="domain.blog"/>
59. </typeAliases><property name="username" value="dev_user"/>
60. <typeAliases>
61. <mappers>
62.   <package name="org.mybatis.builder"/>
63. </mappers><package name="domain.blog"/>
64. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
65. </properties>UserMapper mapper = sqlSession.getMapper(UserMapper.class);<typeAliases>
66. <mappers>
67.   <package name="org.mybatis.builder"/>
68. </mappers><package name="domain.blog"/>
69. </typeAliases>
70. <properties resource="org/mybatis/example/config.properties">
71. <typeAliases>
72. <mappers>
73.   <package name="org.mybatis.builder"/>
74. </mappers><package name="domain.blog"/>
75. </typeAliases><property name="username" value="dev_user"/>
76. <typeAliases>
77. <mappers>
78.   <package name="org.mybatis.builder"/>
79. </mappers><package name="domain.blog"/>
80. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
81. </properties>int num = mapper.updateUser(new User(5, "哈哈哈哈", "123321"));<typeAliases>
82. <mappers>
83.   <package name="org.mybatis.builder"/>
84. </mappers><package name="domain.blog"/>
85. </typeAliases>
86. <properties resource="org/mybatis/example/config.properties">
87. <typeAliases>
88. <mappers>
89.   <package name="org.mybatis.builder"/>
90. </mappers><package name="domain.blog"/>
91. </typeAliases><property name="username" value="dev_user"/>
92. <typeAliases>
93. <mappers>
94.   <package name="org.mybatis.builder"/>
95. </mappers><package name="domain.blog"/>
96. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
97. </properties>System.out.println(num);<typeAliases>
98. <mappers>
99.   <package name="org.mybatis.builder"/>
100. </mappers><package name="domain.blog"/>
101. </typeAliases>
102. <properties resource="org/mybatis/example/config.properties">
103. <typeAliases>
104. <mappers>
105.   <package name="org.mybatis.builder"/>
106. </mappers><package name="domain.blog"/>
107. </typeAliases><property name="username" value="dev_user"/>
108. <typeAliases>
109. <mappers>
110.   <package name="org.mybatis.builder"/>
111. </mappers><package name="domain.blog"/>
112. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
113. </properties>sqlSession.commit();<typeAliases>
114. <mappers>
115.   <package name="org.mybatis.builder"/>
116. </mappers><package name="domain.blog"/>
117. </typeAliases>
118. <properties resource="org/mybatis/example/config.properties">
119. <typeAliases>
120. <mappers>
121.   <package name="org.mybatis.builder"/>
122. </mappers><package name="domain.blog"/>
123. </typeAliases><property name="username" value="dev_user"/>
124. <typeAliases>
125. <mappers>
126.   <package name="org.mybatis.builder"/>
127. </mappers><package name="domain.blog"/>
128. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
129. </properties>sqlSession.close();<typeAliases>
130. <mappers>
131.   <package name="org.mybatis.builder"/>
132. </mappers><package name="domain.blog"/>
133. </typeAliases>
134. }

复制代码

Delete

1. int delUser(int id);
3. <delete id="delUser" parameterType="int"><typeAliases>
4. <mappers>
5.   <package name="org.mybatis.builder"/>
6. </mappers><package name="domain.blog"/>
7. </typeAliases>
8. <properties resource="org/mybatis/example/config.properties">
9. <typeAliases>
10. <mappers>
11.   <package name="org.mybatis.builder"/>
12. </mappers><package name="domain.blog"/>
13. </typeAliases><property name="username" value="dev_user"/>
14. <typeAliases>
15. <mappers>
16.   <package name="org.mybatis.builder"/>
17. </mappers><package name="domain.blog"/>
18. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
19. </properties>delete from user where id=#{id}<typeAliases>
20. <mappers>
21.   <package name="org.mybatis.builder"/>
22. </mappers><package name="domain.blog"/>
23. </typeAliases>
24. </delete>
26. @Test<typeAliases>
27. <mappers>
28.   <package name="org.mybatis.builder"/>
29. </mappers><package name="domain.blog"/>
30. </typeAliases>
31. public void t5(){<typeAliases>
32. <mappers>
33.   <package name="org.mybatis.builder"/>
34. </mappers><package name="domain.blog"/>
35. </typeAliases>
36. <properties resource="org/mybatis/example/config.properties">
37. <typeAliases>
38. <mappers>
39.   <package name="org.mybatis.builder"/>
40. </mappers><package name="domain.blog"/>
41. </typeAliases><property name="username" value="dev_user"/>
42. <typeAliases>
43. <mappers>
44.   <package name="org.mybatis.builder"/>
45. </mappers><package name="domain.blog"/>
46. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
47. </properties>SqlSession sqlSession = MybatisUtil.getSqlSession();<typeAliases>
48. <mappers>
49.   <package name="org.mybatis.builder"/>
50. </mappers><package name="domain.blog"/>
51. </typeAliases>
52. <properties resource="org/mybatis/example/config.properties">
53. <typeAliases>
54. <mappers>
55.   <package name="org.mybatis.builder"/>
56. </mappers><package name="domain.blog"/>
57. </typeAliases><property name="username" value="dev_user"/>
58. <typeAliases>
59. <mappers>
60.   <package name="org.mybatis.builder"/>
61. </mappers><package name="domain.blog"/>
62. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
63. </properties>UserMapper mapper = sqlSession.getMapper(UserMapper.class);<typeAliases>
64. <mappers>
65.   <package name="org.mybatis.builder"/>
66. </mappers><package name="domain.blog"/>
67. </typeAliases>
68. <properties resource="org/mybatis/example/config.properties">
69. <typeAliases>
70. <mappers>
71.   <package name="org.mybatis.builder"/>
72. </mappers><package name="domain.blog"/>
73. </typeAliases><property name="username" value="dev_user"/>
74. <typeAliases>
75. <mappers>
76.   <package name="org.mybatis.builder"/>
77. </mappers><package name="domain.blog"/>
78. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
79. </properties>int i = mapper.delUser(5);<typeAliases>
80. <mappers>
81.   <package name="org.mybatis.builder"/>
82. </mappers><package name="domain.blog"/>
83. </typeAliases>
84. <properties resource="org/mybatis/example/config.properties">
85. <typeAliases>
86. <mappers>
87.   <package name="org.mybatis.builder"/>
88. </mappers><package name="domain.blog"/>
89. </typeAliases><property name="username" value="dev_user"/>
90. <typeAliases>
91. <mappers>
92.   <package name="org.mybatis.builder"/>
93. </mappers><package name="domain.blog"/>
94. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
95. </properties>System.out.println(i);<typeAliases>
96. <mappers>
97.   <package name="org.mybatis.builder"/>
98. </mappers><package name="domain.blog"/>
99. </typeAliases>
100. <properties resource="org/mybatis/example/config.properties">
101. <typeAliases>
102. <mappers>
103.   <package name="org.mybatis.builder"/>
104. </mappers><package name="domain.blog"/>
105. </typeAliases><property name="username" value="dev_user"/>
106. <typeAliases>
107. <mappers>
108.   <package name="org.mybatis.builder"/>
109. </mappers><package name="domain.blog"/>
110. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
111. </properties>sqlSession.commit();<typeAliases>
112. <mappers>
113.   <package name="org.mybatis.builder"/>
114. </mappers><package name="domain.blog"/>
115. </typeAliases>
116. <properties resource="org/mybatis/example/config.properties">
117. <typeAliases>
118. <mappers>
119.   <package name="org.mybatis.builder"/>
120. </mappers><package name="domain.blog"/>
121. </typeAliases><property name="username" value="dev_user"/>
122. <typeAliases>
123. <mappers>
124.   <package name="org.mybatis.builder"/>
125. </mappers><package name="domain.blog"/>
126. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
127. </properties>sqlSession.close();<typeAliases>
128. <mappers>
129.   <package name="org.mybatis.builder"/>
130. </mappers><package name="domain.blog"/>
131. </typeAliases>
132. }

复制代码

4、配置解析

configuration（配置）

• properties（属性）
  
• settings（设置）
  
• typeAliases（类型别名）
  
• typeHandlers（类型处理器）
  
• objectFactory（对象工厂）
  
• plugins（插件）
  
• environments（环境配置）
  
  
  
  • environment（环境变量）
    
    
    
    • transactionManager（事务管理器）
      
    • dataSource（数据源）
      
    
    
  
  
• databaseIdProvider（数据库厂商标识）
  
• mappers（映射器）
  

configuration 配置文件中，对标签的顺序有规定：

1. The content of element type "configuration" must match "(properties?,settings?,typeAliases?,typeHandlers?,objectFactory?,objectWrapperFactory?,reflectorFactory?,plugins?,environments?,databaseIdProvider?,mappers?)".

复制代码

4.1、properties（属性）

这些属性可以在外部进行配置，并可以进行动态替换。你既可以在典型的 Java 属性文件中配置这些属性，也可以在 properties 元素的子元素中设置。例如：

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties>

复制代码

设置好的属性可以在整个配置文件中用来替换需要动态配置的属性值。比如:

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><properties resource="org/mybatis/example/config.properties">
13. <typeAliases>
14. <mappers>
15.   <package name="org.mybatis.builder"/>
16. </mappers><package name="domain.blog"/>
17. </typeAliases><property name="username" value="dev_user"/>
18. <typeAliases>
19. <mappers>
20.   <package name="org.mybatis.builder"/>
21. </mappers><package name="domain.blog"/>
22. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
23. </properties>

复制代码

这个例子中的 username 和 password 将会由 properties 元素中设置的相应值来替换。 driver 和 url 属性将会由 config.properties 文件中对应的值来替换。这样就为配置提供了诸多灵活选择。
也可以在 SqlSessionFactoryBuilder.build() 方法中传入属性值。例如：
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader, props);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader, environment, props);
如果一个属性在不只一个地方进行了配置，那么，MyBatis 将按照下面的顺序来加载：

• 首先读取在 properties 元素体内指定的属性。
  
• 然后根据 properties 元素中的 resource 属性读取类路径下属性文件，或根据 url 属性指定的路径读取属性文件，并覆盖之前读取过的同名属性。
  
• 最后读取作为方法参数传递的属性，并覆盖之前读取过的同名属性。
  

因此，通过方法参数传递的属性具有最高优先级，resource/url 属性中指定的配置文件次之，最低优先级的则是 properties 元素中指定的属性。
4.2、settings（设置）

设置名描述有效值默认值cacheEnabled全局性地开启或关闭所有映射器配置文件中已配置的任何缓存true / falsetruelazyLoadingEnabled延迟加载的全局开关。当开启时，所有关联对象都会延迟加载。 特定关联关系中可通过设置 fetchType 属性来覆盖该项的开关状态。true / falsefalselogImpl指定 MyBatis 所用日志的具体实现，未指定时将自动查找。SLF4J / LOG4J / LOG4J2 / JDK_LOGGING / COMMONS_LOGGING / STDOUT_LOGGING / NO_LOGGING未设置

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><properties resource="org/mybatis/example/config.properties">
13. <typeAliases>
14. <mappers>
15.   <package name="org.mybatis.builder"/>
16. </mappers><package name="domain.blog"/>
17. </typeAliases><property name="username" value="dev_user"/>
18. <typeAliases>
19. <mappers>
20.   <package name="org.mybatis.builder"/>
21. </mappers><package name="domain.blog"/>
22. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
23. </properties><properties resource="org/mybatis/example/config.properties">
24. <typeAliases>
25. <mappers>
26.   <package name="org.mybatis.builder"/>
27. </mappers><package name="domain.blog"/>
28. </typeAliases><property name="username" value="dev_user"/>
29. <typeAliases>
30. <mappers>
31.   <package name="org.mybatis.builder"/>
32. </mappers><package name="domain.blog"/>
33. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
34. </properties><properties resource="org/mybatis/example/config.properties">
35. <typeAliases>
36. <mappers>
37.   <package name="org.mybatis.builder"/>
38. </mappers><package name="domain.blog"/>
39. </typeAliases><property name="username" value="dev_user"/>
40. <typeAliases>
41. <mappers>
42.   <package name="org.mybatis.builder"/>
43. </mappers><package name="domain.blog"/>
44. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
45. </properties><properties resource="org/mybatis/example/config.properties">
46. <typeAliases>
47. <mappers>
48.   <package name="org.mybatis.builder"/>
49. </mappers><package name="domain.blog"/>
50. </typeAliases><property name="username" value="dev_user"/>
51. <typeAliases>
52. <mappers>
53.   <package name="org.mybatis.builder"/>
54. </mappers><package name="domain.blog"/>
55. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
56. </properties><properties resource="org/mybatis/example/config.properties">
57. <typeAliases>
58. <mappers>
59.   <package name="org.mybatis.builder"/>
60. </mappers><package name="domain.blog"/>
61. </typeAliases><property name="username" value="dev_user"/>
62. <typeAliases>
63. <mappers>
64.   <package name="org.mybatis.builder"/>
65. </mappers><package name="domain.blog"/>
66. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
67. </properties><properties resource="org/mybatis/example/config.properties">
68. <typeAliases>
69. <mappers>
70.   <package name="org.mybatis.builder"/>
71. </mappers><package name="domain.blog"/>
72. </typeAliases><property name="username" value="dev_user"/>
73. <typeAliases>
74. <mappers>
75.   <package name="org.mybatis.builder"/>
76. </mappers><package name="domain.blog"/>
77. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
78. </properties><typeAliases>
79. <mappers>
80.   <package name="org.mybatis.builder"/>
81. </mappers><package name="domain.blog"/>
82. </typeAliases>

复制代码

4.3、typeAliases（类型别名）

类型别名可为 Java 类型设置一个缩写名字。 它仅用于 XML 配置，意在降低冗余的全限定类名书写。例如

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><properties resource="org/mybatis/example/config.properties">
13. <typeAliases>
14. <mappers>
15.   <package name="org.mybatis.builder"/>
16. </mappers><package name="domain.blog"/>
17. </typeAliases><property name="username" value="dev_user"/>
18. <typeAliases>
19. <mappers>
20.   <package name="org.mybatis.builder"/>
21. </mappers><package name="domain.blog"/>
22. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
23. </properties><properties resource="org/mybatis/example/config.properties">
24. <typeAliases>
25. <mappers>
26.   <package name="org.mybatis.builder"/>
27. </mappers><package name="domain.blog"/>
28. </typeAliases><property name="username" value="dev_user"/>
29. <typeAliases>
30. <mappers>
31.   <package name="org.mybatis.builder"/>
32. </mappers><package name="domain.blog"/>
33. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
34. </properties>

复制代码

当这样配置时，Blog 可以用在任何使用 domain.blog.Blog 的地方。
也可以指定一个包名，MyBatis 会在包名下面搜索需要的 Java Bean，比如：

1. <typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>

复制代码

每一个在包 domain.blog 中的 Java Bean，在没有注解的情况下，会使用 Bean 的首字母小写的非限定类名来作为它的别名。 比如 domain.blog.Author 的别名为 author；若有注解，则别名为其注解值。见下面的例子：

1. @Alias("author")public class Author {<properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties>...}

复制代码

4.4、环境配置(environments)

MyBatis可以配置成适应多种环境
通过 default="development" 来选择环境

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

复制代码

注意一些关键点:

• 默认使用的环境 ID（比如：default="development"）。
  
• 每个 environment 元素定义的环境 ID（比如：id="development"）。
  
• 事务管理器的配置（比如：type="JDBC"）。
  
• 数据源的配置（比如：type="POOLED"）。
  

默认环境和环境 ID 顾名思义。 环境可以随意命名，但务必保证默认的环境 ID 要匹配其中一个环境 ID。
事务管理器（transactionManager）
在 MyBatis 中有两种类型的事务管理器（也就是 type="JDBC|MANAGED"）：

• JDBC – 这个配置直接使用了 JDBC 的提交和回滚设施，它依赖从数据源获得的连接来管理事务作用域。
  
• MANAGED – 这个配置几乎没做什么。它从不提交或回滚一个连接，而是让容器来管理事务的整个生命周期（比如 JEE 应用服务器的上下文）。 默认情况下它会关闭连接。然而一些容器并不希望连接被关闭，因此需要将 closeConnection 属性设置为 false 来阻止默认的关闭行为。例如:
  

提示 如果你正在使用 Spring + MyBatis，则没有必要配置事务管理器，因为 Spring 模块会使用自带的管理器来覆盖前面的配置。
这两种事务管理器类型都不需要设置任何属性。它们其实是类型别名，换句话说，你可以用 TransactionFactory 接口实现类的全限定名或类型别名代替它们
尽管可以配置多个环境，但每个SqlSessionFactory实例只能选择-种环境。
学会使用配置多套运行环境!
Mybatis默认的事务管理器就是JDBC，连接池: POOLED
4.5、mappers（映射器）

既然 MyBatis 的行为已经由上述元素配置完了，我们现在就要来定义 SQL 映射语句了。 但首先，我们需要告诉 MyBatis 到哪里去找到这些语句。 在自动查找资源方面，Java 并没有提供一个很好的解决方案，所以最好的办法是直接告诉 MyBatis 到哪里去找映射文件。 你可以使用相对于类路径的资源引用，或完全限定资源定位符（包括 file:/// 形式的 URL），或类名和包名等。例如：

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases>

复制代码

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases>

复制代码

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases>

复制代码

1. <typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>

复制代码

4.6、其他配置

• typeHandlers (类型处理器)
  
• objectFactory (对象工厂)
  
• plugins插件
  
  
  
  • mybatis-generator-core
    
  • mybatis-plus
    
  • 通用mappe
    
  
  

4.7、生命周期和作用域

生命周期，和作用域，是至关重要的，因为错误的使用会导致非常严重的并发问题。
SqlSessionFactoryBuilder:

• 一旦创建了SqlSessionFactory, 就不再需要它了
  
• 局部变量
  

SqlSessionFactor

• 说白了就是可以想象为:数据库连接池
  
• SqlSessionFactory 一-旦被创建就应该在应用的运行期间一直存在,没有任何理由丢弃它或重新创建另一个实例。
  
• 因此SqISessionFactory的最佳作用域是应用作用域。
  
• 最简单的就是使用单例模式或者静态单例模式。
  

SqISession

• 连接到连接池的一个请求!
  
• SqISession 的实例不是线程安全的，因此是不能被共享的，所以它的最佳的作用域是请求或方法作用** 域。
  
• 用完之后需要赶紧关闭，否则资源被占用
  

5、处理字段与属性名不一样的问题

实体类中的字段：id<properties resource="org/mybatis/example/config.properties">
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="username" value="dev_user"/>
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="password" value="F2Fa3!33TYyg"/>
</properties><typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases> name<properties resource="org/mybatis/example/config.properties">
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="username" value="dev_user"/>
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="password" value="F2Fa3!33TYyg"/>
</properties><properties resource="org/mybatis/example/config.properties">
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="username" value="dev_user"/>
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="password" value="F2Fa3!33TYyg"/>
</properties>password
数据库中的字段：id<properties resource="org/mybatis/example/config.properties">
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="username" value="dev_user"/>
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="password" value="F2Fa3!33TYyg"/>
</properties><typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases> name<properties resource="org/mybatis/example/config.properties">
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="username" value="dev_user"/>
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="password" value="F2Fa3!33TYyg"/>
</properties><properties resource="org/mybatis/example/config.properties">
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="username" value="dev_user"/>
<typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases><property name="password" value="F2Fa3!33TYyg"/>
</properties>pwd
执行查询语句

1. User{id=1, name='老大', password='null'}
2. User{id=2, name='李二', password='null'}
3. User{id=3, name='张三', password='null'}

复制代码

会发现，字段名不一样，导致查询到的字段值为空
原始解决办法：select id,name,pwd as password from user

1. User{id=1, name='老大', password='123456'}
2. User{id=2, name='李二', password='123456'}
3. User{id=3, name='张三', password='123456'}

复制代码

显示使用resultMap

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><properties resource="org/mybatis/example/config.properties">
13. <typeAliases>
14. <mappers>
15.   <package name="org.mybatis.builder"/>
16. </mappers><package name="domain.blog"/>
17. </typeAliases><property name="username" value="dev_user"/>
18. <typeAliases>
19. <mappers>
20.   <package name="org.mybatis.builder"/>
21. </mappers><package name="domain.blog"/>
22. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
23. </properties><properties resource="org/mybatis/example/config.properties">
24. <typeAliases>
25. <mappers>
26.   <package name="org.mybatis.builder"/>
27. </mappers><package name="domain.blog"/>
28. </typeAliases><property name="username" value="dev_user"/>
29. <typeAliases>
30. <mappers>
31.   <package name="org.mybatis.builder"/>
32. </mappers><package name="domain.blog"/>
33. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
34. </properties><properties resource="org/mybatis/example/config.properties">
35. <typeAliases>
36. <mappers>
37.   <package name="org.mybatis.builder"/>
38. </mappers><package name="domain.blog"/>
39. </typeAliases><property name="username" value="dev_user"/>
40. <typeAliases>
41. <mappers>
42.   <package name="org.mybatis.builder"/>
43. </mappers><package name="domain.blog"/>
44. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
45. </properties>select * from user<properties resource="org/mybatis/example/config.properties">
46. <typeAliases>
47. <mappers>
48.   <package name="org.mybatis.builder"/>
49. </mappers><package name="domain.blog"/>
50. </typeAliases><property name="username" value="dev_user"/>
51. <typeAliases>
52. <mappers>
53.   <package name="org.mybatis.builder"/>
54. </mappers><package name="domain.blog"/>
55. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
56. </properties><properties resource="org/mybatis/example/config.properties">
57. <typeAliases>
58. <mappers>
59.   <package name="org.mybatis.builder"/>
60. </mappers><package name="domain.blog"/>
61. </typeAliases><property name="username" value="dev_user"/>
62. <typeAliases>
63. <mappers>
64.   <package name="org.mybatis.builder"/>
65. </mappers><package name="domain.blog"/>
66. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
67. </properties><properties resource="org/mybatis/example/config.properties">
68. <typeAliases>
69. <mappers>
70.   <package name="org.mybatis.builder"/>
71. </mappers><package name="domain.blog"/>
72. </typeAliases><property name="username" value="dev_user"/>
73. <typeAliases>
74. <mappers>
75.   <package name="org.mybatis.builder"/>
76. </mappers><package name="domain.blog"/>
77. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
78. </properties><properties resource="org/mybatis/example/config.properties">
79. <typeAliases>
80. <mappers>
81.   <package name="org.mybatis.builder"/>
82. </mappers><package name="domain.blog"/>
83. </typeAliases><property name="username" value="dev_user"/>
84. <typeAliases>
85. <mappers>
86.   <package name="org.mybatis.builder"/>
87. </mappers><package name="domain.blog"/>
88. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
89. </properties><properties resource="org/mybatis/example/config.properties">
90. <typeAliases>
91. <mappers>
92.   <package name="org.mybatis.builder"/>
93. </mappers><package name="domain.blog"/>
94. </typeAliases><property name="username" value="dev_user"/>
95. <typeAliases>
96. <mappers>
97.   <package name="org.mybatis.builder"/>
98. </mappers><package name="domain.blog"/>
99. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
100. </properties><properties resource="org/mybatis/example/config.properties">
101. <typeAliases>
102. <mappers>
103.   <package name="org.mybatis.builder"/>
104. </mappers><package name="domain.blog"/>
105. </typeAliases><property name="username" value="dev_user"/>
106. <typeAliases>
107. <mappers>
108.   <package name="org.mybatis.builder"/>
109. </mappers><package name="domain.blog"/>
110. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
111. </properties><properties resource="org/mybatis/example/config.properties">
112. <typeAliases>
113. <mappers>
114.   <package name="org.mybatis.builder"/>
115. </mappers><package name="domain.blog"/>
116. </typeAliases><property name="username" value="dev_user"/>
117. <typeAliases>
118. <mappers>
119.   <package name="org.mybatis.builder"/>
120. </mappers><package name="domain.blog"/>
121. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
122. </properties><properties resource="org/mybatis/example/config.properties">
123. <typeAliases>
124. <mappers>
125.   <package name="org.mybatis.builder"/>
126. </mappers><package name="domain.blog"/>
127. </typeAliases><property name="username" value="dev_user"/>
128. <typeAliases>
129. <mappers>
130.   <package name="org.mybatis.builder"/>
131. </mappers><package name="domain.blog"/>
132. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
133. </properties><properties resource="org/mybatis/example/config.properties">
134. <typeAliases>
135. <mappers>
136.   <package name="org.mybatis.builder"/>
137. </mappers><package name="domain.blog"/>
138. </typeAliases><property name="username" value="dev_user"/>
139. <typeAliases>
140. <mappers>
141.   <package name="org.mybatis.builder"/>
142. </mappers><package name="domain.blog"/>
143. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
144. </properties><properties resource="org/mybatis/example/config.properties">
145. <typeAliases>
146. <mappers>
147.   <package name="org.mybatis.builder"/>
148. </mappers><package name="domain.blog"/>
149. </typeAliases><property name="username" value="dev_user"/>
150. <typeAliases>
151. <mappers>
152.   <package name="org.mybatis.builder"/>
153. </mappers><package name="domain.blog"/>
154. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
155. </properties><properties resource="org/mybatis/example/config.properties">
156. <typeAliases>
157. <mappers>
158.   <package name="org.mybatis.builder"/>
159. </mappers><package name="domain.blog"/>
160. </typeAliases><property name="username" value="dev_user"/>
161. <typeAliases>
162. <mappers>
163.   <package name="org.mybatis.builder"/>
164. </mappers><package name="domain.blog"/>
165. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
166. </properties><properties resource="org/mybatis/example/config.properties">
167. <typeAliases>
168. <mappers>
169.   <package name="org.mybatis.builder"/>
170. </mappers><package name="domain.blog"/>
171. </typeAliases><property name="username" value="dev_user"/>
172. <typeAliases>
173. <mappers>
174.   <package name="org.mybatis.builder"/>
175. </mappers><package name="domain.blog"/>
176. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
177. </properties>

复制代码

结果

1. User{id=1, name='老大', password='123456'}
2. User{id=2, name='李二', password='123456'}
3. User{id=3, name='张三', password='123456'}

复制代码

官方文档：

1. <typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>select id, username, hashedPassword<typeAliases>
6. <mappers>
7.   <package name="org.mybatis.builder"/>
8. </mappers><package name="domain.blog"/>
9. </typeAliases>from some_table<typeAliases>
10. <mappers>
11.   <package name="org.mybatis.builder"/>
12. </mappers><package name="domain.blog"/>
13. </typeAliases>where id = #{id}

复制代码

在这些情况下，MyBatis 会在幕后自动创建一个 ResultMap，再根据属性名来映射列到 JavaBean 的属性上。如果列名和属性名不能匹配上，可以在 SELECT 语句中设置列别名（这是一个基本的 SQL 特性）来完成匹配。比如：

1. <typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>select<properties resource="org/mybatis/example/config.properties">
6. <typeAliases>
7. <mappers>
8.   <package name="org.mybatis.builder"/>
9. </mappers><package name="domain.blog"/>
10. </typeAliases><property name="username" value="dev_user"/>
11. <typeAliases>
12. <mappers>
13.   <package name="org.mybatis.builder"/>
14. </mappers><package name="domain.blog"/>
15. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
16. </properties>user_id<properties resource="org/mybatis/example/config.properties">
17. <typeAliases>
18. <mappers>
19.   <package name="org.mybatis.builder"/>
20. </mappers><package name="domain.blog"/>
21. </typeAliases><property name="username" value="dev_user"/>
22. <typeAliases>
23. <mappers>
24.   <package name="org.mybatis.builder"/>
25. </mappers><package name="domain.blog"/>
26. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
27. </properties><properties resource="org/mybatis/example/config.properties">
28. <typeAliases>
29. <mappers>
30.   <package name="org.mybatis.builder"/>
31. </mappers><package name="domain.blog"/>
32. </typeAliases><property name="username" value="dev_user"/>
33. <typeAliases>
34. <mappers>
35.   <package name="org.mybatis.builder"/>
36. </mappers><package name="domain.blog"/>
37. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
38. </properties><properties resource="org/mybatis/example/config.properties">
39. <typeAliases>
40. <mappers>
41.   <package name="org.mybatis.builder"/>
42. </mappers><package name="domain.blog"/>
43. </typeAliases><property name="username" value="dev_user"/>
44. <typeAliases>
45. <mappers>
46.   <package name="org.mybatis.builder"/>
47. </mappers><package name="domain.blog"/>
48. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
49. </properties> as "id",<properties resource="org/mybatis/example/config.properties">
50. <typeAliases>
51. <mappers>
52.   <package name="org.mybatis.builder"/>
53. </mappers><package name="domain.blog"/>
54. </typeAliases><property name="username" value="dev_user"/>
55. <typeAliases>
56. <mappers>
57.   <package name="org.mybatis.builder"/>
58. </mappers><package name="domain.blog"/>
59. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
60. </properties>user_name<properties resource="org/mybatis/example/config.properties">
61. <typeAliases>
62. <mappers>
63.   <package name="org.mybatis.builder"/>
64. </mappers><package name="domain.blog"/>
65. </typeAliases><property name="username" value="dev_user"/>
66. <typeAliases>
67. <mappers>
68.   <package name="org.mybatis.builder"/>
69. </mappers><package name="domain.blog"/>
70. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
71. </properties><properties resource="org/mybatis/example/config.properties">
72. <typeAliases>
73. <mappers>
74.   <package name="org.mybatis.builder"/>
75. </mappers><package name="domain.blog"/>
76. </typeAliases><property name="username" value="dev_user"/>
77. <typeAliases>
78. <mappers>
79.   <package name="org.mybatis.builder"/>
80. </mappers><package name="domain.blog"/>
81. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
82. </properties><typeAliases>
83. <mappers>
84.   <package name="org.mybatis.builder"/>
85. </mappers><package name="domain.blog"/>
86. </typeAliases> as "userName",<properties resource="org/mybatis/example/config.properties">
87. <typeAliases>
88. <mappers>
89.   <package name="org.mybatis.builder"/>
90. </mappers><package name="domain.blog"/>
91. </typeAliases><property name="username" value="dev_user"/>
92. <typeAliases>
93. <mappers>
94.   <package name="org.mybatis.builder"/>
95. </mappers><package name="domain.blog"/>
96. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
97. </properties>hashed_password<properties resource="org/mybatis/example/config.properties">
98. <typeAliases>
99. <mappers>
100.   <package name="org.mybatis.builder"/>
101. </mappers><package name="domain.blog"/>
102. </typeAliases><property name="username" value="dev_user"/>
103. <typeAliases>
104. <mappers>
105.   <package name="org.mybatis.builder"/>
106. </mappers><package name="domain.blog"/>
107. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
108. </properties> as "hashedPassword"<typeAliases>
109. <mappers>
110.   <package name="org.mybatis.builder"/>
111. </mappers><package name="domain.blog"/>
112. </typeAliases>from some_table<typeAliases>
113. <mappers>
114.   <package name="org.mybatis.builder"/>
115. </mappers><package name="domain.blog"/>
116. </typeAliases>where id = #{id}

复制代码

在学习了上面的知识后，你会发现上面的例子没有一个需要显式配置 ResultMap，这就是 ResultMap 的优秀之处——你完全可以不用显式地配置它们。 虽然上面的例子不用显式配置 ResultMap。 但为了讲解，我们来看看如果在刚刚的示例中，显式使用外部的 resultMap 会怎样，这也是解决列名不匹配的另外一种方式。

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><typeAliases>
13. <mappers>
14.   <package name="org.mybatis.builder"/>
15. </mappers><package name="domain.blog"/>
16. </typeAliases>

复制代码

然后在引用它的语句中设置 resultMap 属性就行了（注意我们去掉了 resultType 属性）。比如:

1. <typeAliases>
2. <mappers>
3.   <package name="org.mybatis.builder"/>
4. </mappers><package name="domain.blog"/>
5. </typeAliases>select user_id, user_name, hashed_password<typeAliases>
6. <mappers>
7.   <package name="org.mybatis.builder"/>
8. </mappers><package name="domain.blog"/>
9. </typeAliases>from some_table<typeAliases>
10. <mappers>
11.   <package name="org.mybatis.builder"/>
12. </mappers><package name="domain.blog"/>
13. </typeAliases>where id = #{id}

复制代码

6、日志

6.1、日志工厂

1、标准日志工厂

1. <properties resource="org/mybatis/example/config.properties">
2. <typeAliases>
3. <mappers>
4.   <package name="org.mybatis.builder"/>
5. </mappers><package name="domain.blog"/>
6. </typeAliases><property name="username" value="dev_user"/>
7. <typeAliases>
8. <mappers>
9.   <package name="org.mybatis.builder"/>
10. </mappers><package name="domain.blog"/>
11. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
12. </properties><properties resource="org/mybatis/example/config.properties">
13. <typeAliases>
14. <mappers>
15.   <package name="org.mybatis.builder"/>
16. </mappers><package name="domain.blog"/>
17. </typeAliases><property name="username" value="dev_user"/>
18. <typeAliases>
19. <mappers>
20.   <package name="org.mybatis.builder"/>
21. </mappers><package name="domain.blog"/>
22. </typeAliases><property name="password" value="F2Fa3!33TYyg"/>
23. </properties>

复制代码

[code]Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.PooledDataSource forcefully closed/removed all connections.PooledDataSource forcefully closed/removed all connections.PooledDataSource forcefully closed/removed all connections.PooledDataSource forcefully closed/removed all connections.Opening JDBC ConnectionCreated connection 359742806.Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@15713d56]==><typeAliases>
<mappers>
  <package name="org.mybatis.builder"/>
</mappers><package name="domain.blog"/>
</typeAliases>Preparing: select * from user==> Parameters:

---

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

Powered by Discuz! X3.4