《oracle分页查询完整代码.docx》由会员分享，可在线阅读，更多相关《oracle分页查询完整代码.docx（9页珍藏版）》请在三一文库上搜索。
1、(1)、实体类： 1package com.domain; 2 3import org.apache.struts.action.ActionForm; 4 5public class PeopleForm extends ActionForm 6 private int id; 7 private String name; 8 private String sex ; 9 private int age;10 private String job;11 public int getId() 12 return id;13 14 public void setId(int id) 15 thi
2、s.id = id;16 17 public String getName() 18 return name;19 20 public void setName(String name) 21 this.name = name;22 23 public String getSex() 24 return sex;25 26 public void setSex(String sex) 27 this.sex = sex;28 29 public int getAge() 30 return age;31 32 public void setAge(int age) 33 this.age =
3、age;34 35 public String getJob() 36 return job;37 38 public void setJob(String job) 39 this.job = job;40 41 42 (2)、Dao: 数据库操作： 1package com.dao; 2import java.sql.*; 3public class JDBConnection 4Connection connection = null; 5static 6 try 7 Class.forName(com.mysql.jdbc.Driver); / 静态块中实现加载数据库驱动 8 catc
4、h (ClassNotFoundException e) 9 e.printStackTrace();10 11 12public Connection creatConnection()13 /创建数据库连接对象14 String url = jdbc:mysql:/localhost:3306/db_database20; /指定数据库连接URL15 String userName = root; /连接数据库用户名16 String passWord = 111; /连接数据库密码17 try 18 connection = DriverManager.getConnection(url
5、,userName, passWord); /获取数据库连接 19 catch (SQLException e) 20 e.printStackTrace();21 22 return connection;2324 /对数据库的查询操作25public ResultSet executeQuery(String sql) 26 ResultSet rs; /定义查询结果集27 try 28 if (connection = null) 29 creatConnection(); /创建数据库连接30 31 Statement stmt = connection.createStatement
6、(); /创建Statement对象 32 rs = stmt.executeQuery(sql); /执行查询SQL语句 33 catch (SQLException e) 34 System.out.println(e.getMessage(); 35 return null; /有异常发生返回null36 37 return rs; /返回查询结果集对象3839/关闭数据库连接40public void closeConnection() 41 if (connection != null) /如果Connection对象42 try 43 connection.close(); /关闭
7、连接44 catch (SQLException e) 45 e.printStackTrace();46 finally 47 connection = null;48 49 505152 业务逻辑： 1package com.dao; 2import java.util.*; 3import com.domain.PeopleForm; 4import java.sql.ResultSet; 5import java.sql.*; 6public class PeopleDao 7 private JDBConnection connection = null; 8 public Peop
8、leDao() 9 connection = new JDBConnection();10 11 /查询所有员工信息方法12public List selectPeople() 13 List list = new ArrayList(); /创建保存查询结果集集合对象14 PeopleForm form = null;15 String sql = select * from tb_emp; /定义查询tb_emp表中全部数据SQL语句16 ResultSet rs = connection.executeQuery(sql); /执行查询17 try 18 while (rs.next()
9、 /循环遍历查询结果集19 form = new PeopleForm(); /创建ActionForm实例20 form.setId(Integer.valueOf(rs.getString(1); /获取查询结果21 form.setName(rs.getString(2);22 form.setSex(rs.getString(3);23 form.setAge(rs.getInt(4);24 form.setJob(rs.getString(5);25 list.add(form); /向集合中添加对象26 27 catch (SQLException ex) 28 29 connec
10、tion.closeConnection(); /关闭数据连接30 return list; /返回查询结果3132(3)Action: 1package com.action; 2 3import org.apache.struts.action.*; 4import javax.servlet.http.*; 5import com.dao.PeopleDao; 6import java.util.List; 7public class PeopleAction extends Action 8private PeopleDao dao = null; 9public ActionForw
11、ard execute(ActionMapping mapping, ActionForm form,10 HttpServletRequest request, HttpServletResponse response) 11 dao = new PeopleDao(); / 创建保存有数据查询类对象12 List list = dao.selectPeople(); / 调用数据查询方法13 int pageNumber = list.size(); / 计算出有多少条记录14 int maxPage = pageNumber; / 计算有多少页数15 String number = re
12、quest.getParameter(i); / 获取保存在request对象中变量16 if (maxPage % 4 = 0) / “4”代表每页显示有4条记录17 maxPage = maxPage / 4; / 计算总页数18 else / 如果总页数除以4不整除19 maxPage = maxPage / 4 + 1; / 将总页数加120 21 if (number = null) / 如果保存在request范围内的当前页数为null22 number = 0; / 将number为023 24 request.setAttribute(number, String.valueO
13、f(number); / 将number保存在request范围内25 request.setAttribute(maxPage, String.valueOf(maxPage); / 将分的总页数保存在request范围内26 int nonce = Integer.parseInt(number) + 1;27 request.setAttribute(nonce, String.valueOf(nonce);28 request.setAttribute(pageNumber, String.valueOf(pageNumber);29 request.setAttribute(list
14、, list);30 return mapping.findForward(peopleAction); / 请求转发地址313233 (4)、页面代码：index.jsp: base href= My JSP index.jsp starting page =pagenation.jsp% List list = (List)request.getAttribute(list); /获取保存在request范围内的数据 int number = Integer.parseInt(String)request.getAttribute(number); int maxPage = Intege
15、r.parseInt(String)request.getAttribute(maxPage); int pageNumber = Integer.parseInt(String)request.getAttribute(pageNumber); int start = number*4;/开始条数 int over = (number+1)*4;/结束条数 int count=pageNumber-over;/还剩多少条记录 if(count利用查询结果集进行分页 编号 姓名 性别 年龄 职位 logic:iterate id=element indexId=index name=list offset= length=4 岁 共为 页 共有 条 当前为第页 首页 首页 尾页 a href=peopleAction.do?i=尾页 上一页 a href=peopleAction.do?i=上一页 下一页 a href=peopleAction.do?i=下一页 (5)、Struts-config.xml 1 2 5 6 7 8 9 1011 12 1314 16 17 1819 20