详解SpringBoot 快速整合MyBatis(去XML化)
作者:yizhiwazi 时间:2022-08-19 16:42:54
序言:
此前,我们主要通过XML来书写SQL和填补对象映射关系。在SpringBoot中我们可以通过注解来快速编写SQL并实现数据访问。(仅需配置:mybatis.configuration.map-underscore-to-camel-case=true)。为了方便大家,本案例提供较完整的层次逻辑SpringBoot+MyBatis+Annotation。
具体步骤
1. 引入依赖
在pom.xml 引入ORM框架(Mybaits-Starter)和数据库驱动(MySQL-Conn)的依赖。
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<!--继承信息 -->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.0.M4</version>
<relativePath/>
</parent>
<!--依赖管理 -->
<dependencies>
<dependency> <!--添加Web依赖 -->
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency> <!--添加Mybatis依赖 -->
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<dependency><!--添加MySQL驱动依赖 -->
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency><!--添加Test依赖 -->
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
</project>
2. 添加数据源
在application.yml 添加数据源,以及开启Mybaits的驼峰映射功能。
spring:
datasource:
url: jdbc:mysql://localhost:3306/socks?useSSL=false
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
mybatis:
configuration:
map-underscore-to-camel-case: true #开启驼峰映射
3. 编写数据层代码
// POJO类如下:
public class User {
private String userId;
private String username;
private String password;
// Getters & Setters ..
}
// 数据层代码如下:
public interface UserMapper {
@Select("select * from t_user where 1=1")
List<User> list();
@Select("select * from t_user where username like #{username}")
List<User> findByUsername(String username);
@Select("select * from t_user where user_id like #{userId}")
User getOne(String userId);
@Delete("delete from t_user where user_id like #{userId}")
int delete(String userId);
}
4. 添加数据库记录
在Navicat 连接本地数据库,随便打开查询窗口,复制下面这段脚本,点击执行即可。
DROP DATABASE IF EXISTS `socks`;
CREATE DATABASE `socks`;
USE `SOCKS`;
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`USER_ID` varchar(50) ,
`USERNAME` varchar(50) ,
`PASSWORD` varchar(50)
) ;
INSERT INTO `t_user` VALUES ('1', 'admin', 'admin');
INSERT INTO `t_user` VALUES ('2', 'yizhiwazi', '123456');
5. 启动项目
@SpringBootApplication
@MapperScan("com.hehe.mapper") //扫描Mapper接口
public class MybatisApplication {
public static void main(String[] args) {
SpringApplication.run(MybatisApplication.class, args);
}
}
6. 单元测试
import static org.assertj.core.api.Assertions.assertThat;
@RunWith(SpringRunner.class)
@SpringBootTest
public class MybatisApplicationTest {
@SuppressWarnings("all")
@Autowired
UserMapper userMapper;
@Test
public void test_db() {
//开始进行测试
assertThat(userMapper.list().size()).isGreaterThan(1);
assertThat(userMapper.getOne("1")).isNotEqualTo(null);
assertThat(userMapper.getOne("xxx")).isEqualTo(null);
}
}
来源:http://www.jianshu.com/p/fa89b59ade40?utm_source=tuicool&utm_medium=referral
标签:Spring,Boot,MyBatis
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
C#实现Base64处理的加密解密,编码解码示例
2023-07-15 12:11:31
Java实现word/pdf转html并在线预览
2022-09-09 09:16:49
![](https://img.aspxhome.com/file/2023/5/65635_0s.png)
java中dart类详细讲解
2022-01-23 13:01:13
Java字符串技巧之删除标点或最后字符的方法
2023-02-06 21:42:50
SpringBoot使用JWT实现登录验证的方法示例
2023-09-19 19:12:10
![](https://img.aspxhome.com/file/2023/9/63689_0s.png)
Springboot内置的工具类之CollectionUtils示例讲解
2023-08-23 20:47:13
![](https://img.aspxhome.com/file/2023/0/58440_0s.jpg)
Spring的refresh()方法相关异常解析
2021-12-08 07:39:07
java中驼峰与下划线的写法互转
2023-09-21 09:47:36
学习Java的Date、Calendar日期操作
2023-09-04 22:26:38
C# GDI+实现时钟表盘
2023-06-20 07:11:32
![](https://img.aspxhome.com/file/2023/7/66117_0s.jpg)
C# Websocket连接实现wss协议
2022-09-02 08:20:41
Android基础教程数据存储之文件存储
2023-08-05 18:18:10
![](https://img.aspxhome.com/file/2023/3/86743_0s.png)
Java中的字符串常量池详细介绍
2023-03-08 09:16:41
Java内存模型(JMM)及happens-before原理
2023-11-25 00:41:05
![](https://img.aspxhome.com/file/2023/2/59972_0s.png)
关于@MapperScan包扫描的坑及解决
2023-02-13 02:45:46
Java GUI编程实现在线聊天室
2022-04-07 22:50:09
Java并发LinkedBlockingQueue源码分析
2022-09-01 08:35:30
![](https://img.aspxhome.com/file/2023/3/66533_0s.png)
Java二维数组简单定义与使用方法示例
2022-01-28 08:31:37
Object类toString()和equals()方法使用解析
2022-10-28 08:48:43
java实现微信小程序登录态维护的示例代码
2023-08-22 18:29:46