js
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<script>
var countRecords;var totalPage;
var currentPage;
var countPage;
$(document).ready(function(){
load(1);
})
function load(currentpage){
$.ajax({
url:"<%=basePath%>loaduserlist",
data:{"uname":$("#un").val(),"usex":$("#usex").val(),"currentpage":currentpage},
type:"post",
dataType:"json",
success:function(result){
$.each(result,function(index,ele){
countRecords=ele.countRecords;
totalPage=ele.totalPage;
currentPage=ele.currentPage;
countPage=ele.countPage;
var lastPage;
var nextPage;
if(index=='list'){
$("#trid").nextAll().remove();
$.each(ele,function(x,el){
var basepath= "http://localhost:8080/Yimai/"
$("#trid").after("<tr><td class= 'first w4 c'> "+el.username+"</td><td class='w1 c'>"+el.real_name+"</td><td class='w2 c'>"+el.sex+"</td><td>"+el.email+"</td><td class='w4 c'>"+el.phone+"</td><td class='w1 c'><a href="+ basepath +"updateuser?userid="+ el.user_id +">修改</a><a class='manageDel' href="+basepath+"deleteuser?userid="+el.user_id+">删除</a></td></tr>");
})
}
if(ele.currentPage==1){lastPage=1}else{lastPage=ele.currentPage-1}
if(ele.currentPage==ele.totalPage){nextPage=ele.totalPage}else{nextPage=ele.currentPage+1}
$("#spiltPage").html("<a href=javascript:load("+nextPage+")>下一页</a><a href =javascript:load("+lastPage+")>上一页</a><a href= javascript:load("+1+")>首页</a><a href = javascript:load("+totalPage+")>尾页</a><a>当前页"+currentPage+"/"+totalPage+"</a>");
})
}
})
}
jsp页面
</script>
<input type = "text" name = "username" id = "un"/>姓名查询<input type="text" name = "sex" id = "usex"/>性别查询
<input οnclick="load(1)" type ="button" value = "搜索"/>
<h2>用户管理</h2><span id ="spiltPage"></span>
<div class="manage">
<table class="list">
<tr id = "trid">
<th>用户名</th>
<th>真实姓名</th>
<th>性别</th>
<th>Email</th>
<th>手机</th>
<th>操作</th>
</tr>
</table>
后台servlet
String username=request.getParameter("uname");
String sex=request.getParameter("usex");
int currentpage=Integer.parseInt(request.getParameter("currentpage"));
Userdao userdao = new Userimple();
PageBean pb = new PageBean();
pb.setCurrentPage(currentpage);
List<User>list = new ArrayList<User>();
System.out.println(username);
System.out.println(currentpage);
Map map=userdao.loadUser(currentpage, pb.getCountPage(),username,sex);
{public Map loadUser(int currentpage,int count,String username ,String sex) {
// TODO Auto-generated method stub
int b = 0;
System.out.println(currentpage);
System.out.println(count);
Map map = new HashMap();
Map map1 = new HashMap();
int a = (currentpage-1)*(count);
map.put("currentpage",a );
map.put("count", count);
System.out.println(username);
if(username==""){
}else{
map.put("used", username);
}
if(sex==""){
}else{
map.put("sex", sex);
}
SqlSession session = Getsession.getSession();
List<User>list=session.selectList("use.loaduser", map);
SqlSession session2 = Getsession.getSession();
System.out.println(session2);
b= session2.selectOne("use.countuser", map);
session.close();
session2.close();
map1.put("list", list);
map1.put("count", b);
return map1;
}//此代码块为loarduser方法的实现}
int b = (Integer)map.get("count");
pb.setCountRecords(b);
PageVo<User> pagevo =new PageVo<User>();
pagevo.setList( (List<User>)map.get("list"));
pagevo.setPb(pb);
JSONObject jso = new JSONObject();
JSON json =jso.fromObject(pagevo);
System.out.println(json);
PrintWriter pw = response.getWriter();
pw.write(json.toString());