xiugaixiangmu2action.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.Db;
import java.sql.Statement;

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

        //修改参数
        String xiangmuId=f.getXiangmuId();
        String xiangmuJingliId=f.getXiangmujingli();
        String xiangmuMiaoshu =f.getXiangmumiaoshu();
        String xiangmumingcheng=f.getXiangmumingcheng();
        String xiangmuYujiezhiriqi=f.getYujiezhiriqi();
        String xiangmuzhuangtaiId=f.getXiangmuzhuangtaiId();

        xiangmuId= new String( xiangmuId.getBytes("ISO-8859-1"), "gbk");
        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");
        xiangmuzhuangtaiId= new String( xiangmuzhuangtaiId.getBytes("ISO-8859-1"), "gbk");

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


        //传递的消息字符串
        String xinxi="";
        if(xiangmuJingliId.equals("")||xiangmumingcheng.equals("")||xiangmuzhuangtaiId.equals(""))
        {
            xinxi="Bug修改失败，请输入完整信息！";
        }
        else
        {
                //连接数据库
                Db db1 = new Db();
                db1.getCon("bugBarrier");
                //子连接字符串
                String s1 ="update xiangmu set xiangmumingcheng='"+xiangmumingcheng+"'";
                String s2 = "where xiangmuid='"+xiangmuId+"'";

                if(!xiangmuJingliId.equals(""))
                {
                    s1=s1+",xiangmuJingliId='"+xiangmuJingliId+"'";
                }
                if(!xiangmuzhuangtaiId.equals(""))
                {
                    s1=s1+",xiangmuzhuangtaiId='"+xiangmuzhuangtaiId+"'";
                }
                if(!xiangmuYujiezhiriqi.equals(""))
                {
                    s1=s1+",xiangmuYujiezhiriqi='"+xiangmuYujiezhiriqi+"'";
                }
                if(!xiangmuMiaoshu.equals(""))
                {
                    s1=s1+",xiangmuMiaoshu='"+xiangmuMiaoshu+"'";
                }
                //主连接字符串
                String s=s1+s2;
                Statement stmt = db1.conn.createStatement();

                stmt.execute(s); //插入数据
                db1.closeConnection();
                xinxi = "修改项目成功!";
            }
            servletRequest.setAttribute("xinxi", xinxi);

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