admin1111action.java

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

package cn.edu.yuyh.admin.action;

import cn.edu.yuyh.admin.actionform.*;
import cn.edu.yuyh.admin.bean.*;
import cn.edu.yuyh.tools.*;
import org.apache.struts.action.*;
import java.sql.*;
import javax.servlet.http.*;


public class Admin1111Action extends Action {
  public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) {
    Connection conn = null;
    ActionForward forward = actionMapping.findForward("doInitOfQuery");
    Admin1111Bean admin1111Bean = new Admin1111Bean();
    Admin1111ActionForm myForm = (Admin1111ActionForm) actionForm;
    String button = (String)httpServletRequest.getParameter("button");//操作类型
    PublicFunction function = new PublicFunction();
    try
    {
      conn = function.getConnection();
      if("doInitOfQuery".equals(button)){
        admin1111Bean.doInitOfQuery(myForm, httpServletRequest, conn);
      }
      if("doQueryInfo".equals(button)){
        if(!Boolean.TRUE.equals(admin1111Bean.doQueryInfo(myForm, httpServletRequest, conn))){
          function.warn(httpServletRequest, "没有找到符合条件的信息！");
        }
      }
      if("doDeleteInfo".equals(button)){
        if(Boolean.TRUE.equals(admin1111Bean.doDeleteInfo(myForm, httpServletRequest, conn))){
          function.warn(httpServletRequest, "信息删除成功！");
        }
        else{
          function.warn(httpServletRequest, "信息删除失败，请与系统管理员联系！");
        }
      }
      if("doInitOfModify".equals(button)){
        if(!Boolean.TRUE.equals(admin1111Bean.doInitOfModify(myForm, httpServletRequest, conn))){
          function.warn(httpServletRequest, "信息提取失败，请与系统管理员联系！");
        }
        forward = actionMapping.findForward("doInitOfModify");
      }
      if("doModifyInfo".equals(button)){
        if(Boolean.TRUE.equals(admin1111Bean.doModifyInfo(myForm, httpServletRequest, conn))){
          function.warn(httpServletRequest, "信息修改成功！");
        }
        else{
          function.warn(httpServletRequest, "信息修改失败，请与系统管理员联系！");
        }
        admin1111Bean.doInitOfQuery(myForm, httpServletRequest, conn);
      }
    }
    catch (Exception e)
    {
      e.printStackTrace();
      function.error(httpServletRequest,e.toString());
      myForm.reset();
    }
    finally
    {
        try{
          conn.close();
        }
        catch(Exception e){
          e.printStackTrace();
        }
    }
    return forward;
  }
}