admin1121bean.java

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

package cn.edu.yuyh.admin.bean;

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

import cn.edu.yuyh.admin.actionform.*;
import cn.edu.yuyh.tools.*;

public class Admin1121Bean{
  public void doInitOfInsert(Admin1121ActionForm myForm,HttpServletRequest httpServletRequest,Connection conn)
                 throws Exception{
    try {
      this.doInitOptionsCollection(myForm,httpServletRequest,conn);
      myForm.reset();
     }
    catch (Exception e) {
      throw e;
    }
  }
  public void doInitOptionsCollection(Admin1121ActionForm myForm,HttpServletRequest httpServletRequest,Connection conn)
                 throws Exception
  {
    PublicFunction function = new PublicFunction();
    try
    {
      myForm.setOcdeptno(function.initOcdeptno(httpServletRequest,conn));
      myForm.setOcspecialno(function.initOcspecialno(httpServletRequest,conn));
    }
    catch (Exception e)
    {
      throw e;
    }
  }
  public Boolean doInsertInfo(Admin1121ActionForm myForm,HttpServletRequest httpServletRequest,Connection conn)
                 throws Exception{
    PublicFunction function = new PublicFunction();
    String sno = function.trim(myForm.getSno());
    String password = function.trim(myForm.getPassword());
    String sname = function.trans2iso8859(function.trim(myForm.getSname()));
    String id_card = function.trim(myForm.getId_card());
    String deptno = function.trim(myForm.getDeptno());
    String specialno = function.trim(myForm.getSpecialno());
    String sclass = function.trim(myForm.getSclass1())+function.trim(myForm.getSclass2());
    StringBuffer sql = new StringBuffer();

    sql.append("insert into Student(Sno,Password,Sname,ID_Card,DeptNo,SpecialNo,Class)");
    sql.append(" values('"+sno+"','"+password+"','"+sname+"','"+id_card+"','"+deptno+"','"+specialno+"','"+sclass+"')");
    PreparedStatement pstmt = conn.prepareStatement(sql.toString());
    try {
      int number = pstmt.executeUpdate();
      doInitOptionsCollection(myForm,httpServletRequest,conn);
      if (number == 0)
      {
        return Boolean.FALSE;
      }
    }
    catch (Exception e) {
      e.printStackTrace();
      throw e;
    }
    return Boolean.TRUE;
  }
}