yuanwenjian.rar_超市管理系统

package servlet; import java.io.IOException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import util.Validate; import bean.SelectBean; public class SelectServlet extends HttpServlet { /** * Constructor of the object. */ public SelectServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Validate vd = new Validate(); String zonglei = vd.getUnicode(request.getParameter("zonglei")); String name = vd.getUnicode(request.getParameter("name")); String candi = vd.getUnicode(request.getParameter("candi")); String maxkucun = vd.getUnicode(request.getParameter("maxkucun")); String minkucun = vd.getUnicode(request.getParameter("minkucun")); String maxjinjia = vd.getUnicode(request.getParameter("maxjinjia")); String minjinjia = vd.getUnicode(request.getParameter("minjinjia")); String maxdanjia = vd.getUnicode(request.getParameter("maxdanjia")); String mindanjia = vd.getUnicode(request.getParameter("mindanjia")); String [] args = {"id","name","candi","jinjia","danjia","danwei","zhonglei","kucun"}; String sql = "select * from shangpin"; if(zonglei != null && !zonglei.equals("")){ sql = sql+" where zhonglei='"+zonglei+"'"; } if(name != null && !name.equals("")){ sql = sql+" where name='%"+name+"%'"; } if(candi != null && !candi.equals("")){ sql = sql+" where candi='%"+candi+"%'"; } if(maxkucun != null && !maxkucun.equals("")){ sql = sql+" where kucun>"+maxkucun; } if(minkucun != null && !minkucun.equals("")){ sql = sql+" where kucun<"+minkucun; } if(maxjinjia != null && !maxjinjia.equals("")){ sql = sql+" where jinjia>"+maxjinjia; } if(minjinjia != null && !minjinjia.equals("")){ sql = sql+" where jinjia<"+minjinjia; } if(maxdanjia != null && !maxdanjia.equals("")){ sql = sql+" where danjia>"+maxdanjia; } if(mindanjia != null && !mindanjia.equals("")){ sql = sql+" where danjia<"+mindanjia; } SelectBean sb = new SelectBean(); ArrayList al = sb.select(sql, args); request.setAttribute("select", al); RequestDispatcher rd=request.getRequestDispatcher("/select.jsp"); rd.forward(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request,response); } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }