SpringBoot整合Mybatis-方式2：mapper使用XML配置方式

缺乏、安全感 2022-05-12 09:52 281阅读 0赞

上一篇博文已经详细介绍了SpringBoot环境搭建过程，这一节介绍一下SpringBoot整合Mybatis，在mapper中数据库的查询操作使用的是注解的方式，本文将介绍使用XML的方式进行整合。

# SpringBoot整合Mybatis #

**方式2：mapper使用XML**

项目结构

![70][]

1：准备数据库数据和配置数据源以及配置Mybatis的XML配置文件

![70 1][]

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> #加载Mybatis配置文件 mybatis.mapper-locations = classpath:mapper/*Mapper.xml mybatis.config-location = classpath:config/sqlMapConfig.xml &nbsp; #数据源必填项 spring.datasource.driver-class-name= com.mysql.jdbc.Driver spring.datasource.url = jdbc:mysql://localhost:3306/study?useUnicode=true&amp;characterEncoding=utf-8 spring.datasource.username = root spring.datasource.password = 123456 &nbsp; #选填 # Number of ms to wait before throwing an exception if no connection is available. spring.datasource.tomcat.max-wait=10000 # Maximum number of active connections that can be allocated from this pool at the same time. spring.datasource.tomcat.max-active=50 # Validate the connection before borrowing it from the pool. spring.datasource.tomcat.test-on-borrow=true </td> 
 </tr> 
 </tbody> 
</table>

2：编写Mapper.Xml和sqlMapConfig.xml

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> userMapper.xml </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"&gt; &lt;mapper namespace="com.liujia.springdemo.mapper.UserMapper" &gt; &nbsp;&nbsp;&nbsp; &lt;select id="getAll" resultType="com.liujia.springdemo.entity.User"&nbsp; &gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT * &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM user &nbsp;&nbsp;&nbsp; &lt;/select&gt; &lt;/mapper&gt; </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> sqlMapConfig.xml </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> &lt;?xml version="1.0" encoding="UTF-8" ?&gt; &lt;!DOCTYPE configuration &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PUBLIC "-//mybatis.org//DTD Config 3.0//EN" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "http://mybatis.org/dtd/mybatis-3-config.dtd"&gt; &lt;configuration&gt; &nbsp;&nbsp;&nbsp;&nbsp; &lt;typeAliases&gt; &nbsp;&nbsp;&nbsp;&nbsp; &lt;/typeAliases&gt; &lt;/configuration&gt; </td> 
 </tr> 
 </tbody> 
</table>

3：加maven依赖

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!-- Spring-Mybatis --&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dependency&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;groupId&gt;org.mybatis.spring.boot&lt;/groupId&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;artifactId&gt;mybatis-spring-boot-starter&lt;/artifactId&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;version&gt;1.3.2&lt;/version&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dependency&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!-- MySQL驱动 --&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;dependency&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;groupId&gt;mysql&lt;/groupId&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/dependency&gt; </td> 
 </tr> 
 </tbody> 
</table>

4：编写实体类

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> public class User implements Serializable { &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; private static final long serialVersionUID = 1L; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; private int id;// id &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; private String name;// 姓名 &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; private int age;// 年龄 &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; public int getId() { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return id; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; public void setId(int id) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.id = id; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; public String getName() { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return name; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; public void setName(String name) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.name = name; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; public int getAge() { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return age; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; public void setAge(int age) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.age = age; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; @Override &nbsp;&nbsp;&nbsp;&nbsp; public String toString() { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return "User [id=" + id + ", name=" + name + ", age=" + age + "]"; &nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; } </td> 
 </tr> 
 </tbody> 
</table>

5：编写mapper

6：编写service层

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> import java.util.List; &nbsp; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; &nbsp; import com.liujia.springdemo.entity.User; import com.liujia.springdemo.mapper.UserMapper; &nbsp; @Service public class UserService { &nbsp;&nbsp;&nbsp; @Autowired &nbsp;&nbsp;&nbsp; private UserMapper userMapper; &nbsp; &nbsp;&nbsp;&nbsp; public List&lt;User&gt; getAll() { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return userMapper.getAll(); &nbsp;&nbsp;&nbsp; }; } </td> 
 </tr> 
 </tbody> 
</table>

7：编写Copntroller层

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> import java.util.List; &nbsp; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; &nbsp; import com.liujia.springdemo.entity.User; import com.liujia.springdemo.service.UserService; &nbsp; @RestController public class UserController { &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; @Autowired &nbsp;&nbsp;&nbsp;&nbsp; private UserService userService; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; @RequestMapping("/getallusers") &nbsp;&nbsp;&nbsp;&nbsp; public List&lt;User&gt; getAllUsers() { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return userService.getAll();&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; } } </td> 
 </tr> 
 </tbody> 
</table>

8：增加包扫描和运行程序

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> @SpringBootApplication @MapperScan(basePackages = { "com.liujia.springdemo.mapper"}) public class Application { &nbsp; &nbsp;&nbsp;&nbsp; public static void main(String[] args) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SpringApplication.run(Application.class, args); &nbsp;&nbsp;&nbsp; } &nbsp; &nbsp;&nbsp;&nbsp; @Bean &nbsp;&nbsp;&nbsp; public CommandLineRunner commandLineRunner(ApplicationContext ctx) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return args -&gt; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("Let's inspect the beans provided by Spring Boot:"); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String[] beanNames = ctx.getBeanDefinitionNames(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Arrays.sort(beanNames); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (String beanName : beanNames) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(beanName); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }; &nbsp;&nbsp;&nbsp; } } </td> 
 </tr> 
 </tbody> 
</table>

运行结果

![70 2][]

参考文献

[https://docs.spring.io/spring-boot/docs/2.0.5.RELEASE/reference/htmlsingle/\#boot-features-using-jdbc-template][https_docs.spring.io_spring-boot_docs_2.0.5.RELEASE_reference_htmlsingle_boot-features-using-jdbc-template]

[https://blog.csdn.net/saytime/article/details/74783296][https_blog.csdn.net_saytime_article_details_74783296]

总结：

两种方式的区别

1：是否需要在application.properties中配置mapper.xml和sqlMapperConfig.xml

2：将SQL语句写在了XML中

由于第二种方式将比较繁琐的SQL语句写在了配置文件中，整个代码结构更加清晰，本人更加喜欢此种配置方式。

源码下载地址

[https://download.csdn.net/download/caoshangfeidie000/10670735][https_download.csdn.net_download_caoshangfeidie000_10670735]

[70]: /images/20220512/1dcd378d74a8423497d3de2281636664.png
[70 1]: /images/20220512/51e44c833e4047f7b95554758340c197.png
[70 2]: /images/20220512/b3eb7176e7274b70a74fde43beaa6109.png
[https_docs.spring.io_spring-boot_docs_2.0.5.RELEASE_reference_htmlsingle_boot-features-using-jdbc-template]: https://docs.spring.io/spring-boot/docs/2.0.5.RELEASE/reference/htmlsingle/#boot-features-using-jdbc-template
[https_blog.csdn.net_saytime_article_details_74783296]: https://blog.csdn.net/saytime/article/details/74783296
[https_download.csdn.net_download_caoshangfeidie000_10670735]: https://download.csdn.net/download/caoshangfeidie000/10670735