日期:2014-05-16 浏览次数:20391 次
SearchServlet代码如下: package servlet.user; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import dao.DBOperation; import util.Validate; public class SearchServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Validate vd = new Validate(); String name = vd.getUnicode(request.getParameter(“name”)); String bookl = vd.getUnicode(request.getParameter(“bookl”)); String types = vd.getUnicode(request.getParameter(“types”)); DBOperation dbo=new DBOperation(); String sql = “select * from books “; if (name != null && !name.equals(“”)) { sql += “where name like ‘%” + name + “%’”; } if (bookl != null && !cuban.equals(“”)) { sql += “where publishing like ‘%” + bookl + “%’”; } if (types != null && !types.equals(“”)) { sql += “where type=’” + types + “’”; } request.setAttribute(“search”, dbo.queryReturnList(sql)); RequestDispatcher rd = request.getRequestDispatcher(“/user/booklist.jsp”); rd.forward(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }