随笔档案(496)

package com.zh.util;

import com.zh.conpool.Condata;
import java.sql.ResultSet;
import java.sql.SQLException;

public class page
{

     ResultSet rs;
     ResultSet rst;
     private int intCountTopic;
     public int intPageSize;
     public int intPageCount;
     public int intPage;
     private String Countsql;
     private String Pagisql;
     private String str;
     private String str_where;
     private String str_parameter;
     private String nowPage;
     private String HttpFile;
     Condata db;

     public page()
     {
         rs = null;
         rst = null;
         intCountTopic = 0;
         intPage = 0;
         Countsql = null;
         Pagisql = null;
         str = null;
         str_where = null;
         str_parameter = "";
         db = new Condata();
     }

     public static void main(String args[])
     {
     
     }

     public void setPages(int i)
     {
         intPageSize = i;
     }

     public String getPagisql()
     {
         return Pagisql;
     }

     public ResultSet setQuerysql(String s, String s1, String s2, String s3)
         throws SQLException
     {
         ResultSet resultset = null;
         nowPage = s3;
         HttpFile = s2;
         Countsql = "select count(*) from " + s + " " + s1;
         Pagisql = "select * from " + s + " " + s1 + " order by id desc";
         try
         {
             Condata _tmp = db;
             Condata.getConnection();
         }
         catch(Exception exception)
         {
             exception.getMessage();
         }
         try
         {
             resultset = querySql(Countsql, Pagisql);
         }
         catch(SQLException sqlexception)
         {
             sqlexception.getMessage();
         }
         return resultset;
     }

     public ResultSet querySql(String s, String s1)
         throws SQLException
     {
         try
         {
             Condata condata = db;
             Condata.getConnection();
         }
         catch(Exception exception) { }
         if(nowPage == null)
         {
             intPage = 1;
         } else
         {
             intPage = Integer.parseInt(nowPage);
             if(intPage < 1)
                 intPage = 1;
         }
         rs = db.executeQuery(s);
         if(rs.next())
             intCountTopic = rs.getInt(1);
         intPageCount = intCountTopic % intPageSize == 0 ? intCountTopic / intPageSize : intCountTopic / intPageSize + 1;
         if(intPage > intPageCount)
             intPage = intPageCount;
         rs.close();
         rst = db.executeQuery(s1);
         return rst;
     }

     public int getCountTopic()
     {
         return intCountTopic;
     }

     public int getPageCount()
     {
         return intPageCount;
     }

     public int getIntPage()
     {
         return intPage;
     }

     public String PageFooter()
     {
         String s = "<form action=" + HttpFile + " name=form1 methord=post>";
         int i = intPage - 1;
         int j = intPage + 1;
         int k = (intPageSize * getIntPage() + 1) - intPageSize;
         if(k < 0)
             k = 0;
         s = s + "<font style='font-size: 9pt'>\u603B\u8BA1<font color='red'>" + getCountTopic() + "</font>\u6761\u8BB0\u5F55," + "\u3010\u5171<font   color='red'>" + getPageCount() + "</font>\u9875\u3011";
         s = s + "\u3010" + intPageSize + "\u6761/\u9875\u3011 \u5F53\u524D\u7B2C<font color='red'>" + getIntPage() + "</font>\u9875(\u5217\u51FA\u7B2C" + k + "\u5230\u7B2C" + getIntPage() * intPageSize + "\u6761) &nbsp; &nbsp; ";
         if(intPage > 1)
             s = s + " <A href=" + HttpFile + "?pages=1" + str_parameter + ">\u9996\u9875</A> ";
         else
             s = s + " \u9996\u9875 ";
         if(intPage > 1)
             s = s + " <A href=" + HttpFile + "?pages=" + i + str_parameter + ">\u4E0A\u4E00\u9875</A> ";
         else
             s = s + " \u4E0A\u4E00\u9875 ";
         if(intPage < intPageCount)
             s = s + " <A href=" + HttpFile + "?pages=" + j + str_parameter + ">\u4E0B\u4E00\u9875</A> ";
         else
             s = s + " \u4E0B\u4E00\u9875 ";
         if(intPageCount > 1 && intPage != intPageCount)
             s = s + " <A href=" + HttpFile + "?pages=" + intPageCount + str_parameter + ">\u5C3E\u9875</A>";
         else
             s = s + " \u5C3E\u9875</font>";
         s = s + "</form>";
         return s;
     }

     public void closeConn()
     {
         db.close();
     }
}