用MVC模式实现对pubs的模糊查询应用.docVIP

用MVC模式实现对pubs的模糊查询应用 对图书表查询select title_id,title,price from titles where title like %key% 1、把Access复制到c:\，在控制面板建立ODBC数据源：my1 2、把JSTL标签库复制到tomcat\webapps\ROOT\WEB-INF\lib 3、Eclipse制作一个项目指到c:\tomcat7\webapps\ROOT\WEB-INF，要添加servlet-api.jar包。 4、编程： 1)写JavaBean封装数据。 2)写JavaBean实现业务逻辑。 3)设计一个输入关键字的JSP表单应用。 4)写Servlet，实现控制器：读取表单，调用JB，结果传统JSP显示。 import javax.servlet.*; import javax.servlet.http.*; public void doGet(HttpServletRequest request, HttpServletResponse response) { String name=request.getParameter(userName); RequestDispatcher go= request.getRequestDispatcher(/disp.jsp); try{ go.forward(request, response); }catch(Exception e) {} } ///////////////////////// public void doPost(HttpServletRequest request, HttpServletResponse response) { doGet(request,response); } 部署ServletROOT\WEB-INF\web.xml servlet servlet-classgxu.MyServlet/servlet-class servlet-nameobj1/servlet-name /servlet servlet-mapping servlet-nameobj1/servlet-name url-pattern/myServlet/url-pattern /servlet-mapping 4)写JSP输出显示。JSTL实现打印 MyServlet.java: package gxu; import javax.servlet.RequestDispatcher; import javax.servlet.http.*; import java.util.*; public class MyServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) { try{ String kw=request.getParameter(kw); if(kw!=null kw.length()0) { Query sv=new Query(); List list=sv.myQuery(kw); request.setAttribute(result,list); RequestDispatcher go=request.getRequestDispatcher(print.jsp); go.forward(request, response); } else { RequestDispatcher go=request.getRequestDispatcher(error.jsp); go.forward(request, response); } }catch(Exception e) { System.out.print(e); } } public void doPost(HttpServletRequest request, HttpServletResponse response) { doGet(request,response); } } Quary.java package gx