MyBatis笔记

不到断气不罢休  金牌会员 | 2022-9-23 22:09:18 | 显示全部楼层 | 阅读模式
打印 上一主题 下一主题
楼主

主题 890|帖子 890|积分 2670

MyBatis

MyBatis特性


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

下载地址


持久化层技术对比


  • JDBC

    • SQL 夹杂在Java代码中耦合度高
    • 维护不易且实际开发需求中 SQL 有变化，频繁修改的情况多见
    • 代码冗长，开发效率低

  • Hibernate 和 JPA

    • 操作简便，开发效率高
    • 程序中的长难复杂 SQL 需要绕过框架
    • 内部自动生产的 SQL，不容易做特殊优化
    • 基于全映射的全自动框架，大量字段的 POJO 进行部分映射时比较困难
    • 反射操作太多，导致数据库性能下降

  • MyBatis

    • 轻量级，性能出色
    • SQL 和 Java 编码分开，功能边界清晰。Java代码专注业务、SQL语句专注数据
    • 开发效率稍逊于HIbernate，但是完全能够接受

开发环境

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


1.创建Maven工程

2.配置打包方式为jar

3.引入依赖

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

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

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

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


  • 映射文件的namespace要和mapper的全类名保持一致
  • 映射文件中SQL语句的id要和mapper接口中的方法名一致
UserMapper.xml
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3. <settings>
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>
  7. <plugins>
  8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  10. </settings>PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  11. <settings>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins>
  15. <plugins>
  16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  17. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  18. </settings>"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  19. <mapper namespace="com.xust.mybatis.mapper.UserMapper">
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><insert id="insertUser">
  26.                 insert into t_user values(null,'张三','123',23,'女','123456@qq.com')
  27.         </insert>
  28. </mapper>
复制代码
8.junit测试

SqlSession:代表Java程序和数据库之间的会话。HttpSession是Java程序和浏览器之间的会话
SqlSessionFactory:是生产SqlSession的工厂
MyBatisTest.java
  1. package com.xust.mybatis.test;
  3. import com.xust.mybatis.mapper.UserMapper;
  4. import org.apache.ibatis.io.Resources;
  5. import org.apache.ibatis.session.SqlSession;
  6. import org.apache.ibatis.session.SqlSessionFactory;
  7. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
  8. import org.junit.Test;
  10. import java.io.IOException;
  11. import java.io.InputStream;
  13. public class MyBatisTest {
  14. <plugins>
  15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  16. </plugins>@Test
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>public void testMyBatis() throws IOException {
  20. <settings>
  21. <plugins>
  22.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  23. </plugins>
  24. <plugins>
  25.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  26. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  27. </settings>//加载核心配置文件
  28. <settings>
  29. <plugins>
  30.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  31. </plugins>
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  35. </settings>InputStream is= Resources.getResourceAsStream("mybatis-config.xml");
  36. <settings>
  37. <plugins>
  38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  39. </plugins>
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  43. </settings>//获取SqlSessionFactoryBuilder
  44. <settings>
  45. <plugins>
  46.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  47. </plugins>
  48. <plugins>
  49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  50. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  51. </settings>SqlSessionFactoryBuilder sqlSessionFactoryBuilder=new SqlSessionFactoryBuilder();
  52. <settings>
  53. <plugins>
  54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  55. </plugins>
  56. <plugins>
  57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  58. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  59. </settings>//获取SqlSessionFactory
  60. <settings>
  61. <plugins>
  62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  63. </plugins>
  64. <plugins>
  65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  66. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  67. </settings>SqlSessionFactory sqlSessionFactory=sqlSessionFactoryBuilder.build(is);
  68. <settings>
  69. <plugins>
  70.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  71. </plugins>
  72. <plugins>
  73.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  74. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  75. </settings>//获取SqlSession
  76. <settings>
  77. <plugins>
  78.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  79. </plugins>
  80. <plugins>
  81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  82. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  83. </settings>SqlSession sqlSession=sqlSessionFactory.openSession();
  84. <settings>
  85. <plugins>
  86.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  87. </plugins>
  88. <plugins>
  89.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  90. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  91. </settings>//获取mapper接口对象
  92. <settings>
  93. <plugins>
  94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  95. </plugins>
  96. <plugins>
  97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  98. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  99. </settings>UserMapper mapper=sqlSession.getMapper(UserMapper.class);
  100. <settings>
  101. <plugins>
  102.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  103. </plugins>
  104. <plugins>
  105.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  106. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  107. </settings>//测试功能
  108. <settings>
  109. <plugins>
  110.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  111. </plugins>
  112. <plugins>
  113.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  114. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  115. </settings>int result=mapper.insertUser();
  116. <settings>
  117. <plugins>
  118.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  119. </plugins>
  120. <plugins>
  121.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  122. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  123. </settings>//提交事务
  124. <settings>
  125. <plugins>
  126.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  127. </plugins>
  128. <plugins>
  129.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  130. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  131. </settings>sqlSession.commit();
  132. <settings>
  133. <plugins>
  134.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  135. </plugins>
  136. <plugins>
  137.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  138. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  139. </settings>System.out.println("result:"+result);
  140. <plugins>
  141.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  142. </plugins>}
  143. }
