shanchubugleibieaction.java~14~

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

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 shanchubugleibieAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse) throws Exception{
        shanchuleibieActionForm f = (shanchuleibieActionForm) actionForm;
        String bugLeibieId=f.getBugLeibie();
               bugLeibieId = new String(bugLeibieId.getBytes("ISO-8859-1"), "gbk");
                           String s = "";
               if(!bugLeibieId.trim().equals(""))
               {
                   //连接数据库
                   Db db1 = new Db();
                   db1.getCon("bugBarrier");
                   //先看是否有此项1
                   Statement stmt = db1.conn.createStatement();
                   s = "select * from bugleibie where bugLeibieId='" + bugLeibieId+"'";
                   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="insert into bugleibie(bugleibiezhi) values('"+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");
    }
}