genggaibugzhuangtaiaction.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 db.Db;
import java.sql.Statement;
import java.sql.ResultSet;

public class genggaibugzhuangtaiAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        genggaibugzhuangtaiActionForm f = (genggaibugzhuangtaiActionForm) actionForm;
        String bugid=f.getBugid();
        String bugzhuangtaiid=f.getBugzhuangtaiid();

        bugid= new String( bugid.getBytes("ISO-8859-1"), "gbk");
        bugzhuangtaiid= new String( bugzhuangtaiid.getBytes("ISO-8859-1"), "gbk");

        //连接数据库
        Db db1 = new Db();
        db1.getCon("bugBarrier");

        String xinxi="";
        Statement stmt = db1.conn.createStatement();
        String s="update bug set bugzhuangtaiid='"+bugzhuangtaiid+"' where bugid='"+bugid+"'";
        stmt.execute(s);

        String bugzhuangtaizhi="";
        Statement stmt1 = db1.conn.createStatement();

        ResultSet rs=stmt.executeQuery("select * from bugzhuangtai where bugzhuangtaiid='"+bugzhuangtaiid+"'");
        rs.next();
        bugzhuangtaizhi=rs.getString("bugzhuangtaizhi");

        db1.closeConnection();

        xinxi="提交成功！ Bugid："+bugid+" Bug现状态："+bugzhuangtaizhi;
        servletRequest.setAttribute("xinxi",xinxi);
        return actionMapping.findForward("tishixinxi");
    }
}