tianjiamokuaiaction.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 gerenxinxi.gerenxinxi;
import xiangmu.xiangmuliebiao;
import db.Db;
import javax.servlet.http.HttpSession;
import yonghu.ceshirenyuanliebiao;
import xiangmu.xiangmu;
import java.sql.Statement;
import java.sql.ResultSet;
import yonghu.yonghuliebiao;
import yonghu.kaifarenyuanliebiao;
import java.util.Iterator;
import xiangmu.mokuailiebiao;
import xiangmu.*;

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


        String mokuaiZhi=f.getMokuaitmp();
                mokuaiZhi = new String(mokuaiZhi.getBytes("ISO-8859-1"), "gbk");

                //得到对象
                HttpSession session = servletRequest.getSession();
                gerenxinxi yonghu1 = new gerenxinxi();
                yonghu1 = (gerenxinxi) session.getAttribute("yonghu1");
                String xiangmuid = yonghu1.getSuochuxiangmu().getXiangmuId();

                if (!mokuaiZhi.trim().equals("")) {
                    //连接数据库
                    Db db1 = new Db();
                    db1.getCon("bugBarrier");
                    String s = "";
                    //先看项目中是否有此模块
                    Statement stmt = db1.conn.createStatement();
                    s = "select * from mokuai where xiangmuid='" + xiangmuid +
                        "' and mokuaiZhi='" + mokuaiZhi + "'";
                    ResultSet rs = stmt.executeQuery(s);
                    int n = 0;
                    while (rs.next()) {
                        n++;
                    }
                    if (n == 0) {

                        Statement stmt2 = db1.conn.createStatement();
                        s = "insert into mokuai (xiangmuId,mokuaiZhi) values('" + xiangmuid + "','" +
                            mokuaiZhi + "')";
                        stmt.execute(s);
                    }
                    db1.closeConnection();
                }

                //拿到此项目
                xiangmuliebiao xl = new xiangmuliebiao();
                xl.addxiangmu(xiangmuid, "", "", "", "", "");
                Iterator i1 = xl.xiangmuitems.iterator();
                xiangmu xm = new xiangmu();
                if (i1.hasNext()) {
                    xm = (xiangmu) i1.next();
                }
                servletRequest.setAttribute("xm", xm);

                //全部用户列表
                yonghuliebiao yl = new yonghuliebiao();
                yl.addyonghu();
                servletRequest.setAttribute("yl", yl);

                //得到测试人员
                ceshirenyuanliebiao cl = new ceshirenyuanliebiao(xiangmuid);
                servletRequest.setAttribute("cl", cl);

                //得到开发人员
                kaifarenyuanliebiao kl = new kaifarenyuanliebiao(xiangmuid);
                servletRequest.setAttribute("kl", kl);

                //项目状态列表
                xiangmuzhuangtailiebiao xmztlb = new xiangmuzhuangtailiebiao();
                servletRequest.setAttribute("xmztlb", xmztlb);

                //模块列表
                mokuailiebiao ml = new mokuailiebiao();
                ml.addmokuai(xiangmuid);
                servletRequest.setAttribute("ml", ml);

                //提示信息
                String xinxi="添加模块成功!";
                servletRequest.setAttribute("xinxi",xinxi);

                return actionMapping.findForward("xiugaixiangmu");

    }
}