复制代码
上面是手动提交事务，SqlSession默认不自动提交事务，自动提交可以在获取sqlSession对象时，使用SqlSession sqlSession = sqlSessionFactory.openSession(true)，传入一个Boolean类型的参数，值为true，这样就可以自动提交。
9.加入log4j日志功能

引入依赖
  1. <dependency>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins><groupId>log4j</groupId>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><artifactId>log4j</artifactId>
  8. <plugins>
  9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  10. </plugins><version>1.2.17</version>
  11. </dependency>
复制代码
log4j.xml
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
  3. <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins><appender name="STDOUT" >
  7. <settings>
  8. <plugins>
  9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  10. </plugins>
  11. <plugins>
  12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  13. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  14. </settings><param name="Encoding" value="UTF-8" />
  15. <settings>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins>
  19. <plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  22. </settings><layout >
  23.                         <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m (%F:%L) \n" />
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings></layout>
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins></appender>
  35. <plugins>
  36.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  37. </plugins><logger name="java.sql">
  38. <settings>
  39. <plugins>
  40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  41. </plugins>
  42. <plugins>
  43.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  44. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  45. </settings><level value="debug" />
  46. <plugins>
  47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  48. </plugins></logger>
  49. <plugins>
  50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  51. </plugins><logger name="org.apache.ibatis">
  52. <settings>
  53. <plugins>
  54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  55. </plugins>
  56. <plugins>
  57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  58. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  59. </settings><level value="info" />
  60. <plugins>
  61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  62. </plugins></logger>
  63. <plugins>
  64.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  65. </plugins><root>
  66. <settings>
  67. <plugins>
  68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  69. </plugins>
  70. <plugins>
  71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  72. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  73. </settings><level value="debug" />
  74. <settings>
  75. <plugins>
  76.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  77. </plugins>
  78. <plugins>
  79.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  80. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  81. </settings><appender-ref ref="STDOUT" />
  82. <plugins>
  83.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  84. </plugins></root>
  85. </log4j:configuration>
复制代码
日志的级别：FATAL(致命)>ERROR(错误)>WARN(警告)>INFO(信息)>DEBUG(调试)
日志级别越低，打印越详细
增删改查

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

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


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

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

单个字面量类型的参数

