1、导入需要mybatis的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
2、aplication.yml中配置数据库连接
################# 数据库基本配置
spring:
datasource:
username: root
password: root
# 注意时间区
url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
driver-class-name: com.mysql.jdbc.Driver # mysql 5
type: com.alibaba.druid.pool.DruidDataSource
dbcp2:
initial-size: 5
tomcat:
max-active: 200
filters: stat,wall,log4j
############### 整合mybatis
mybatis:type-aliases-package: com.chini.jdbx.demo.mapper
mybatis:
type-aliases-package: com.chini.jdbx.demo.popj # 实体类
mapper-locations: classpath:mybatis/mapper/*.xml # mapper.xml放置的位置
3、实体类popj:略
4、mapper接口 以查询为例
@Mapper
@Repository
public interface UserMapper {
List<User> getAllUsers();
}
5、UserMapper.xml中写对应的sql的语句
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.chini.jdbx.demo.mapper.UserMapper">
<select id="getAllUsers" resultType="User">
select * from user
</select>
</mapper>
6、UserController调用
@RestController
public class UserController {
@Autowired
UserMapper userMapper;
@GetMapping("/getAll")
public List<User> getAllUsers(){
List<User> allUsers = userMapper.getAllUsers();
for(User user : allUsers)
System.out.println(user.getName());
return allUsers;
}
}
网友评论