registerevent.java~2~

小型论文管理系统 功能还不是很完善 有待改进

package stumanage.events;

import stumanage.events.EditRegisterEvent;
import stumanage.beans.*;
import java.util.ResourceBundle;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletContext;
import java.sql.*;
import javax.servlet.http.HttpSession;
public class RegisterEvent
    extends EventHandleBase {
  private boolean regSuccess = false;
  private String roles;
  public RegInfo regInfo = new RegInfo();
  public RegisterEvent() {
  }
  public void process (ServletContext sc,
                       HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
    HttpSession session = request.getSession();
    user = (UserInfo)session.getAttribute("user");
    //if(user!=null) {
     // System.out.println(user.getUserID()+"   "+user.getUsername());
   // }
    PreparedStatement stmt;
    Connection con= null;
    //request.setCharacterEncoding("GB2312");
    roles = request.getParameter("role");
    System.out.println(roles);
    //UserInfo userinfo = (UserInfo)session.getAttribute("user");
    if((request.getParameter("userID")==null)||(request.getParameter("username")==null)||(request.getParameter("password")==null)||(request.getParameter("rePass")==null)||(roles==null)){
      regInfo.setInfo("请输入所有信息");
      session.setAttribute("user",null);
      System.out.println(regInfo.getInfo());
      return;
    }
    if(!request.getParameter("password").equals(request.getParameter("rePass"))) {
      regInfo.setInfo("您两次输入的密码不一致，请重新输入");
      session.setAttribute("regInfo",regInfo);
      session.setAttribute("user",null);
      System.out.println(regInfo.getInfo());
      return;
    }
    //session.setAttribute("user",userinfo);
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      String dsn = "jdbc:odbc:info";
      System.out.println("jdbc:odbc:info");
      con = DriverManager.getConnection(dsn);
      String sql = new String();
      //String username = request.getParameter("username");
      //String password = request.getParameter("password");
      if(roles.equalsIgnoreCase("student")) {
        sql = "INSERT INTO SInfo(SNo,SName,SPass) VALUES(?,?,?)";
      }
      else {
        sql = "INSERT INTO TInfo(TNo,TName,TPass) VALUES(?,?,?)";
      }
      System.out.println(sql);
      stmt = con.prepareStatement(sql);
      System.out.println("stmt = con.prepareStatement(sql);");
      stmt.setString(1,request.getParameter("userID"));
      stmt.setString(2,request.getParameter("username"));
      stmt.setString(3,request.getParameter("password"));
      System.out.println("stmt.setString");
      stmt.executeUpdate();
      user.setUserID(request.getParameter("userID"));
      user.setPassword(request.getParameter("password"));
      String temp = new String(request.getParameter("username").getBytes("ISO8859_1"));
      user.setUsername(temp);
      user.setRole(roles);
      session.setAttribute("user",user);
      regSuccess = true;
    } catch(Exception exc) {
      regInfo.setInfo("发生异常");
      session.setAttribute("user",null);
      System.out.println(regInfo.getInfo());
    }
    session.setAttribute("regInfo",regInfo);


    //Debug.log (this, "process", "Using default process");
  }

  protected String getURL() {
    ResourceBundle rd = ResourceBundle.getBundle("URL");
    String url = null;
    if (regSuccess) {
      if (roles.equalsIgnoreCase("student")) {
        url = rd.getString("SLOGIN");
      }
      else {
        url = rd.getString("TLOGIN");
      }
    }
    if(url!=null)
      return url;
    else {
       url = rd.getString("REGERROR");
       return url;
    }

  }
}