- 1. 导入pom.xml文件坐标
- 2. 配置mybaitsConfig.xml
- 3. 使用测试代码进行测试
- 4. 附上完整的项目
- 1. 搭建数据库
- 2. 创建项目
- 3. 测试代码
mysql mysql-connector-java 8.0.22 org.mybatis mybatis 3.5.7 junit junit 4.12 test org.junit.jupiter junit-jupiter RELEASE compile com.github.pagehelper pagehelper 5.1.9 com.github.jsqlparser jsqlparser 2.0
注意事项
- 使用的mysql数据库版本是8.0.22
- 注意各个插件的版本
3. 使用测试代码进行测试
@Test
void findAll(){
// 设置分页的相关参数
PageHelper.startPage(2, 2);
List userList = mapper.findAll();
for (User user : userList) {
System.out.println(user);
}
}
结果如下:
User{id=3, username='lisi', password='111', birthday=Sat Oct 30 20:01:45 CST 2021}
User{id=4, username='lisi', password='111', birthday=Sat Oct 30 20:07:40 CST 2021}
4. 附上完整的项目
1. 搭建数据库
- 数据库名——mybatis
- 表名——user
- 创建表的语句
CREATE TABLE USER( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAr(50), PASSWORD VARCHAr(50), birthday BIGINT );2. 创建项目
- 创建User
public class User {
private Integer id;
private String username;
private String password;
private String birthday;
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + ''' +
", password='" + password + ''' +
", birthday='" + birthday + ''' +
'}';
}
public String getBirthday() {
return birthday;
}
public void setBirthday(String birthday) {
this.birthday = birthday;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
- 创建UserMapper
public interface UserMapper {
public List findAll();
}
- 配置文件sqlMapConfig.xml
- jdbc.properties
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT username=root password=2550
- UserMapper.xml
3. 测试代码select * from user
@Test
void findAll(){
// 设置分页的相关参数
PageHelper.startPage(2, 2);
List userList = mapper.findAll();
for (User user : userList) {
System.out.println(user);
}
// 获得与分页相关的参数
PageInfo pageInfo = new PageInfo(userList);
System.out.println("当前页:" + pageInfo.getPageNum());
System.out.println("每页显示条数: " + pageInfo.getPageSize());
System.out.println("总条数: " + pageInfo.getTotal());
System.out.println("总页数:" + pageInfo.getPages());
System.out.println("上一页:" + pageInfo.getPrePage());
System.out.println("下一页:" + pageInfo.getNextPage());
System.out.println("是否是第一页:" + pageInfo.isIsFirstPage());
System.out.println("是否是最后页:" + pageInfo.isIsLastPage());
sqlSession.close();
}



