基于JSP的在线书店销售系统的设计与实现外文文献及翻译

1. SimpleWe wanted to build a system that could be programmed easily without a lot of eso-teric training and which leveraged today’s standard practice. So even though we found that C++ was unsuitable, we designed Java as closely to C++ as possible in order to make the system more comprehensible. Java omits many rarely used, poorly understood, confusing features of C++ that, in our experience, bring more grief than benefit.The syntax for Java is, indeed, a cleaned-up version of the syntax for C++. There is no need for header files, pointer arithmetic (or even a pointer syntax), structures, unions, operator overloading, virtual base classes, and so on. (See the C++ notes interspersed throughout the text for more on the differences between Java and C++.) The designers did not, however, attempt to fix all of the clumsy features of C++. For example, the syn-tax of the switch statement is unchanged in Java. If you know C++, you will find the tran- sition to the Java syntax easy. If you are used to a visual programming environment (such as Visual Basic), you will not find Java simple. There is much strange syntax (though it does not take long to get the hang of it). More important, you must do a lot more programming in Java. The beauty of Visual Basic is that its visual design environment almost automatically pro-vides a lot of the infrastructure for an application. The equivalent functionality must be programmed manually, usually with a fair bit of code, in Java. There are, however, third-party development environ ments that provide “drag-and-drop”-style program development.2.Object OrientedSimply stated, object-oriented design is a technique for programming that focuses on the data (= objects) and on the interfaces to that object. To make an analogy with carpentry, an “object-oriented” carpenter would be mostly concerned with the chair he was building, and secondarily with the tools used to make it; a “non-object-oriented” carpenter would think primarily of his tools. The object-oriented facilities of Java are essentially those of C++.Object orientation has proven its worth in the last 30 years, and it is inconceivable that a modern programming language would not use it. Indeed, the object-oriented features of Java are comparable to those of C++. The major difference between Java and C++ lies in multiple inheritance, which Java has replaced with the simpler concept of interfaces, and in the Java metaclass model.work-SavvyJava has an extensive library of routines for coping with TCP/IP protocols like HTTP and FTP. Java applications can open and access objects across the Net via URLs with the same ease as when accessing a local file system.4.RobustJava is intended for writing programs that must be reliable in a variety of ways. Java puts a lot of emphasis on early checking for possible problems, later dynamic (runtime) checking, and eliminating situations that are error-prone. . . . The single biggest difference between Java and C/C++ is that Java has a pointer model that elim- inates the possibility of overwriting memory and corrupting data.5.SecureJava is intended to be used in networked/distributed environments. Toward that end, a lot of emphasis has been placed on security. Java enables the construction of virus-free, tamper-free systems.From the beginning, Java was designed to make certain kinds of attacks impossible,among them:•Overrunning the runtime stack—a common attack of worms and viruses•Corrupting memory outside its own process space•Reading or writing files without permission6.Architecture NeutralThe compiler generates an architecture-neutral object file format—the compiled code is executable on many processors, given the presence of the Java runtime sys-tem. The Java compiler does this by generating bytecode instructions which have nothing to do with a particular computer architecture. Rather, they are designed to be both easy to interpret on any machine and easily translated into native machinecode on the fly.7.PortableUnlike C and C++, there are no “implementation-dependent” aspects of the specifi- cation. The sizes of the primitive data types are specified, as is the behavior of arith-metic on them.For example, an int in Java is always a 32-bit integer. In C/C++, int can mean a 16-bit integer, a 32-bit integer, or any other size that the compiler vendor likes. The only restriction is that the int type must have at least as many bytes as a short int and cannot have more bytes than a long int. Having a fixed size for number types eliminates a major porting headache. Binary data is stored and transmitted in a fixed format, eliminating confusion about byte ordering. Strings are saved in a standard Unicode format..8.InterpretedThe Java interpreter can execute Java bytecodes directly on any machine to which the interpreter has been ported. Since linking is a more incremental and lightweight process, the development process can be much more rapid and exploratory.9.High PerformanceWhile the performance of interpreted bytecodes is usually more than adequate, there are situations where higher performance is required. The bytecodes can be translated on the fly (at runtime) into machine code for the particular CPU the application is running on.10.Multithreaded[The] benefits of multithreading are better interactive responsiveness and real-time behavior.11.DynamicIn a number of ways, Java is a more dynamic language than C or C++. It was designed toadapt to an evolving environment. Libraries can freely add new meth- ods and instance variables without any effect on their clients. In Java, finding out runtime type information is straightforward..This is an important feature in those situations in which code needs to be added to a running program. A prime example is code that is downloaded from the Internet to run in a browser. In Java 1.0, finding out runtime type information was anything but straightforward, but current versions of Java give the programmer full insight into both the structure and behavior of its objects. This is extremely useful for systems that need to analyze objects at runtime, such as Java GUI builders, smart debuggers, pluggable components, and object databases.Common Misconceptions about Java1.Java is an extension of HTML.Java is a programming language; HTML is a way to describe the structure of a web page. They have nothing in common except that there are HTML extensions for placing Java applets on a web page.2.I use XML, so I don’t need Java.Java is a programming language; XML is a way to describe data. You can process XML data with any programming language, but the Java API contains excellent support for XML processing. In addition, many important third-party XML tools are implemented in Java. See V olume II for more information.3.Java is an easy programming language to learn.No programming language as powerful as Java is easy. You always have to distinguish between how easy it is to write toy programs and how hard it is to do serious work. Also, consider that only four chapters in this book discuss the Java language.4.Java will become a universal programming language for all platforms.This is possible, in theory, and it is certainly the case that every vendor but Microsoft seems to want this to happen. However, many applications, already working perfectly well on desktops, would not work well on other devices or inside a browser. Also, these applications have been written to take advantage of the speed of the processor and the native user interface library and have been ported to all the important platforms any-way. Among these kinds of applications are word processors, photo editors, and web browsers. They are typically written in C or C++, and we see no benefit to the end user in rewriting them in Java.5.Java is just another programming language.Java is a nice programming language; most programmers prefer it over C, C++, or C#. But there have been hundreds of nice programming languages that never gained wide- spread popularity, whereas languages with obvious flaws, such as C++ and Visual Basic, have been wildly successful.Why? The success of a programming language is determined far more by the utility of the support system surrounding it than by the elegance of its syntax. Are there useful, convenient, and standard libraries for the features that you need to implement? Are there tool vendors that buildgreat programming and debugging environments? Does the language and the toolset integrate with the rest of the computing infrastructure? Java is successful because its class libraries let you easily do things that were hard before, such as networking and multithreading. The fact that Java reduces pointer errors is a bonus and so programmers seem to be more productive with Java, but these factors are not the source of its success.6.Now that C# is available, Java is obsolete.C# took many good ideas from Java, such as a clean programming language, a virtual machine, and garbage collection. But for whatever reasons, C# also left some good stuff behind, in particular security and platform independence. If you are tied to Windows, C# makes a lot of sense. But judging by the job ads, Java is still the language of choice for a majority of developers.7.Java is proprietary, and it should therefore be avoided.Sun Microsystems licenses Java to distributors and end users. Although Sun has ulti- mate contr ol over Java through the “Java Community Process,” they have involved many other companies in the development of language revisions and the design of new libraries. Source code for the virtual machine and the libraries has always been freely available, but only for inspection, not for modification and redistribution. Up to this point, Java has been “closed source, but playing nice.”8.Java is interpreted, so it is too slow for serious applications.In the early days of Java, the language was interpreted. N owadays, except on “micro”platforms such as cell phones, the Java virtual machine uses a just-in-time compiler. The“hot spots” of your code will run just as fast in Java as they would in C++, and in some cases, they will run faster.Java does have some additional overhead over C++. Virtual machine startup time is slow, and Java GUIs are slower than their native counterparts because they are painted in a platform-independent manner.People have complained for years that Java applications are too slow. How ever, today’s computers are much faster than they were when these complaints started.A slow Java program will still run quite a bit better than those blazingly fast C++ programs did afew years ago. At this point, these complaints sound like sour grapes, and some detrac- tors have instead started to complain that Java user interfaces are ugly rather than slow.9.All Java programs run inside a web page.All Java applets run inside a web browser. That is the definition of an applet—a Java program running inside a browser. But most Java programs are stand-alone applications that run outside of a web browser. In fact, many Java programs run on web servers and produce the code for web pages.10.Java programs are a major security risk.11.JavaScript is a simpler version of Java.JavaScript, a scripting language that can be used inside web pages, was invented by Netscape and originally called LiveScript. JavaScript has a syntax that is reminiscent of Java, but otherwise there are no relationships (except for the name, of course). A subset of JavaScript is standardized as ECMA-262. JavaScript is more tightly integrated with browsers than Java applets are. In particular, a JavaScript program can modify the document that is being displayed, whereas an applet can only control the appearance of a limited area.12.With Java, I can replace my computer with a $500 “Internet appliance.”When Java was first released, some people bet big that this was going to happen. Ever since the first edition of this book, we have believed it is absurd to think that home users are going to give up a powerful and convenient desktop for a limited machine with no local storage. We found the Java-powered network computer a plausible option for a “zero administration initiative” to cut the costs of computer ownership in a business,but even that has not happened in a big way.On the other hand, Java has become widely distributed on cell phones. We must confess that we haven’t yet seen a must-have Java application running on cell phones, but the usual fare of games and screen savers seems to be selling well in many markets.1.简单性人们希望构建一个无需深奥的专业训练就可以进行编程的系统，并且要符合当今的标准惯例。

