4S零配件管理系统毕业设计（论文）.doc

大连交通大学信息工程学院毕业设计(论文)任务书题 目 鼎盛4S零配件管理系统任务及要求：1.设计（研究）内容和要求任务：1、 调查鼎盛4S店零配件管理系统当前技术的发展近况，完成实习报告，字数不少于3000，第三周交给指导老师。2、 结合自己实习情况安排进度，填写进度计划表，第二周完成后交给指导老师签字，并严格执行。3、 按照软件工程思想，独立完成系统的设计和程序开发，完成代码估计2000行左右。4、 用JavaEE技术实现鼎盛4S店零配件管理系统。5、 程序简洁，算法可行，运行情况良好。要求：1、 每周和指导老师至少见面沟通一次，回报课题进展情况，接受老师询问。2、 接到任务书后，查阅与题目及专业相关的外文资料进行翻译，要求不少于10000个外文字符，译出汉字不得少于3000，于第四周交给指导老师审阅。3、 毕业设计第13周完成毕业论文的装订，并由指导老师评阅。论文要求12000字以上，包括综述、系统总体设计、系统实现、性能分析、结论等。4、 教学第13周通过中软及教研室组织进行软件验收，验收时要提供软件使用说明书。5、 于第13周提出毕业答辩申请并签字。6、 第14 周答辩，要求制作PPT2.原始依据通过大学几年的学习，已经学习了诸如软件工程、数据库原理及应用、数据结构、C+、Visual Basic、JAVA等多门程序设计语言和网络等基础知识和专业知识，学生有能力而且可以独立完成小中型项目的设计与开发。学校现有设备和环境可以提供给学生实习和上机，而且具有专业老师可以指导学生。3.参考文献1 温涛.东软Java软件工程师.大连:东软电子出版社.20072 毛璟骏.Macromedia Dreamweaver MX动态网站开发标准教程.北京:人民大学出社.20073 黄璐.高永梅.基于JSP的网络管理系统的设计与实现.北京:清华大学出版社.20074 刘鲁.软件测试讲解.北京:航天航空大学出版社.20065 黄映霞.JSP项目开发案例.北京:清华大学出版社.2010.26 飞思科技产品研发中心.SQL2000基础与提高M.北京:电子工业出版社.20067 邹启杰.软件工程实用教程M.大连:东软信息学院.20088 张青.SQL2000中文版基础教程M.北京:清华大学出版社.20039 闫海珍.Java实用教程基于WebLogic和Eclipse M.大连:电子工业出版社.200710 Sun. Inc. JavaTM 2 SDK. Standard Edition Documentation Version 1.4.1 EB/OL. Sun Microsystems.Inc.2002指导教师签字：教研室主任签字：2012年3月26日大连交通大学信息工程学院毕业设计(论文)进度计划与考核表学生姓名刘畅专业班级软件工程08-1班指导教师常敬岩史 原本课题其他人员无题目鼎盛4S店零配件管理系统日期计划完成内容完成情况指导老师检查签字第1周拟订毕业论文进度计划与考核表第2周完成实习或调研报告第3周提交外文文献翻译资料第4周系统概要设计阶段第5周系统详细设计阶段第6周系统编码实施、完成论文初稿第7周完成系统编码实施第8周系统编码调试、提交论文初稿第9周完成系统编码调试、完善毕业论文第10周完成撰写毕业设计论文编写及代码测试第11周完成论文终稿、准备毕业论文打印、装订第12周提交毕业论文终稿及代码第13周完成毕业论文第14周毕业论文答辩指导教师签字： 年月日注：“计划完成内容”由学生本人认真填写，其它由指导教师考核时填写。大连交通大学信息工程学院毕业设计(论文)调研报告学生姓名 刘畅 专业班级 软件工程08-1班指导教师 常敬岩 史原 职 称 高工 讲师 所在单位 信息科学系软件工程教研室 教研室主任 刘瑞杰 完成日期 2012年 4月6日Database trendsDatabase management system has experienced 30 years of evolution, has made brilliant achievements, developed into a rich subject, forming a total tens of billions of dollars in a software industry. According to Gartner Dataquest's survey, in 2000 total sales of the international database market $ 8.8 billion, up 10% over 1999. According to CCID's report, China's 2000 total sales of database management systems market, 2.48 billion yuan, compared with an increase of 41.7% in 1999, accounting software market, 10.8% of total sales. Can be seen, the database has become a huge and rapidly growing market.Currently, the representative of the market Oracle's database products, including Oracle, IBM's DB2 and Microsoft SQL Server and so on. In a certain sense, these characteristics of the product reflects the current database, the highest industry standards and trends. Therefore, the analysis of these mainstream product development status of our understanding of database technology is an important aspect of development.Relational database technology is still the mainstreamRelational database technology in the 1970s, after 80 years to 90 years of development is relatively mature, once in the early 1990s by the great challenges of object-oriented database, but the market finally chose a relational database. Whether it is Oracle's Oracle 9i, IBM's DB2, or Microsoft SQL Server are all relational databases. Gartner Dataquest report shows relational database management system (RDBMS) the largest market share in 2000, the RDBMS market share of 80% of the database market, this proportion increased by more than 15% in 1999. This set of data to fully explain today's RDBMS is still the most popular database software. At present, due to the rise of Internet applications, XML-formatted data have emerged, some scholars believe that the next generation of academic database model to support the new XML database. Author of this negative attitude that the relationship between the technology is still the mainstream, whether it is multi-media content management, XML data support, or support for complex objects in a relational system and so will be the core technology based on the expansion. Products to form a series On the one hand, Web and data warehousing applications such as the rise of the absolute amount of data at an alarming rate in the rapid expansion; the other hand, rapid growth in mobile and embedded applications. For the different needs of the market, the database is the direction towards the series. For example, IBM's DB2 Universal Database products ranging from high-end enterprise-class parallel database server, DB2 Everywhere products to the mobile terminal set of series. See from the support platform, today's DB2 on the mainframe is no longer the exclusive product, which supports the current mainstream variety of platforms, including Linux and Windows NT. In addition, it also has a variety of middleware products, such as DB2 Connect, DB2 Datajointer, DB2 Replication, which form a large database of family.Support a variety of Internet applicationsDatabase management system is a network economy, one of the important infrastructure. Support the Internet (and even Mobile Internet) database applications has become an important aspect of database system. For example, Oracle's full support starting from version 8 of Internet applications, the representative of the Internet database. Microsoft is SQL Server as its whole. NET program is an important component. For Internet applications, because users can not be predicted in advance, which requires the database to handle more than before with large amounts of data as well as the more users the ability to provide services, that is to have good scalability and high availability . In addition, the Internet provides a lot of data in XML format is characterized by semi-structured data to support this type of data storage, sharing, management, retrieval is the development direction of the various database vendors.Extended to the intelligent direction of integrationWidespread use of database technology for businesses and organizations to collect and accumulate a large amount of data. Extensive knowledge of the reality of poor data led directly to online analytical processing (OLAP), data warehouse (Data Warehousing) and data mining (Data Mining) and other technologies, to promote the database to the intelligent direction. At the same time more and more complex enterprise applications will involve the application server, Web server, other databases, legacy systems and third party software applications, database products and the software is often a good integration of the entire system performance. Oracle's products include Oracle 9i OLAP, data mining, ETL tools such as a complete set of BI (Business Intelligence) support platform, middleware and its tight integration with the core database features, Oracle Application Server, a key function is to increase cache feature that can unload data from the database to the application server to speed up Web users for data access speed. IBM has also put its BI suite as a key to the development of the database. Microsoft believes that the next generation of business intelligence will be its main profit point.Trends in database technology Data, computer hardware and database applications, these three technologies and systems to promote the development of the database. Database to manage the data complexity and data volumes are growing rapidly; computer hardware platform development is still the practice of Moore's Law; database applications quickly to the depth, breadth. In particular, the emergence of the Internet has greatly changed the database application environment, the database field to make an unprecedented technical challenge. Changes in these factors driving advances in database technology, a number of new database technology, such as Web database technology, parallel database technology, data warehousing and online analytical techniques, data mining and business intelligence, content management technology, massive data management technology. Due to space limitations, this can not be started one by one to explain these changes, but from the sum of these changes in the development of database technology presents the salient features."Four high" that DBMS with high reliability, high performance, high scalability and high security. Database is the core of enterprise information systems and infrastructure, its reliability and performance is of great concern to business leaders. Because, once the downtime will result in huge economic losses businesses, and even lead to legal disputes. The most typical example is the securities trading system, if a market is coming, as trading volume soared, resulting in insufficient capacity of database systems, database systems led to the collapse of securities companies and investors will be to huge losses. Early computer applications in China, as the computer system is not necessary components of business operations, people understand the importance of the database, and in order to save funds are often used on some low-level data management software, such as dBASE, etc., or piracy the software. However, with the deepening of the process of information technology, computer systems increasingly become an indispensable part of the operation, then, stable and efficient database system is a necessary condition. In the Internet environment, but also thousands or tens of thousands of users consider supporting both access and 7x24 hours continuous operation requirements, to provide online data backup, fault tolerance, disaster recovery and information security measures.In fact, the database system is technically stable and efficient long-lasting pursuit. In addition, the development of enterprise information systems from the point of view, a system scalability is very important. As the business expanded, the original size and capacity of the system is no longer time to adapt to new requirements, not to replace the higher-end machines, but based on the original new equipment, such as processor, memory, etc., which to distribute the load purposes. Data security is another important issue, the ordinary mechanisms based authorization can not meet the requirements of many applications, the new role-based authorization mechanisms, and some security elements, such as storage covert channel analysis, mark, encryption, reasoning control and so, in some applications need to be surly."Internet" means the database system to support the application of the Internet environment, information systems to support "Internet visits" to achieve the data exchange between different databases and sharing, to deal with XML data type as the representative of online data, even to consider the development of wireless communications has brought revolutionary change. Compared with traditional databases, the Internet environment, the database system to be equipped to handle larger amounts of data and provide services for more users the ability to provide effective support for long transactions, to provide fast access to XML data type effective support."Synergy" requirement for industry applications, the core of the DBMS, based on the development of a rich suite of database and application components, with manufacturing information, and other areas of e-government suite of applications bundled to form the core of the DBMS for the industry application software product family. To meet application needs, joint development of database and application suite components, database technology has become the new trend and product development. Planning major expansion in Oracle 11i also alleged a variety of major support for the application suite.In the early 1970s, EECodd first proposed the relational model. The mid-1970s, IBM Corporation in the development of SYSTEM R relational database management system developed by the SQL language, the earliest of the SQL language (called SEQUEL2) in November 1976 the IBM Journal of R & D on the published.In 1979, ORACLE Corporation offers the first commercial SQL, IBM's DB2 and SQL / DS database system also achieved SQL. In October 1986, the United States using ANSI SQL relational database management system as a standard language (ANSI X3. 135-1986), after the International Organization for Standardization (ISO) adopted as international standards. In 1989, the U.S. ANSI in ANSI X3.135-1989 to adopt the report as defined in the SQL relational database management system standard language, known as the ANSI SQL 89, instead of the standard ANSI X3.135-1986 version. The standard adopted by the following organizations: the International Organization for Standardization (ISO), for the ISO 9075-1989 report "Database Language SQL With Integrity Enhancement"U.S. Federal Government, published in The Federal Information Processing Standard Publication (FIPS PUB) 127Currently, all major relational database management systems support some form of SQL language, most of the database intended to comply with ANSI SQL89 standard.Advantages of SQLSQL is widely used is indicative of its advantages. It allows all users, including the application programmer, DBA administrators and end users benefit greatly.(1) non-procedural languageSQL is a non-procedural language, because it is a deal with a record of data to provide automatic navigation. SQL allows the user to work on high-level data structures, rather than a single record of the operation, operational records set. Collection of all the SQL statements received as input and returns a collection as output. A collection of SQL feature allows an SQL statement results as input to another SQL statement. SQL does not require the user to specify the data storage method. This feature allows users to more easily focus on the results obtained. All SQL statements use the query optimizer, which is part of the RDBMS, which it has decided to specify the data access speed of the fastest means. The query optimizer knows what indexes exist, where suitable, and the user never needs to know whether there is an index table, the table what type of index.(2) a unified languageSQL DB can be used for all user activity model, including system administrators, database administrators, application programmers, decision support system personnel, and many other types of end users. Basic SQL commands can be learned with little time, the most senior command can be mastered within a few days. SQL provides commands for many tasks,Previous database management system for these types of operations to provide a separate language, and SQL will be fully unified in a language task.(3) is the common language for all relational databaseLanguage developed by Microsoft