userinformation.java

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

package web;
import lms.*;

public class UserInformation extends DataBase
{
  private String UserID;
  public UserInformation()
  {
    super();
  }

  public void setUserID(String UserID)
  {
    this.UserID = UserID;
  }
  public String getUserID()
  {
    return this.UserID;
  }
  /*get the value of Penalty*/
  public float getPenalty()
  {
    String sql = "select Penalty from User_table where UserID='"+UserID+"'";
    float Penalty=0;
    try
    {
      //System.out.println(sql);
      rs = stm.executeQuery(sql);
      if(rs.absolute(1))
      {
        Penalty = rs.getFloat("Penalty");
        //System.out.println("test--"+Penalty);
      }
    }
    /*must return the value of Penalty even if it is zero*/
    catch(Exception ex)
    {
      System.out.println(ex.getMessage());
      return Penalty;
    }
    return Penalty;
  }
}