毕业设计说明书基于JSP的在线书店销售系统的设计与实现专业学生姓名班级学号指导教师完成日期基于JSP的在线书店销售系统的设计与实现摘要：21世纪，随着计算机科学技术的发展，贸易的全球化和网络的全球化两大特征走到了一起，形成了如今风靡全球的电子商务。

电子商务在Internet中的应用越来越广泛，为广大网络用户提供了更加周到和人性化的服务已逐渐成为当今Web应用的潮流，而购物网站正是这种活动的具体表现形式。

网上购物在我国的发展虽不如欧美，但当今发展很快，众多网上购物网站不断涌现，较有代表的如eBay易趣、taobao淘宝、1pai雅虎新浪一拍等。

随着我国互联网的更加普及和电子商务的日趋成熟，会有越来越大的消费群体，市场潜力会得到充分发挥。

与传统C/S相比，B/S更具优势（如客户端无须安装软件等）。

合理规划和设计B/S模式的电子商务网站，直接关系到网络销售系统的运行效率，以及消费者的兴趣。

对网络销售系统不合时宜的设计，不仅无助于问题的解决，而且会耽误商机，使自己处于被动地位。

临渊羡鱼，不如退而结网。

网络购物系统的完善和便捷将是现代社会必然的需求。

任务书研究了基于JSP技术和SQL Server数据库开发网络图书销售系统的全过程。

