public ActionForward queryUser(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
//UserForm userForm = (UserForm) form;
UserService userService = (UserService)this.getBean("userService");
List users = userService.queryUser();
String start=request.getParameter("start");
String limit=request.getParameter("limit");
try {
int index=Integer.parseInt(start);
int pageSize=Integer.parseInt(limit);
if(users!=null && users.size()>0){
String json="{totalProperty:"+users.size()+",root:[";
for(int i=index;i<index+pageSize && i<users.size();i++){
Custmer cust=(Custmer)users.get(i);
json+="{id:'"+cust.getUserid()+"',name:'"+cust.getUsername()+"',phone:'"+cust.getPhone()+"'}";
if(i!=pageSize+index-1 && i!=users.size()-1){
json+=",";
}
}
json+="]}";
response.getWriter().write(json);
System.out.println(json);
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
HttpServletRequest request, HttpServletResponse response) {
//UserForm userForm = (UserForm) form;
UserService userService = (UserService)this.getBean("userService");
List users = userService.queryUser();
String start=request.getParameter("start");
String limit=request.getParameter("limit");
try {
int index=Integer.parseInt(start);
int pageSize=Integer.parseInt(limit);
if(users!=null && users.size()>0){
String json="{totalProperty:"+users.size()+",root:[";
for(int i=index;i<index+pageSize && i<users.size();i++){
Custmer cust=(Custmer)users.get(i);
json+="{id:'"+cust.getUserid()+"',name:'"+cust.getUsername()+"',phone:'"+cust.getPhone()+"'}";
if(i!=pageSize+index-1 && i!=users.size()-1){
json+=",";
}
}
json+="]}";
response.getWriter().write(json);
System.out.println(json);
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
本文介绍了一种基于Java的用户数据分页查询方法,通过接收前端传递的开始位置和每页显示数量参数,从数据库中获取相应范围内的用户信息,并将其转换为JSON格式返回。该方法使用了自定义的服务接口进行数据查询。
1310

被折叠的 条评论
为什么被折叠?



