自定义pageBean

domain包–>model:

1.pageBean类–>对应复杂查询的数据

package cn.itcast.domain;
import java.util.List;

public class PageBean<T> {

private int totalPage;  // 总页数
private int totalCount;  // 数据总条数
private int rows;  // 显示条数
private int currentPage;  // 当前页码
private List<T> list;  // 查询到的rows条数据

public int getTotalPage() {
    return totalPage;
}

public void setTotalPage(int totalPage) {
    this.totalPage = totalPage;
}

public int getTotalCount() {
    return totalCount;
}

public void setTotalCount(int totalCount) {
    this.totalCount = totalCount;
}

public int getRows() {
    return rows;
}

public void setRows(int rows) {
    this.rows = rows;
}

public int getCurrentPage() {
    return currentPage;
}

public void setCurrentPage(int currentPage) {
    this.currentPage = currentPage;
}

public List<T> getList() {
    return list;
}

public void setList(List<T> list) {
    this.list = list;
}

@Override
public String toString() {
    return "PageBean{" +
            "totalPage=" + totalPage +
            ", totalCount=" + totalCount +
            ", rows=" + rows +
            ", currentPage=" + currentPage +
            ", list=" + list +
            '}';
}
subject是什么:在Mapper.xml文件中定义查询语句: 复制 <select id="findTeachersByPage" resultMap="teacherMap"> select * from teacher <where> <if test="teacherName != null and teacherName != ''"> and teacher_name like concat('%', #{teacherName}, '%') </if> <if test="subject != null and subject != ''"> and subject = #{subject} </if> </where> order by id desc limit #{start}, #{pageSize} </select> 在Dao层中定义方法: 复制 public List<Teacher> findTeachersByPage(int start, int pageSize, String teacherName, String subject); 在Service层中调用Dao层方法,并进行分页处理: 复制 int totalCount = teacherDao.getTotalCount(teacherName, subject); // 获取总记录数 int totalPage = (totalCount % pageSize == 0) ? (totalCount / pageSize) : (totalCount / pageSize + 1); // 计算总页数 List<Teacher> teachers = teacherDao.findTeachersByPage(start, pageSize, teacherName, subject); // 获取当前页的数据 PageBean pageBean = new PageBean(currentPage, pageSize, totalCount, totalPage, teachers); // 封装分页数据 return pageBean; 在Controller层中获取请求参数,并调用Service层方法: 复制 @RequestMapping("/findTeachersByPage") public String findTeachersByPage(@RequestParam(defaultValue = "1") int currentPage, String teacherName, String subject, Model model) { int pageSize = 10; // 每页显示的记录数 int start = (currentPage - 1) * pageSize; // 当前页的起始记录索引 PageBean pageBean = teacherService.findTeachersByPage(start, pageSize, teacherName, subject); // 获取分页数据 model.addAttribute("pageBean", pageBean); model.addAttribute("teacherName", teacherName); model.addAttribute("subject", subject); return "teacherList"; } 其中,PageBean是一个自定义
06-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值