摘要
本论文的研究课题是《基于JSP技术的订单管理系统》的实现。本系统通过对数据库的信息检索及维护功能，为用户和管理员提供网上选购图书和订单的生成、管理服务。整个研究过程经过需求分析、系统设计、系统开发和测试四个阶段的工作。 本系统是基于Internet，采用浏览器／服务器的三层次结构，系统的服务器端（Server）由Servlets和JavaBean实现，负责客户端浏览器（Browser）与Web服务器（Web Server）间的通信，并以JDBC数据连接为基础实现了Web服务器（Web Server）与数据库（Microsoft Access XP）之间的数据交换。系统使用jdk1.4.0作为Java环境，Tomcat4.0服务器作为JSP的支持平台。
系统由四个功能模块组成：
⏹注册登陆模块：用户、管理员注册、登陆，并修改注册信息 ⏹图书查询模块：用户可通过设置不同的搜索围和关键字来查询图书，也可以通过分类查看来查看一类图书
⏹图书选购模块：用户对购物车中的图书进行添加、删除、修改数量，并对生成订单，在订单被审核前，可修改订单容
⏹系统管理模块：管理员查看订单和其详细信息的，并通过审核订单来修改订单状态，审核后的订单用户不能修改；管理员也在这个模块中添加修改图书、分类、等信息。
系统使用了JSP+JavaBean的开发模式，将对数据库、字符串等常用操作封装在JavaBean中，设计上使用了MVC模式（即模型、视图、控制）的思想，实现逻辑与显示的分离，JSP只负责页面的显示，而业务逻辑等由bean来实现，隐藏了复杂的数据库等程序逻辑操作，减少在JSP中脚本代码的使用，使得JSP页更加易于维护，并提高了系统的安全性。
本系统重点阐述了订单管理系统中“订”和“管”的问题，详细设计了系统中的图书选购模块和系统管理模块，解决了用户选购图书和管理员对订单管理的业务问题，达到了系统设计的预期目标。
关键字：JDBC JavaBean MVC
Abstract
The research subject of the present paper is the implementation of the Order Management System based on JSP technology. The system provides the users and administrators with the service of book purchasing, order creation and management on the Internet by querying and maintaining of the database. The whole research process is divided into four stages, viz. analysis of demands, and the design, development and testing of the system.
This system is based on the Internet, adopting the three-hierarchy browser/server. The server is implemented by Servlet and JavaBean, being responsible for the communication between Browser and Web Server. The server also implements the data exchange between the Web Server and Access database through a JDBC bridge. The system uses jdk1.4.0 as its Java environment and Tomcat4.0 as its JSP platform.
System includes 4 function modules:
⏹Register and login module: users and administrators register, login and modify their register information.
⏹Book search module: users can search books by setting different ranges and keywords; they can also look over a series of books by the categorical search.
⏹Book purchasing module: user can add, delete, modify the quality of books in the shopping vehicle and submit the orders. Before the orders are checked, the content of the orders can be modified.
⏹System management module: administrators examine orders and their details, and modify the status of the orders by the function of order checking, but the users cannot modify the order after the examination; in this module administrators can also add or modify the information of books, such as their categories and publishers.
