SpringBoot整合Mybatis
发表于更新于
字数总计:822阅读时长:4分钟阅读量: 成都
SpringBoot整合Mybatis
创建项目
使用Intellij IDEA快速创建SpringBoot项目
选择springboot版本号，并且勾选MyBatis与MySQL驱动
配置MyBatis
SpringBoot项目配置MyBatis特别简单，只需要在配置文件中填写所需的连接信息就行了
在application.yml配置文件中添加连接信息
1
2
3
4
5
6
| spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test
username: manager
password: mk123456
|
这样就配置完成了，是不是非常简单
创建实体类
创建一个用户装载数据库中的表的数据的实体类
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
| package com.example.main;
import java.util.Date;
public class User {
private Integer id;
private String name;
private String gender;
private Integer age;
private String phone;
private Date birthday;
private Double balance;
public User() {
}
public User(Integer id, String name, String gender, Integer age, String phone, Date birthday, Double balance) {
this.id = id;
this.name = name;
this.gender = gender;
this.age = age;
this.phone = phone;
this.birthday = birthday;
this.balance = balance;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", gender='" + gender + '\'' +
", age=" + age +
", phone='" + phone + '\'' +
", birthday=" + birthday +
", balance=" + balance +
'}';
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public Double getBalance() {
return balance;
}
public void setBalance(Double balance) {
this.balance = balance;
}
}
|
创建持久层访问类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| package com.example.dao;
import com.example.main.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;
@Mapper
public interface UserDao {
@Select("select * from t_user")
List<User> queryAll();
}
|
创建服务类
创建服务接口
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| package com.example.service;
import com.example.main.User;
import java.util.List;
public interface UserService {
List<User> getAllUsers();
}
|
实现服务类接口
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.service.impl;
import com.example.dao.UserDao;
import com.example.main.User;
import com.example.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public List<User> getAllUsers() {
return userDao.queryAll();
}
}
|
创建持久层访问接口
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| package com.example.dao;
import com.example.main.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;
@Mapper
public interface UserDao {
@Select("select * from t_user")
List<User> queryAll();
}
|
编写测试代码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| package com.example.service;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
@SpringBootTest
class UserServiceTest {
@Autowired
private UserService userService;
@Test
void getAllUsers() {
System.out.println(userService.getAllUsers());
}
}
|
如果输出正确，表示配置成功
