DB2 分页

最新推荐文章于 2021-04-27 17:29:29 发布

stevenbill

最新推荐文章于 2021-04-27 17:29:29 发布

阅读量141

点赞数

CC 4.0 BY-SA版权

分类专栏： DataBase JSP 文章标签： DB2 JSP

本文链接：https://blog.youkuaiyun.com/stevenbill/article/details/83975756

DataBase 同时被 2 个专栏收录

56 篇文章

订阅专栏

JSP

20 篇文章

订阅专栏

//db.jsp


<%@ page language="java" import="java.util.*,java.sql.*,com.abin.db.connection.*,java.text.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>DIV+CSS</title>
  </head>
  <body>
<%
	Connection conn=null;
	Statement stmt=null;
	ResultSet rs=null;
	String sql=null;
	int pagesize=3;
	int pagenum=1;
	int endpage;
	int startPage=1;
	if(request.getParameter("pageno")!=null){
		pagenum=Integer.parseInt(request.getParameter("pageno"));
	}
	startPage=(pagenum-1)*pagesize+1;
	endpage=(startPage+pagesize);
	try{
		 String driver="com.ibm.db2.jcc.DB2Driver";
		 String url="jdbc:db2://localhost:50000/lee";
		 String username="acer";
		 String password="abin";
		Class.forName(driver).newInstance();
		conn=DriverManager.getConnection(url,username,password);
		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+"";
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		out.println("<table border=2>");
		out.println("<tr>");
		out.println("<th width=200>"+"username"+"</th>");
		out.println("<th width=200>"+"age"+"</th>");
		out.println("</tr>");
		while(rs.next()){
			out.println("<tr>");
			out.println("<td>"+rs.getString("username")+"</td>");
			out.println("<td>"+rs.getInt("age")+"</td>");
			out.println("</tr>");
		}
		out.println("</table>");


	}catch(Exception e){
		e.printStackTrace();
	}finally{
		if(null!=conn){
			conn.close();
		}
		if(null!=stmt){
			stmt.close();
		}
		if(null!=rs){
			rs.close();
		}
	}
	int pagecurrent=pagenum-1;
	int pagenext=pagenum+1;
	out.println("<a href='db.jsp?pageno="+pagecurrent+"'>"+"上一页"+"</a>");
	out.println("<a href='db.jsp?pageno="+pagenext+"'>"+"下一页"+"</a>");
	out.println("<br/>");
	Calendar cal=Calendar.getInstance();
	SimpleDateFormat sdf=new SimpleDateFormat("yyyy:MM:dd HH:mm:ss");
	String show=sdf.format(cal.getTime());
	out.println(show);


%>	
<br/>
<a href="add.jsp">新增</a>
  </body>
</html>