首页 > 代码库 > SpringMVC + Mybatis + maven 后台分页设计
SpringMVC + Mybatis + maven 后台分页设计
一.前端jsp页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ include file="/common/taglibs.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>房源管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="http://www.mamicode.com/${path}/public/css/commonpc.css" rel="stylesheet" type="text/css" />
<link href="http://www.mamicode.com/${path}/public/css/admin.css" rel="stylesheet" type="text/css" />
<link href="http://www.mamicode.com/${path}/public/css/bootstrap/bootstrap.css" type="text/css" rel="stylesheet" />
<link rel="stylesheet" href="http://www.mamicode.com/${path}/public/css/compiled/user-list.css" type="text/css" media="screen" />
<script type="text/javascript" src="http://www.mamicode.com/${path}/public/js/jquery-1.4.4.min.js"></script>
<script>
function searchHS(){
var housenum=$("#housenum").val();
var housename=$("#housename").val();
var para = "housenum=" + housenum ;
para += "&housename=" + housename ;
para = para.replace(/[\r\n]/g,"").replace(/undefined/g,"").replace(/[]/g,"");
window.location.href=http://www.mamicode.com/encodeURI("${path}/house/list?" + para);
}
</script>
<style>
label {
display: block;
margin-bottom: 5px;
display: inline-table;
}
.input-btn {
width: 130px;
}
.mr5 {
margin-right: 5px;
}
.ss-btn {
border: 1px solid #1ba794;
background-color: #1ba794;
margin-top: 0px;
height: 24px;
color: #fff;
font-size: 14px;
}
input[type="text"]{
height: 23px;
margin-bottom: 0px;
}
</style>
</head>
<body style="padding-left:350px;">
<div class="rygl-tit">
<span class="rygl fl">房源列表</span>
<div class="fr pdr80 pdt20">
<button class="tjdr-btn mr30" onclick="window.location.href=http://www.mamicode.com/‘${path}/house/add‘">添加</button>
</div>
</div>
<p style="clear:both;"></p>
<div style="padding-top: 20px;padding-left: 75px;">
<div class="fl">
<input type="hidden" id="pageNo" name="pageNo" />
<label>房源编号:</label>
<input class="input-btn mr5" type="text" id="housenum" name="housenum" value="http://www.mamicode.com/${housenum}"/>
<label>房源名称:</label>
<input class="input-btn mr5" type="text" id="housename" name="housename" value="http://www.mamicode.com/${housename}"/>
</div>
<input class="ss-btn" value="http://www.mamicode.com/搜索" type="button" onclick="searchHS()"/>
</div>
<%-- 加载分页时请求路径 及 请求方式--%>
<form id="queryForm" name="queryForm" action="${path}/house/list" method="post">
<input type="hidden" id="pageNo" name="pageNo" />
</form>
<div class="table-style">
<table cellspacing="0">
<thead>
<tr>
<th>房源编号</th>
<th>房源名称</th>
<th>创建人</th>
<th>操作</th>
<th style="display:none">${userid}</th>
</tr>
</thead>
<c:forEach items="${houselist}" var="list">
<tbody>
<tr class="bg-con">
<td class="ddbh">${list.houseNum }</td>
<td class="ddyzf">${list.houseName}</td>
<td class="ddyzf" >${list.createPeople}</td>
<td class="cz">
<a class="ckxq" href="http://www.mamicode.com/${path}/house/look/?id=${list.houseresid}">查看</a>
<a class="ckxq" href="http://www.mamicode.com/${path}/house/edit?id=${list.houseresid}">修改</a>
<a class="ckxq" href="http://www.mamicode.com/${path}/house/del?id=${list.houseresid}" confirm(‘确定删除吗?‘)" >删除</a>
</td>
</tr>
</tbody>
</c:forEach>
</table>
</div>
${houseRec.pageNoDisp }
</body>
</html>
二.后台代码
/////////////////////////////////1.业务控制层（controller层）////////////////////////////
package com.sykj.haoguanjia.controller.system;
import java.util.List;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.sykj.haoguanjia.model.HouseRes;
import com.sykj.haoguanjia.service.HouseResService;
/**
* @author hykang
* @date 2017-05-09
*
*/
@Controller
@RequestMapping("/house")
public class HouseController {
@Autowired
private HouseResService houseResService;
@RequestMapping("/list")
public String houseList(@RequestParam(value = "http://www.mamicode.com/pageNo", defaultValue = "http://www.mamicode.com/1") int pageNo,String housenum,String housename,Model model){
List<HouseRes> pagelist = null;
try {
HouseRes pageRec = new HouseRes();
pageRec.setPageNo(pageNo);
pageRec.setHouseNum(housenum);
if(!"".equals(housename) && housename != null){
housename=new String(housename.getBytes("ISO-8859-1"),"UTF-8");
//housename = java.net.URLDecoder.decode(housename, "utf-8");
}
pageRec.setHouseName(housename);
pageRec.setDeleteFlag(0);
pagelist = houseResService.findPageData(pageRec);
model.addAttribute("houselist", pagelist);
model.addAttribute("houseRec", pageRec);
model.addAttribute("housenum", housenum);
model.addAttribute("housename", housename);
} catch (Exception e) {
e.printStackTrace();
}
return "house/list";
}
}
////////////////////////////////2.service层//////////////////////////////////////////
package com.sykj.haoguanjia.service;
import java.util.List;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Service;
import com.sykj.haoguanjia.dao.HouseResMapper;
import com.sykj.haoguanjia.model.HouseRes;
/**
* @author hekang
*
*/
@Service
public class HouseResService {
@Autowired
private HouseResMapper houseResMapper;
public List<HouseRes> findPageData(HouseRes record) throws DataAccessException{
return houseResMapper.findPageData(record);
}
}
////////////////////////////////////////3.DAO层///////////////////////////////////////
package com.sykj.haoguanjia.dao;
import java.util.List;
import com.sykj.haoguanjia.model.HouseRes;
public interface HouseResMapper {
List<HouseRes> findPageData(HouseRes record);
}
////////////////////////////////////////4.Mapper.xml/////////////////////////////////////
<resultMap id="BaseResultMap" type="com.sykj.haoguanjia.model.HouseRes">
<id column="houseresid" jdbcType="BIGINT" property="houseresid" />
<result column="house_num" jdbcType="VARCHAR" property="houseNum" />
<result column="house_name" jdbcType="VARCHAR" property="houseName" />
<result column="create_people" jdbcType="BIGINT" property="createPeople" />
</resultMap>
<select id="findPageData" parameterType="com.sykj.haoguanjia.model.HouseRes" resultMap="BaseResultMap">
select
<include refid="Base_Column_List"/>
from tb_house_res
<include refid="selectWhereClause"/>
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>
////////////////////////////////////5.房源实体类////////////////////////////////////////////////////
package com.sykj.haoguanjia.model;
import java.math.BigDecimal;
import java.util.Date;
import com.sykj.haoguanjia.page.PageHelper;
public class HouseRes extends PageHelper{
private Long houseresid;
private String houseNum;
private String houseName;
private Long createPeople;
public Long getHouseresid() {
return houseresid;
}
public void setHouseresid(Long houseresid) {
this.houseresid = houseresid;
}
public String getHouseNum() {
return houseNum;
}
public void setHouseNum(String houseNum) {
this.houseNum = houseNum == null ? null : houseNum.trim();
}
public String getHouseName() {
return houseName;
}
public void setHouseName(String houseName) {
this.houseName = houseName == null ? null : houseName.trim();
}
public Long getCreatePeople() {
return createPeople;
}
public void setCreatePeople(Long createPeople) {
this.createPeople = createPeople;
}
}
//////////////////////////////////6.分页类///////////////////////////////////////////
package com.sykj.haoguanjia.page;
import java.util.List;
import java.util.Map;
import org.apache.log4j.Logger;
import org.codehaus.jackson.map.ObjectMapper;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
/**
* 封装分页数据
*/
public class PageHelper {
private static final Logger logger = Logger.getLogger(PageHelper.class);
private static ObjectMapper mapper = new ObjectMapper();
public static String DEFAULT_PAGESIZE = "10";
private int pageNo; // 当前页码
private int pageSize; // 每页行数
private int totalRecord; // 总记录数
private int totalPage; // 总页数
private Map<String, String> params; // 查询条件
private Map<String, List<String>> paramLists; // 数组查询条件
private String searchUrl; // Url地址
private String pageNoDisp; // 可以显示的页号(分隔符"|"，总页数变更时更新)
private String orderByClause;
public PageHelper() {
pageNo = 1;
pageSize = Integer.valueOf(DEFAULT_PAGESIZE);
totalRecord = 0;
totalPage = 0;
params = Maps.newHashMap();
paramLists = Maps.newHashMap();
searchUrl = "";
pageNoDisp = "";
}
public static PageHelper newBuilder(int pageNo, int pageSize, String url) {
PageHelper page = new PageHelper();
page.setPageNo(pageNo);
page.setPageSize(pageSize);
page.setSearchUrl(url);
return page;
}
/**
* 查询条件转JSON
*/
public String getParaJson() {
Map<String, Object> map = Maps.newHashMap();
for (String key : params.keySet()) {
if (params.get(key) != null) {
map.put(key, params.get(key));
}
}
String json = "";
try {
json = mapper.writeValueAsString(map);
} catch (Exception e) {
logger.error("转换JSON失败", e);
}
return json;
}
/**
* 数组查询条件转JSON
*/
public String getParaListJson() {
Map<String, Object> map = Maps.newHashMap();
for (String key : paramLists.keySet()) {
List<String> lists = paramLists.get(key);
if (lists != null && lists.size() > 0) {
map.put(key, lists);
}
}
String json = "";
try {
json = mapper.writeValueAsString(map);
} catch (Exception e) {
logger.error("转换JSON失败", e);
}
return json;
}
/**
* 总件数变化时，更新总页数并计算显示样式
*/
private void refreshPage() {
// 总页数计算
totalPage = totalRecord % pageSize == 0 ? totalRecord / pageSize : (totalRecord / pageSize + 1);
// 防止超出最末页（浏览途中数据被删除的情况）
if (pageNo > totalPage && totalPage != 0) {
pageNo = totalPage;
}
pageNoDisp = computeDisplayStyleAndPage();
}
/**
* 计算页号显示样式 这里实现以下的分页样式("[]"代表当前页号)，可根据项目需求调整 [1],2,3,4,5,6,7,8..12,13
* 1,2..5,6,[7],8,9..12,13 1,2..6,7,8,9,10,11,12,[13]
*/
private String computeDisplayStyleAndPage() {
StringBuffer buffer = new StringBuffer();
List<Integer> pageDisplays = Lists.newArrayList();
if (totalPage <= 11) {
for (int i = 1; i <= totalPage; i++) {
pageDisplays.add(i);
}
} else if (pageNo < 7) {
for (int i = 1; i <= 8; i++) {
pageDisplays.add(i);
}
pageDisplays.add(0);// 0 表示 省略部分(下同)
pageDisplays.add(totalPage - 1);
pageDisplays.add(totalPage);
} else if (pageNo > totalPage - 6) {
pageDisplays.add(1);
pageDisplays.add(2);
pageDisplays.add(0);
for (int i = totalPage - 7; i <= totalPage; i++) {
pageDisplays.add(i);
}
} else {
pageDisplays.add(1);
pageDisplays.add(2);
pageDisplays.add(0);
for (int i = pageNo - 2; i <= pageNo + 2; i++) {
pageDisplays.add(i);
}
pageDisplays.add(0);
pageDisplays.add(totalPage - 1);
pageDisplays.add(totalPage);
}
buffer.append("<div style=‘text-align:right;padding-right:20px;‘>");
if (pageNo==1) {
buffer.append("首页");
buffer.append("上一页");
}else{
buffer.append("<a class=‘tcdNumber‘ href=‘javascript:_doQuery(1);‘>首页</a>");
buffer.append("<a class=‘tcdNumber‘ href=‘javascript:_doQuery("+(pageNo-1)+");‘>上一页</a>");
}
for(Integer i:pageDisplays){
if(i==0){
buffer.append("<a class=‘tcdNumber‘ >"+"..."+"</a>");
}else if( i == pageNo ) {
buffer.append("<a class=‘curNumber‘ href=‘javascript:_doQuery("+i+");‘>"+i+"</a>");
} else {
buffer.append("<a class=‘tcdNumber‘ href=‘javascript:_doQuery("+i+");‘>"+i+"</a>");
}
}
if (pageNo==totalPage) {
buffer.append("下一页");
buffer.append("尾页");
}else{
buffer.append("<a class=‘tcdNumber‘ href=‘javascript:_doQuery("+(pageNo+1)+");‘>下一页</a>");
buffer.append("<a class=‘tcdNumber‘ href=‘javascript:_doQuery("+totalPage+");‘>尾页</a>");
}
buffer.append("</div>");
buffer.append("<script type=‘text/javascript‘>");
buffer.append("function _doQuery(pageNo){document.queryForm.pageNo.value=http://www.mamicode.com/pageNo;document.queryForm.submit();}");
buffer.append("</script>");
return buffer.toString();
}
public String getHTML(){
return null;
}
public int getPageNo() {
return pageNo;
}
public void setPageNo(int pageNo) {
this.pageNo = pageNo;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getTotalRecord() {
return totalRecord;
}
public void setTotalRecord(int totalRecord) {
this.totalRecord = totalRecord;
refreshPage();
}
public int getTotalPage() {
return totalPage;
}
public void setTotalPage(int totalPage) {
this.totalPage = totalPage;
}
public Map<String, String> getParams() {
return params;
}
public void setParams(Map<String, String> params) {
this.params = params;
}
public Map<String, List<String>> getParamLists() {
return paramLists;
}
public void setParamLists(Map<String, List<String>> paramLists) {
this.paramLists = paramLists;
}
public String getSearchUrl() {
return searchUrl;
}
public void setSearchUrl(String searchUrl) {
this.searchUrl = searchUrl;
}
public String getPageNoDisp() {
return pageNoDisp;
}
public void setPageNoDisp(String pageNoDisp) {
this.pageNoDisp = pageNoDisp;
}
public String getOrderByClause() {
return orderByClause;
}
public void setOrderByClause(String orderByClause) {
this.orderByClause = orderByClause;
}
}
本文出自 “不凡人生——求知者” 博客，请务必保留此出处http://825272560.blog.51cto.com/11004487/1941378
SpringMVC + Mybatis + maven 后台分页设计