loginbean.java

这是一个jsp + sql server在线测试系统,可供初学者参考

package webtest;
import java.sql.*;
import java.io.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: 天津财经学院  信息管理与信息系统——高职升本0101班
 * @author 王刚
 * @version 1.0
 */

public class LoginBean{
  private String userName="";
  private String passWord="";
  private String userTureName="";
  private String errorMessage="";
  private String Isvalid="";
  //Access sample property
  public boolean isVerified() {
    String newpass="";
    Sql_data query=new Sql_data();
    String sql="select Password,Studentname,Isvalid from StudentLogin where (StudentID='"+userName+"')";
    ResultSet rs=query.executeQuery(sql);
    try{
      while(rs.next()){
        newpass=rs.getString("Password");
        userTureName=rs.getString("Studentname");
        Isvalid=rs.getString("Isvalid").trim();
      }
    }
    catch(SQLException e){
      System.err.println(e.getMessage());
      return false;
    }
    if(userName==null||userName.length()==0) {
      errorMessage="请您从系统主页面登录进入系统！";
      return false;
    }
    if(passWord==null||passWord.length()==0) return false;
    if(newpass==null||newpass.length()==0){
      errorMessage="您的学号输错了，请重新输入！";
      return false;
    }
    if(Isvalid==null||Isvalid.length()==0)
    {
     errorMessage="您的个人信息注册错了，请联系管理员！";
     return false ;
    }
    if (newpass.trim().equals(passWord)){
      errorMessage="成功登录";}
    else{
      errorMessage="您的密码输错了，请重新输入！";
      return false;
    }
    if(Isvalid.equals("0")){
      errorMessage="您已经考过了或者您的个人信息注册错了！";
      return false;
    }
    else{
      sql="update StudentLogin set Isvalid='0' where StudentID='"+userName.trim()+"'";
      query.executeInsert(sql);
      query.close();
    }
    return true;
 }
  //Access sample property
  public void setUserName(String newValue){
    userName=newValue;
  }
  public void setPassWord(String newValue){
    passWord=newValue;
  }
  public String getUserTureName(){
    return userTureName;
  }
  public String getErrorMessage(){
    return errorMessage;}
}