addcustomer.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 AddCustomer {

  private CustomerInformation customer = null;
  private String error = null;
  private Database dbConn = null;
  private String nextURL = null;

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

  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 String getNextURL() { return((nextURL != null) ? nextURL : ""); }
  public void setNextURL(String nextURL_) { nextURL = nextURL_; }

  public void init(HttpServletRequest request, HttpServletResponse response) throws ServletException {
    if (dbConn == null) error = "No Database Connection";
    if (customer == null) error = "No customer Information";
    int customerId = 0;
    try {
      String sqlstr = "select max(personId) + 1 from resume ";
      ResultSet rs = dbConn.select(sqlstr);
      if (rs.next()){
        customerId = rs.getInt(1) ;
        if(customerId <= 0){
          error ="Excetue error!";
         }
      }
      rs.close();
      sqlstr = "insert into resume(personId,personName,sex,age,degree,nation,bornPlace,politics," +
        "foreignLanguage,foreignLevel,computerLevel,stature,marriage,idCard,duty,school,major,documentPlace," +
        "presentPlace,workedYear,wage,positionId,address,zip,telephone,email,resume,relation,request) values( " +
        customerId + ",'" + customer.getPersonName() + "','" + customer.getSex() + "'," + customer.getAge() + ",'" +
        customer.getDegree() + "','" + customer.getNation() + "','" + customer.getBornPlace() +"','" +
        customer.getPolitics() + "','" + customer.getForeignLanguage() +"','" + customer.getForeignLevel() + "','" +
        customer.getComputerLevel() + "'," + customer.getStature() + ",'" + customer.getMarriage() + "','" +
        customer.getIdCard() +"','" + customer.getDuty() + "','" + customer.getSchool() + "','" + customer.getMajor() +
        "','" + customer.getDocumentPlace() + "','" + customer.getPresentPlace() + "'," + customer.getWorkedYear() + ",'" +
        customer.getWages() + "'," + customer.getPositionId() + ",'" + customer.getAddress() + "','" + customer.getZip() + "','" +
        customer.getTelephone() + "','" + customer.getEmail() + "','" + customer.getResume() + "','" +
        customer.getRelation() + "','" + customer.getRequest() + "')";
      dbConn.insert(sqlstr);
      request.getRequestDispatcher(response.encodeURL(getNextURL())).forward(request, response);
    } catch (Exception e) {
      error = "SQL Error";
     }
  }

  public AddCustomer() {
  }
}