{}中username可替换为任意值，${}要手动添加''
Test.java
  1. public class ParameterTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetUserByUsername(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>Users user=mapper.GetUserByUsername("李四");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(user);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
#{}
  1. <select id="GetUserByUsername" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where username=#{username}
  11. </select>
复制代码
${}
  1. <select id="GetUserByUsername" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where username='${username}'
  11. </select>
复制代码
多个字面量类型的参数

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

  • 以arg0,arg1…为键，以参数为值；
  • 以param1,param2…为键，以参数为值；
{}中必须按照上面的参数写
Test.java
  1. public class ParameterTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testCheckLogin(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>Users user=mapper.checkLogin("李四","123");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(user);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
#{}
  1. <select id="checkLogin" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where username=#{arg0} and password=#{arg1}
  11. </select>
复制代码
${}
  1. <select id="checkLogin" resultType="User">
  2.         select * from t_user where username ='${param1}' and password ='${param2}'
  3. </select>
复制代码
map集合类型的参数

mapper接口中的方法需要的参数为多个时，此时可以手动创建map集合，将这些数据放在map中只需要通过${}和#{}访问map集合的键就可以获取相对应的值
Test.java
  1. public class ParameterTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testCheckLoginByMap(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>Map<String,Object> map=new HashMap<>();
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>map.put("username","李四");
  40. <settings>
  41. <plugins>
  42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  43. </plugins>
  44. <plugins>
  45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  47. </settings>map.put("password","123");
  48. <settings>
  49. <plugins>
  50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  51. </plugins>
  52. <plugins>
  53.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  54. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  55. </settings>Users user=mapper.checkUserByMap(map);
  56. <settings>
  57. <plugins>
  58.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  59. </plugins>
  60. <plugins>
  61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  62. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  63. </settings>System.out.println(user);
  64. <plugins>
  65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  66. </plugins>}
  67. }
复制代码
#{}
  1. <select id="GetUserByUsername" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where username=#{username}
  11. </select> and password=#{password}
复制代码
${}略
实体类类型的参数

通过访问实体类对象中的属性名获取属性值
Test.java
  1. public class ParameterTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testInsertUser(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>int result=mapper.insertUser(new Users(null,"王五","123",23,"男","123@q.com"));
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(result);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
#{}
  1. <insert id="insertUser">
  2. <insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
  3. <plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>insert into t_user values(null,#{username},#{password},#{age},#{sex},#{email})
  6. </insert>
  7. </insert>
复制代码
${}略
使用@Param注解命名参数

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

  • 以@Param注解的value属性值为键，以参数为值
  • 以param1,param2…为键，以参数为值
Test.java
  1. public class ParameterTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testChesckLoginByParam(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>ParameterMapper mapper=sqlSession.getMapper(ParameterMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>Users user=mapper.checkLoginByParam("李四","123");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(user);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
mapper.java
  1. Users checkLogdinByParam(@Param("username") String username,@Param("password") String password);
复制代码
mapper.xml
  1. <select id="GetUserByUsername" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where username=#{username}
  11. </select> and password=#{password}
复制代码
MyBatis查询功能

查询一个实体类对象
  1. Users getUserById(@Param("id") Integer id);
复制代码
  1. <select id="getUserById" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where id=#{id}
  11. </select>
复制代码
  1. public class SelectMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void getUsereById(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>System.out.println(mapper.getUserById(3));
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins>}
  35. }
复制代码
查询List集合
  1. List<Users> getAllUser();
复制代码
  1. <select id="getAllUser" resultType="users">
  2. <select id="getAllUserToMap" resultType="map">
  3. <select id="getAllUserToMap1" resultType="map">
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>select * from t_user
  7. </select>
  8. </select>
  9. </select>
复制代码
  1. public class SelectMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void getAllUsers(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>System.out.println(mapper.getAllUser());
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins>}
  35. }
复制代码
查询单个数据
  1. Integer getCount();
复制代码
  1. <select id="getCount" resultType="java.lang.Integer">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select count(*) from t_user
  5. </select>
复制代码
  1. public class SelectMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetCount(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>System.out.println(mapper.getCount());
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins>}
  35. }
复制代码
查询一条数据为map集合
  1. Map<String,Object> getUserByIdToMap(@Param("id") Integer id);
复制代码
  1. <select id="getUserById" resultType="users">
  2. <select id="getAllUser" resultType="users">
  3. <select id="getAllUserToMap" resultType="map">
  4. <select id="getAllUserToMap1" resultType="map">
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>select * from t_user
  8. </select>
  9. </select>
  10. </select> where id=#{id}
  11. </select>
复制代码
  1. public class SelectMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetUserByIdToMap(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>System.out.println(mapper.getUserByIdToMap(3));
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins>}
  35. }
复制代码
查询多条数据为map集合

法一：
  1. List<Map<String,Object>> getAllUserToMap();
复制代码
  1. <select id="getAllUser" resultType="users">
  2. <select id="getAllUserToMap" resultType="map">
  3. <select id="getAllUserToMap1" resultType="map">
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>select * from t_user
  7. </select>
  8. </select>
  9. </select>
复制代码
  1. public class SelectMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetAllUserToMap(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>System.out.println(mapper.getAllUserToMap());
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins>}
  35. }
