xiugaibug2action.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 xiugaibug2Action extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse) throws Exception{
        chuangjianbugActionForm f= (chuangjianbugActionForm) actionForm;

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

         //表单提交的
         String bugid=f.getBugid();
         String banbenhao=f.getBanbenhao();
         String bugBiaoti=f.getBugbiaoti();
         String bugLeibieId=f.getBugleibie();
         String bugMiaoshu=f.getBugmaoshu();
         String caozuoxitongid=f.getCaozuoxitong();
         String bugChulizheId=f.getKaifarenyuan();
         String bugSuoshumokuaiId=f.getSuoshumokuai();
         String bugYanzhongchengduId=f.getYouxianji();
         String bugYujiezhishijian=f.getYujiezhiriqi();
         //必添内容
         String xiangmuid=yonghu1.getSuochuxiangmu().getXiangmuId();
         String yonghuid=yonghu1.getBenrenxinxi().getYonghuId();

         bugid= new String( bugid.getBytes("ISO-8859-1"), "gbk");
         banbenhao= new String( banbenhao.getBytes("ISO-8859-1"), "gbk");
         bugBiaoti= new String( bugBiaoti.getBytes("ISO-8859-1"), "gbk");
         bugLeibieId= new String(bugLeibieId.getBytes("ISO-8859-1"), "gbk");
         bugMiaoshu= new String(bugMiaoshu.getBytes("ISO-8859-1"), "gbk");
         caozuoxitongid= new String(caozuoxitongid.getBytes("ISO-8859-1"), "gbk");
        bugSuoshumokuaiId= new String(bugSuoshumokuaiId.getBytes("ISO-8859-1"), "gbk");
          bugChulizheId= new String( bugChulizheId.getBytes("ISO-8859-1"), "gbk");
         bugYanzhongchengduId= new String(bugYanzhongchengduId.getBytes("ISO-8859-1"), "gbk");
         bugYujiezhishijian= new String(bugYujiezhishijian.getBytes("ISO-8859-1"), "gbk");

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

                 if(!banbenhao.equals(""))
                 {
                     s1=s1+",banbenhao='"+banbenhao+"'";
                 }
                 if(!bugLeibieId.equals(""))
                 {
                     s1=s1+",bugLeibieId='"+bugLeibieId+"'";
                 }
                 if(!bugMiaoshu.equals(""))
                 {
                     s1=s1+",bugMiaoshu='"+bugMiaoshu+"'";
                 }
                 if(!caozuoxitongid.equals(""))
                 {
                     s1=s1+",caozuoxitongid='"+caozuoxitongid+"'";
                 }
                 if(!bugSuoshumokuaiId.equals(""))
                 {
                     s1=s1+",bugSuoshumokuaiId='"+bugSuoshumokuaiId+"'";
                 }
                 if(!bugChulizheId.equals(""))
                 {
                     s1=s1+",bugChulizheId='"+bugChulizheId+"'";
                 }
                 if(!bugYanzhongchengduId.equals(""))
                 {
                     s1=s1+",bugYanzhongchengduId='"+bugYanzhongchengduId+"'";
                 }
                 if(!bugYujiezhishijian.equals(""))
                 {
                     s1=s1+",bugYujiezhishijian='"+bugYujiezhishijian+"'";
                 }
                 //主连接字符串
                 String s=s1+s2;
                 Statement stmt = db1.conn.createStatement();
                 stmt.execute(s); //插入数据
                 db1.closeConnection();
                 xinxi = "修改Bug成功!";
             }
             servletRequest.setAttribute("xinxi", xinxi);
             return actionMapping.findForward("tishixinxi");


    }
}