一、实体层
User.java
package com.example.demo.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private Long id;
private String userName;
private String passwd;
private String createDate;
}
Pager.java
package com.example.demo.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Pager {
private Object data;
private int pageTotle;
}
二、创建UserMapper.xml
<?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.demo.mapper.UserMapper">
</mapper>
三、通过ResultMap建立User实体和t_user表的映射关系
<resultMap id="userResult" type="User">
<result column="id" property="id"/>
<result column="user_name" property="userName"/>
<result column="passwd" property="passwd"/>
<result column="create_date" property="createDate"/>
</resultMap>
# 四、在UserMapper中添加查询所有用户的方法
UserMapper.java
public interface UserMapper {
public List<User> selectAll(int pageIndex, int pageSize);
}
UserMapper.xml
<sql id="sql_template">
select id,user_name,passwd,create_date from t_user
</sql>
<select id="selectAll" resultMap="userResult">
<include refid="sql_template"></include>limit #{pageIndex}, #{pageSize}
</select>
五、在IUserService中添加业务方法
IUserService接口
public interface IUserService {
public Pager queryUserList(int pageIndex, int pageSize);
}
UserServiceImpl实现类
package com.example.demo.service.Impl;
import com.example.demo.entity.User;
import com.example.demo.mapper.UserMapper;
import com.example.demo.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserServiceImpl implements IUserService {
@Autowired(required = false)
private UserMapper userMapper;
@Override
public Pager queryUserList(int pageIndex, int pageSize) {
List<User> list = userMapper.selectAll((pageIndex-1)*pageSize, pageSize);
int count = userMapper.selectCount();
return new Pager(list, count);
}
}
六、在UserController中测试
package com.example.demo.controller;
import com.example.demo.entity.User;
import com.example.demo.mapper.UserMapper;
import com.example.demo.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RequestMapping("/user")
@RestController
public class UserController {
@Autowired
private IUserService iUserService;
@RequestMapping("/list")
public Pager findUserList(int pageIndex, int pageSize){
return iUserService.queryUserList(pageIndex, pageSize);
}
}
七、运行效果![请添加图片描述](https://img-blog.csdnimg.cn/dabd63b617de452cb2ffdeaf7e1f35dd.png)