modifyme.java

一个用JSP写的基于了B/S的图书馆管理系统

package web;
import lms.*;

public class ModifyMe extends DataBase
{
  /*
   暂时只能修改四项，能够扩展
  */
 private String UserID;
 private String Email ;
 private String Address;
 private String Phone;
 private String Password;

 public ModifyMe()
 {
    super();
    this.UserID = "";
    this.Email = "";
    this.Address = "";
    this.Phone = "";
    this.Password = "";
  }
  public void setUserID(String UserID)
  {
    this.UserID = UserID;
  }
  public String getUserID()
  {
    return this.UserID;
  }

  public void setEmail(String Email)
  {
    this.Email =Email;
  }
  public String getEmail()
  {
    return this.Email;
  }

  public void setAddress(String Address)
  {
    this.Address = Address;
  }
  public String getAddress()
  {
    return this.Address;
  }

  public void setPhone(String Phone)
  {
    this.Phone = Phone ;
  }
  public String getPhone()
  {
    return this.Phone;
  }

  public void setPassword(String Password)
  {
    this.Password = Password;
  }

  public String getPassword()
  {
    return this.Password;
  }
  /*
  modify individual information
  */
  public boolean Update()
  {
    boolean success = true;
    String sql = "update User_table set Email='"+this.Email
        +"',Address='"+this.Address+"',Phone='"+this.Phone
        +"',UserPassword='"+this.Password+"' where UserID='"+this.UserID+"'";
    int i = 0;
    try
    {
      /* note the number of recodes been updated */
      //System.out.println(sql);
      i = stm.executeUpdate(sql);
      //System.out.println(i);
      this.close();
      //System.out.println(success);
    }
    catch(Exception ex)
    {
      success = false;
    }
    finally
    {
      //System.out.println("finally--"+success);
      return success;
    }
  }
}