updateposition.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.
 */
import java.util.*;
import java.sql.*;
import java.io.*;

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

public class UpdatePosition {
  private PositionInformation position = null;
  private String error = null;
  private Database dbConn = null;
  private String nextURL = null;

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

  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 (position == null) error = "No Position Information";
    try {
      String  sqlstr = null;
      sqlstr = "update position set positionName = '" + position.getPositionName() + "',positionDetail = '" +
      position.getPositionDetail() + "',positionRequest = '" + position.getPositionRequest() + "' where positionId = " +
      position.getPositionId();
      dbConn.update(sqlstr);
      request.getRequestDispatcher(response.encodeURL(getNextURL())).forward(request, response);
    } catch (Exception e) {
      error = "SQL Error";
     }
  }

  public UpdatePosition() {
  }
}