listcustomer.java

一个关于商业的网站

package com.everstar.career;
/**
 * 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 ListCustomer {
  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 int positionId = 0;  //the key of the position
  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 void setPositionId(int newPositionId) {positionId = newPositionId;}
  public int getPositionId() {return positionId;}

  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！";
    if (positionId <= 0) error = "No Posiition Id";
    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 * from  resume where  positionId = " + positionId;
        ResultSet rs = dbConn.select(sqlstr);
        while (--start > 0 && rs.next());
        bcBeans.clear() ;
        int  i = 0 ;
        while( count-- > 0 && rs.next() ){
          i=1;
          CustomerInformation  customer= new CustomerInformation();
          customer.setPersonId(rs.getInt(1));
          customer.setPersonName(rs.getString(2));
          customer.setSex(rs.getString(3));
          customer.setAge(rs.getInt(4));
          customer.setDegree(rs.getString(5));
          customer.setNation(rs.getString(6));
          customer.setBornPlace(rs.getString(7));
          customer.setPolitics(rs.getString(8));
          customer.setForeignLanguage(rs.getString(9));
          customer.setForeignLevel(rs.getString(10));
          customer.setComputerLevel(rs.getString(11));
          customer.setStature(rs.getInt(12));
          customer.setMarriage(rs.getString(13));
          customer.setIdCard(rs.getString(14));
          customer.setDuty(rs.getString(15));
          customer.setSchool(rs.getString(16));
          customer.setMajor(rs.getString(17));
          customer.setDocumentPlace(rs.getString(18));
          customer.setPresentPlace(rs.getString(19));
          customer.setWorkedYear(rs.getInt(20));
          customer.setWages(rs.getString(21));
          customer.setPositionId(rs.getInt(22));
          customer.setAddress(rs.getString(23));
          customer.setEmail(rs.getString(24));
          customer.setZip(rs.getString(25));
          customer.setTelephone(rs.getString(26));
          customer.setResume(rs.getString(27));
          customer.setRelation(rs.getString(28));
          customer.setRequest(rs.getString(29));
          bcBeans.add(customer);
        }
        rs.close();
        dbConn.close();
    }catch (Exception e){
      error = "SQL Error";
     }
  }

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

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

  public CustomerInformation getCustomer(int idx) {
    return((CustomerInformation)bcBeans.elementAt(idx));
  }

  public ListCustomer() {
  }
}