loginbean.java

1.简单缩减版的教务管理系统 2.Struts+SQLServer2000 3.包含数据库（含表格说明）和源代码 4.主页源自厦门大学教务处首页 5.完整实现其中第一个功能模块

package cn.edu.yuyh.login.bean;
import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import javax.servlet.http.*;

import cn.edu.yuyh.login.actionform.LoginActionForm;
import cn.edu.yuyh.tools.*;

public class LoginBean{
  public Boolean doLogin(LoginActionForm myForm,HttpServletRequest httpServletRequest,Connection conn)
                 throws Exception{
    String username = myForm.getUsername();
    String password = myForm.getPassword();
    String usertype = myForm.getUsertype();
    String sql = "";
    ResultSet rs = null;
    PreparedStatement pstmt = null;

    if("0".equals(usertype)){
      sql="select * from Admin where ID=? and Password=?";
      myForm.setUsertype("管理员");
    }
    else if("1".equals(usertype)){
      sql="select * from Student where Sno=? and Password=?";
      myForm.setUsertype("学生");
    }
    else if("2".equals(usertype)){
      sql="select * from Teacher where Tno=? and Password=?";
      myForm.setUsertype("教师");
    }

    PublicFunction function = new PublicFunction();

    try {
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1,function.trans2iso8859(username));
      pstmt.setString(2,function.trans2iso8859(password));
      rs = pstmt.executeQuery();
      while(rs.next())
      {
        return Boolean.TRUE;
      }
    }
    catch (Exception e) {
      e.printStackTrace();
      throw e;
    }
    finally {
      rs.close();
      pstmt.close();
    }
    return Boolean.FALSE;
  }
}