chuangjianxiangmuaction.java~30~

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

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

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

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