javaWeb书店管理系统

一、实验目的理解并掌握编码与测试相关理论与方法；进一步熟悉利用编程语言实现系统；要求学生理解测试在软件开发中的重要地位；学生了解测试用例与测试报告的相关书写规范。二、实验内容与要求根据系统的特点，选取javaWebMVC开发模型实现该系统；系统的编码结构：边界类：1个html（项目首页），13个jsp（中间跳转的页面），一个css（界面美化功能），一个javascript（控制输入合法性）。控制类：一个servlet类（连接边界类和实体类）实体类：一个datebase类（连接数据库），一个bookinfo类（书本的增删检查操作）服务器采用tomcat。如下图展示：对系统进行测试分析，并对系统功能实施测试，编写测试用例，系统已经实现可以让手机电脑一起访问并做操作；撰写实验报告，同时需要了解测试报告相应的规范与写法。下面是一些界面的展示（没有全部展示）：登录页面顾客首页购买页面订单页面查询页面查询结果管理员页面添加图书页面添加图书信息不完整页面三、完整开发代码(按照上面截图部署即可实现)Table.css:body{background:#ffffff;margin:15;}body,table,th,td,input,select,textarea{font-family:Tahoma,Verdana,Arial,Helvetica,sans-serif;font-size:12px;}table.default{border:1pxsolid#3366CC;border-collapse:collapse;width:80%;}table.defaulttd{padding:2525;height:26px;text-align:center;border:1pxsolid#ffffff;background-color:#f0f0f0;}table.defaulttr.titletd{font-weight:bold;text-align:center;background:#99CCFF;color:red;border:1pxsolid#ffffff;white-space:nowrap;height:26px;}table.defaultth.item{font-weight:bold;color:#333333;text-align:center;vertical-align:top;padding:10px;font-size:14px;}xyh.css:body{font-family:Arial,Helvetica,sans-serif;font-size:12px;color:#666666;background:#fff;text-align:center;}*{margin:0;padding:0;}a{color:#1E7ACE;text-decoration:none;}a:hover{color:#000;text-decoration:underline;}h3{font-size:14px;font-weight:bold;}pre,p{color:#1E7ACE;margin:4px;}input,select,textarea{padding:1px;margin:2px;font-size:11px;}.buttom{padding:1px10px;font-size:12px;border:1px#1E7ACEsolid;background:#D0F0FF;}#formwrapper{width:450px;margin:15pxauto;padding:20px;text-align:left;border:1pxsolid#A4CDF2;}fieldset{padding:10px;margin-top:5px;border:1pxsolid#A4CDF2;background:#fff;}fieldsetlegend{color:#1E7ACE;font-weight:bold;padding:3px20px3px20px;border:1pxsolid#A4CDF2;background:#fff;}fieldsetlabel{float:left;width:120px;text-align:right;padding:4px;margin:1px;}fieldsetdiv{clear:left;margin-bottom:2px;}.input{width:120px;}.enter{text-align:center;}.clear{clear:both;}Common.js:functionisNum(num){for(i=0;i<num.length;i++){c=num.charAt(i);if(c>'9'||c<'0'){returnfalse;}}returntrue;}functioncheck(){if(form1.id.value==""){alert("noid!");form1.id.focus();returnfalse;}if(.value==""){alert("noname!");.focus();returnfalse;}if(form1.author.value==""){alert("noauthor!");form1.author.focus();returnfalse;}if(form1.press.value==""){alert("nopress!");form1.press.focus();returnfalse;}if(form1.date.value==""){alert("nodate!")form1.date.focus();returnfalse;}if(!isNum(form1.price)){alert("priceiswrong!")form1.price.focus();returnfalse;}if(!isNum(form1.account)){alert("accountiswring!")form1.account.focus();returnfalse;}Bookinfo.java:packagebean;importjava.lang.String;importjava.lang.System;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;publicclassbookinfo{privateStringid;privateStringname;privateStringauthor;privateStringpress;privateStringdate;privateintprice;privateintaccount;publicvoidsetName(Stringname){=name;}publicStringgetName(){returnname;}publicvoidsetAuthor(Stringauthor){this.author=author;}publicStringgetAuthor(){returnauthor;}publicvoidsetDate(Stringdate){this.date=date;}publicStringgetDate(){returndate;}publicvoidsetPress(Stringpress){this.press=press;}publicStringgetPress(){returnpress;}publicvoidsetId(Stringid){this.id=id;}publicStringgetId(){returnid;}publicvoidsetAccount(intacount){this.account=acount;}publicintgetAccount(){returnaccount;}publicvoidsetPrice(intprice){this.price=price;}publicintgetPrice(){returnprice;}publicstaticArrayList<bookinfo>getbooklist(){ArrayList<bookinfo>list=newArrayList<bookinfo>();Stringsql="select*frombook.bookshop";dbbeanjdbc=newdbbean();ResultSetrs=jdbc.executeQuery(sql);try{while(rs.next()){bookinfobi=newbookinfo();bi.setId(rs.getString("id"));bi.setName(rs.getString("name"));bi.setAuthor(rs.getString("author"));bi.setPress(rs.getString("press"));bi.setDate(rs.getString("date"));bi.setPrice(rs.getInt("price"));bi.setAccount(rs.getInt("account"));list.add(bi);}rs.close();}catch(SQLExceptione){e.printStackTrace();}jdbc.close();returnlist;}//通过编号书名作者来搜索publicstaticArrayList<bookinfo>getbookbyway(Stringid,Stringname,Stringauthor){ArrayList<bookinfo>list=newArrayList<bookinfo>();Stringsql=null;intway=0;if(!id.equals("")){way=way+1;}if(!name.equals("")){way=way+10;}if(!author.equals("")){way=way+100;}if(way==1||way==11||way==101){sql="select*frombook.bookshopwhereid='"+id+"'";}if(way==10){sql="select*frombook.bookshopwherenamelike'%"+name+"%'";}if(way==100){sql="select*frombookshopwhereauthorlike'%"+author+"%'";}if(way==110){sql="select*frombookshopwherenamelike'%"+name+"%'andauthorlike'%"+author+"%'";}dbbeanjdbc=newdbbean();ResultSetrs=jdbc.executeQuery(sql);try{while(rs.next()){bookinfobi=newbookinfo();bi.setDate(rs.getString("date"));bi.setPress(rs.getString("press"));bi.setAuthor(rs.getString("author"));bi.setName(rs.getString("name"));bi.setId(rs.getString("id"));bi.setPrice(rs.getInt("price"));bi.setAccount(rs.getInt("account"));list.add(bi);}rs.close();}catch(SQLExceptione){System.out.println("nofind");}jdbc.close();returnlist;}publicstaticbookinfogetbookbyid(Stringid){Stringsql="select*frombook.bookshopwhereid='"+id+"'";dbbeanjdbc=newdbbean();ResultSetrs=jdbc.executeQuery(sql);bookinfobi=newbookinfo();try{if(rs.next()){bi.setDate(rs.getString("date"));bi.setPress(rs.getString("press"));bi.setAuthor(rs.getString("author"));bi.setName(rs.getString("name"));bi.setId(rs.getString("id"));bi.setPrice(rs.getInt("price"));bi.setAccount(rs.getInt("account"));}rs.close();}catch(SQLExceptione){System.out.println("nofind");}jdbc.close();returnbi;}publicstaticintupdatebook(Stringid,Stringname,Stringauthor,Stringpress,Stringdate,intprice,intaccount){intresult=0;Stringsql="updatebook.bookshopsetname='"+name+"',author='"+author+"',press='"+press+"',date='"+date+"',price="+price+",account="+account+"whereid='"+id+"'";dbbeanjdbc=newdbbean();result=jdbc.executeUpdate(sql);returnresult;}publicstaticintdeletebook(Stringid){intresult=0;Stringsql="deletefrombook.bookshopwhereid='"+id+"'";dbbeanjdbc=newdbbean();result=jdbc.executeUpdate(sql);returnresult;}publicstaticintaddbook(Stringid,Stringname,Stringauthor,Stringpress,Stringdate,intprice,intaccount){intresult=0;Stringsql="insertintobook.bookshop(id,name,author,press,date,price,account)values('"+id+"','"+name+"','"+author+"','"+press+"','"+date+"',"+price+","+account+")";dbbeanjdbc=newdbbean();result=jdbc.executeUpdate(sql);returnresult;}}}Dbbean.java:packagebean;importjava.lang.*;importjava.sql.*;publicclassdbbean{privateStringdriverStr="com.mysql.jdbc.Driver";privateStringconnStr="jdbc:mysql://localhost:3306/book?characterEncoding=utf-8";privateStringname="root";privateStringpassword="xyh201268";privateConnectionconn=null;privateStatementstmt=null;publicdbbean(){try{Class.forName(driverStr);conn=DriverManager.getConnection(connStr,name,password);stmt=conn.createStatement();}catch(Exceptionex){System.out.println("connecttodatabaseisworry!");}}publicintexecuteUpdate(Strings){intresult=0;try{result=stmt.executeUpdate(s);}catch(Exceptionex){System.out.println("updatewrong!");}returnresult;}publicResultSetexecuteQuery(Strings){ResultSetrs=null;try{rs=stmt.executeQuery(s);}catch(Exceptionex){System.out.println("searchwrong!");}returnrs;}publicvoidclose(){try{stmt.close();conn.close();}catch(Exceptionex){System.out.println("cannotclosethedatabase!");}}}Servlet.java:packageservlets;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjava.io.IOException;importjava.util.ArrayList;importjava.lang.*;/***CreatedbyAdministratoron14-5-31.*/publicclassServletextendsHttpServlet{protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{doPost(request,response);}protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding("utf-8");Stringaction=request.getServletPath();if(action.equals("/servlets/depend.do")){Stringvalue=request.getParameter("password");if(value.equals("123")){ArrayList<bean.bookinfo>list=bean.bookinfo.getbooklist();request.setAttribute("list",list);request.getRequestDispatcher("/manager.jsp").forward(request,response);}else{ArrayList<bean.bookinfo>list=bean.bookinfo.getbooklist();request.setAttribute("list",list);request.getRequestDispatcher("/reader.jsp").forward(request,response);}}elseif(action.equals("/servlets/list_m.do")){ArrayList<bean.bookinfo>list=bean.bookinfo.getbooklist();request.setAttribute("list",list);request.getRequestDispatcher("/manager.jsp").forward(request,response);}elseif(action.equals("/servlets/list_r.do")){ArrayList<bean.bookinfo>list=bean.bookinfo.getbooklist();request.setAttribute("list",list);request.getRequestDispatcher("/reader.jsp").forward(request,response);}elseif(action.equals("/servlets/edit.do")){Stringid=request.getParameter("id");bean.bookinfobi=bean.bookinfo.getbookbyid(id);request.setAttribute("bi",bi);request.getRequestDispatcher("/edit.jsp").forward(request,response);}elseif(action.equals("/servlets/update.do")){Stringid=request.getParameter("id");Stringname=request.getParameter("name");Stringauthor=request.getParameter("author");Stringpress=request.getParameter("press");Stringdate=request.getParameter("date");Strings_price=request.getParameter("price");Strings_account=request.getParameter("account");intprice=Integer.parseInt(s_price);intaccount=Integer.parseInt(s_account);intr=bean.bookinfo.updatebook(id,name,author,press,date,price,account);if(r==1){request.getRequestDispatcher("/success_m.jsp").forward(request,response);}else{request.getRequestDispatcher("/failure_m.jsp").forward(request,response);}}elseif(action.equals("/servlets/delete.do")){Stringid=request.getParameter("id");intr=bean.bookinfo.deletebook(id);if(r==1){request.getRequestDispatcher("/success_m.jsp").forward(request,response);}else{request.getRequestDispatcher("/failure_m.jsp").forward(request,response);}}elseif(action.equals("/servlets/add.do")){Stringid=request.getParameter("id");Stringname=request.getParameter("name");Stringauthor=request.getParameter("author");Stringpress=request.getParameter("press");Stringdate=request.getParameter("date");Strings_price=request.getParameter("price");Strings_account=request.getParameter("account");intprice=Integer.parseInt(s_price);intaccount=Integer.parseInt(s_account);intr=bean.bookinfo.addbook(id,name,author,press,date,price,account);if(r==1){request.getRequestDispatcher("/success_m.jsp").forward(request,response);}else{request.getRequestDispatcher("/failure_m.jsp").forward(request,response);}}elseif(action.equals("/servlets/buy.do")){Stringbuy=request.getParameter("buy");bean.bookinfobi=bean.bookinfo.getbookbyid(buy);request.setAttribute("bi",bi);request.getRequestDispatcher("/buy.jsp").forward(request,response);}elseif(action.equals("/servlets/search_r.do")){Stringid=request.getParameter("id");Stringname=request.getParameter("name");Stringauthor=request.getParameter("author");Stringuser=request.getParameter("user");ArrayList<bean.bookinfo>list=bean.bookinfo.getbookbyway(id,name,author);request.setAttribute("list",list);if(user.equals("reader")){request.getRequestDispatcher("/sear_result_r.jsp").forward(request,response);}if(user.equals("manager")){request.getRequestDispatcher("/sear_result_m.jsp").forward(request,response);}}elseif(action.equals("/servlets/check_buy.do")){Stringid=request.getParameter("id");Strings_num_buy=request.getParameter("num_buy");intnum_buy=Integer.parseInt(s_num_buy);bean.bookinfobi=bean.bookinfo.getbookbyid(id);if(bi.getAccount()>=num_buy){request.setAttribute("bi",bi);request.setAttribute("s_num_buy",s_num_buy);request.getRequestDispatcher("/success_buy.jsp").forward(request,response);}else{request.getRequestDispatcher("/failure_r.jsp").forward(request,response);}}elseif(action.equals("/servlets/print_order.do")){Stringid=request.getParameter("id");Strings_num_buy=request.getParameter("s_num_buy");bean.bookinfobi=bean.bookinfo.getbookbyid(id);intnum_buy=Integer.parseInt(s_num_buy);bean.bookinfo.updatebook(id,bi.getName(),bi.getAuthor(),bi.getPress(),bi.getDate(),bi.getPrice(),(bi.getAccount()-num_buy));request.getRequestDispatcher("/print_order.jsp").forward(request,response);}}}Add_book.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"%><html><head><linkrel="stylesheet"href="/bookshop/css/table.css"type="text/css"><title></title></head><scriptlanguage="JavaScript"src="/bookshop/js/common.js"></script><body><center><formname="form1"onsubmit="returncheck()"action="/bookshop/servlets/add.do"method="post"><tableclass="default"align="center"border="1"> <center><h2>图书信息</h2></center><tr><thclass="item">编号</th><td><inputtype="text"name="id">*(不能为空)</td></tr><tr><thclass="item">书名</th><td><inputtype="text"name="name">*(不能为空)</td></tr><tr><thclass="item">作者</th><td><inputtype="text"name="author">*(不能为空)</td></tr><tr><thclass="item">出版社</th><td><inputtype="text"name="press">*(不能为空)</td></tr><tr><thclass="item">出版日期</th><td><inputtype="text"name="date">*(不能为空)</td></tr><tr><thclass="item">价格</th><td><inputtype="text"name="price">*(只能数字)</td></tr><tr><thclass="item">库存</th><td><inputtype="text"name="account">*(只能数字)</td></tr><tr><tdcolspan="2"align="center"><inputtype="submit"value="添加"><inputtype="reset"value="重置"></td></tr></table></form></center></body></html>buy.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"import="bean.bookinfo"%><html><head><linkrel="stylesheet"href="/bookshop/css/table.css"type="text/css"><title></title></head><body><%request.setCharacterEncoding("utf-8");bookinfobi=(bookinfo)request.getAttribute("bi");%><center><formaction="/bookshop/servlets/check_buy.do"method="post"><inputtype="hidden"name="id"value=${bi.id}><p><h2>订单信息</h2><tableclass="default"><tr><thclass="item">编号</th><td><inputtype="text"value="<%=bi.getId()%>"name="name"></td></tr><tr><thclass="item">书名</th><td><inputtype="text"value="<%=bi.getName()%>"name="name"></td></tr><tr><thclass="item">作者</th><td><inputtype="text"value="<%=bi.getAuthor()%>"name="author"></td></tr><tr><thclass="item">出版社</th><td><inputtype="text"value="<%=bi.getPress()%>"name="press"></td></tr><tr><thclass="item">出版日期</th><td><inputtype="text"value="<%=bi.getDate()%>"name="date"></td></tr><tr><thclass="item">价格</th><td><inputtype="text"value="<%=bi.getPrice()%>"name="price"></td></tr><tr><thclass="item">库存</th><td><inputtype="text"value="<%=bi.getAccount()%>"name="account"></td></tr><tr><thclass="item">购买数量</th><td><inputtype="text"name="num_buy"></td></tr><tr><tdcolspan="2"align="center"><inputtype="submit"value="提交"><inputtype="reset"value="重置"></td></tr></table></form></center></body></html>edit.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"import="bean.bookinfo"%><html><head><linkrel="stylesheet"href="/bookshop/css/table.css"type="text/css"><title></title></head><body><%request.setCharacterEncoding("utf-8");bookinfobi=(bookinfo)request.getAttribute("bi");%><center><formaction="/bookshop/servlets/update.do"method="post"><inputtype="hidden"name="id"value=${bi.id}><h2><caption>修改信息</caption></h2><tableclass="default"><tr><thclass="item">编号</th><td><inputtype="text"value="<%=bi.getId()%>"name="id"></td></tr><tr><thclass="item">书名</th><td><inputtype="text"value=<%=bi.getName()%>name="name"></td></tr><tr><thclass="item">作者</th><td><inputtype="text"value=<%=bi.getAuthor()%>name="author"></td></tr><tr><thclass="item">出版社</th><td><inputtype="text"value="<%=bi.getPress()%>"name="press"></td></tr><tr><thclass="item">出版日期</th><td><inputtype="text"value="<%=bi.getDate()%>"name="date"></td></tr><tr><thclass="item">价格</th><td><inputtype="text"value="<%=bi.getPrice()%>"name="price"></td></tr><tr><thclass="item">库存</th><td><inputtype="text"value="<%=bi.getAccount()%>"name="account"></td></tr><tr><tdcolspan="2"align="center"><inputtype="submit"value="提交"><inputtype="reset"value="重置"></td></tr></table></form></center></body></html>failure_m.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"%><html><head><title></title></head><body><center><h2>操作失败</h2><ahref="javascript:history.back()">点击返回</a></center></body></html>failure_r.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"%><html><head><title></title></head><body><center><h2>购买信息错误</h2><ahref="javascript:history.back()">点击返回</a></center></body></html>index.html:<!DOCTYPEhtml><html><head><metacharset="UTF-8"><linkrel="stylesheet"href="/bookshop/css/xyh.css"type="text/css"><title></title></head><body><divid="formwrapper"><h3>图书商店用户登录</h3><formmethod="post"name="apLogin"id="apLogin"action="/bookshop/servlets/depend.do"><fieldset><legend>顾客/管理员登录</legend><div><labelfor="UName">用户名</label><inputtype="text"name="UName"class="input"id="UName"size="18"maxlength="30"/>*(顾客不用输入)<br/></div><div><labelfor="PWord">密码</label><inputtype="password"name="password"class="input"id="PWord"size="18"maxlength="30"/>*(顾客不用输入)<br/></div><divclass="cookiechk"><labelfor="CookieYN"style="color:#1E7ACE;cursor:pointer;">记住我</label><inputtype="checkbox"name="CookieYN"id="CookieYN"value="1"/><ahref="#"title="选择是否记录您的信息"></a><inputname="login791"type="submit"class="buttom"value="登录"/></div><divclass="forgotpass"><ahref="#">您忘记密码?</a></div></fieldset></form></div><hralign="center"noshadecolor="#FF0000"><p><center><h3>友请连接</h3><ahref="">sina</a><ahref="/">sohu</a><br><p>Copyright@2014-2015NETWORK.席燚海邓匀翔袁野</p></center></body></html>manager.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"import="java.util.ArrayList,bean.bookinfo"%><html><head><linkrel="stylesheet"href="/bookshop/css/table.css"type="text/css"><title></title></head><body><%Stringuser="manager";%><center><h2><ahref="/bookshop/add_book.jsp">添加图书</a></h2><tableclass="default"align="center"border="1"> <tr><tdcolspan="9"align="right"><ahref="/bookshop/search_r.jsp?user=<%=user%>">点击查询</a></td></tr><tr><thclass="item">编号</th><thclass="item">书名</th><thclass="item">作者</th><thclass="item">出版社</th><thclass="item">出版日期</th><thclass="item">价格</th><thclass="item">库存</th><thclass="item"colspan="2">管理</th></tr><%request.setCharacterEncoding("utf-8");ArrayList<bookinfo>list=(ArrayList<bookinfo>)request.getAttribute("list");for(bookinfobi:list){Stringid=bi.getId();%><tr><td><%=bi.getId()%></td><td><%=bi.getName()%></td><td><%=bi.getAuthor()%></td><td><%=bi.getPress()%></td><td><%=bi.getDate()%></td><td><%=bi.getPrice()%></td><td><%=bi.getAccount()%></td><td><ahref="/bookshop/servlets/edit.do?id=<%=id%>">修改</a></td><td><ahref="/bookshop/servlets/delete.do?id=<%=id%>">删除</a></td></tr><%}%></table><p></p><aalign="right"href="/bookshop/index.html">返回主页</a></center></body></html>print_order.jsp:<%--CreatedbyIntelliJIDEA.User:AdministratorDate:14-12-28Time:下午8:49TochangethistemplateuseFile|Settings|FileTemplates.--%><%@pagecontentType="text/html;charset=UTF-8"language="java"%><html><head><title></title></head><body><center><h2>正在打印订单，请稍候...</h2><p><ahref="/bookshop/servlets/list_r.do">返回主页</a></center></body></html>reader.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"import="java.util.ArrayList,bean.bookinfo"%><html><head><linkrel="stylesheet"href="/bookshop/css/table.css"type="text/css"><title></title></head><body><%Stringuser="reader";%><center><formaction="/bookshop/servlets/buy.do"method="post"><tableclass="default"align="center"border="1"><trclass="title"><h2>现有图书信息</h2></tr><p></p><tr><tdcolspan="8"align="right"><ahref="/bookshop/search_r.jsp?user=<%=user%>">点击查询</a></td></tr><tr><thclass="item">编号</th><thclass="item">书名</th><thclass="item">作者</th><thclass="item">出版社</th><thclass="item">出版日期</th><thclass="item">价格</th><thclass="item">库存</th><thclass="item">购买</th></tr><%request.setCharacterEncoding("utf-8");ArrayList<bookinfo>list=(ArrayList<bookinfo>)request.getAttribute("list");for(bookinfobi:list){Stringid=bi.getId();%><tr><td><%=bi.getId()%></td><td><%=bi.getName()%></td><td><%=bi.getAuthor()%></td><td><%=bi.getPress()%></td><td><%=bi.getDate()%></td><td><%=bi.getPrice()%></td><td><%=bi.getAccount()%></td><td><inputtype="radio"name="buy"value="<%=bi.getId()%>"></td><inputtype="hidden"name="id"value="<%=bi.getId()%>"></tr><%}%></table><p><inputtype="submit"value="提交"></form><aalign="right"href="/bookshop/index.html">返回主页</a></center></body></html>sear_result_m.jsp:<%@pagecontentType="text/html;charset=UTF-8"language="java"import="java.util.ArrayList,bean.bookinfo"%><html><head><linkrel="stylesheet"href="/bookshop/css/table.css"type="text/css"><title></title></head><body><center><caption><h2>ResultsOfSearch</h2></caption><p><tableclass="default"align="center"border="1"><tr><thclass="item">Num</th><thclass="item">Name</th><thclass="item">Author</th><thclass="item">Press</th><thclass="item">Press_Date</th><thclass="item">Price</th><thclass="item">Account</th><thclass="item"colspan="2">Manage</th></tr><%request.setCharacterEncoding("utf-8");ArrayList<bookinfo>list=(ArrayList<bookinfo>)request.getAttribute("list");for(bookinfob