纯Jsp数据库案例解析.docVIP

纯Jsp数据库案例解析 一、多种数据查询的处理 数据库资料请见booksql_new.txt文件。 数据表book结构 注意以下的代码都是在webroot的jdbcsample文件夹下执行成功的 新建文件conn.jsp，把数据库连接文件写入，后面所有调用数据库的页面包含这个文件即可。 conn.jsp参考代码： %@ page language=java import=java.util.* pageEncoding=utf-8% %@ page import=java.sql.* % !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleMy JSP conn.jsp starting page/title meta http-equiv=pragma content=no-cache meta http-equiv=cache-control content=no-cache meta http-equiv=expires content=0 meta http-equiv=keywords content=keyword1,keyword2,keyword3 meta http-equiv=description content=This is my page !-- link rel=stylesheet type=text/css href=styles.css -- /head body % //连接数据库 String sDBDriver = com.mysql.jdbc.Driver; Class.forName(sDBDriver); String sConnStr = jdbc:mysql://localhost:3306/bookdb?useUnicode=trueamp;characterEncoding=UTF-8; String username=root; String password=123456; Connection con = DriverManager.getConnection(sConnStr,username,password); % /body /html 完成对于以上书表的一系列查询活动： book_detail.jsp显示某书的具体数据显示，图片显示处理；若无指明某本书进入b中的列表页面。 book_detail.jsp参考代码 %@ page language=java import=java.util.* pageEncoding=utf-8% % String path = request.getContextPath(); String basePath = request.getScheme()+://+request.getServerName()+:+request.getServerPort()+path+/; % !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head base href=%=basePath% titleMy JSP bookquery.jsp starting page/title meta http-equiv=pragma content=no-cache meta http-equiv=cache-control content=no-cache meta http-equiv=expires content=0 meta http-equiv=keywords content=keyword1,keyword2,keyword3 meta http-equiv=description content=This is my page !-- link rel=stylesheet type=text/css href=styles.css -- /head body center table border=1 %@include file=conn.jsp % %String bookId=request.getParameter(bookId); if(bookId==null){ response.sendRedirect(books.jsp); } Statement stmt = con.createStatement(); ResultSet rs=null;