//db.jsp
1. <%@ page language="java" import="java.util.*,java.sql.*,com.abin.db.connection.*,java.text.*" pageEncoding="utf-8"%>
2. <%
3. String path = request.getContextPath();
4. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
5. %>
6.
7.
8.
9.
10.
DIV+CSS 11.
12.
13. <%
14. Connection conn=null;
15. Statement stmt=null;
16. ResultSet rs=null;
17. String sql=null;
18. int pagesize=3;
19. int pagenum=1;
20. int endpage;
21. int startPage=1;
22. if(request.getParameter("pageno")!=null){
23. pagenum=Integer.parseInt(request.getParameter("pageno"));
24. }
25. startPage=(pagenum-1)*pagesize+1;
26. endpage=(startPage+pagesize);
27. try{
28. String driver="com.ibm.db2.jcc.DB2Driver";
29. String url="jdbc:db2://localhost:50000/lee";
30. String username="acer";
31. String password="abin";
32. Class.forName(driver).newInstance();
33. conn=DriverManager.getConnection(url,username,password);
34. sql="select * from (select username,age,rownumber() over(order by id desc) as rowid from lee ) a where a.rowid>="+startPage+" and a.rowid<"+endpage+"";
35. stmt=conn.createStatement();
36. rs=stmt.executeQuery(sql);
37. out.println("
");
38. out.println("");
39. out.println(""+"username"+" | ");
40. out.println(""+"age"+" | ");
41. out.println("
");
42. while(rs.next()){
43. out.println("");
44. out.println(""+rs.getString("username")+" | ");
45. out.println(""+rs.getInt("age")+" | ");
46. out.println("
");
47. }
48. out.println("
");
49.
50.
51. }catch(Exception e){
52. e.printStackTrace();
53. }finally{
54. if(null!=conn){
55. conn.close();
56. }
57. if(null!=stmt){
58. stmt.close();
59. }
60. if(null!=rs){
61. rs.close();
62. }
63. }
64. int pagecurrent=pagenum-1;
65. int pagenext=pagenum+1;
66. out.println("
"+"上一页"+"");
67. out.println("
"+"下一页"+"");
68. out.println("
");
69. Calendar cal=Calendar.getInstance();
70. SimpleDateFormat sdf=new SimpleDateFormat("yyyy:MM:dd HH:mm:ss");
71. String show=sdf.format(cal.getTime());
72. out.println(show);
73.
74.
75. %>
76.
77.
新增 78.
79.