registerbean.java

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

package cn.edu.yuyh.register.bean;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import javax.servlet.http.*;

import cn.edu.yuyh.register.actionform.RegisterActionForm;
import cn.edu.yuyh.tools.*;

public class RegisterBean{
  public Boolean doRegister(RegisterActionForm myForm,HttpServletRequest httpServletRequest,Connection conn)
                 throws Exception{
    String userid = myForm.getUserid();
    String username = myForm.getUsername();
    String password = myForm.getPassword();

    String sql="insert into users(userID,username,password,type) values(?,?,?,'stud')";
    PublicFunction function = new PublicFunction();

    boolean bTemp = false;
    PreparedStatement pstmt = null;
    try {
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1,function.trans2iso8859(userid));
      pstmt.setString(2,function.trans2iso8859(username));
      pstmt.setString(3,function.trans2iso8859(password));
      int intTemp = pstmt.executeUpdate();

      if(intTemp==0)
      {
        return Boolean.FALSE;
      }
      else
      {
        return Boolean.TRUE;
      }
    }
    catch (Exception e) {
      e.printStackTrace();
      throw e;
    }
    finally {
      pstmt.close();
    }
  }
}