复制代码
法二：
  1. @MapKey("id")
  2. Map<String,Object> getAllUserToMap1();
复制代码
  1. <select id="getAllUser" resultType="users">
  2. <select id="getAllUserToMap" resultType="map">
  3. <select id="getAllUserToMap1" resultType="map">
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>select * from t_user
  7. </select>
  8. </select>
  9. </select>
复制代码
  1. public class SelectMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetAllUserToMap1(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SelectMapper mapper=sqlSession.getMapper(SelectMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>System.out.println(mapper.getAllUserToMap1());
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins>}
  35. }
复制代码
特殊SQL的执行

模糊查询

第三种方法最常用
  1. List<Users> getUserByLike(@Param("username") String username);
复制代码
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><select id="getAllUser" resultType="users">
  9. <select id="getAllUserToMap" resultType="map">
  10. <select id="getAllUserToMap1" resultType="map">
  11. <plugins>
  12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  13. </plugins>select * from t_user
  14. </select>
  15. </select>
  16. </select> where username like "%"#{username}"%"
复制代码
  1. public class SQLMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetUserByLike(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>List<Users> list=mapper.getUserByLike("a");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(list);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
批量删除
  1. int deleteMore(@Param("ids") String ids);
复制代码
  1. <delete id="deleteMore">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>delete from t_user where id in (${ids})
  5. </delete>
复制代码
  1. public class SQLMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testDeleteMore(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>int result=mapper.deleteMore("1,2,3");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(result);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
动态设置表名
  1. List<Users> getUserByTableName(@Param("tableName") String tableName);
复制代码
  1. <select id="getUserByTableName" resultType="users">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select * from ${tableName}
  5. </select>
复制代码
  1. public class SQLMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testGetUserByTableName(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>List<Users> list=mapper.getUserByTableName("t_user");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>System.out.println(list);
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>}
  43. }
复制代码
添加功能获取自增的主键

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

  • useGeneratedKeys：设置使用自增的主键
  • keyProperty：因为增删改有统一的返回值是受影响的行数，因此只能将获取的自增的主键放在传输的参数user对象的某个属性中
  1. void insertUser(Users user);
复制代码
  1. <insert id="insertUser">
  2. <insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
  3. <plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>insert into t_user values(null,#{username},#{password},#{age},#{sex},#{email})
  6. </insert>
  7. </insert>
复制代码
  1. public class SQLMapperTest {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>@Test
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>public void testInsertUser(){
  8. <settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>SqlSession sqlSession= SqlSessionUtils.getSqlSession();
  16. <settings>
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  23. </settings>SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
  24. <settings>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins>
  28. <plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  31. </settings>Users user=new Users(null,"赵六","123",23,"男","123@qq.com");
  32. <settings>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  39. </settings>mapper.insertUser(user);
  40. <settings>
  41. <plugins>
  42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  43. </plugins>
  44. <plugins>
  45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  47. </settings>System.out.println(user);
  48. <plugins>
  49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  50. </plugins>}
  51. }
复制代码
自定义映射resultMap

字段名与属性名不一致

数据库

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

EmpMapper.xml
  1. <select id="getAllEmp" resultType="emp">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select eid,emp_name empNaem,age,sex,email from t_emp
  5. </select>
复制代码
方法二：配置映射

在mybatis-config.xml中添加配置后自动将下划线映射为驼峰
mybatis-config.xml
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings>
复制代码
EmpMapper.xml
  1. <select id="getAllEmp" resultType="emp">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select * from t_emp
  5. </select>
复制代码
方法三：自定义映射resultMap

所有属性都要列出来
EmpMapper.xml
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings><settings>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins>
  19. <plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  22. </settings><select id="getAllEmp" resultType="emp">
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins>select * from t_emp
  26. </select>
复制代码
多对一映射

方法一：级联操作

Emp.java
  1. public class Emp {
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>private Integer eid;
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins>private String empName;
  8. <plugins>
  9.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  10. </plugins>private Integer age;
  11. <plugins>
  12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  13. </plugins>private String sex;
  14. <plugins>
  15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  16. </plugins>private String email;
  17. <plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>private Dept dept;
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>......
  23. }
复制代码
Dept.java
  1. package com.xust.mybatis.pojo;
  3. public class Dept {
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>private Integer did;
  7. <plugins>
  8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  9. </plugins>private String deptName;
  10. <plugins>
  11.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  12. </plugins>......
  13. }
复制代码
EmpMapper.xml
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings><settings>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins>
  19. <plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  22. </settings><settings>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins>
  26. <plugins>
  27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  29. </settings>select * from t_emp left join t_dept on t_emp.did=t_dept.did where t_emp.eid=#{eid}
复制代码
方法二：association

association用来处理多对一的映射关系
javaType中是类型名
EmpMapper.xml
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings><settings>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins>
  19. <plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  22. </settings><settings>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins>
  26. <plugins>
  27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  29. </settings><settings>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  36. </settings><plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins>
复制代码
方法三：分步查询

EmpMapper.xml
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings><settings>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins>
  19. <plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  22. </settings><settings>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins>
  26. <plugins>
  27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  29. </settings>select * from t_emp where eid=#{eid}
复制代码
DeptMapper.xml
  1. <select id="getEmpAndDeptByStepTwo" resultType="Dept">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select * from t_dept where did=#{did}
  5. </select>
复制代码
  1. public class ResultMapTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void testGetEmpAndDeptByStep(){<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings>EmpMapper mapper=sqlSessaion.getMapper(EmpMapper.class);<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>Emp emp=mapper.getEmpAndDeptByStepOne(1);<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings>System.out.println(emp);<plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>}}
复制代码
一对多映射

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

collection：用来处理一对多的映射关系
ofType：表示该属性对饮的集合中存储的数据的类型
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings><settings>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins>
  19. <plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  22. </settings><settings>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins>
  26. <plugins>
  27.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  28. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  29. </settings><settings>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins>
  33. <plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  36. </settings><settings>
  37. <plugins>
  38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  39. </plugins>
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  43. </settings><settings>
  44. <plugins>
  45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  46. </plugins>
  47. <plugins>
  48.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  49. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  50. </settings><plugins>
  51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  52. </plugins>select * from t_dept left join t_emp on t_dept.did=t_emp.did where t_dept.did=#{did}
复制代码
  1. public class ResultMapTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void testGetDeptAndEmp(){<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings>DeptMapper mapper=sqlSessaion.getMapper(DeptMapper.class);<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>Dept dept=mapper.getDeptAndEmp(1);<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings>System.out.println(dept);<plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>}}
