chongxinfenpeiaction.java~14~

Bug管理系统

package xiangmu;

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

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

        String bugid=f.getBugid();
        String yonghuid=f.getYonghuid();

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

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

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


        ResultSet rs=stmt.executeQuery("select * from yonghu where yonghuid='"+yonghuid+"'");
        rs.next();
        String chuangjianzhe=rs.getString("bugzhuangtaizhi");

        db1.closeConnection();

        xinxi="提交成功！ Bugid："+bugid+" 被分配给："+chuangjianzhe ;

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