前期工作
1.导入mybatis整合依赖
1
2
3
4
5
6
|
<!-- mybatis整合 -->
< dependency >
< groupId >org.mybatis.spring.boot</ groupId >
< artifactId >mybatis-spring-boot-starter</ artifactId >
< version >2.1.4</ version >
</ dependency >
|
2.连接数据库
3.连接完数据库就去applicaton.yml配置一下数据库
1
2
3
4
5
6
|
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql: //localhost :3306 /mybatis ?serverTimezone=UTC&useUnicode= true &characterEncoding=utf-8
driver-class-name: com.mysql.cj.jdbc.Driver
|
开始整合
1.编写与数据库对应的实体类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
package com.example.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private Integer id;
private String name;
private String pwd;
}
|
为了偷懒,导入了lombok
1
2
3
4
5
|
<!-- lombok -->
< dependency >
< groupId >org.projectlombok</ groupId >
< artifactId >lombok</ artifactId >
</ dependency >
|
2.编写mapper
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
package com.example.mapper;
import com.example.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository
public interface UserMapper {
//查询用户的全部信息
List<User> getUserList();
//select 找出id=1的用户
User getUserById( int id);
//insert 增加一个用户
int insertUser(User user);
//delete 删除id=4的用户
int deleteUser( int id);
//update 将id=2的用户名字改为小龙
int updateUser(User user);
}
|
3.编写mapper.xml文件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<? 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.example.mapper.UserMapper" >
< select id = "getUserList" resultType = "user" >
select *
from mybatis.user
</ select >
< select id = "getUserById" resultType = "user" parameterType = "int" >
select *
from mybatis.user
where id = #{id};
</ select >
< insert id = "insertUser" parameterType = "user" >
insert into mybatis.user (id, name, pwd)
values (#{id}, #{name}, #{pwd});
</ insert >
< delete id = "deleteUser" parameterType = "int" >
delete
from mybatis.user
where id = #{id};
</ delete >
< update id = "updateUser" parameterType = "user" >
update mybatis.user
set name = #{name},
pwd = #{pwd}
where id = #{id};
</ update >
</ mapper >
|
这里我们用了别名而且我们把这个mapper.xml文件放在了resources目录下,所以我们要去application.yml配置一下
1
2
3
|
mybatis:
type -aliases-package: com.example.pojo
mapper-locations: classpath:mybatis /mapper/ *.xml
|
mapper.xml文件编写的位置:
4.编写controller
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
package com.example.controller;
import com.example.mapper.UserMapper;
import com.example.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class UserController {
@Autowired
private UserMapper userMapper;
@GetMapping ( "/getUserList" )
public List<User> getUserList(){
return userMapper.getUserList();
}
@GetMapping ( "/getUserById/{id}" )
public User getUserById( @PathVariable ( "id" ) int id){
return userMapper.getUserById(id);
}
@GetMapping ( "/insertUser" )
public String insertUser(){
userMapper.insertUser( new User( 5 , "xiaoming" , "111" ));
return "ok" ;
}
@GetMapping ( "/deleteUser" )
public String deleteUser(){
userMapper.deleteUser( 5 );
return "ok" ;
}
@GetMapping ( "/updateUser" )
public String updateUser(){
userMapper.updateUser( new User( 5 , "xx" , "111" ));
return "ok" ;
}
}
|
5.进行测试
以上就是Springboot整合mybatis的步骤的详细内容,更多关于Springboot整合mybatis的资料请关注服务器之家其它相关文章!
原文链接:https://juejin.cn/post/6949443343780675620