复制代码
方法二：分步查询

DeptMapper.xml
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>select * from t_dept where did=#{did}
复制代码
EmpMapper.xml
  1. <select id="getAllEmp" resultType="emp">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select * from t_emp
  5. </select> where did=#{did}
复制代码
  1. public class ResultMapTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void testGetDeptAndEmpByStep(){<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings>DeptMapper mapper=sqlSessaion.getMapper(DeptMapper.class);<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>Dept dept=mapper.getDeptAndEmpByStepOne(1);<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings>System.out.println(dept);<plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>}}
复制代码
动态SQL

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

if标签可以对test中接收到的属性值进行判断，为true则拼接if标签下的内容
where后加1=1为了更好实现拼接效果，防止出现拼接错误
  1. List<Emp> getEmpByCondition(Emp emp);
复制代码
  1. <select id="getAllEmp" resultType="emp">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select * from t_emp
  5. </select> where 1=1<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings><plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins>and emp_name=#{empName}<settings>
  15. <plugins>
  16.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  17. </plugins>
  18. <plugins>
  19.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  20. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  21. </settings><settings>
  22. <plugins>
  23.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  24. </plugins>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  28. </settings>and age=#{age}<settings>
  29. <plugins>
  30.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  31. </plugins>
  32. <plugins>
  33.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  34. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  35. </settings><settings>
  36. <plugins>
  37.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  38. </plugins>
  39. <plugins>
  40.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  41. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  42. </settings>and sex=#{sex}<settings>
  43. <plugins>
  44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  45. </plugins>
  46. <plugins>
  47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  48. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  49. </settings><settings>
  50. <plugins>
  51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  52. </plugins>
  53. <plugins>
  54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  56. </settings>and email=#{email}<plugins>
  57.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  58. </plugins>
