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

        String BugYanzhongchengduZhi=f.getBugYanzhongchengduZhi();
               BugYanzhongchengduZhi = new String(BugYanzhongchengduZhi.getBytes("ISO-8859-1"), "gbk");
                           String s = "";
               if(!BugYanzhongchengduZhi.trim().equals(""))
               {
                   //连接数据库
                   Db db1 = new Db();
                   db1.getCon("bugBarrier");
                   //先看是否有此项1
                   Statement stmt = db1.conn.createStatement();
                   s = "select * from BugYanzhongchengdu where bugYanzhongchengduZhi='" + BugYanzhongchengduZhi+"'";

                   ResultSet rs = stmt.executeQuery(s);
                   int i = 0;
                   while (rs.next()) {
                       i++;
                   }
                   if (i==0) {
                      Statement stmt1 = db1.conn.createStatement();
                      s="insert into BugYanzhongchengdu(bugYanzhongchengduZhi) values('"+BugYanzhongchengduZhi+"')";
                      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="bug优先级:"+BugYanzhongchengduZhi+"添加成功!";
                    servletRequest.setAttribute("xinxi",xinxi);

        return actionMapping.findForward("xitongcanshu");
    }
}