selectposition.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 SelectPosition {
  private int positionId = 0;
  private PositionInformation position = null;
  private Database dbConn = null;  //database connection
  private String error = null;

  public void setPositionId(int newPositionId) { positionId = newPositionId;}
  public int getPositionId() { return positionId;}

  public void setPosition(PositionInformation newPosition) { position = newPosition;}
  public PositionInformation getPosition() { return position;}

  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 Postion Id";
    if (position == null) error = "No Position Information";
    try{
      String sql = "select * from position where positionId = " + positionId;
      ResultSet rs = dbConn.select(sql) ;
      if(rs.next()){
        position.setPositionId(rs.getInt("position"));
        position.setPositionName(rs.getString("positionName"));
        position.setPositionDetail(rs.getString("positionDetail"));
        position.setPositionRequest(rs.getString("positionRequest"));
        position.setCount(rs.getInt("count"));
      }
        rs.close();
        dbConn.close();
      }catch(Exception e) {
       error = "SQL Error";
     }
  }

  public SelectPosition() {
  }
}