maven依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.8</version>
</dependency>
mybatis.cfg.xml
<plugins>
<!-- com.github.pagehelper为PageHelper类所在包名 -->
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!--数据库方言-->
<property name="helperDialect" value="mysql"/>
<!--合理化分页-->
<property name="reasonable" value="true"/>
</plugin>
</plugins>
controller
@RequestMapping("/selectAllLocation")
@ResponseBody
public Msg selectAllLocation(@RequestParam(required = true,defaultValue = "1")Integer page) {
PageHelper.startPage(page,10);
List<Location> locationList = locationService.selectAllLocation();
if (!locationList.isEmpty()) {
PageInfo<Location> locationPageInfo = new PageInfo<>(locationList);
return Msg.success().add("locationPageInfo",locationPageInfo);
} else return Msg.fail();
}
对我而言,最烦人的就是前端的js
html
$("#updateLocationInfo").click(function () {
if (sessionStorage.getItem("login_admin_msg") == 202 || sessionStorage.getItem("admin_name") == null) {
alert("请先登录!");
window.location.href = "/admin/toIndex_admin";
}
$("ul#ul_1 li").attr("class", "");
$("ul#ul_2 li").attr("class", "");
$("ul#ul_3 li").attr("class", "");
$("ul#ul_3").children("li:eq(2)").attr('class', 'active');
$("div#main").empty();
$.ajax({
url: "/admin/selectAllLocation",
type: "get",
success: function (result) {
if (result.code == 200) {
var htmladd_0 = '';
$('div#main').empty();
$('div#main').append('<h1 class="page-header">修改地址信息</h1>');
htmladd_0 = '<table class="table" id="updateLocation_table">\n' +
' <tr>\n' +
' <th>城市编号</th>\n' +
' <th>名称</th>\n' +
' <th>风险等级</th>\n' +
' </tr>\n' +
' </table>';
$("div#main").append(htmladd_0);
$.each(result.extend.locationPageInfo.list, function (index, item) {
var loc_idTd = $("<td></td>").append(item.loc_id);
var loc_nameTd = $("<td></td>").append(item.loc_name);
var loc_risklevelTd = $("<td></td>").append(item.loc_risklevel);
var editLocBtn = $("<button></button>")
.append("<span class='glyphicon glyphicon-pencil'></span>")
.addClass("btn btn-primary edit_location");
editLocBtn.attr("edit_loc_id", item.loc_id);
editLocBtn.attr("edit_loc_name", item.loc_name);
editLocBtn.attr("edit_loc_risklevel", item.loc_risklevel);
var delLocBtn = $("<button ></button>").append("<span class='glyphicon glyphicon-trash'></span>")
.addClass("btn btn-danger del_location");
delLocBtn.attr("del_loc_id", item.loc_id);
var opTd = $("<td></td>").append(editLocBtn).append(delLocBtn);
if (parseInt(item.loc_risklevel) == 0) {
$("<tr bgcolor='#baffaa'></tr>")
.append(loc_idTd)
.append(loc_nameTd)
.append(loc_risklevelTd)
.append(opTd)
.appendTo("#updateLocation_table tbody");
}
if (parseInt(item.loc_risklevel) == 1) {
$("<tr bgcolor='#fff3c5'></tr>")
.append(loc_idTd)
.append(loc_nameTd)
.append(loc_risklevelTd)
.append(opTd)
.appendTo("#updateLocation_table tbody");
}
if (parseInt(item.loc_risklevel) == 2 || parseInt(item.loc_risklevel) == 3) {
$("<tr bgcolor='#ffb5ab'></tr>")
.append(loc_idTd)
.append(loc_nameTd)
.append(loc_risklevelTd)
.append(opTd)
.appendTo("#updateLocation_table tbody");
}
});
var locationPageInfo = result.extend["locationPageInfo"];
if (locationPageInfo.pageNum == 1) {
var page = '<ul class="pagination">\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + 1 + ')">首页</a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pageNum + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pages + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.nextPage + ')">下一页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.pages + ')">尾页</a></li>\n' +
' </ul>';
} else if (locationPageInfo.pageNum == locationPageInfo.pages) {
var page = '<ul class="pagination">\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + 1 + ')">首页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.prePage + ')">上一页</a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pageNum + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pages + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.pages + ')">尾页</a></li>\n' +
' </ul>';
} else {
var page = '<ul class="pagination">\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + 1 + ')">首页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.prePage + ')">上一页</a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pageNum + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pages + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.nextPage + ')">下一页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.pages + ')">尾页</a></li>\n' +
' </ul>';
}
$("div#main").append(page);
} else if (result.code == 100) {
$("div#main").append('<div class="alert alert-success">\n' +
' <strong>无城市信息</strong>\n' +
'</div>');
}
}, error: function (result) {
alert("error!");
}
});
});
分页中每个按钮调用的js函数
function selectPage(result) {
$.ajax({
url: "/admin/selectAllLocation?page=" + result,
type: "get",
success: function (result) {
if (result.code == 200) {
var htmladd_0 = '';
$('div#main').empty();
$('div#main').append('<h1 class="page-header">修改地址信息</h1>');
htmladd_0 = '<table class="table" id="updateLocation_table">\n' +
' <tr>\n' +
' <th>城市编号</th>\n' +
' <th>名称</th>\n' +
' <th>风险等级</th>\n' +
' </tr>\n' +
' </table>';
$("div#main").append(htmladd_0);
$.each(result.extend.locationPageInfo.list, function (index, item) {
var loc_idTd = $("<td></td>").append(item.loc_id);
var loc_nameTd = $("<td></td>").append(item.loc_name);
var loc_risklevelTd = $("<td></td>").append(item.loc_risklevel);
var editLocBtn = $("<button></button>")
.append("<span class='glyphicon glyphicon-pencil'></span>")
.addClass("btn btn-primary edit_location");
editLocBtn.attr("edit_loc_id", item.loc_id);
editLocBtn.attr("edit_loc_name", item.loc_name);
editLocBtn.attr("edit_loc_risklevel", item.loc_risklevel);
var delLocBtn = $("<button ></button>").append("<span class='glyphicon glyphicon-trash'></span>")
.addClass("btn btn-danger del_location");
delLocBtn.attr("del_loc_id", item.loc_id);
var opTd = $("<td></td>").append(editLocBtn).append(delLocBtn);
if (parseInt(item.loc_risklevel) == 0) {
$("<tr bgcolor='#baffaa'></tr>")
.append(loc_idTd)
.append(loc_nameTd)
.append(loc_risklevelTd)
.append(opTd)
.appendTo("#updateLocation_table tbody");
}
if (parseInt(item.loc_risklevel) == 1) {
$("<tr bgcolor='#fff3c5'></tr>")
.append(loc_idTd)
.append(loc_nameTd)
.append(loc_risklevelTd)
.append(opTd)
.appendTo("#updateLocation_table tbody");
}
if (parseInt(item.loc_risklevel) == 2 || parseInt(item.loc_risklevel) == 3) {
$("<tr bgcolor='#ffb5ab'></tr>")
.append(loc_idTd)
.append(loc_nameTd)
.append(loc_risklevelTd)
.append(opTd)
.appendTo("#updateLocation_table tbody");
}
});
var locationPageInfo = result.extend["locationPageInfo"];
if (locationPageInfo.pageNum == 1) {
var page = '<ul class="pagination">\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + 1 + ')">首页</a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pageNum + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pages + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.nextPage + ')">下一页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.pages + ')">尾页</a></li>\n' +
' </ul>';
} else if (locationPageInfo.pageNum == locationPageInfo.pages) {
var page = '<ul class="pagination">\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + 1 + ')">首页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.prePage + ')">上一页</a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pageNum + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pages + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.pages + ')">尾页</a></li>\n' +
' </ul>';
} else {
var page = '<ul class="pagination">\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + 1 + ')">首页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.prePage + ')">上一页</a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pageNum + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link"><span>第' + locationPageInfo.pages + '页</span></a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.nextPage + ')">下一页</a></li>\n' +
' <li class="page-item"><a class="page-link" οnclick="selectPage(' + locationPageInfo.pages + ')">尾页</a></li>\n' +
' </ul>';
}
$("div#main").append(page);
} else if (result.code == 100) {
$("div#main").append('<div class="alert alert-success">\n' +
' <strong>无城市信息</strong>\n' +
'</div>');
}
}, error: function (result) {
alert("error!");
}
});
}
Msg.java
package com.rzab.pojo;
import java.util.HashMap;
import java.util.Map;
public class Msg {
private int code;
private String msg;
private Map<String,Object> extend=new HashMap<String,Object>();
public int getCode() {
return code;
}
public void setCode(int code) {
this.code = code;
}
public String getMsg() {
return msg;
}
public void setMsg(String msg) {
this.msg = msg;
}
public Map<String, Object> getExtend() {
return extend;
}
public void setExtend(Map<String, Object> extend) {
this.extend = extend;
}
public static Msg success() {
Msg result=new Msg();
result.setCode(200);
result.setMsg("处理成功!");
return result;
}
public static Msg fail() {
Msg result=new Msg();
result.setCode(100);
result.setMsg("处理失败!");
return result;
}
public Msg add(String key,Object value) {
this.getExtend().put(key, value);
return this;
}
@Override
public String toString() {
return "Msg{" +
"code=" + code +
", msg='" + msg + '\'' +
", extend=" + extend +
'}';
}
}