shanchucaozuoxitongaction.java

Bug管理系统

package tmp;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import db.Db;
import xiangmu.caozuoxitongliebiao;
import xiangmu.youxianjiliebiao;
import java.sql.Statement;
import java.sql.ResultSet;
import xiangmu.leibieliebiao;

public class shanchucaozuoxitongAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        shanchucaozuoxitongActionForm f = (shanchucaozuoxitongActionForm) actionForm;

        String caozuoxitongId=f.getCaozuoxitong();
                               caozuoxitongId = new String(caozuoxitongId.getBytes("ISO-8859-1"), "gbk");
                                           String s = "";
                               if(!caozuoxitongId.trim().equals(""))
                               {
                                   //连接数据库
                                   Db db1 = new Db();
                                   db1.getCon("bugBarrier");
                                   //先看是否有此项1
                                   Statement stmt = db1.conn.createStatement();
                                   s = "select * from caozuoxitong where caozuoxitongId='" + caozuoxitongId+"'";
                                   ResultSet rs = stmt.executeQuery(s);
                                   int i = 0;
                                   while (rs.next()) {
                                       i++;
                                   }
                                   if (i!=0) {
                                       //在检查bug表中是否有项
                                       Statement stmt2 = db1.conn.createStatement();
                                       s="select * from bug where caozuoxitongId='"+caozuoxitongId+"'";
                                       ResultSet rs2 = stmt2.executeQuery(s);
                                                          int j = 0;
                                      while (rs2.next()) {
                                          j++;
                                      }
                                      if(j!=0)
                                      {
                                          String xinxi="此类型有Bug引用，不可以删除！请先删除引用的bug";
                                         servletRequest.setAttribute("xinxi",xinxi);
                                         return actionMapping.findForward("tishixinxi");
                                      }
                                      //删除此项
                                      Statement stmt1 = db1.conn.createStatement();
                                      s="delete from caozuoxitong where caozuoxitongId='"+caozuoxitongId+"'";
                                      stmt1.execute(s);
                                   }
                                   db1.closeConnection();
                               }

                               //bug类别列表
                                    leibieliebiao lblb=new leibieliebiao();
                                    servletRequest.setAttribute("lblb",lblb);
                                    //bug严重状态
                                    youxianjiliebiao yxjlb=new youxianjiliebiao();
                                    servletRequest.setAttribute("yl",yxjlb);
                                    //操作系统列表
                                    caozuoxitongliebiao czxtlb=new caozuoxitongliebiao();
                                    servletRequest.setAttribute("czxtlb",czxtlb);

                                    //提示信息
                                    String xinxi="删除成功!";
                                    servletRequest.setAttribute("xinxi",xinxi);

                        return actionMapping.findForward("xitongcanshu");

    }
}