spring boot 整合mybatis 简单整洁

最新推荐文章于 2023-04-11 13:24:44 发布

原创最新推荐文章于 2023-04-11 13:24:44 发布 · 567 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#spring boot #mybatis

本文详细介绍了如何将Spring Boot与Mybatis进行整合。首先在pom.xml中添加Mybatis依赖并配置appliaction.properties，包括实体类包路径、下划线转驼峰策略、默认查询大小和超时时间，以及Mapper XML文件位置。接着配置数据库连接信息，使用Druid数据源。然后创建UserDao接口和UserService实现业务逻辑，最后通过DemoController测试接口，返回用户信息。

                                spring boot 整合 mybatis

1.在pom.xml 中添加 mybatis 相关依赖

<dependency>
		<groupId>org.mybatis.spring.boot</groupId>
		<artifactId>mybatis-spring-boot-starter</artifactId>
		<version>1.3.1</version>
</dependency>
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.0.5</version>
</dependency>

在appliaction.properties 中添加相关配置
#mybatis
mybatis.type-aliases-package=com.imooc.miaosha.domain # 这个位置下的实体类对应数据库
mybatis.configuration.map-underscore-to-camel-case=true # 下划线转化成驼峰
mybatis.configuration.default-fetch-size=100
mybatis.configuration.default-statement-timeout=3000
mybatis.mapperLocations = classpath:com/zzy/miaosha/dao/*.xml # 扫描这个位置下的xml文件
在appliaction.properties 中添加数据库连接的配置

druid

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/miaosha?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat
spring.datasource.maxActive=2
spring.datasource.initialSize=1
spring.datasource.maxWait=60000
spring.datasource.minIdle=1
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=select ‘x’
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxOpenPreparedStatements=20

测试
1.新建 UserDao

@Mapper
public interface UserDao {
@Select(“select * from user where id = #{id}”)
public User getUserById(@Param(“id”) int id);

}

2 . 新建 UserService

@Service
public class UserService {
@Autowired
private UserDao userDao;
public User getUser(int id) {
return userDao.getUserById(id);
}
}
3. 新建 DemoController

@RequestMapping("/getUser")
@ResponseBody
public JsonResult getUser() {
User user = this.userService.getUser(1);
return JsonResult.success(user);
}
4. 测试成功
{“code”:0,“msg”:“success”,“data”:{“id”:1,“name”:“zhangsan”}}