Day4-SSM(用户管理系统) 用户管理界面分页+搜索
Java方向(SSM+SpringBoot)项目实训
Day4(2020.7.23)
用户管理界面分页+搜索
1.bean下创建PageInfo实体类;
PageInfo:
package com.roger0123.bean;
import java.util.List;
public class PageInfo<T> {
private List<T> list;//存放user数据
private int size;
private int totalPage;
private int totalCount;
private int currentPage;
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
public int getSize() {
return size;
}
public void setSize(int size) {
this.size = size;
}
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 getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
@Override
public String toString() {
return "PageInfo{" +
"list=" + list +
", size=" + size +
", totalPage=" + totalPage +
", totalCount=" + totalCount +
", currentPage=" + currentPage +
'}';
}
}
2.修改UserDao接口;
UserDao中添加:
List<User> findAll(@Param("start")int start,@Param("username")String username);
// List<User> findAll(); //注释掉之前的findAll方法
int getTotalCount(@Param("username")String username);
3.修改UserMapper.xml文件;
UserMapper中添加:
<!-- <select id="findAll" resultType="user">-->
<!-- select * from ssm_user-->
<!-- </select>-->
//注释掉
<select id="findAll" resultType="user">
select * from ssm_user
<if test="username != null and username != ''">
where username like concat("%",#{username},"%")
</if>
limit #{start},5
</select>
<select id="getTotalCount" resultType="int">
select count(*) from ssm_user
<if test="username!=null and username != ''">
where username like concat("%",#{username},"%")
</if>
</select>
4.修改UserService接口;
UserService中添加:
PageInfo<User> findAll(int currentPage, String username);
// List<User> findAll();
5.修改UserServiceImpl类;
UserServiceImpl中添加:
@Override
public PageInfo<User> findAll(int currentPage, String username) {
PageInfo<User> pageInfo = new PageInfo<>();
pageInfo.setSize(5);
//tc 为查询数据的总行数
int tc = userDao.getTotalCount(username);
pageInfo.setTotalCount(tc);
//tp 为总页数
int tp = (int)Math.ceil(tc/5.0);//自动向上取整
pageInfo.setTotalPage(tp);
if (currentPage<1){
pageInfo.setCurrentPage(1);
}else if(currentPage>tp){
pageInfo.setCurrentPage(tp);
}else{
pageInfo.setCurrentPage(currentPage);
}
//0,5,10,15...
int start = (pageInfo.getCurrentPage()-1)*5;
List<User> userList = userDao.findAll(start,username);
pageInfo.setList(userList);
return pageInfo;
}
// @Override
// public List<User> findAll(){
// return userDao.findAll();
// }
6.修改UserController类;
UserController中添加:
// @RequestMapping("/findAll.do")
// public ModelAndView findAll(){
// List<User> users = userService.findAll();
// ModelAndView mv = new ModelAndView();
// mv.addObject("users",users);
// mv.setViewName("user-list");
// return mv;
// }
@RequestMapping("/findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue = "1")int currentPage, String username,
@RequestParam(defaultValue = "0")int type, HttpSession session){
//这个判断语句是确保 查询内容翻页不出错,ERROR(显示为所有内容)
if (type==1){
session.setAttribute("searchName",username);
}else {
username = (String) session.getAttribute("searchName");
}
PageInfo<User> pageInfo = userService.findAll(currentPage,username);
ModelAndView mv = new ModelAndView();
mv.addObject("pageInfo",pageInfo);
mv.setViewName("user-list");
return mv;
}
6.修改user-list.jsp;
6.1 修改<c:forEach items="${}" var=“user”>中{}内为自己user信息存放的位置,如pageInfo.list;
6.2 在 处添加上一页下一页等页面按钮组件;
<div class="box-footer">
<div class="pull-left">
<div class="form-group form-inline">
总共${pageInfo.totalPage} 页,共${pageInfo.totalCount} 条数据,当前第${pageInfo.currentPage}页。
</div>
</div>
<div class="box-tools pull-right">
<ul class="pagination">
<li><a href="/user/findAll.do?currentPage=1" aria-lable="Previous">首页</a></li>
<li><a href="/user/findAll.do?currentPage=${pageInfo.currentPage - 1}" >上一页</a></li>
<c:forEach begin="1" end="${pageInfo.totalPage}" var="pageNum">
<li><a href="/user/findAll.do?currentPage=${pageNum}">${pageNum}</a> </li>
</c:forEach>
<li><a href="/user/findAll.do?currentPage=${pageInfo.currentPage + 1}" >下一页</a></li>
<li><a href="/user/findAll.do?currentPage=${pageInfo.totalPage}" aria-lable="Next">尾页</a></li>
</ul>
</div>
</div>
Test:
1.数据库中事先插入测试数据;
2.进入用户管理界面,显示出数据库中所有的用户信息,点击下一页或者2翻页;
3.查看下一页用户信息成功;
4.在上方搜索栏,搜索x,验证模糊搜索功能;
翻页成功;