关键词：电子商务；网络图书销售系统；JSPDesign and implementation of online bookstore salessystem based on JSPAbstract：In the 21st century, with the development of science and technology of the computer, trade globalization and two major characteristics of globalization of the network got togather, have formed the nowadays-fashionable e-commerce in the world. The application in Internet of e-commerce is more and more extensive, have already nowadays become the trend that Web uses gradually users more thoughtful and more humanized service after offering to the masses of network, and the shopping website is exactly this kind of concrete form of expression of moving about. Although the development of online shopping in our country is not so good as America and Europe, nowadays develop quickly, emerge constantly, have relatively on behalf of if eBay E, taobao, 1pai,etc. With Internet popularization and e-commerce of our country ripe becoming, there are bigger and bigger consumption colonies; the market potential will be given full play to. Compared with traditional C/S, B/S has even more advantages (such as needn't install software in the client, etc.). Rational planning and designing the e-commerce website of B/S mode, concern the operational efficiency of the marketing system of the network, and consumers' interest directly. The unseasonable design to the marketing system of the network is not only helpless to the settlement of the problem, but alse delay the business opportunity, will make oneself in the passive position. It's better to go back and make a net than to stand by the pond and long for fish. The systematic perfection and convenient of shopping at network will be modern society's inevitable demands. This text has studied the whole course of books marketing system of network on the basis of JSP technology and SQL Server database. Key words：E-commerce; books marketing system of network; ASP目录1概述 (1)1.1课题背景 (1)1.2课题研究的意义和现状 (1)1.3课题的系统概述 (2)2在线书店销售系统的相关技术介绍 (3)2.1B ROWSER/SERVER结构 (3)2.1.1三层结构 (4)2.2JSP的运作模式 (4)2.3SQL S ERVER 2005简介 (5)3 基于JSP的在线书店销售系统的设计 (5)3.1需求分析 (5)3.1.1系统需要解决的主要问题 (5)3.1.2系统开发环境 (6)3.2系统具备的功能 (6)3.3用例模型 (6)3.3.1用户U SE CASE图 (6)3.3.2管理员U SE CASE图 (7)3.3.3书店销售系统E-R图 (7)3.4数据库的设计与实现 (8)3.4.1数据库的需求分析 (8)3.4.2数据库的逻辑设计 (8)3.5数据库的结构创建 (9)4基于JSP的在线书店销售系统的实现 (12)4.1后台系统和数据库的配置 (12)4.1.1后台服务器配置 (12)4.1.2后台数据库的配置 (12)4.1.3后台全局配置文件 (12)4.2前端网络页面的开发与设计 (13)4.2.1用户注册网页 (13)4.2.2用户登录页面 (17)4.2.3管理员操作页面 (18)4.2.4用户购物操作 (20)4.2.5管理员管理页面 (23)4.2.6个人资料修改页面 (24)5系统测试 (26)5.1软件测试的目的和原则 (26)5.2测试的方法 (26)5.2.1黑盒测试 (26)5.2.2白盒测试 (26)5.3测试实例(测试集)的研究与选择 (27)5.4系统的维护 (27)6结束语 (28)参考文献 (29)致谢 (31)基于JSP的在线书店销售系统的设计与实现1概述1.1课题背景新世纪的到来，Internet和计算机网络技术的蓬勃发展，网络化和全球化已成为不可抗拒的世界潮流。

外文翻译基于ASPNET的网上图书销售系统的设计与实现Active Server Pages (ASP) is a server-side scripting environment that enables the development of dynamic web ns。

With ASP。

developers can create and deploy web server ns that incorporate HTML pages。

script orders。

ActiveX modules。

and powerful web ns。

The ASP platform is highly flexible and allows for easy n and n of web ns.One of the key benefits of ASP is its ability to combine HTML pages and script orders to create dynamic web pages。

This feature enables developers to create highly interactive and responsive web ns that can adapt to changing user needs and preferences。

nally。

ASP supports the use of ActiveX modules。

which further enhances the nality and performance of web ns.Another advantage of ASP is its ease of development and n。

The platform provides a user-friendly interface that allows developers to quickly and easily create and modify web ns。

毕业设计说明书英文文献及中文翻译学生姓名：学号：学院：专业：指导教师：Struts——an open-source MVC implementationBy: Malcolm Davis.Source: Struts--an open-source MVC implementation[J].IBM Systems JournalThis article introduces Struts, a Model-View-Controller implementation that uses servlets and JavaServer Pages (JSP) technology. Struts can help you control change in your Web project and promote specialization. Even if you never implement a system with Struts,you may get some ideas for your future servlets and JSP page implementation.IntroductionKids in grade school put HTML pages on the Internet. However, there is a monumental difference between a grade school page and a professionally developed Web site. The page designer (or HTML developer) must understand colors, the customer, product flow, page layout, browser compatibility, image creation, JavaScript, and more. Putting a great looking site together takes a lot of work, and most Java developers are more interested in creating agreat looking object interface than a user interface. Java Server Pages (JSP) technology provides the glue between the page designer and the Java developer.If you have worked on a large-scale Web application, you understand the term change.Model-View-Controller (MVC) is a design pattern put together to help control change. MVC decouples interface from business logic and data. Struts is an MVC implementation that uses Servlets 2.2 and JSP 1.1 tags, from the J2EE specifications, as part of the implementation. Y ou may never implement a system with Struts, but looking at Struts may give you some ideas on your future Servlets and JSP implementations.Model-View-Controller (MVC)JSP tags solved only part of our problem. We still have issues with validation, flow control, and updating the state of the application. This is where MVC comes to the rescue.MVC helps resolve some of the issues with the single module approach by dividing theproblem into three categories:• ModelThe model contains the core of the application's functionality. The model encapsulates thestate of the application. Sometimes the only functionality it contains is state. It knows nothing about the view or controller.• View• The view provides the presentation of the model. It is the look of the application. The view can access the model getters, but it has no knowledge of the setters. In addition, it knows nothing about the controller. The view should be notified when changes to the model occur. ControllerThe controller reacts to the user input. It creates and sets the model.MVC Model 2The Web brought some unique challenges to software developers, most notably the stateless connection between the client and the server. This stateless behavior made it difficult for the model to notify the view of changes. On the Web, the browser has to re-query the server to discover modification to the state of the application.Another noticeable change is that the view uses different technology for implementation than the model or controller. Of course, we could use Java (or PERL, C/C++ or what ever) code to generate HTML. There are several disadvantages to that approach:• Java programmers should develop services, not HTML.• Changes to layout would require changes to code.• Customers of the service should be able to create pages to meet their specific needs.• The page designer isn't able to have direct involvement in page development.• HTML embedded into code is ugly.For the Web, the classical form of MVC needed to change.MVC Model 2 Struts, an MVC 2 implementation Struts is a set of cooperating classes, servlets, and JSP tags that make up a reusable MVC 2 design. This definition implies that Struts is a framework, rather than a library, but Struts also contains an extensive tag library and utility classes that work independently of the framework.• Client browserAn HTTP request from the client browser creates an event. The Web container will respond with an HTTP response.• ControllerThe Controller receives the request from the browser, and makes the decision where to send the request. With Struts, the Controller is a command design pattern implemented as a servlet. The struts-config.xml file configures the Controller.• Business logicThe business logic updates the state of the model and helps control the flow of the application.With Struts this is done with an Action class as a thin wrapper to the actual business logic.• Model stateThe model represents the state of the application. The business objects update the application state. ActionForm bean represents the Model state at a session or request level, and not at a persistent level. The JSP file reads information from the ActionForm bean using JSP tags.• ViewThe view is simply a JSP file. There is no flow logic, no business logic, and no model information -- just tags. Tags are one of the things that make Struts unique compared to other frameworks like V elocity.Struts detailsDisplayed in Figure 6 is a stripped-down UML diagram of the org.apache.struts.action package and shows the minimal relationships among ActionServlet (Controller), ActionForm (Form State), and Action (Model Wrapper).The ActionServlet classDo you remember the days of function mappings? Y ou would map some input event to a ointer to a function. If you where slick, you would place the configuration information into ale and load the file at run time. Function pointer arrays were the good old days of structured rogramming in C.Life is better now that we have Java technology, XML, J2EE, and all that. The Struts ontroller is a servlet that maps events (an event generally being an HTTP post) to classes. guess what -- the Controller uses a configuration file so you don_t have to hard-code the alues. Life changes, but stays the same.ActionServlet is the Command part of the MVC implementation and is the core of the ramework. ActionServlet (Command) creates and uses Action, an ActionForm, and ctionForward. As mentioned earlier, the struts-config.xml file configures the command. uring the creation of the Web project, Action and ActionForm are extended to solve the pecific problem space. The file struts-config.xml instructs ActionServlet on how to use the xtended classes. There are several advantages to this approach:• The entire logical flow of the application is in a hierarchical text file. This makes itasier to view and understand, especially with large applications.• The page designer does not have to wade through Java code to understand the flow of e application.• The Java developer does not need to recompile code when making flow changes. Command functionality can be added by extending ActionServlet.The ActionForm classActionForm maintains the session state for the Web application. ActionForm is anbstract class that is sub-classed for each input form model. When I say input form model, Im saying ActionForm represents a general concept of data that is set or updated by a HTML form. For instance, you may have a UserActionForm that is set by an HTML Form. The Struts framework will:• Check to see if a UserActionForm exists; if not, it will create an instance of the class.• Struts will set the state of the UserActionForm using corresponding fields from the HttpServletRequest. No more dreadful request.getParameter() calls. For instance, the Struts framework will take fname from request stream and call UserActionForm.setFname().• The Struts framework updates the state of the UserActionForm before passing it to the business wrapper UserAction.• Before passing it to the Action class, Struts will also conduct form state validation by calling the validation() method on UserActionForm. Note: This is not always wise to do. There might be ways of using UserActionForm in other pages or business objects, where the validation might be different. V alidation of the state might be better in the UserAction class.• The UserActionForm can be maintained at a session level.Notes:• The struts-config.xml file controls which HTML form request maps to which ActionForm. • Multiple requests can be mapped UserActionForm.• UserActionForm can be mapped over multiple pages for things such as wizards.The Action classThe Action class is a wrapper around the business logic. The purpose of Action class is to translate the HttpServletRequest to the business logic. To use Action, subclass and overwrite the process() method.The ActionServlet (Command) passes the parameterized classes to ActionForm using the perform() method. Again, no more dreadful request.getParameter() calls. By the time the event gets here, the input form data (or HTML form data) has already been translated out of the request stream and into an ActionForm class.Note: "Think thin" when extending the Action class. The Action class should control the flow and not the logic of the application. By placing the business logic in a separate package or EJB, we allow flexibility and reuse.Another way of thinking about Action class is as the Adapter design pattern. The purpose of the Action is to "Convert the interface of a class into another interface the clients expect. Adapter lets classes work together that couldn_t otherwise because of incompatibility interface" (from Design Patterns - Elements of Reusable OO Software by Gof). The client in this instance is the ActionServlet that knows nothing about our specific business class interface. Therefore, Struts provides a business interface it does understand, Action. By extending the Action, we make our business interface compatible with Struts business interface. (An interesting observation is that Action is a class and not an interface. Action started as an interface and changed into a class over time. Nothing's perfect.)The Error classesThe UML diagram (Figure 6) also included ActionError and ActionErrors. ActionError encapsulates an individual error message. ActionErrors is a container of ActionError classes that the View can access using tags. ActionErrors is Struts way of keeping up with a list of errors.UML diagram of the relationship of the Command (ActionServlet) to the Model (Action) The ActionMapping classAn incoming event is normally in the form of an HTTP request, which the servlet Container turns into an HttpServletRequest. The Controller looks at the incoming event and dispatches the request to an Action class. The struts-config.xml determines what Action class the Controller calls. The struts-config.xml configuration information is translated into a set of ActionMapping, which are put into container of ActionMappings. (If you have not noticed it, classes that end with s are containers) The ActionMapping contains the knowledge of how a specific event maps to specific Actions. The ActionServlet (Command) passes the ActionMapping to the Action class via the perform() method. This allows Action to access the information to control flow.ActionMappingsActionMappings is a collection of ActionMapping objects.Struts pros Use of JSP tag mechanism The tag feature promotes reusable code and abstracts Java code from the JSP file. This feature allows nice integration into JSP-based development tools that allow authoring with tags.• Tag libraryWhy re-invent the wheel, or a tag library? If you cannot find something you need in the library, contribute. In addition, Struts provides a starting point if you are learning JSP tag technology.• Open sourceY ou have all the advantages of open source, such as being able to see the code and having everyone else using the library reviewing the code. Many eyes make for great code review.• Sample MVC implementationStruts offers some insight if you want to create your own MVC implementation.• Manage the problem spaceDivide and conquer is a nice way of solving the problem and making the problem manageable.中北大学2014届毕业设计英文文献译文Struts 一个开源的MVC实现作者：马尔科姆·戴维斯。

基于JSP的网上书店系统设计随着互联网的普及和电子商务的发展，网上书店系统已成为人们购物生活中不可或缺的一部分。

使用Java Server Pages（JSP）技术，可以帮助开发人员快速创建动态的、交互式的Web应用程序。

本文将介绍如何设计一个基于JSP的网上书店系统。

在开始设计网上书店系统之前，我们需要对系统的需求进行详细的分析。

主要包括以下几个方面：用户注册与登录：允许用户注册账户并登录系统。

书籍浏览与搜索：展示所有书籍供用户浏览，并支持用户按照书名、作者、出版社等关键字搜索书籍。

购物车功能：允许用户将感兴趣的书籍加入购物车，并可以查看购物车中的书籍信息。

订单生成与支付：用户可以从购物车中删除书籍或者修改数量，最后生成订单并完成支付。

后台管理：管理员可以管理书籍信息、用户信息和订单信息等。

根据上述需求分析，我们可以将系统设计为以下几个模块：用户模块：包括用户注册、登录、浏览书籍、搜索书籍、添加书籍到购物车、删除书籍、修改数量、生成订单、支付等功能。

管理员模块：包括用户管理、书籍管理、订单管理等。

数据库模块：用于存储用户信息、书籍信息、订单信息等。

在JSP技术中，我们可以使用JavaBean组件来封装数据，使用Servlet 来处理业务逻辑，使用JSP页面来展示数据和交互。

数据库连接：使用Java数据库连接（JDBC）技术，与数据库建立连接，实现数据的增删改查操作。

JSP与Servlet交互：使用JSP页面接收用户输入，通过Servlet处理业务逻辑，并返回结果给JSP页面展示。

JavaBean组件：使用JavaBean组件封装数据，减少代码冗余，提高代码复用性。

HTML5与CSS3：使用HTML5和CSS3技术实现页面的布局和美化。

JavaScript与JSP交互：使用JavaScript技术实现页面的动态效果和交互效果，同时可以与JSP页面进行交互，实现前后台的交互。

支付接口：使用第三方支付接口实现支付功能，保证支付安全可靠。

基于JSP的在线书店销售系统的设计与实现 - 外文文献及翻译文献来源本文献选自2019年IEEE会议论文集，作者为Qiuyue Luo、Liangye He。

原文题目为Design and Implementation of Online Bookstore Sales System based on JSP。

文献摘要随着网络技术的快速发展，越来越多的商业活动正在向线上迁移。

在线书店作为一个重要的商业模式之一，成为了一个备受关注的领域。

本文献介绍了一种基于JSP技术的在线书店销售系统的设计与实现。

该系统包括用户注册、书籍浏览、购物车、订单管理等功能模块。

通过对系统的详细设计，提高了系统的可靠性、安全性、稳定性和性能，从而为用户提供更好的在线购物体验。

文献翻译随着互联网技术的飞速发展，越来越多的商业活动正在向线上迁移。

在线书店成为了一个备受关注的领域。

为了更好地满足用户的需求，设计和实现一个高效可靠的在线书店销售系统显得尤为重要。

本文献介绍了一种基于JSP技术的在线书店销售系统的设计和实现。

该系统包括用户注册、书籍浏览、购物车、订单管理等功能模块。

通过本系统的详细设计，提高了系统的可靠性、安全性、稳定性和性能，为用户提供更好的在线购物体验。

具体来说，本系统的设计和实现主要包括以下方面：1.用户注册和登录功能：用户可以使用自己的账号和密码登录系统，也可以选择注册新的账号。

2.书籍浏览和搜索功能：用户可以浏览所有书籍的详细信息，并根据自己的需求进行搜索。

3.购物车功能：用户可以将自己喜欢的书籍添加到购物车中，并随时查看购物车中的商品数量和价格。

4.订单管理功能：用户可以查看自己的订单，并对订单进行管理和修改。

本系统采用了JSP技术和MySQL数据库，可以实现高效、可靠和安全的在线交易。

值得注意的是，为了提高系统的安全性和可靠性，我们采用了多个措施。

首先，用户的账号和密码将被加密保存，避免被不法之徒获取。

目录概要 (2)前言 (2)第1章概述 (3)1.1 开发背景.......................................................................................................................... 错误!未定义书签。

1.2 JAVA简介......................................................................................................................... 错误!未定义书签。

1.3 SQL简介 (3)第2章需求分析........................... 错误!未定义书签。

2.1 系统组成：...................................................................................................................... 错误!未定义书签。

2.2 系统要求配置.................................................................................................................. 错误!未定义书签。

第3章详细设计.. (8)3.1 数据库设计 (9)3.1.1 数据库需求分析 (9)3.1.2 数据库逻辑结构设计 (11)3.2 人机一体化设计 (13)3．2．1后台管理部分 (13)3．2．2前台部分 (13)第4章系统测试 (29)4.1 数据库连接 (29)4.2 检测网站运行速度 (29)第5章总结 (32)参考文献 (33)致谢 (34)概要随着Internet技术的发展，人们的日常生活已经离不开网络。

毕业设计说明书英文文献及中文翻译班级：学号：姓名：学院：专业：指导教师：1 Struts Framework Based on MVCIn the traditional Web application, Java Server Pages(JSP) pages are responsible for handling all things, for example, receiving requests, executing business logics, choosingthe next page. These complicated things may lead to chaos of JSP pages’ codes and be harmful for the extension and maintenance of pages. The Model-View-Controller (MVC) mode separates the programming codes into three different areas, which has solved the above problem. MVC can realize J2EE application system's stratification and the loose coupling of three layers or multilayer, and it is a realization way of orienting dynamic content. The MVC mode divides application into three core components of Model, View and Controller.Struts is a realization of MVC. It is an open source Web application framework and uses Servlet and JSP marks that belong to the J2EE norm as a part of the realization. Struts inherits MVC characteristics and realizes some corresponding changes and extension according to J2EE traits. Struts separates Java codes of JSP by Java Bean and Action class to be the MVC mode, transmits data among the three partitions of Model, View and Controller, demonstrates the connection between various classes and JSP pages by configuration files finally and it intends to realize the separation of presentation layer, business layer and data layer. The Struts structure is shown in Figure 1.The Model contains the business logic that exchanges data with a persistence layer. The View is in charge of producing what is directly visible to the user, . web pages. The Controller is the layer that receives requests from clients, determines what business logic takes place and where to go next. In the Struts framework, the Model uses Java classes for the business logic. The View can be implemented with JSP and the Tag lib of Struts. The Controller is a J2EE component known as Servlet, more specifically an ActionServlet object, which determines what or when logic gets executed and where the control should get directed.2 Hibernate Framework Based on ORMWorking with both the object-oriented software and the relational database is a complicated task with Java Database Connectivity (JDBC) because there is mismatch between how data is represented in objects versus relational database. So with JDBC, developers have to write pure the Structured Query Languag (SQL) statements to map an object model's data representation to a relational data model and its corresponding database schema.Introduction of HibernateHibernate is a flexible and powerful Object-Relational Mapping (ORM) solution to map Java classes to database tables. It is a powerful, high performance object-relational persistence and query service. Hibernate allows developers to express queries in its own portable SQL extension (Hibernate Query Language (HQL))[3], as well as in native SQL, or with an object-oriented criteria and example Application Programming Interface(API). Hibernate itself takes care of this mapping using XML files so developers don’t need to write code for this.Hibernate is an open source and it is free to use for both development and production deployments, which is a bridge between Java application and relational database and takes charge of mapping between Java objects and relational data. The inside of Hibernate packs the operation of accessing database by JDBC, which provides API of object-oriented database access to upper layer application. So developers can use the object programming thought to operate database sufficiently, caring for the bottom database structure unnecessarily.Hibernate relieves the developer from 95 percent of common data persistence related programming tasks, compared to manual coding with SQL and the JDBC API[4]. And it can integrate various Web server or application server, and nearly support all popular databases server.Principle of HibernateAs shown in figure , Hibernate lies in the middle layer that is between applicationand database .In the provided persistent service, Hibernate maps class to rows of datasheet by properties and mapping files of class itself. Application interacts with database by Persitstent Object (PO) to handle data directly.ApplicationPersistent ObjectsHibernateHibernate.properties XML.MappingDatabaseFigure Hibernate systematic structure3 The Integration of Struts and HibernateIn the open source frameworks, for the presentation part, Tapestry has the powerful and natural combination of pages, its document is too conceptional to benefit programming. And its learning curve was too steep and so on. For the logic part, Spring has a good integration function, but there is a lack of public controller. And EJB depends on the EJB containers, at the same time, it is realized complicatedly. While Struts has been applied extensively because of its advantages.At present, most of systems apply the relational databases mainly, while Java is an object-oriented language essentially. In Model part of Struts framework application, using SQL and JDBC to operate databases when storing and fetching objects reduces programming efficiency and the systematic maintainability. Traditional J2EE-based application applies heavyweight framework based on EJB that adapts to the large enterprise development, while development and debugging by EJB container need to consume a plenty of time and high price. EJB3 improves the disadvantages of original EJB, but its application is not mature yet.Hibernate can substitute Container-Managed Persistence (CMP) to accomplish heavy responsibility of permanence in J2EE framework of applying a word, Hibernate can resolve the difficulties coming from using traditional CMP, JDBC and Data Access Object(DAO) in a technological development. For reducing the coupling of code and raising systematic development efficiency, this paper suggests J2EE application development tactics based on Struts and Hibernate.The Struts design shows the MVC framework sufficiently, which all control flows need a configuration file to manage, and which is convenient to maintain. The integration of Struts and Hibernate is that Hibernate solves the model layer of Struts, which makes developers operate Java objects instead of database. The integration shows the object-oriented thought sufficiently and solves some problems of the database operation in traditional J2EE well.Flow of FrameworkThe flow of integration framework based on Struts and Hibernate is shown in Figure 3. At first, users send Http requests by Browser, then Http requests are accepted by ActionServlet of the control component in business layer, then gave to RequestProcessor which gets corresponding Action from ActionMapping by request URL[3]. Besides, ActionForm packs JSP pages, which can make a checking to data of datasheet if it is needed, send back ActionErrors to visual pages if there are mistakes and transfer the data of pages to Action if it passes validation.Request Processor transfers the “execute” method of Action and the method transfers the business logic module. Hibernate accomplishes interaction of databases and JavaBean. The operation of processing business logic interacts with database by data permanence layer and field object layer. The “execute” method of Action will return ActionForward objects that are accepted by ActionServlet after executing.Systematic Structure of the Integration FrameworkThe EIS layer of the multi-layer J2EE systematic structure can be partitioned into the data permanence layer and the data resource layer. It means a system can be divided into five layers as a whole.Client Layer: This layer runs in the Browser of users’ machin es and handles interaction with users, transmits and shows messages to users. J2EE platform supports different type users including HTML users, Java Applets, Java application, etc.Presentation Layer: This layer works in J2EE Web container, produces the systematic representation logic, handles users’ requests and makes the responses. The entire Web is built on Struts framework, in which the View component is composed of JSP/HTML pages whose data is expressed by ActionForm Bean, the Controller component is composed of ActionServlet united and Action Classes, and the Model component is realized by business logic Logic Layer: This layer accomplishes the required business of system, provides the required business method to presentation layer. It can receive data from client programs and save them to the storage equipment after proper disposal, read data from the data storage equipment, then send them out to client programs.1 基于MVC的Struts框架在传统的Web应用程序，Java服务器页面（JSP）页面负责处理所有的事情，例如，接收请求，执行业务逻辑，选择下一个页面。

毕业论文外文翻译The Active Server Pages( ASP)The Active Server Pages( ASP) is a server to carry the script plait writes the environment, using it can create to set up with circulate the development, alternant Web server application procedure. Using the ASP cans combine the page of HTML, script order to create to set up the alternant the page of Web with the module of ActiveX with the mighty and applied procedure in function that according to Web. The applied procedure in ASP develops very easily with modify.The HTML plait writes the personnel if you are a simple method that a HTML plait writes the personnel, you will discover the script of ASP providing to create to have diplomatic relation with each other page. If you once want that collect the data from the form of HTML, or use the name personalization HTML document of the customer, or according to the different characteristic in different usage of the browser, you will discover ASP providing an outstanding solution. Before, to think that collect the data from the form of HTML, have to study a plait distance language to create to set up a CGI application procedure. Now, you only some simple instruction into arrive in your HTML document, can collect from the form the data combine proceeding analysis. You need not study the complete plait distance language again or edit and translate the procedure to create to have diplomatic relation alone with each other page.Along with control to use the ASP continuously with the phonetic technique in script, you can create to set up the more complicated script. For the ASP, you can then conveniently usage ActiveX module to carry out the complicated mission, link the database for example with saving with inspectional information.If you have controlled a script language, such as VBScript, JavaScript or PERL, and you have understood the method that use the ASP.As long as installed to match the standard cowgirl in the script of ActiveX script engine, can use in the page of ASPan any a script language. Does the ASP take the Microsoft? Visual Basic? Scripting Edition ( VBScript) with Microsoft? Script? Of script engine, like this you can start the editor script immediately. PERL, REXX with Python ActiveX script engine can from the third square develops the personnel acquires. The Web develops the personnel if you have controlled a plait distance language, such as Visual Basic, you will discover the ASP creates a very vivid method that set up the Web application procedure quickly. Pass to face to increase in the HTML the script order any, you can create the HTML that set up the applied procedure connects. Pass to create to set up own the module of ActiveX, can will apply the business in the procedure logic seal to pack and can adjust from the script, other module or from the other procedure the mold piece that use.The usage ASP proceeds the calculating Web can convert into the visible benefits, it can make the supplier of Web provide the alternant business application but not only is to announce the contents. For example, the travel agency can compare the announcement aviation schedule makes out more; Using the script of ASP can let the customer inspect the current service, comparison expenses and prepare to book seats.Include too can lower in the Windows NT Option Microsoft in the pack Transaction Server ( MTS) on the server complexity of constructing the procedure with expenses. The MTS can resolve to develop those confidentialities strong, can ratings of and the dependable Web applies the complexity problem of the procedure. Active Server Pages modelThe browser requests from the server of Web. Hour of asp document, the script of ASP starts circulating. Then the server of Web adjusts to use the ASP, the ASP reads completely the document of the claim, carry out all scripts order any, combining to deliver the page of Web to browser.Because script is on the server but is not at the customer to carry the movement, deliver the page of Web on the browser is on the Web server born. Combining to deliver the standard HTML to browser. Because only the result that there is script returns the browser, so the server carries the not easy replication in script. The customer cans not see to create to set up them at script order that the page that view.We introduce the Basic form of the database language known as SQL, a language that allows us to query and manipulate data on computerized relational database systems. SQL has been the lingua franca for RDBMS since the early 1980s, and it is of fundamental importance for many of the concepts presented in this text. The SQL language is currently in transition from the relational form (the ANSI SQL –92 standard) to a newer object-relational form (ANSI SQL -99, which was released in 1999). SQL-99 should be thought of as extending SQL-92, not changing any of the earlier valid language. Usually, the basic SQL we define matches most closely the ANSI SQL standards basic subsets, called Entry SQL -92 and core SQL-99 that are commonly implemented; our touchstone in defining basic SQL is to provide a syntax that is fully available on most of the major RDBMS products[7].We begin with an overview of SQL capabilities, and then we explain something about the multiple SQL standards and dialects and how we will deal with these in our presentation.We will learn how to pose comparable queries in SQL, using a form known as the Select statement. As we will see, the SQL select statement offers more flexibility in a number of ways than relational algebra for posing queries. However, there is no fundamental improvement in power, nothing that could not be achieved in relational algebra , given a few well-considered extensions. For this reason, experience with relational algebra gives us a good idea of what can be accomplished in SQL. At the same time, SQL and relational algebra have quite different conceptual models in a number of respects, and the insight drawn from familiarity with the relational algebra approach may enhance your understanding of SQL capabilities.The most important new feature you will encounter with SQL is the ability to pose queries interactively in a computerized environment. The SQL select statement is more complicated and difficult to master than the relatively simple relational algebra, but you should never feel list or uncertain as long as you have access to computer facilities where a few experiments can clear up uncertainties about SQL use. The interactive SQL environment discussed in the current chapter allows you to type a query on a monitor screen and get an immediate answer. Such interactive queries are sometimes called ad box queries. This term refers to the fact that an SQL selectstatement is meant to be composed all at once in a few type written lines and not be dependent on any prior interaction in a user session. The feature of not being dependent on prior interaction is also down as non-procedurality. SQL differs in this way even from relational algebra, where a prior alias statement might be needed in order to represent a product of a table with itself. The difference between SQL and procedural languages such as java or c is profound: you do not need to write a program to try out an SQL query, you just have to type the relatively short, self-contained text of the query and submit it .Of course, an SQL query can be rather complex . A limited part of this full form, know as a sub-query, is defined recursively, and the full select statement form has one added clause. You should not feel intimidated by the complexity of the select statement, however. The fact that a select statement is non-procedural means that it has a lot in common with a menu driven application, where a user is expected to fill in some set of choices from a menu and then press the enter key to execute the menu choices all at once. The various clauses of the select statement correspond to menu choices: you will occasionally need all these clauses, but on not expect to use all of them every time you pose a query.Observed reliability depends on the context in which the system s used. As discussed already, the system environment cannot be specified in advance nor can the system designers place restrictions on that environment for operational systems. Different systems in an environment may react to problems in unpredictable ways, thus affecting the reliability of all of these systems. There for, even when the system has been integrated, it may be difficult to make accurate measurements of its reliability.Visual Basic Database Access prospectsWith the recent Web application software and the rapid development of the existing data stored in diverse forms, Visual Basic Database Access Solutions faces such as rapid extraction enterprises located in the internal and external business information with the multiple challenges. To this end Microsoft, a new database access strategy "unified data access" (UniversalDataAccess) strategy. "Unified data access" to provide high-performance access, including relational and non-relationaldata in a variety of sources, provide independent in the development of language development tools and the simple programming interface, these technologies makes enterprise integration of multiple data sources, better choice of development tools, application software, operating platforms, and will establish a maintenance easy solution possible.汉语翻译Active Server Pages（ASP）是服务器端脚本编写环境，使用它可以创建和运行动态、交互的Web 服务器应用程序。

JIU JIANG UNIVERSITY毕业论文题目基于J2EE的图书销售系统的设计与实现英文题目Design and Implementation of BookSales System Based on J2EE 院系信息科学与技术学院专业计算机科学与技术姓名曹春雷班级学号 A101208 指导教师郭莉二Ｏ一四年六月摘要网上图书销售系统,是一种较为流行、电子商务类的方式，也是电子商务的一个缩影，目前，市场上服务于图书销售的系统，种类繁多。

本系统是采用J2EE开发；通过对系统的研究，得到图书销售系统的需求，使用J2EE架构，开发一个比较完善、逻辑合理的图书销售系统。

本系统采用JA V A开发语言，系统后台数据库采用开源、操作简单的、性能优良的MYSQL数据库，实现一个是基于WEB、采用B/S模式的图书销售之系统。

本系统中主要功能有：图书的在线展示功能、在线交易的功能、在线搜索的功能、客户在线服务的功能，还有系统管理员的相关功能等。

论文中说明了：在线买卖图书的方式之优势、以及图书销售的发展趋势，通过对开发设计的网站进行分析、设计且实现的过程，论文中介绍了关于图书销售系统的详细内容。

关键词：图书销售系统,电子商务,数据库AbstractBook sales system,I think it is a more popular way of e-commerce,e-commerce is a microcosm,currently on book sales system , is really endless,the system I was using j2ee development;through my system the study not only understand: how to use j2ee framework to develop a more complete,logical and reasonable online book sales system,whereby you can also extend the idea to develop a similar,other forms of electronic commerce systems.System I am using JA V A development language,back-end database system I was using open source, simple operation,very easy to use,MYSQL database,the realization of a WEB -based,with the B / S mode,online book sales system.Some of the main function of the system is:Book online display function,the function of online transactions,online search function,online customer service functions,as well as related functions such as system administrators.I explained the paper: the advantages of online trading book approach,as well as his development of the trend,I analyze my website design,design as well as realization of the process,I have do the introduction for everyone.Keywords: Book Sales System, Electronic Commerce, Database目录摘要 (I)Abstract (II)1 前言1.1开发背景 (1)1.2开发意义 (2)1.3结构透视 (3)2 可行性研究及开发工具与开发模式2.1可行性研究 (4)2.2设计原则 (6)2.3系统开发工具与开发模式的选择 (7)2.4小结 (8)3 需求分析3.1功能需求 (9)3.2数据流图 (10)3.3用例图 (12)3.4小结 (14)4 系统的总体设计4.1功能设计 (15)4.2数据库设计 (16)4.3小结 (28)5 系统的实现5.1管理员模块 (29)5.2会员模块 (32)5.3小结 (33)6 测试、分析与总结6.1测试的重要性 (34)6.2测试方法 (35)6.3单元测试用例 (35)6.4系统运行情况 (36)6.5小结 (36)结论 (37)致谢 (39)参考文献 (40)1 前言1.1开发背景图书销售系统是一种Online图书销售之平台。

基于JSP的网上书店系统的设计与实现摘要：随着电子商务化的发展和普及，传统的实体书店跟网上书店相比存在耗费大量时间和精力等问题。

用网上虚拟商店来管理和销售图书，也就是能够用计算机来管理图书信息管理和进行图书销售，这样既比传统书店的管理专业化，又能够为商店节约时间人力和纸张，同时也为消费者提供了方便。

该网上书店系统采用B/S架构的详细信息管理系统，使用JSP高效率的设计优点并以MyEclipse8.5为开发工具。

对一切的模块以及过程进行了更加详细的解释说明。

网上书店管理系统能够最大程度的被用户理解，并且充分的发挥了网上图书管理系统的作用。

关键字：系统管理；网上销售；SQL数据库；JSP脚本绪论当今时代是一个知识的海洋，与此同时也就有越来越多的人想通过知识来丰富自己的阅历和自己的见解。

如今人们的生活压力逐渐增大导致大多数的人们想读书却没有时间和精力出门购买书籍的情况发生。

为了满足人们的这种不出户愿望，网上图书销售系统便应运而生。

从网上书店销售系统的图书购买、图书发货、客户收到图书、发送确认收货通知等一切过程。

在此过程中，最主要的是图书订单处理。

图书订单处理过程包括消费者付款方式、预留消费者相关信息、通知快递公司揽件图书、图书信息跟踪、消费者签收图书快递等等。

便于更好地完成整个系统的销售工作，系统的管理员还保证对消费者的订单以及将要消费的订单详情及时保存到数据库中。

为了更完美的让用户使用网上图书销售管理系统，管理员还需对库存中的每种图书有一个详细的了解。

例如：每一次的订单完成之后，虚拟仓库里剩余的书籍的数量、种类的清单等以免图书不能及时上架影响客户的购买，管理员应该了如指掌，这样才能方便下一位客户的购买和预定而且能保证网上书店的正常运营。

1 系统设计1.1目标设计网上图书销售管理系统的基本功能：1.用户的注册●如果用户需要购买图书就要先注册。

●用户注册完成之后，需要管理员的同意方可成为本书店的会员。

●如果管理员没有同意，则用户不能在本书店进行购买活动。

中南大学本科生毕业论文（设计）摘要本文介绍了以网上书店为代表的商务电子的发展状况、技术背景，具体讲述了如何使用JSP建立了一个网上书店系统，网上书店的建立流程、数据库设计、功能模块的设计，以及每一个功能模块的代码实现方法。

本系统采用JSP+JavaBean的模式来订制一个小型电子商务平台，系统采用界面与业务逻辑分离的三层结构设计，将业务逻辑封装在JavaBean中，使得系统的安全性、可维护性、可重用性和可扩展性都大大提高。

系统采用SQLServer为后台数据库以JSP Web为页面形式，涉及到数据库、网络、Web服务器、j2ee等方面的技术，实现了较为完备的功能。

包括有前台管理：图书分类、图书详情浏览、可按书名、作者、出版社或者全部关键字查询图书，购物车功能；后台管理：订单处理、用户信息管理、图书的添加、删除等等。

另外，对系统的安全性也做了相关设置。

整个系统具有友好的用户界面，操作简单实用，功能较为完备。

关键词B2C，网上书店，JSP，JavaBean，B/SABSTRACTIt is discussed in this paper the development, related technology of E-Commerce in short, and how to set up a Bookshop Online System, the building-flow, database setting, function module design, how to implement every function module code concretely. It is a small E-Commerce platform based on JSP+JavaBean mode. The system makes the use of three layers structure based on separation of interface and operation logic. It is packaged in the JavaBean, which advanced the security, maintainability, reusability and extensibility of the system.The System is implemented by using SQLServer as backstage database and performed by JavaServer Pages. It involved the related technology such as database, web server and Java 2 Enterprise Edition. Also the system is carried out the following function: Interface Management, including sorting books, looking through book details, looking for books according to title, author, publishing company or all of the keys above, shopping car function. Administrators Management: dealing with order, user information and adding or deleting books. Besides，the security of the system is also taken into consideration. It shows friendly consumer interface and provides simple operation, completed function.KEY WORDS Business to Consumer, Bookshop Online, JavaServer Pages, JavaBean, Browser/Server目录摘要------------------------------------------------------------------ⅠABSTRACT------------------------------------------------------------Ⅱ目录------------------------------------------------------------------Ⅲ第一章绪论---------------------------------------------------------- 1 1.1 选题设计开发的背景和意义------------------------------------------ 11.1.1 选题应用背景------------------------------------------------- 11.1.2 开发网上书店的意义------------------------------------------- 1 1.2 网上书店国内外发展现状-------------------------------------------- 31.2.1 国外现状----------------------------------------------------- 31.2.2 我国网上书店现状--------------------------------------------- 41.2.2 我国网上书店面临的主要问题----------------------------------- 4 1.3 系统设计目标------------------------------------------------------ 5 第二章网上书店系统分析---------------------------------------------- 6 2.1 系统设计思想------------------------------------------------------ 6 2.2 系统结构设计------------------------------------------------------ 72.2.1 逻辑体系结构------------------------------------------------- 72.2.2 结构设计----------------------------------------------------- 8 2.3 系统运行环境------------------------------------------------------ 82.3.1 系统配置概述------------------------------------------------- 82.3.2 Java SDK的安装以及环境变量的配置---------------------------- 92.3.3 安装和配置web服务器----------------------------------------- 92.3.4 数据库连接-------------------------------------------------- 10 2.4 系统安全管理 ----------------------------------------------------- 13 第三章系统总体设计------------------------------------------------- 14 3.1 系统总体功能介绍------------------------------------------------- 14 3.2 主要功能模块功能介绍--------------------------------------------- 163.2.1 客户界面系统功能模块---------------------------------------- 163.2.2 管理界面系统功能模块---------------------------------------- 17 3.3 系统数据库设计--------------------------------------------------- 17 第四章系统详细设计介绍--------------------------------------------- 224.1 系统关键技术----------------------------------------------------- 224.1.1 JSP/SERVLET和JDBC技术------------------------------------- 224.1.2 JavaBean ---------------------------------------------------- 24 4.2 系统选型及开发工具介绍------------------------------------------- 254.2.1 B/S模式---------------------------------------------------- 254.2.2 EditPlus介绍----------------------------------------------- 26 4.3 分系统的总体设计------------------------------------------------- 274.3.1 前台介绍---------------------------------------------------- 274.3.2 系统流程图-------------------------------------------------- 29 4.4 模块实现--------------------------------------------------------- 314.4.1 前台购书系统------------------------------------------------ 314.4.2 后台管理系统------------------------------------------------ 35 4.5 系统实现--------------------------------------------------------- 39 4.6 系统特点--------------------------------------------------------- 41 第五章系统所遇问题与分析-------------------------------------------- 425.1 中文乱码问题的分析解决------------------------------------------- 42 5.2 精确查询与模糊查询----------------------------------------------- 43 5.3 系统的编译和发行------------------------------------------------- 43 5.4 注意事项--------------------------------------------------------- 44 第六章总结-------------------------------------------------------- 456.1 课题研究内容总结------------------------------------------------- 45 6.2 后续研究工作展望------------------------------------------------- 45 致谢---------------------------------------------------------------- 46 参考文献------------------------------------------------------------- 47第一章绪论1.1 选题设计开发的背景和意义1.1.1 选题应用背景20世纪末，随着计算机科学的发展，网络技术和数据库技术在Internet中的应用越来越广泛，为广大网络用户提供了更加周到和以人为本的服务。