复制代码
  1. public class DynamicSQLMapperTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void testGetEmpByCondition(){<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings>DynamicSQLMapper mapper=sqlSessaion.getMapper(DynamicSQLMapper.class);<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>List list=mapper.getEmpByCondition(new Emp(null,"张三",12,"男","123@qq.com"));<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings>System.out.println(list);<plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>}}
复制代码
where标签

相比直接使用if标签，where标签会自动清除多余的and和or,条件全不满足时where不起作用，不会出现拼接错误
但是where标签只能将内容之前多余的and和or清除，如果and和or放在拼接的语句之后，则不能清除
  1. <select id="getAllEmp" resultType="emp">
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>select * from t_emp
  5. </select><settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings><settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings><settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>emp_name=#{empName}<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings><settings>
  34. <plugins>
  35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  36. </plugins>
  37. <plugins>
  38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  40. </settings><settings>
  41. <plugins>
  42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  43. </plugins>
  44. <plugins>
  45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  47. </settings><plugins>
  48.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  49. </plugins>and age=#{age}<settings>
  50. <plugins>
  51.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  52. </plugins>
  53. <plugins>
  54.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  55. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  56. </settings><settings>
  57. <plugins>
  58.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  59. </plugins>
  60. <plugins>
  61.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  62. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  63. </settings><settings>
  64. <plugins>
  65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  66. </plugins>
  67. <plugins>
  68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  69. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  70. </settings><plugins>
  71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  72. </plugins>and sex=#{sex}<settings>
  73. <plugins>
  74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  75. </plugins>
  76. <plugins>
  77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  78. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  79. </settings><settings>
  80. <plugins>
  81.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  82. </plugins>
  83. <plugins>
  84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  85. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  86. </settings><settings>
  87. <plugins>
  88.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  89. </plugins>
  90. <plugins>
  91.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  92. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  93. </settings><plugins>
  94.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  95. </plugins>and email=#{email}<settings>
  96. <plugins>
  97.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  98. </plugins>
  99. <plugins>
  100.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  101. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  102. </settings><plugins>
  103.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  104. </plugins>
复制代码
trim标签

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

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

collection：设置要循环的数组或集合
item：表示集合或数组中的每一个数据
separator：设置循环体之间的分隔符，分隔符前后默认有一个空格
open：开始符
close：结束符
  1. int deleteMoreByArray(@Param("eids") Integer[] eids);
