select.java~29~

来自「bbs系统」· JAVA~29~ 代码 · 共 67 行

package bbs.beans.select;

import bbs.beans.dbcontact.ContactBean;
import java.util.Vector;
import java.lang.Integer;
import java.sql.*;


class Select
{
    private Statement stm;
    private ResultSet result;
    private String sql;
    public int curpage;//当前是多少页
    public int pagenum;//一共有多少页
    public int rownum;//一共有多少行
    public int rowsperpage=16;//每页有多少行

    public Select()
    {
      ContactBean contact=new ContactBean();
      stm=contact.getStm();
    }

    private void getRownum()throws Exception
     {
       int ret=0;
       result=stm.executeQuery("select * from topicplan,boardinfo where "+sql);
          if(result.next())
            ret=result.getInt(1);
       this.rownum=ret;
      }

   private void countPageNum()
    {
      if (this.rownum%this.rowsperpage==0)
          {
            this.pagenum=this.rownum/this.rowsperpage;
          }
          else
          {
            this.pagenum=this.rownum/this.rowsperpage+1;
          }
        }

   public Vector listData(String sql,String page)
   {
     Vector v;
     this.sql=sql;
     int num=Integer.parseInt(page);//.获得当前的页面号


      try
      {
        this.getRownum();
        this.countPageNum();

       }
        catch(Exception e)
        {
         e.printStackTrace();
        }

   }

}