package thisjsp;import java.sql.*;import java.util.*;import java.io.*;import com.borland.dx.sql.dataset.*;public class listBean{  private String sample = "Start value";  private java.sql.ResultSet listResult;  //Access sample property  private QueryDataSet result=null;  private QueryDataSet queryDataSet1 = new QueryDataSet();  private Database database1 = new Database();  private int count=0;  private int currentValue=0,countPage=0;  public String getSample()  {    return sample;  }  //Access sample property  public void setSample(String newValue)  {    if (newValue!=null)    {      sample = newValue;    }  }//初始化結果集------------------------------------------------------------------  public void getListResult(Writer out) throws Exception  {    try{       queryDataSet1.close();       queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT * FROM bk", null, true, Load.ALL));       queryDataSet1.open();       }    catch(Exception e){       e.printStackTrace();    }    result=queryDataSet1;    if (result!=null)       {       count=result.getRowCount();       currentValue=1;       }    countPage=(((count/10)*10==count)?count/10:count/10+1);//計算該數據集的頁數    out.write("當前是第"+currentValue+"/"+countPage+"頁"); }//條件查詢 public void getListResult(String str,Writer out) throws Exception {   try   {     queryDataSet1.close();     queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1,"select * from bk where "+str.trim(),null,true,Load.ALL));     queryDataSet1.open();   }   catch(Exception eee){}   result=queryDataSet1;   if (result!=null)   {     count=result.getRowCount();     currentValue=1;   }   countPage=(((count/10)*10==count)?count/10:count/10+1);//計算該數據集的頁數   out.write("當前是第"+currentValue+"/"+countPage+"頁"); }//首頁--------------------------------------------------------------------------  public void firstPag(Writer out) throws Exception  {    if (result!=null)    {       result.first();       currentValue=1;    }    else       currentValue=0;    out.write("當前是第"+currentValue+"/"+countPage+"頁");  }//下一頁------------------------------------------------------------------------  public void nextPage(Writer out) throws Exception  {    int i=10;    if (currentValue<=countPage)    {       currentValue++;       out.write("當前是第"+currentValue+"/"+countPage+"頁");    }  }//上一頁------------------------------------------------------------------------  public void previousPage(Writer out) throws Exception  {     int i=21,j=0;     if (((count/10)*10)!=count)          i=21;     if ((((count/10)*10)==count)&&(currentValue==countPage))         i=20;     if (currentValue>=countPage&&((count/10)*10)!=count)        {        i=10+count%10;        out.write("i="+i);        }     if (result.atLast())     {       j=1;     }     else        j=0;     if (currentValue>=1)     {       while(i>1&&result.prior())       {         i--;       }     if (currentValue>1)         currentValue--;     //if (j==1)      // result.next();     }     if (countPage<=1)       result.first();     out.write("當前是第"+currentValue+"/"+countPage+"頁");  }//最后一頁----------------------------------------------------------------------  public void lastPage(Writer out) throws Exception  {       pubMovePage();       out.write("當前是第"+currentValue+"/"+countPage+"頁");  }//  public void pubMovePage() throws Exception  {     result.last();     int sumRecount=result.getRowCount()%10;     currentValue=countPage;     if (sumRecount==0)     {       int i=10;         while((i--)>1&&result.prior());     }     else     {          while ((sumRecount--)>1&&result.prior());     }     //result.next();     if (countPage<=1)       result.first();  }//顯示頁面----------------------------------------------------------------------  public void getListPage(Writer out) throws Exception  {    int i=10;    if (currentValue>countPage)        {        pubMovePage();        }    if (currentValue<=countPage&&currentValue>0)   {    do   {     out.write("<tr>");      out.write("<td width=35>"+result.getInt(0)+"</td>");      out.write("<td width=0 bgcolor=#CCCCCC></td>");      out.write(" <td width=320><a href=\"\">"+result.getString(6)+"</a></td>");      out.write("<td width=0 bgcolor=#CCCCCC></td>");      out.write("<td width=100>"+result.getString(6)+"</td>");      out.write("<td width=0 bgcolor=#CCCCCC></td>");      out.write("<td width=143 bgcolor=#FFFFFF>"+result.getBigDecimal(2)+"</td>");      out.write("<td width=1 bgcolor=#CCCCCC></td>");      out.write("<td width=306>"+result.getString(3)+"</td>");      out.write("</tr>");      out.write("<tr bgcolor=#CCCCCC> ");      out.write("<td colspan=9 height=1></td>");    out.write("</tr>");    }   while(result.next()&&i-->1);   }     }public listBean()  {    try    {      jbInit();    }    catch(Exception e)    {      e.printStackTrace();    }  }  private void jbInit() throws Exception  {    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT bk.num,bk.name FROM\"D:\\book\".bk", null, true, Load.ALL));    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:jbksk", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    database1.setDatabaseName("");  }  private Database database2 = new Database();  private QueryDataSet queryDataSet2 = new QueryDataSet();}