第四天的主要任务是完成分页管理,一下是需要改动的地方
首先需要修改数据库,给数据库加一个age字段,然后在bean里面添加一个类PageInfo
PageInfo类
package com.zhongruan.bean;
import java.util.List;
// 分页类
public class PageInfo<T> {
// 当前页需要展示的数据
private List<T> list;
private int totalPage; // 总页数
private int totalCount; // 总记录数
private int size; // 每页数据量
private int currentPage; // 当前页数
public PageInfo() {
}
public PageInfo(List<T> list, int totalPage, int totalCount, int size, int currentPage) {
this.list = list;
this.totalPage = totalPage;
this.totalCount = totalCount;
this.size = size;
this.currentPage = currentPage;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
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 getSize() {
return size;
}
public void setSize(int size) {
this.size = size;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
@Override
public String toString() {
return "PageInfo{" +
"list=" + list +
", totalPage=" + totalPage +
", totalCount=" + totalCount +
", size=" + size +
", currentPage=" + currentPage +
'}';
}
}
User类(加上int类型的age)
package com.zhongruan.bean;
import com.mysql.cj.x.protobuf.MysqlxDatatypes;
public class User {
private int id;
private String username;
private String password;
private int age;
public User() {
}
public User(int id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
this.age = age;
}
public User(String username, String password) {
this.username = username;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int 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;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
dataList.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head>
<!-- 页面meta -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>武汉理工</title>
<meta name="description" content="AdminLTE2定制版">
<meta name="keywords" content="AdminLTE2定制版">
<!-- Tell the browser to be responsive to screen width -->
<meta content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" name="viewport">
<!-- Bootstrap 3.3.6 -->
<!-- Font Awesome -->
<!-- Ionicons -->
<!-- iCheck -->
<!-- Morris chart -->
<!-- jvectormap -->
<!-- Date Picker -->
<!-- Daterange picker -->
<!-- Bootstrap time Picker -->
<!--<link rel="stylesheet" href="../../../plugins/timepicker/bootstrap-timepicker.min.css">-->
<!-- bootstrap wysihtml5 - text editor -->
<!--数据表格-->
<!-- 表格树 -->
<!-- select2 -->
<!-- Bootstrap Color Picker -->
<!-- bootstrap wysihtml5 - text editor -->
<!--bootstrap-markdown-->
<!-- Theme style -->
<!-- AdminLTE Skins. Choose a skin from the css/skins
folder instead of downloading all of them to reduce the load. -->
<!-- Ion Slider -->
<!-- ion slider Nice -->
<!-- bootstrap slider -->
<!-- bootstrap-datetimepicker -->
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<!-- jQuery 2.2.3 -->
<!-- jQuery UI 1.11.4 -->
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<!-- Bootstrap 3.3.6 -->
<!-- Morris.js charts -->
<!-- Sparkline -->
<!-- jvectormap -->
<!-- jQuery Knob Chart -->
<!-- daterangepicker -->
<!-- datepicker -->
<!-- Bootstrap WYSIHTML5 -->
<!-- Slimscroll -->
<!-- FastClick -->
<!-- iCheck -->
<!-- AdminLTE App -->
<!-- 表格树 -->
<!-- select2 -->
<!-- bootstrap color picker -->
<!-- bootstrap time picker -->
<!--<script src="../../../plugins/timepicker/bootstrap-timepicker.min.js"></script>-->
<!-- Bootstrap WYSIHTML5 -->
<!--bootstrap-markdown-->
<!-- CK Editor -->
<!-- InputMask -->
<!-- DataTables -->
<!-- ChartJS 1.0.1 -->
<!-- FLOT CHARTS -->
<!-- FLOT RESIZE PLUGIN - allows the chart to redraw when the window is resized -->
<!-- FLOT PIE PLUGIN - also used to draw donut charts -->
<!-- FLOT CATEGORIES PLUGIN - Used to draw bar charts -->
<!-- jQuery Knob -->
<!-- Sparkline -->
<!-- Morris.js charts -->
<!-- Ion Slider -->
<!-- Bootstrap slider -->
<!-- bootstrap-datetimepicker -->
<!-- 页面meta /-->
<link rel="stylesheet" href="../plugins/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="../plugins/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="../plugins/ionicons/css/ionicons.min.css">
<link rel="stylesheet" href="../plugins/iCheck/square/blue.css">
<link rel="stylesheet" href="../plugins/morris/morris.css">
<link rel="stylesheet" href="../plugins/jvectormap/jquery-jvectormap-1.2.2.css">
<link rel="stylesheet" href="../plugins/datepicker/datepicker3.css">
<link rel="stylesheet" href="../plugins/daterangepicker/daterangepicker.css">
<link rel="stylesheet" href="../plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">
<link rel="stylesheet" href="../plugins/datatables/dataTables.bootstrap.css">
<link rel="stylesheet" href="../plugins/treeTable/jquery.treetable.css">
<link rel="stylesheet" href="../plugins/treeTable/jquery.treetable.theme.default.css">
<link rel="stylesheet" href="../plugins/select2/select2.css">
<link rel="stylesheet" href="../plugins/colorpicker/bootstrap-colorpicker.min.css">
<link rel="stylesheet" href="../plugins/bootstrap-markdown/css/bootstrap-markdown.min.css">
<link rel="stylesheet" href="../plugins/adminLTE/css/AdminLTE.css">
<link rel="stylesheet" href="../plugins/adminLTE/css/skins/_all-skins.min.css">
<link rel="stylesheet" href="../css/style.css">
<link rel="stylesheet" href="../plugins/ionslider/ion.rangeSlider.css">
<link rel="stylesheet" href="../plugins/ionslider/ion.rangeSlider.skinNice.css">
<link rel="stylesheet" href="../plugins/bootstrap-slider/slider.css">
<link rel="stylesheet" href="../plugins/bootstrap-datetimepicker/bootstrap-datetimepicker.css">
</head>
<body class="hold-transition skin-purple sidebar-mini">
<div class="wrapper">
<!-- 页面头部 -->
<jsp:include page="header.jsp"></jsp:include>
<!-- 页面头部 /-->
<!-- 导航侧栏 -->
<jsp:include page="aside.jsp"></jsp:include>
<!-- 导航侧栏 /-->
<!-- 内容区域 -->
<!-- @@master = admin-layout.html-->
<!-- @@block = content -->
<div class="content-wrapper">
<!-- 内容头部 -->
<section class="content-header">
<h1>
用户管理
<small>用户列表</small>
</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> 首页</a></li>
<li><a href="#">用户管理</a></li>
<li class="active">用户列表</li>
</ol>
</section>
<!-- 内容头部 /-->
<!-- 正文区域 -->
<section class="content">
<!-- .box-body -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">列表</h3>
</div>
<div class="box-body">
<!-- 数据表格 -->
<div class="table-box">
<!--工具栏-->
<div class="pull-left">
<div class="form-group form-inline">
<div class="btn-group">
<button type="button" class="btn btn-default" title="新建"><i class="fa fa-file-o"></i> 新建</button>
<button type="button" class="btn btn-default" title="删除"><i class="fa fa-trash-o"></i> 删除</button>
<button type="button" class="btn btn-default" title="开启"><i class="fa fa-check"></i> 开启</button>
<button type="button" class="btn btn-default" title="屏蔽"><i class="fa fa-ban"></i> 屏蔽</button>
<button type="button" class="btn btn-default" title="刷新"><i class="fa fa-refresh"></i> 刷新</button>
</div>
</div>
</div>
<div class="box-tools pull-right">
<div class="has-feedback">
<input type="text" class="form-control input-sm" placeholder="搜索">
<span class="glyphicon glyphicon-search form-control-feedback"></span>
</div>
</div>
<!--工具栏/-->
<!--数据列表-->
<table id="dataList" class="table table-bordered table-striped table-hover dataTable">
<thead>
<tr>
<th class="" style="padding-right:0px;">
<input id="selall" type="checkbox" class="icheckbox_square-blue">
</th>
<th class="sorting_asc">ID</th>
<th class="sorting_desc">用户名</th>
<th class="sorting_asc sorting_asc_disabled">密码</th>
<th class="sorting_desc sorting_desc_disabled">年龄</th>
<th class="text-center">操作</th>
</tr>
</thead>
<tbody>
<%-- c:forEach JSTL 提供的遍历标签 --%>
<c:forEach items="${pageInfo.list}" var="user">
<tr>
<td><input name="ids" type="checkbox"></td>
<td>${user.id}</td>
<td>${user.username}</td>
<td>${user.password}</td>
<td>${user.age}</td>
<td class="text-center">
<a href="/user/toUpdate?id=${user.id}" class="btn bg-olive btn-xs">编辑</a>
<a class="btn bg-olive btn-xs">详情</a>
<a href="/user/delete?id=${user.id}" class="btn bg-olive btn-xs">删除</a>
</td>
</tr>
</c:forEach>
</tbody>
<!--
<tfoot>
<tr>
<th>Rendering engine</th>
<th>Browser</th>
<th>Platform(s)</th>
<th>Engine version</th>
<th>CSS grade</th>
</tr>
</tfoot>-->
</table>
<!--数据列表/-->
</div>
<!-- 数据表格 /-->
</div>
<!-- /.box-body -->
<!-- .box-footer-->
<div class="box-footer">
<div class="pull-left">
<div class="form-group form-inline">
总共${pageInfo.totalPage} 页,共${pageInfo.totalCount} 条数据。 每页
<select class="form-control">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</select> 条
</div>
</div>
<div class="box-tools pull-right">
<ul class="pagination">
<li>
<a href="${pageContext.request.contextPath}/user/findAll03?currentPage=1" aria-label="Previous">首页</a>
</li>
<li><a href="${pageContext.request.contextPath}/user/findAll03?currentPage=${pageInfo.currentPage - 1}">上一页</a></li>
<c:forEach begin="1" end="${pageInfo.totalPage}" var="pageNum">
<li><a href="${pageContext.request.contextPath}/user/findAll03?currentPage=${pageNum}">${pageNum}</a></li>
</c:forEach>
<li><a href="${pageContext.request.contextPath}/user/findAll03?currentPage=${pageInfo.currentPage + 1}">下一页</a></li>
<li>
<a href="${pageContext.request.contextPath}/user/findAll03?currentPage=${pageInfo.totalPage}" aria-label="Next">尾页</a>
</li>
</ul>
</div>
</div>
<!-- /.box-footer-->
</div>
</section>
<!-- 正文区域 /-->
</div>
<!-- @@close -->
<!-- 内容区域 /-->
</div>
<script src="../plugins/jQuery/jquery-2.2.3.min.js"></script>
<script src="../plugins/jQueryUI/jquery-ui.min.js"></script>
<script>
$.widget.bridge('uibutton', $.ui.button);
</script>
<script src="../plugins/bootstrap/js/bootstrap.min.js"></script>
<script src="../plugins/raphael/raphael-min.js"></script>
<script src="../plugins/morris/morris.min.js"></script>
<script src="../plugins/sparkline/jquery.sparkline.min.js"></script>
<script src="../plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="../plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
<script src="../plugins/knob/jquery.knob.js"></script>
<script src="../plugins/daterangepicker/moment.min.js"></script>
<script src="../plugins/daterangepicker/daterangepicker.js"></script>
<script src="../plugins/daterangepicker/daterangepicker.zh-CN.js"></script>
<script src="../plugins/datepicker/bootstrap-datepicker.js"></script>
<script src="../plugins/datepicker/locales/bootstrap-datepicker.zh-CN.js"></script>
<script src="../plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>
<script src="../plugins/slimScroll/jquery.slimscroll.min.js"></script>
<script src="../plugins/fastclick/fastclick.js"></script>
<script src="../plugins/iCheck/icheck.min.js"></script>
<script src="../plugins/adminLTE/js/app.min.js"></script>
<script src="../plugins/treeTable/jquery.treetable.js"></script>
<script src="../plugins/select2/select2.full.min.js"></script>
<script src="../plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
<script src="../plugins/bootstrap-wysihtml5/bootstrap-wysihtml5.zh-CN.js"></script>
<script src="../plugins/bootstrap-markdown/js/bootstrap-markdown.js"></script>
<script src="../plugins/bootstrap-markdown/locale/bootstrap-markdown.zh.js"></script>
<script src="../plugins/bootstrap-markdown/js/markdown.js"></script>
<script src="../plugins/bootstrap-markdown/js/to-markdown.js"></script>
<script src="../plugins/ckeditor/ckeditor.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="../plugins/input-mask/jquery.inputmask.extensions.js"></script>
<script src="../plugins/datatables/jquery.dataTables.min.js"></script>
<script src="../plugins/datatables/dataTables.bootstrap.min.js"></script>
<script src="../plugins/chartjs/Chart.min.js"></script>
<script src="../plugins/flot/jquery.flot.min.js"></script>
<script src="../plugins/flot/jquery.flot.resize.min.js"></script>
<script src="../plugins/flot/jquery.flot.pie.min.js"></script>
<script src="../plugins/flot/jquery.flot.categories.min.js"></script>
<script src="../plugins/ionslider/ion.rangeSlider.min.js"></script>
<script src="../plugins/bootstrap-slider/bootstrap-slider.js"></script>
<script src="../plugins/bootstrap-datetimepicker/bootstrap-datetimepicker.js"></script>
<script src="../plugins/bootstrap-datetimepicker/locales/bootstrap-datetimepicker.zh-CN.js"></script>
<script>
$(document).ready(function() {
// 选择框
$(".select2").select2();
// WYSIHTML5编辑器
$(".textarea").wysihtml5({
locale: 'zh-CN'
});
});
// 设置激活菜单
function setSidebarActive(tagUri) {
var liObj = $("#" + tagUri);
if (liObj.length > 0) {
liObj.parent().parent().addClass("active");
liObj.addClass("active");
}
}
$(document).ready(function() {
// 激活导航位置
setSidebarActive("admin-datalist");
// 列表按钮
$("#dataList td input[type='checkbox']").iCheck({
checkboxClass: 'icheckbox_square-blue',
increaseArea: '20%'
});
// 全选操作
$("#selall").click(function() {
var clicks = $(this).is(':checked');
if (!clicks) {
$("#dataList td input[type='checkbox']").iCheck("uncheck");
} else {
$("#dataList td input[type='checkbox']").iCheck("check");
}
$(this).data("clicks", !clicks);
});
});
</script>
</body>
</html>
UserServiceImpl(分页实现的方法)
package com.zhongruan.service.impl;
import com.zhongruan.bean.PageInfo;
import com.zhongruan.bean.User;
import com.zhongruan.dao.UserDao;
import com.zhongruan.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
UserDao userDao;
@Override
public List<User> findAll() {
return userDao.findAll();
}
@Override
public User login(User user) {
return userDao.checkUser(user);
}
//修改之后的register 因为insert语句返回值是int类型,所以如果写成User register()会返回错误
@Override
public boolean register(User user) {
//检查用户是否存在
User queryUser = userDao.checkUser(user);
if (queryUser != null){
return false;
}else{
int rows=userDao.addUser(user);
return rows ==1;
}
}
//day4
@Override
public void deleteByID(int id) {
userDao.deleteByID(id);
}
@Override
public User findByID(int id) {
return userDao.findByID(id);
}
@Override
public int update(User user) {
return userDao.update(user);
}
@Override
public PageInfo<User> findByPage(int currentPage) {
PageInfo<User> pageInfo = new PageInfo<>();
// 指定每页的数据量
pageInfo.setSize(5);
// 指定总数据量
int totalCount = userDao.getTotal();
pageInfo.setTotalCount(totalCount);
// 指定总页数 ceil() 向上取整 floor() 向下取整 round() 四舍五入
int totalPage = (int) Math.ceil(totalCount / (double)pageInfo.getSize());
pageInfo.setTotalPage(totalPage);
// 判断当前页是否合理
if (currentPage < 1) {
pageInfo.setCurrentPage(1);
} else if (currentPage > totalPage) {
pageInfo.setCurrentPage(totalPage);
} else {
pageInfo.setCurrentPage(currentPage);
}
// 指定当前页的数据 指定sql语句中的两个参数
int start = (pageInfo.getCurrentPage() - 1) * pageInfo.getSize();
List<User> list = userDao.findAllByPage(start, pageInfo.getSize());
pageInfo.setList(list);
return pageInfo;
}
}
UserHandler
package com.zhongruan.controller;
import com.zhongruan.bean.PageInfo;
import com.zhongruan.bean.User;
import com.zhongruan.dao.UserDao;
import com.zhongruan.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpServletRequest;
@Controller
@RequestMapping("/user")
public class UserHandler {
// @Controller 表示UserHandler类 是一个控制器类(处理请求)
@Autowired
UserDao userDao;
@Autowired
UserService userService;
@RequestMapping("/findAll")
public ModelAndView index() {
System.out.println("index方法执行 ");
ModelAndView mv = new ModelAndView();
mv.addObject("list", userService.findAll());
mv.setViewName("list");
return mv;
// ModelAndView 数据视图
// return "index";
}
@RequestMapping("/findAll01")
public ModelAndView index01() {
ModelAndView mv = new ModelAndView();
mv.addObject("list", userService.findAll());
mv.setViewName("list");
return mv;
}
@RequestMapping("/login")
public String login(String username, String password) {
System.out.println(username + "====" + password);
// 对 用户名和密码 进行 校验
User user = userService.login(new User(username, password));
System.out.println(user);
if (user == null) {
System.out.println("登录失败");
return "pages/failer";
} else {
System.out.println("登录成功");
return "pages/success";
}
}
@RequestMapping("/register")
public String register(String username, String password, String check_password) {
if (password.equals(check_password)) {
System.out.println(username + "====" + password);
userService.register(new User(username, password));
System.out.println("注册成功");
return "pages/success";
}else {
System.out.println("两次密码输入不一致");
return "pages/failer";
}
}
@RequestMapping("/findAll02")
public ModelAndView findAll(){
ModelAndView mv = new ModelAndView();
mv.setViewName("pages/dataList");
mv.addObject("list", userService.findAll());
return mv;
}
@RequestMapping("/delete")
public String delete(int id){
userService.deleteByID(id);
return "redirect:findAll02";
}
//将数据展示在界面上 更新的前置操作
@RequestMapping("toUpdate")
public ModelAndView toUpdate(int id){
ModelAndView mv = new ModelAndView();
User user = userService.findByID(id);
mv.addObject("user", user);
mv.setViewName("pages/user-update");
return mv;
}
@RequestMapping("/update")
public String Update(User user){
int flag = userService.update(user);
if(flag==1){
System.out.println("修改成功!");
}else{
System.out.println("修改失败!");
}
return "redirect:findAll02";
}
//分页 currentPage当前页数
@RequestMapping("/findAll03")
public ModelAndView findAllByPage(@RequestParam(defaultValue = "1") int currentPage) {
ModelAndView mv = new ModelAndView();
PageInfo<User> pageInfo = userService.findByPage(currentPage);
System.out.println(pageInfo);
// 将数据返回到页面上
mv.setViewName("pages/dataList");
mv.addObject("pageInfo", pageInfo);
return mv;
}
}
UserDao
package com.zhongruan.dao;
import com.zhongruan.bean.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface UserDao {
// 查询全部用户 的方法
List<User> findAll();
//检查
User checkUser(User user);
// 新增用户
int addUser(User user);
void deleteByID(int id);
User findByID(int id);
int update(User user);
int getTotal();
List<User> findAllByPage(@Param("start") int start, @Param("size") int size);
}
UserDao.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.zhongruan.dao.UserDao">
<select id="findAll" resultType="User">
select * from t_user
</select>
<insert id="addUser" parameterType="User">
insert into t_user (username, password) values (#{username}, #{password})
</insert>
<select id="checkUser" parameterType="User" resultType="User">
select * from t_user where username=#{username} and password = #{password};
</select>
<delete id="deleteByID" parameterType="int">
delete from t_user where id = #{id}
</delete>
<select id="findByID" parameterType="int" resultType="User">
select * from t_user where id = #{id}
</select>
<update id="update" parameterType="user">
update t_user set username=#{username},password=#{password} ,age = #{age} where id=#{id}
</update>
<select id="getTotal" resultType="int">
select count(*) from t_user
</select>
<select id="findAllByPage" parameterType="int" resultType="User">
select * from t_user limit #{start}, #{size}
</select>
<!--
<update id="updateUser" parameterType="User">
update t_user set username = #{username} where id = #{id}
</update>
<select id="findUser" resultType="User">
select * from t_user where username = #{username} and password = #{password}
</select>
-->
<!--
<select id="exist" resultType="User" >
select * from t_user where username = #{username} and password = #{password}
</select>
-->
</mapper>
UserServiceImpl(前面跟之前的代码只增加这么多)
//day4
@Override
public void deleteByID(int id) {
userDao.deleteByID(id);
}
@Override
public User findByID(int id) {
return userDao.findByID(id);
}
@Override
public int update(User user) {
return userDao.update(user);
}
@Override
public PageInfo<User> findByPage(int currentPage) {
PageInfo<User> pageInfo = new PageInfo<>();
// 指定每页的数据量
pageInfo.setSize(5);
// 指定总数据量
int totalCount = userDao.getTotal();
pageInfo.setTotalCount(totalCount);
// 指定总页数 ceil() 向上取整 floor() 向下取整 round() 四舍五入
int totalPage = (int) Math.ceil(totalCount / (double)pageInfo.getSize());
pageInfo.setTotalPage(totalPage);
// 判断当前页是否合理
if (currentPage < 1) {
pageInfo.setCurrentPage(1);
} else if (currentPage > totalPage) {
pageInfo.setCurrentPage(totalPage);
} else {
pageInfo.setCurrentPage(currentPage);
}
// 指定当前页的数据 指定sql语句中的两个参数
int start = (pageInfo.getCurrentPage() - 1) * pageInfo.getSize();
List<User> list = userDao.findAllByPage(start, pageInfo.getSize());
pageInfo.setList(list);
return pageInfo;
}
UserService(增加以下方法)
/* 7.23更新 函数 */
void deleteByID(int id);
User findByID(int id);
int update(User user);
PageInfo<User> findByPage(int currentPage);
结束了,比较潦草,下次补充一下