tianjialeibiaoaction.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.ResultSet;
import java.sql.Statement;
import xiangmu.youxianjiliebiao;
import xiangmu.caozuoxitongliebiao;
import xiangmu.leibieliebiao;

public class tianjialeibiaoAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        tianjialeibiaoActionForm f = (tianjialeibiaoActionForm) actionForm;
        String bugLeibiezhi=f.getBugLeibiezhi();
        bugLeibiezhi = new String(bugLeibiezhi.getBytes("ISO-8859-1"), "gbk");
                    String s = "";
        if(!bugLeibiezhi.trim().equals(""))
        {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //先看是否有此项1
            Statement stmt = db1.conn.createStatement();
            s = "select * from bugleibie where bugLeibiezhi='" + bugLeibiezhi+"'";
            ResultSet rs = stmt.executeQuery(s);
            int i = 0;
            while (rs.next()) {
                i++;
            }
            if (i==0) {
               Statement stmt1 = db1.conn.createStatement();
               s="insert into bugleibie(bugleibiezhi) values('"+bugLeibiezhi+"')";
               stmt1.execute(s);
            }
            db1.closeConnection();
        }

        //bug类别列表
             leibieliebiao lblb=new leibieliebiao();
             servletRequest.setAttribute("lblb",lblb);
             //bug严重状态
             youxianjiliebiao yxjlb=new youxianjiliebiao();
             servletRequest.setAttribute("yl",yxjlb);
             //操作系统列表
             caozuoxitongliebiao czxtlb=new caozuoxitongliebiao();
             servletRequest.setAttribute("czxtlb",czxtlb);

             //提示信息
             String xinxi="bug类别:"+bugLeibiezhi+"添加成功!";
             servletRequest.setAttribute("xinxi",xinxi);

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