tianjialeibiaoaction.java~15~

来自「Bug管理系统」· JAVA~15~ 代码 · 共 43 行

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;

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");
        if(!bugLeibiezhi.trim().equals(""))
        {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            String s = "";
            //先看是否有此项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();
            }
            db1.closeConnection();
        }
        return actionMapping.findForward("xitongcanshu");
    }
}