本文详细介绍了如何使用jQuery EasyUI与Java配合实现DataGrid的分页功能。首先强调了jQuery库的引入顺序，接着展示了如何在HTML中创建带有分页功能的datagrid，并定义了列和数据。然后，提供了对应的Student实体类和DAO实现，用于从数据库获取分页数据。最后，通过Servlet处理请求，将分页数据返回给前端，并展示了前端显示效果。
注意：jquery-1.8.0.min.js要在jquery.easyui.min.js之前引入。
2、Create datagrid from an existing table element, defining columns, rows, and data in html.
title="社团基本信息"
class="easyui-datagrid"
style="width:1200px;height:600px;"
url="list"
pagination="true"
rownumbers="true"
fitColumns="true"
singleSelect="true">
学号姓名院系Email电话QQ性别出生年月参加时间所在社团职务爱好
3、表student对应的实体
public class Student {
private int id;
private String stu_id;
private String stu_name;
private String stu_password;
private String stu_yuanxi;
private String stu_job;
private String stu_email;
private String stu_phone;
private String stu_qq;
private String stu_sex;
private String stu_age;
private String depart_name;
private String role_name;
private int depart_id;
private int role_id;
private String stu_like;
private int u_id;
private String u_dept;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
......
｝
4、DAO实现获取student记录
public List listStudent(int pageNumber,int pageSize){
List list=new ArrayList();
String sql="select * from student limit " + pageNumber+"," + pageSize ;
try {
list = runner.query(sql, new BeanListHandler(Student.class));
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
5、Servlet实现跳转，将数据返回给前台
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//处理乱码
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=UTF-8");
int page;
try {
page = Integer.parseInt(request.getParameter("page"));
} catch (NumberFormatException e) {
page = 1;
}
int row;
try {
row = Integer.parseInt(request.getParameter("rows"));
} catch (NumberFormatException e) {
row = 10;
}
PrintWriter out = response.getWriter();
//获得student列表
StudentInfoService studentInfoService = new StudentInfoService();
List list =studentInfoService.listStudent(page, row) ;
long total = studentInfoService.results() ;
Map map = new HashMap();
map.put("total", total);
map.put("rows", list);
Gson gson = new Gson();
String json = gson.toJson(map);
out.write(json);
out.flush();
out.close();
}
6、前台效果图
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
