listpoll.java

一个关于商业的网站

package com.everstar.poll;

/**
 * Title:        webstar
 * Description:  this is the webstar project
 * $ Modified Record:
 * $2003.4.6: Created.
 * Copyright (C) 2003 www.studyjava.com All rights reserved.
 * @version 1.0
 */
import java.util.*;
import java.sql.*;
import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;
import com.everstar.database.*;

public class ListPoll {
  private int recFrom = 1;       // first record displayed
  private int numRecPerPage = 20; // maximum number of records displayed
  private String actPrev = null; //previous page
  private String actNext = null; //next page
  private Database dbConn = null;  //database connection
  private String error = null;
  private Vector bcBeans = new Vector();

  public int getRecFrom() { return(recFrom); }
  public void setRecFrom(int newRecFrom) { recFrom = newRecFrom; }

  public int getNumRecPerPage() { return(numRecPerPage); }
  public void setNumRecPerPage(int newNumRecPerPage) { numRecPerPage = newNumRecPerPage; }

  public String getActPrev() { return(actPrev); }
  public void setActPrev(String newActPrev) { actPrev = newActPrev; }

  public String getActNext() { return(actNext); }
  public void setActNext(String newActNext) { actNext = newActNext; }

  public Database getDbConn() { return(dbConn); }
  public void   setDbConn(Database newDbConn) { dbConn = newDbConn; }

  public void setError(String newError) { error = newError;}
  public String getError() { return error;}

  public void init() throws ServletException {
    if (dbConn == null)  error = "No Database Connection！";
    int start = recFrom;
    int count = numRecPerPage;
    if (actNext != null) start += numRecPerPage;
	else if (actPrev != null) {
		if ((start -= numRecPerPage) < 1) start = 1;
	    } else start = 1;
    recFrom = start;
    try {
        String sqlstr = "select themeNo,status,author,themeTitle,themeDetail,createTime ,overTime from  themeinfo ";
        ResultSet rs = dbConn.select(sqlstr);
        while (--start > 0 && rs.next());
        bcBeans.clear() ;
        int  i = 0 ;
        while( count-- > 0 && rs.next() ){
          i=1;
          PollInformation  poll = new PollInformation();
          poll.setThemeNo(rs.getInt(1));
          poll.setStatus(rs.getInt(2));
          poll.setAuthor(rs.getString(3));
          poll.setThemeTitle(rs.getString(4));
          poll.setThemeDetail(rs.getString(5));
          poll.setCreatTime(rs.getString(6));
          poll.setOverTime(rs.getString(7));
          bcBeans.add(poll);
        }
        rs.close();
        dbConn.close();
    }catch (Exception e){
      error = "SQL Error";
     }
  }

  public int getNumRec(){return(getNumOfPoll());}

  public int getNumOfPoll(){ return(bcBeans.size()); }

  public PollInformation getPoll(int idx) {
    return((PollInformation)bcBeans.elementAt(idx));
  }

  public ListPoll() {
  }
}