jsp oracle分页与sqlserver分页 -

lms168

浏览: 61560 次
性别:
来自: 成都

最近访客更多访客>>

sky_liu

orz128

zhoudinghan

15858193405

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

jsp oracle分页与sqlserver分页

博客分类：

java

先来个sqlserver分页
数据库很简单就一张表
表字段有：
id，主键，自动增长
name 组名

直接贴代码;

<%@ page language="java" import="java.sql.*,java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
String pageNowStr=request.getParameter("pageNow");       //当前是第几页
int pageNow=1;
if(pageNowStr!=null){
  pageNow=Integer.valueOf(pageNowStr);
}
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
  <table border="1">
    <%
		Connection conn=null;
		PreparedStatement pst=null;
		ResultSet result=null;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");             
			conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=Spring_dataBase","sa","123456");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		int pageSize=3;       //每页多少条记录
		int rowCount=0;      //总共有多少条记录
		int pageCount=0;     //总共有多少页记录
		
		String queryPageCount="select count(*) from Group_tbl";
		try {
		    pst=conn.prepareStatement(queryPageCount);
			result=pst.executeQuery();
		   while(result.next()){
	    		rowCount=result.getInt(1);  //获取页数
	    	}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	  if(rowCount%pageSize==0){
	     pageCount=rowCount/pageSize;
		}else{
		 pageCount=rowCount/pageSize+1;
		}
		         		
		System.out.print("pageCount"+pageCount);
		String sql="select top "+pageSize+" * from Group_tbl where id not in(select top "+pageSize*(pageNow-1)+"id from Group_tbl)";
		try {
		    pst=conn.prepareStatement(sql);
			result=pst.executeQuery();
			while(result.next()){
				out.print("<tr><td>"+result.getString("id")+"</td><td>"+ result.getString("name")+"</td></tr>");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
				result.close();
				pst.close();
				conn.close();
		}
     %>
</table>
          <%
            if(pageNow!=1){     
              out.print("<a href=sqlserver.jsp?pageNow="+(pageNow-1)+">上一页</a>&nbsp;&nbsp;&nbsp;");
              }
            for(int i=pageNow;i<pageNow+3;i++){  
              if(i<=pageCount)      //使其不超过总页数
               out.print("<a href=sqlserver.jsp?pageNow="+i+">"+i+"</a>&nbsp;&nbsp;&nbsp;");
      
            }  
             if(pageNow<pageCount)  
             out.print("<a href=sqlserver.jsp?pageNow="+(pageNow+1)+">下一页</a>");
           %>


 <br>
  </body>
</html>

效果如下;