selectcustomer.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 SelectCustomer {

  private int customerId = 0;
  private CustomerInformation customer = null;
  private String error = null;
  private Database dbConn = null;

  public int getCustomerId() { return customerId;}
  public void setCustomerId(int newCustomerId) { customerId = newCustomerId;}

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

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

  public void setCustomer(CustomerInformation newCustomer) { customer = newCustomer;}
  public CustomerInformation getCustomer() { return customer;}

  public void init() throws ServletException {
    if (dbConn == null) error = "No Database Connection";
    if (customerId <= 0) error = "No Customer Id";
    if (customer == null) error = "No Customer Information";
    try{
      String sql = "select * from resume where personId = " + customerId;
      ResultSet rs = dbConn.select(sql) ;
      if(rs.next()){
        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.setZip(rs.getString(25));
        customer.setTelephone(rs.getString(26));
        customer.setEmail(rs.getString(24));
        customer.setResume(rs.getString(27));
        customer.setRelation(rs.getString(28));
        customer.setRequest(rs.getString(29));
      }
      rs.close();
      sql = "select positionName from position where positionId = " + customer.getPositionId();
      rs = dbConn.select(sql);
      if (rs.next()) customer.setPositionName(rs.getString(1));
      rs.close();
      dbConn.close();
      }catch(Exception e) {
       error = "SQL Error";
     }
  }

  public SelectCustomer() {
  }
}