javaWeb书店管理系统

一、实验目的

1) 理解并掌握编码与测试相关理论与方法； 2) 进一步熟悉利用编程语言实现系统；

3) 要求学生理解测试在软件开发中的重要地位； 4) 学生了解测试用例与测试报告的相关书写规范。

二、实验内容与要求

1) 根据系统的特点，选取javaWeb MVC开发模型实现该系统； 2) 系统的编码结构：

边界类：1个html（项目首页），13个jsp（中间跳转的页面），一

个css（界面美化功能），一个javascript（控制输入合法性）。

控制类：一个servlet类（连接边界类和实体类）

实体类：一个datebase类（连接数据库），一个bookinfo类（书

本的增删检查操作）

服务器采用tomcat。 如下图展示：

3) 对系统进行测试分析，并对系统功能实施测试，编写测试用例，系

统已经实现可以让手机电脑一起访问并做操作；

4) 撰写实验报告，同时需要了解测试报告相应的规范与写法。

1. 下面是一些界面的展示（没有全部展示）：

登录页面

顾客首页

购买页面

订单页面

查询页面

查询结果

管理员页面

添加图书页面

添加图书信息不完整页面

三、完整开发代码(按照上面截图部署即可实现)

: body{

background: #ffffff; margin: 15; }

body,table,th,td,input,select,textarea{

font-family: Tahoma,Verdana,Arial,Helvetica,sans-serif; font-size: 12px; } {

border: 1px solid #3366CC; border-collapse: collapse; width: 80%; } td{

padding: 2 5 2 5; height: 26px; text-align: center;

border: 1px solid #ffffff;

background-color: #f0f0f0; } td{

font-weight: bold; text-align: center; background: #99CCFF; color: red;

border: 1px solid #ffffff; white-space: nowrap; height: 26px; } {

font-weight: bold; color: #333333; text-align: center; vertical-align: top; padding: 10px; font-size: 14px; }

:

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:1px 10px;font-size:12px;

border:1px #1E7ACE solid;background:#D0F0FF;} #formwrapper {width:450px;margin:15px auto;

padding:20px;text-align:left;border:1px solid #A4CDF2;} fieldset {padding:10px;margin-top:5px;

border:1px solid #A4CDF2;background:#fff;} fieldset legend {color:#1E7ACE;font-weight:bold;

padding:3px 20px 3px 20px;border:1px solid #A4CDF2; background:#fff;}

fieldset label {float:left;width:120px; text-align:right;padding:4px;margin:1px;} fieldset div {clear:left;margin-bottom:2px;} .input { width:120px;}

.enter{ text-align:center;} .clear {clear:both;}

:

function isNum(num){ for(i=0;i<;i++) {

c=(i);

if(c>'9'||c<'0'){ return false; } }

return true; }

function check(){ if\"\")

{alert (\"no id!\");

return false;} if\"\")

{alert(\"no name!\");

return false;}

if\"\") {

alert(\"no author!\"); return false;

} if\"\") {

alert(\"no press!\"); return false; } if\"\"){

alert(\"no date!\") return false; }

if(!isNum){

alert(\"price is wrong!\") return false; }

if(!isNum){

alert(\"account is wring!\") return false; }

:

package bean;

import class bookinfo{ private String id; private String name; private String author; private String press; private String date; private int price; private int account;

public void setName(String name) { = name; }

public String getName() { return name; }

public void setAuthor(String author) { = author; }

public String getAuthor() { return author; }

public void setDate(String date) { = date; }

public String getDate() { return date; }

public void setPress(String press) { = press; }

public String getPress() { return press; }

public void setId(String id) { = id; }

public String getId() {

return id; }

public void setAccount(int acount) { = acount; }

public int getAccount() { return account; }

public void setPrice(int price) { = price; }

public int getPrice() { return price; }

public static ArrayList getbooklist(){

ArrayList list=new ArrayList(); String sql=\"select * from \"; dbbean jdbc=new dbbean(); ResultSet rs=(sql); try{

while()){

bookinfo bi=new bookinfo(); (\"id\")); (\"name\")); (\"author\")); (\"press\")); (\"date\")); (\"price\")); (\"account\")); (bi); } (); }

catch(SQLException e){ (); } ();

return list; } ; import .*;

public class dbbean{

private String driverStr=\"\"; private String connStr=\"jdbc:\"; private String name=\"root\";

private String password=\"xyh201268\"; private Connection conn=null; private Statement stmt=null; public dbbean(){ try{

(driverStr);

conn=(connStr,name,password); stmt=(); }

catch(Exception ex){

\"connect to database is worry!\"); } }

public int executeUpdate(String s){ int result=0; try{

result=(s); }

catch(Exception ex){

\"update wrong!\"); }

return result; }

public ResultSet executeQuery(String s){ ResultSet rs=null; try{

rs=(s); }

catch(Exception ex){ \"search wrong!\"); }

return rs; }

public void close(){ try{();(); }

catch(Exception ex){

\"can not close the database!\"); } } }

:

package servlets;

import .*; /**

* Created by Administrator on 14-5-31. */

public class Servlet extends HttpServlet { protected

void

doGet(HttpServletRequest response)

throws

request,

HttpServletResponse IOException {

ServletException,

doPost(request, response); }

protected

void

doPost(HttpServletRequest response)

throws

request,

HttpServletResponse IOException { (\"utf-8\");

ServletException,

String action=(); if(\"/servlets/\")){

String value=(\"password\"); if(\"123\")){

ArrayList<> list= (\"list\list);

(\"/\").forward(request,response); } else

{ list);

(\"/\").forward(request,response); } } else if (\"/servlets/\")){ ArrayList<> list= (\"list\ (\"/\").forward(request,response); } else if (\"/servlets/\")){ ArrayList<> list= (\"list\ (\"/\").forward(request,response); } else if(\"/servlets/\")){ String id =(\"id\"); bi= (\"bi\ (\"/\").forward(request,response); ArrayList<> list=

(\"list\ }

else if(\"/servlets/\")){ String id=(\"id\"); String name=(\"name\"); String author=(\"author\"); String press=(\"press\"); String date=(\"date\"); String s_price=(\"price\"); String s_account=(\"account\"); int price=(s_price); int account=(s_account); int r= if (r==1){

(\"/\").forward(request,response); }

else{(\"/\").forward(request,response); } }

else if (\"/servlets/\")){ String id=(\"id\");

int r= if (r==1){

(\"/\").forward(request,response); }

else{(\"/\").forward(request,response); } }

else if (\"/servlets/\")){ String id=(\"id\"); String name=(\"name\"); String author=(\"author\"); String press=(\"press\"); String date=(\"date\"); String s_price=(\"price\"); String s_account=(\"account\"); int price=(s_price); int account=(s_account);

int r= name, author, press, date,price,account); if (r==1){

(\"/\").forward(request,response); } else{

(\"/\").forward(request,response); } }

else if (\"/servlets/\")){

String buy=(\"buy\");

bi= (\"bi\ (\"/\").forward(request,response); }

else if (\"/servlets/\")){ String id=(\"id\"); String name=(\"name\"); String author=(\"author\"); String user=(\"user\");

ArrayList<> list= (\"list\ if (\"reader\")){

(\"/\").forward(request,response); }

if (\"manager\")) {

(\"/\").forward(request,response); } }

else if (\"/servlets/\")){ String id=(\"id\");

String s_num_buy=(\"num_buy\"); int num_buy=(s_num_buy);

bi= if()>=num_buy){ (\"bi\

(\"s_num_buy\

(\"/\").forward(request,response); }else{

(\"/\").forward(request,response); } }

else if (\"/servlets/\")){ String id=(\"id\");

String s_num_buy=(\"s_num_buy\");

bi= int num_buy=(s_num_buy); (\"/\").forward(request,response); }

} } :

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" import=\"\" %>

<% (\"utf-8\");

bookinfo bi=(bookinfo)(\"bi\");

%>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" import=\"\" %>

<% (\"utf-8\");

bookinfo bi=(bookinfo)(\"bi\"); %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\"

import=\"\" %>

<% String user=\"manager\"; %>

()%><%=

()%><%=

: <%--

Created by IntelliJ IDEA. User: Administrator Date: 14-12-28 Time: 下午8:49

To change this template use File | Settings | File Templates. --%>

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" import=\"\" %>

<% String user=\"reader\";%>

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" import=\"\" %>

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" import=\"\" %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>

<% (\"utf-8\");

String user=(String)(\"user\"); %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" import=\"\" %>

<% (\"utf-8\");

bookinfo bi=(bookinfo)(\"bi\");

String s_num_buy=(String)(\"s_num_buy\"); %>

:

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>