chuangjianxiangmuaction.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 javax.servlet.http.HttpSession;
import db.*;
import java.sql.Statement;
import java.sql.ResultSet;

public class chuangjianxiangmuAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        chuangjianxiangmuActionForm f = (chuangjianxiangmuActionForm) actionForm;
        String xiangmuJingliId=f.getXiangmujingli();
        String xiangmuMiaoshu =f.getXiangmumiaoshu();
        String xiangmumingcheng=f.getXiangmumingcheng();
        String xiangmuYujiezhiriqi=f.getYujiezhiriqi();

        xiangmuJingliId= new String( xiangmuJingliId.getBytes("ISO-8859-1"), "gbk");
        xiangmuMiaoshu= new String( xiangmuMiaoshu.getBytes("ISO-8859-1"), "gbk");
        xiangmumingcheng= new String( xiangmumingcheng.getBytes("ISO-8859-1"), "gbk");
        xiangmuYujiezhiriqi= new String( xiangmuYujiezhiriqi.getBytes("ISO-8859-1"), "gbk");

        //得到用户本人信息
        HttpSession session = servletRequest.getSession();
        gerenxinxi yonghu1 = (gerenxinxi) session.getAttribute("yonghu1");

        //必添参数
        String xiangmuzhuangtaiId=yonghu1.getBenrenxinxi().getYonghuId();

        //提示信息
        String xinxi="";
        if(xiangmuJingliId.equals("")||xiangmumingcheng.equals(""))
        {
            xinxi="新建项目失败，输入信息不完整！";
            servletRequest.setAttribute("xinxi",xinxi);
            return actionMapping.findForward("tishixinxi");
        }
        //连接数据库
        Db db1 = new Db();
        db1.getCon("bugBarrier");

        //子查询字符串
        String s1="insert into xiangmu(xiangmuChuangjianriqi,xiangmumingcheng,xiangmuJingliId,xiangmuzhuangtaiId";
        String s2=")values(getdate(),'"+xiangmumingcheng+"','"+xiangmuJingliId+"','1'";
        if (!xiangmuMiaoshu.equals("")) {
            s1 = s1 + ",xiangmuMiaoshu";
            s2 = s2 + ",'" + xiangmuMiaoshu + "' ";
        }
        if (!xiangmuYujiezhiriqi.equals("")) {
            s1 = s1 + ",xiangmuYujiezhiriqi";
            s2 = s2 + ",'" + xiangmuYujiezhiriqi + "' ";
        }
        //主查询字符串
        String s="";
        System.out.println(s);
        s=s1+s2+")";
        //获得表中数据
        Statement stmt = db1.conn.createStatement();
        stmt.execute(s); //插入数据

       Statement stmt1=db1.conn.createStatement();
       ResultSet rs1=stmt1.executeQuery("select xiangmuid from xiangmu where xiangmumingcheng='"+xiangmumingcheng+"'");//提取项目id
       while(rs1.next())
       {
             String id=rs1.getString("xiangmuid");
             System.out.println(id);
             Statement stmt2=db1.conn.createStatement();
             Statement stmt3=db1.conn.createStatement();
             s="insert into ceshirenyuan values('"+id+"','0')";

             stmt2.execute(s);
             s="insert into kaifarenyuan values('"+id+"','0')";

             stmt3.execute(s);

       }

        db1.closeConnection();


        xinxi = "新建项目成功!";
        servletRequest.setAttribute("xinxi",xinxi);
        return actionMapping.findForward("tishixinxi");
    }
}