chuangjianxiangmuaction.java~31~

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

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;

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 + "' ";
        }

        //主查询字符串
        String s="";
        s=s1+s2+")";
        //获得表中数据
        Statement stmt = db1.conn.createStatement();
        stmt.execute(s); //插入数据
        db1.closeConnection();

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