shanchuyouxianjiaction.java~13~

来自「Bug管理系统」· JAVA~13~ 代码 · 共 76 行

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 shanchuyouxianjiAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        shanchuyouxianjiActionForm f = (shanchuyouxianjiActionForm) actionForm;

        String bugYanzhongchengduId=f.getBugYanzhongchengdu();
                       bugYanzhongchengduId = new String(bugYanzhongchengdu.getBytes("ISO-8859-1"), "gbk");
                                   String s = "";
                       if(!bugYanzhongchengdu.trim().equals(""))
                       {
                           //连接数据库
                           Db db1 = new Db();
                           db1.getCon("bugBarrier");
                           //先看是否有此项1
                           Statement stmt = db1.conn.createStatement();
                           s = "select * from bugleibie where bugYanzhongchengduId='" + bugYanzhongchengdu+"'";
                           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 bugLeibieId='"+bugLeibieId+"'";
                               ResultSet rs2 = stmt2.executeQuery(s);
                                                  int j = 0;
                              while (rs.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 bugleibie where bugleibieid='"+bugLeibieId+"'";
                              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);

                return actionMapping.findForward("xitongcanshu");

    }
}