pagetest.java

jsp实现的分页连接数据库的新闻发布系统tomcat＋jsp+jdk1.4

package mypack;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class PageTest{
	ResultSet rs=null;
	ResultSet rstmp=null;	
	String sql="";
	int pageSize=6;
	int pageNum=3;
	String str="";
	int totalPage=1;
	String nowPage="";
	ConnDB db;
	int totalRecord;
	public PageTest(){
		 db=new ConnDB();
		}
	
	public String showOnePage(ResultSet rs,int pageNum,int pageSize){
		str="";
		try {
			rs.absolute((pageNum-1)*pageSize+1);
	    }
	    catch (Exception ex) {
	    	System.out.println ("dberror");
	    }
	    for(int i=1;i<=pageSize;i++){
	    	str+="<table>";
	    	str+=showOneRecord(rs);
	    	str+="</table>";
	    	try {
	    		if(!rs.next())break;
		    }
		    catch (Exception ex) {
		    }
	    	}
		return str;
		}
	
	public String showOneRecord(ResultSet rs){
		String tt="";
	  try {
    	tt+="<tr>";
    	tt+="<td align='center'>"+rs.getInt(1)+"</td>";
    	tt+="<td align='center'>"+rs.getString(2)+"</td>";
    	tt+="<td align='center'>"+rs.getString(3)+"</td>";
    	tt+="<td align='center'>"+rs.getString(4)+"</td>";
    	tt+="</tr>";
  	}
  	catch (Exception ex) {
    	System.out.println("数据库查询失败: "+ex);
  		}
  	return tt;
	}

	public String querySql(String pagetemp){
		//nowPage=request.getParameter("page");
		nowPage=pagetemp;
		if(nowPage==null){pageNum=1;}
		else{
			
			pageNum=Integer.parseInt(nowPage);
			if(pageNum<1)
			pageNum=1;
		}
		try {
			rstmp=db.executeQuery("select count(*) from hero");
		if(rstmp.next())
		totalRecord=rstmp.getInt(1);
		totalPage=(totalRecord+pageSize-1)/pageSize;
		
		if(pageNum>totalPage){
			pageNum=totalPage;
			}
		rstmp.close();
	    }
	    catch (Exception ex) {
	    }
		
		rs=db.executeQuery("select * from hero");
		String strtmp=showOnePage(rs,pageNum,pageSize);
	//	strtmp+=PageFooter();
		return strtmp;
		}
		
	public int getTotalRecord(){
		return  totalRecord;
		}
	public int getPageCount(){
		return totalPage;
		
		}
	public int getPageNum(){
		return pageNum;
		}
		
	public String PageFooter(){
		String str="";
		str+="共"+getTotalRecord()+"项";
		str+="共"+getPageCount()+"页";
	  
    if(pageNum!=1)
    {
      
      str+="<A href=index.jsp?page=1>第一页</A>";
      str+="<A href=index.jsp?page="+(pageNum-1)+">上一页</A>";
    }
    if(pageNum!=totalPage)
    {
      str+="<A href=index.jsp?page="+(pageNum+1)+" class='style1'>下一页</A>";
      str+="<A href=index.jsp?page="+totalPage+" class='style1'>最后一页</A>";
    }
   		return str;
		}

		}