复制代码
  1. <plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>delete from t_emp where eid in<settings>
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>
  7. <plugins>
  8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  10. </settings><settings>
  11. <plugins>
  12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  13. </plugins>
  14. <plugins>
  15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  16. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  17. </settings><plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>#{eid}<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>
复制代码
  1. public class DynamicSQLMapperTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void testDeleteMoreByArray(){<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>SqlSession sqlSessaion= SqlSessionUtils.getSqlSession();<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings>DynamicSQLMapper mapper=sqlSessaion.getMapper(DynamicSQLMapper.class);<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>int result=mapper.deleteMoreByArray(new Integer[]{6,7,8});<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings>System.out.println(result);<plugins>
  34.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  35. </plugins>}}
复制代码
批量删除

,换成or
  1. <plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>delete from t_emp where eid in<settings>
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>
  7. <plugins>
  8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  10. </settings><settings>
  11. <plugins>
  12.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  13. </plugins>
  14. <plugins>
  15.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  16. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  17. </settings><plugins>
  18.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  19. </plugins>#{eid}<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>
复制代码
批量添加
  1. int insertMoreByList(@Param("emps") List<Emp> emps);
复制代码
  1. <plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>insert into t_emp values<settings>
  4. <plugins>
  5.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  6. </plugins>
  7. <plugins>
  8.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  9. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  10. </settings><plugins>
  11.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  12. </plugins>(null,#{emp.empName},#{emp.age},#{emp.sex},#{emp.email},null)<plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins>
复制代码
  1. public class DynamicSQLMapperTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void insertMoreByList() {<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>SqlSession sqlSession = SqlSessionUtils.getSqlSession();<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings>DynamicSQLMapper mapper = sqlSession.getMapper(DynamicSQLMapper.class);<settings>
  20. <plugins>
  21.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  22. </plugins>
  23. <plugins>
  24.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  25. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  26. </settings>Emp emp1 = new Emp(null,"a",1,"男","123@qq.com");<settings>
  27. <plugins>
  28.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  29. </plugins>
  30. <plugins>
  31.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  32. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  33. </settings>Emp emp2 = new Emp(null,"b",1,"男","123@321.com");<settings>
  34. <plugins>
  35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  36. </plugins>
  37. <plugins>
  38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  39. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  40. </settings>Emp emp3 = new Emp(null,"c",1,"男","123@321.com");<settings>
  41. <plugins>
  42.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  43. </plugins>
  44. <plugins>
  45.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  46. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  47. </settings>List emps = Arrays.asList(emp1, emp2, emp3);<settings>
  48. <plugins>
  49.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  50. </plugins>
  51. <plugins>
  52.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  53. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  54. </settings>mapper.insertMoreByList(emps);<settings>
  55. <plugins>
  56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  57. </plugins>
  58. <plugins>
  59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  60. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  61. </settings>System.out.println(emps);<plugins>
  62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  63. </plugins>}}
复制代码
SQL标签

sql片段，可以记录一段公共sql片段，在使用的地方通过include标签进行引入
  1. <sql id="empColumns">eid,emp_name,age,sex,email</sql>
  3. <select id="getEmpByCondition" resultType="Emp">
  4.         select <include refid="empColumns"></include> from t_emp
  5. </select>
复制代码
MyBatis缓存

MyBatis一级缓存

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

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

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

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

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

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

  • 默认情况是不设置，也就是没有刷新间隔，缓存仅仅调用语句（增删改）时刷新
size属性：引用数目，正整数

  • 代表缓存最多可以存储多少个对象，太大容易导致内存溢出
readOnly属性：只读，true/false

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


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

向pom.xml中添加依赖
  1. <dependency>
  2.         <groupId>org.mybatis.caches</groupId>
  3.         <artifactId>mybatis-ehcache</artifactId>
  4.         <version>1.2.1</version>
  5. </dependency>
  7. <dependency>
  8.         <groupId>ch.qos.logback</groupId>
  9.         <artifactId>logback-classic</artifactId>
  10.         <version>1.2.3</version>
  11. </dependency>
