系统公告：
ASP.NET课程设计说明书
专
业： 计算机科学与技术
班
级： 0801 学
号： 0812030111 学生姓名： 欧阳锋 指导教师： 言天舒
湖南工业大学科技学院教务部 制
基于JSP的企业进销存管理系统 I
基于JSP的企业进销存管理系统
摘 要
进销存管理系统是商业信息管理的重要部分，面对大量的商品信息，采用人力处理将浪费大量的时间、人力和物力，且对数据操作的准确性不高。本文提出了一种易于操作的进销存管理系统对整个流程中涉及到的表单进行半自动化处理。本系统的设计目标是管理企业的进货、销售、库存、帐务等过程。用户通过使用本系统可以为企业有效减少盲目进货，降低进货成本，合理控制库存，减少资金占用并提高市场灵敏度，提升企业市场竞争力。
本系统可以管理货品的基本信息，客户信息，供货商信息，员工信息等。它还可以建立以及查询企业在进货、销售、库存等过程中产生的各种单据，包括进货单，销售单，入库单，出库单，进货付款单，销售收款单等。本系统还可以对各种单据进行统计分析，并提供报表打印功能。本系统采用二级用户管理，有着良好的系统安全性。关键词：JSP、企业进销存管理系统、SQLyog数据库、Dreamweaver
基于JSP的企业进销存管理系统 1 绪论
随着中国电子商务、互联网业务的迅猛发展。国内许多企业已跨入电脑网络管理时代，并因此提高了管理效率和市场竞争力。但目前仍有部分企业还停留在原始记账管理阶段。而随着全球经济信息化的进程和WTO的成功实现，企业面临着前所未有的机遇和挑战，在如此激变的社会形势和激烈的市场竞争下，愈来愈多的企业管理者意识到效率管理和科学管理的重要性，以及增强市场竞争力的迫切性，因此建立科学、规范、高效的管理制度和秉承富有竞争力的经营理念是每一个企业管理者的渴望，企业采用电脑管理进货、库存、销售等诸多环节也已成为趋势及必然。
基于JSP的企业进销存管理系统 1 开发环境
2.1 JSP技术简介
随着电子计算机技术的迅猛发展，Java作为一种面向对象的程序设计语言，它降低了Internet应用程序的编写难度。在www.xiexiebang.commodity information, using human processing will waste a lot of time, manpower and material resources, and the accuracy of the data operation is not high.This paper puts forward a kind of easy operation for the flow purchase-sell-stock management system that involves in form for half an automated.This system design goal is to manage the enterprise of its purchases, sales, inventory, accounting processes.Users by using this system can provide the enterprises effectively reduce blindly replenish onr's stock, reduce purchase cost, reasonable control inventory, reduce nbre and improve market sensitivity, and promote enterprise's competitiveness.module design and realization, as well as concrete contact surface design and function.This system can manage goods of basic information, customer information, supplier information, employee information, etc.It also can build and inquires enterprise in incoming goods, sales, inventory process to produce a variety of documents, including restocked sheet, sales orders, GRN and outbound order, purchase and sales of voucher, paying bills etc.This system can also to all the documents of statistical analysis, and provide print function.The system USES the secondary user management, there are good system security.KEY WORDS: JSP, Enterprise Purchase-sell-stock Management System, SQL database, Dreamweaver Sever
基于JSP的企业进销存管理系统 5 the introduction With China's e-commerce, Internet rapid development of business.Many domestic enterprises has entered the computer network management era, and therefore improve the management efficiency and competitiveness.But there is still some enterprise still stays in the original accounting management phase.But as the global economy's process of informationization and WTO the successful realization, the enterprise is facing unprecedented opportunities and challenges, so the drastically changing social situation in the fierce market competition, more and more enterprises managers realize efficient management and the importance of scientific management, and enhance the competitiveness of urgency, thereby establishing a scientific, standardized and effective management system and adhering to the competitive business philosophy is each enterprise managers longing, enterprise USES computer management, inventory, sales restocking etc many link also has become the trend and inevitable.the development environment 2.1 JSP technology introduction Along with the rapid development of the computer technology, Java as an object-oriented programming language, it decreases the Internet applications writing difficulty.In the www.xiexiebang.come more colorful.The JSP page will display logic and Web design and separation, support reusable component based design, make based on Web application development become quickly and easily.2.2 MySQL5.5 database profile MySQL is really a multi-user, multithreading SQL database server.MySQL, based on a client/server architecture implementation, it consists of a server daemon MySQL and many different client and library composition.SQL is a standard language, it makes the storage, update, and accessing information more easily.SQL language can be a web search product information and store customer information, and at the same time MySQL also fast enough and flexible to allow stored records and image.6 2.3 Eclipse3.6 profile Eclipse is an open source, based on a Java extensible development platform.By itself, it is just a framework and a set of service, used for constructing through plug-ins components development environment.Eclipse also includes the plugin Development Environment(Plug-in Development to PDE), the component, mainly aimed at hopes to expand Eclipse of software developers, because it allows them to construct and Eclipse Environment seamless integration tools.2.4 JDK 1.6 JDK(Java Development Kit)is from Microsystems for Java Development member of the product.Since the launch since, Java JDK has become the most widely used Java SDK.JDK is the core of the whole Java, including a Java running environment, Java tools and Java base class library.2.5 operating system environment Operating system: Windows 7/2000 / XP / 2003, This system USES is clicked/Server mode design.Database system: MySQL The application server: Tomcat6.0 Server operating system: Windows Server 2000 Assist in the development tools: Dreamweaver The browser: IE5.0, recommend using IE6.0.system feasibility study 3.1 technical feasibility study The development of enterprise purchase-sell-stock management system based on B/S model, mainly including front application program development and the setting and maintenance of database two aspects.This system is used JSP and SQL Sever respectively as the front-end and
基于JSP的企业进销存管理系统 7 after development tools.Therefore speak from technology development, this system is feasible.3.2 economic feasibility study Enterprise purchase-sell-stock management system is a informationization, intelligent and advanced management concept of aggregation.While management is a dynamic process, in its operation procedure should be taken various measures.Not only can save them a lot of time, but also for the enterprise the decisions can provide valuable information for enterprises to bring huge economic benefits.3.3 operation feasibility study The system USES Windows based graphical user interface, and the system is familiar operating system, for those who have a general knowledge of computer personnel can easily handcuffed.And the whole enterprise purchase-sell-stock management system adopts the most friendly interface, introduction and clear, do not need the database in-depth understanding.Comprehensive three aspects above, this system has the high feasibility of developing, both technically or economic and operation.Therefore, can design the system of data flow chart, establish the data dictionary.system requirement analysis 4.1 system whole function analysis Along with the progress of the society and the increasing popularity of computer, management and control of all walks of life have become cannot leave computer assisted.The development of the system is in order to assist the most enterprise basic management and realize the information management of the systematic, standardization and automation.Simplify the large people daily work mechanical repetition of operation, makes some process trival and large amount of data work have already efficient, realizes to workflow layers of control, coordination, thus enhancing the competitiveness of the enterprises.8 4.2 module function analysis Enterprise purchase-sell-stock management system is a typical database development application, by login, fundamental information management module, purchase information management module, sales information management module, inventory information management module, operation analysis module, system maintenance module components.5.System software design 5.1 system design goal This system is for small and medium enterprises operating enters sells saves the process design, mainly realizes below target: System adopts the man-machine dialogue way, interface aesthetics friendly, information query flexible, convenient, quick, accurate, data storage safe;Keyboard, rapid response, Strong sales check-out function;Comprehensive bill inquires the function;Powerful annual sales FenXiTu and sale of goods, ranking statistics, Realize various query, such as many conditions query, fuzzy query etc;Administrators can set operator's privileges;5.2 overall design 5.2.1 system architecture design The system USES the B/S structure as basic structure, namely, the client browser/Web server/database structure.5.2.2 system structure design In software hierarchical structure design, this system USES more popular three-layer framework design, both the presentation layer, business layer, and data access layer.5.2.3 The data access layer requires special features Realizing access to data function, receiving SQL statements and as a parameter and return the result of manipulating database, such as create/closes the connection, execute SQL database, and it directly deal with.5.2.4 business logic layer Implementing the system logic functions.Business layer in accordance with module, the software business logic into a number of modules, reduced and data access layer and the coupling
基于JSP的企业进销存管理系统 9 representation layer, the benefits of is, convenient page upgrades, and a business function expansion.5.3 detailed design 5.3.1 login Administrator users with operators users through the same login entrance into the system, the system of user input username, password, and user role verification, through the identity authentication user into management system desktop.5.3.2 base material The basic data module includes: the customer information management, Suppliers of information management, Product information management, Company information management.5.3.3 restocked management Unloading information management including new unloading information, modify and unloading information, delete and unloading information, information in-out warehouse queries.5.3.4 order management Order information management include the new order information, modify order information, delete order information, information inquiries orders.5.3.5 inventory management Warehouse management information including new warehouse information, modify warehouse information, delete warehouse information, information warehouse queries.5.3.6 business analysis Operating analysis module according to sales single search analysis, commodity sales analysis and customer sales analysis, three function to realize.5.3.7 system maintenance management System maintenance management includes user management, the authority management, cipher amending, cancel such function, need for operators can use features access for setting, classification management.database design Database design is to analyze and create preservation system data database structure design, database analysis is database project development cycle in an important stage, with modern software development, manual analytical method has been difficult to meet the database system
database analysis of requirement, must use the corresponding tools.system development System development include: login, system management homepage, company management(company browsing, company editor), customer management(customers browse, customer edit), product management(product browsing, product editor)and supplier management(supplier browsing, supplier editor)software testing 8.1 software testing principle Should begin and constant software testing, the practice has proved unit test as soon as possible to discover a problem, reduce the error amount later test.Should be avoided by programmers check their own work.(refers to late system testing phase, not including unit test)8.2 software testing purposes Test ultimate goal is to avoid mistakes happen to ensure the application to normal and efficient operation.8.3 software testing steps Focused on the source code realization with every program unit test, check whether each program modules correctly realized the required functions.
基于JSP的在线留言板系统设计
摘 要 本文从当前一般企业公司的网站融入在线留言功能的作用入手，探讨了基于JSP的在线留言板系统的需求分析，总体设计。重点分析了留言板的数据库设计、页面设计、系统的流程及设计特色等。
【关键词】JSP 在线留言 数据库留言板系统的需求分析
目前很多大型企业公司的网站上都提供了在线留言功能。其主要目的，搜集客户对该企业的意见和建议，为了更好改进产品质量或是服务等。同时也为个人之间，团体之间，个人与团体之间的交流，提供了交流的平台与便捷服务，在Internet上实现信息的传递，提高办事效率。本系统以Internet为平台，以JSP作为开发工具，SQLServer2005为后台数据库，构建一个小型留言板网站系统，从功能需求到框架规划再到数据库设计，最后功能实现。
该系统主要由前台功能和后台功能两部分组成。前台提供注册功能。注册的用户可以在留言板上进行主题查看，发表留言，回复留言。如果没有注册的用户没有权利发表留言或是回复留言但可以查看主题，查看留言内容，后台版主管理者可以进行留言的相关操作外，有权对留言进行审核，如果出现语言不逊或是恶意伤害的留言进行屏敝或删除管理等操作。系统的总体设计
2.1 数据库设计
数据库设计是把现实世界的模型按照需求分析转换成数据库的模型的过程，它是建立数据库应用系统的核心问题。数据库的数据是一切操作的基础，如果数据库设计不好，则影响其开发功能的实现及后期的维护。通过需求分析，抽象出现实世界的实体模型有人，留言，回复留言。每个实体在留言系统中有其重要属性。如人的属性有用户ID，姓名，权限，密码，电话，邮箱等，其中用户ID是主属性。留言的属性有留言ID，留言姓名，留言主题，留言内容，留言时间，IP，电话等。其中留言ID为主属性，回复留言的主属性有用户ID，留言ID，回复的内容，回复的时间等。其中用户ID为主属性。在以上分析中，留言板中注册的用户有两类人员，一是普通用户，一是管理员，为了区分两者身份，可以在人的属性中增加权限属性，如其值1为管理员，0为普通用户。据此便可以设计出符合实际需求分析的三张表，分别为，user用户表，leaveword留言表，reply留言回复表。
2.2 系统主页设计
为了使留言板系统的页面更加美观，页面风格保持一致，编写了CSS文件和JavaScript文件，采用了CSS外部样式。并建立了一个独立的JS文件，方便多个网页文件引入。
2.3 系统功能设计
详见系统流程图
2.4 系统特色
（1）此留言板系统虽然小巧。但功能完善。
（2）不同用户都有个自的权限。登陆后执行的功能各不相同。实现了多个不同用户的访问。
（3）页面风格统一，简单且美观。
（4）数据库设计合理规范，用户注册的信息符合要求才可以注册成功。具有很好的完整性。
参考文献
[1]王品.JSP实现留言板系统[J].计算机光盘与软件，2012.作者简介
黄军，男，教师，研究方向为软件开发。
作者单位
贵州工业职业技术学院 贵州省贵阳市 550000
点击咨询 