SpringBoot整合mybatis
1、创建SpringBoot项目
导入需要的依赖,mysql,mybatis等
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
<dependency>
<groupId>org.springframework.experimental</groupId>
<artifactId>spring-native</artifactId>
<version>${spring-native.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.24</version>
</dependency>
</dependencies>
2、用idea链接数据库
3、创建实体类pojo
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private String name;
private int age;
}
4、配置主配置类
需要在application.properties中配mybatis的配置文件
#数据库配置
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#整合mybatis
mybatis.type-aliases-package=com.zhangpl.springbootmybatis.pojo
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.type-handlers-package=com.zhangpl.springbootmybatis.service
5、创建mapper层接口
@Mapper
@Component
public interface UserMapper {
List<User> querryUser();
User queryById(String name );
int updateUser(User user);
int addUser(User user);
int deleteUser(String name);
}
6、mybatis的xml配置文件实现mapper接口
<?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.zhangpl.springbootmybatis.mapper.UserMapper">
<select id="querryUser" resultType="User">
select * from user;
</select>
</mapper>
7、controller层编写
@RestController
@RequestMapping("/queryUser")
//@ResponseBody
public class UserController {
@Autowired
// UserService userService;
private UserMapper userMapper;
@GetMapping("/user")
public List<User> users(){
return userMapper.querryUser();
}
8、测试
浏览器地址栏访问