复制代码
resources下创建ehcache.xml文件
  1. <settings>
  2. <plugins>
  3.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  4. </plugins>
  5. <plugins>
  6.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  7. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  8. </settings><settings>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins>
  12. <plugins>
  13.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  14. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  15. </settings>
复制代码
设置二级缓存类型

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

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

1.添加依赖和插件

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

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

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

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

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

步骤

添加依赖
  1. <dependency>
  2.         <groupId>com.github.pagehelper</groupId>
  3.         <artifactId>pagehelper</artifactId>
  4.         <version>5.2.0</version>
  5. </dependency>
复制代码
配置插件
  1. <plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>
复制代码
开启分页功能
  1. public class PageHelperTest {<plugins>
  2.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  3. </plugins>@Test<plugins>
  4.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  5. </plugins>public void testPageHelper(){<settings>
  6. <plugins>
  7.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  8. </plugins>
  9. <plugins>
  10.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  11. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  12. </settings>try {<settings>
  13. <plugins>
  14.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  15. </plugins>
  16. <plugins>
  17.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  18. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  19. </settings><plugins>
  20.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  21. </plugins>InputStream is= Resources.getResourceAsStream("mybatis-config.xml");<settings>
  22. <plugins>
  23.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  24. </plugins>
  25. <plugins>
  26.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  27. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  28. </settings><plugins>
  29.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  30. </plugins>SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);<settings>
  31. <plugins>
  32.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  33. </plugins>
  34. <plugins>
  35.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  36. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  37. </settings><plugins>
  38.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  39. </plugins>SqlSession sqlSession=sqlSessionFactory.openSession(true);<settings>
  40. <plugins>
  41.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  42. </plugins>
  43. <plugins>
  44.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  45. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  46. </settings><plugins>
  47.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  48. </plugins>EmpMapper mapper=sqlSession.getMapper(EmpMapper.class);<settings>
  49. <plugins>
  50.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  51. </plugins>
  52. <plugins>
  53.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  54. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  55. </settings><plugins>
  56.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  57. </plugins>PageHelper.startPage(1,4);<settings>
  58. <plugins>
  59.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  60. </plugins>
  61. <plugins>
  62.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  63. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  64. </settings><plugins>
  65.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  66. </plugins>List list = mapper.selectByExample(null);<settings>
  67. <plugins>
  68.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  69. </plugins>
  70. <plugins>
  71.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  72. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  73. </settings><plugins>
  74.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  75. </plugins>list.forEach(emp-> System.out.println(emp));<settings>
  76. <plugins>
  77.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  78. </plugins>
  79. <plugins>
  80.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  81. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  82. </settings>} catch (IOException e) {<settings>
  83. <plugins>
  84.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  85. </plugins>
  86. <plugins>
  87.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  88. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  89. </settings><plugins>
  90.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  91. </plugins>e.printStackTrace();<settings>
  92. <plugins>
  93.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  94. </plugins>
  95. <plugins>
  96.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  97. </plugins><setting name="mapUnderscoreToCamelCase" value="true"/>
  98. </settings>}<plugins>
  99.     <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
  100. </plugins>}}
复制代码
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！

本帖子中包含更多资源

您需要 登录 才可以下载或查看，没有账号？立即注册

x
回复

使用道具 举报

0 个回复

倒序浏览
返回列表

快速回复

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 or 立即注册

本版积分规则

不到断气不罢休

金牌会员
这个人很懒什么都没写!

楼主热帖

标签云

存储 服务器
微信订阅号
微信服务号
微信客服
小程序
H5
关于我们 商务合作 网站地图
©Copyright 2022-2024 杭州祥升科技有限公司 版权所有 浙ICP备20004199号
快速回复 返回顶部 返回列表