page_bean.java

FAQ管理全源代码,可以实现一般的FAQ管理功能,界面简洁而明快,占用资源不大.

package faq_project;

import java.sql.*;
import java.util.*;

public class Page_Bean {
  private Connection con;
  private ResultSet rs;
  private Statement stmt;

  private static int GOTO_PAGE = 1; //当前的页值。
  private int MAX_PAGE = 0; //最大的页数。
  private int ROW_COUNT = 0; //总行数。
  private int ROW_PAGE = 10;//一个页面显示几行数。
  public Page_Bean() throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    DriverManager.setLoginTimeout(3);
    con = DriverManager.getConnection("jdbc:odbc:asdf", "sa", "");
    stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                               ResultSet.CONCUR_UPDATABLE);
    rs = stmt.executeQuery(
        "SELECT COUNT(*) AS Expr1 FROM FAQ");
    rs.next();
    ROW_COUNT = rs.getInt(1);
  }
  public void flush()throws Exception{
    rs=stmt.executeQuery("SELECT * FROM FAQ");
  }

  public Iterator getList()throws Exception{
    int index=ROW_PAGE*GOTO_PAGE*5;
    int i=index;
    flush();
    List lst = new ArrayList();
    while(rs.next()){
      lst.add(String.valueOf(rs.getInt(1)));
      lst.add(rs.getString(2));
      if (rs.getString(3) == null) {
        lst.add("暂时无人回答");
      }
      else {
        lst.add(rs.getString(3));
      }
      lst.add(rs.getString(4));
      lst.add(rs.getString(5));
    }
    Iterator r=lst.iterator();
    while(r.hasNext()&&i>ROW_PAGE*5){
          r.next();
          i--;}
        List vector=new ArrayList();
      while(r.hasNext()&&i>=1){
        vector.add(r.next().toString());
      i--;}
    Iterator iterator=vector.iterator();
      return iterator;
  }

  public void gotoPage(int a) {
    if(a<=MAX_PAGE&&a>=1)
    GOTO_PAGE = a;
  }

  public void nextPage() {
    if(GOTO_PAGE<MAX_PAGE)
      GOTO_PAGE ++;
  }

  public void blackPage() {
    if(GOTO_PAGE>1)
      GOTO_PAGE--;
  }
  public void setGOTO_PAGE(int GOTO_PAGE) {
    this.GOTO_PAGE = GOTO_PAGE;
  }
  public void setROW_PAGE(int ROW_PAGE) {
    if(ROW_COUNT>ROW_PAGE){
      if (ROW_COUNT % ROW_PAGE == 0)
        MAX_PAGE = Math.round( ROW_COUNT/ ROW_PAGE);
      else
        MAX_PAGE = Math.round( ROW_COUNT/ ROW_PAGE)+1;
    }
    else
      MAX_PAGE=1;
  }
  public int getGOTO_PAGE() {
    return GOTO_PAGE;
  }
  public int getMAX_PAGE() {
    return MAX_PAGE;
  }
}