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

用MVC模式实现对pubs的模糊查询应用对图书表查询select title_id,title,price from titles where title like %key%1、把Access复制到c:，在控制面板建立ODBC数据源：my12、把JSTL标签库复制到tomcatwebappsROOTWEB-INFlib3、Eclipse制作一个项目指到c:tomcat7webappsROOTWEB-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);部署Servlet-ROOTWEB-INFweb.xml gxu.MyServlet obj1 obj1 /myServlet 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);elseRequestDispatcher 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.javapackage gxu;import java.sql.*;import java.util.*;public class Query public List myQuery(String key)ArrayList list=new ArrayList();/tryString drv=sun.jdbc.odbc.JdbcOdbcDriver;Class.forName(drv);String url=jdbc:odbc:mypubs;Connection con=DriverManager.getConnection(url,);Statement st=con.createStatement();String sql=select title_id,title,price from titles where title like %+key+%;ResultSet rs=st.executeQuery(sql);while(rs.next()DataVO obj=new DataVO();obj.setBookID(rs.getString(1);obj.setBookName(rs.getString(2);obj.setBookPrice(rs.getString(3);list.add(obj);con.close();catch(Exception e)System.out.print(e);return list;DataVO.java:package gxu;public class DataVO private String bookID=null;private String bookName=null;private String bookPrice=null;/public void setBookID(String str)bookID=str;public String getBookID()return bookID;public void setBookName(String str)bookName=str;public String getBookName()return bookName;public void setBookPrice(String str)bookPrice=str;public String getBookPrice(