基于SSH的电影院网上订票系统的设计与实现

发布时间：2018-09-09 08:34

【摘要】：伴随着我国全面推动信息化及互联网+建设的趋势,国家的各个行业均在朝着互联网方向进发,影视行业也是面临这样的使命与挑战。本文介绍的电影院网上订票系统就是一个解决当前传统电影院售票的方式存在的问题,使电影的发行及销售顺应互联网及电子商务的有效措施。本论文主要设计目标是一个电影院网上订票系统,主要创新点为SSH整合框架技术和My SQL查询优化这两方面的研究。在分别详细研究SSH框架特点,仔细分析其不同整合方式优缺点的基础上总结出契合Web应用三层(表示层、业务逻辑层和数据持久层)结构最佳的SSH框架整合技术方案,并在此基础上设计实现了基于SSH整合框架的电影院网上订票系统。在系统数据库设计中,本论文重点对My SQL查询优化技术从My SQL配置参数调优和My SQL查询重用功能两个方面进行了研究。并提出数据库查询优化措施,包括对My SQL数据缓冲区和日志缓冲区参数的调优,以及通过设计算法来消除SQL语句多余字符及规范化SQL语句中的关键词来提高My SQL查询结果重用的概率,从而提高了My SQL的查询性能并进行了相关测试验证。本论文最终确定系统采用B/S开发架构,设计符合MVC设计模式,将功能分为前端会员购票模块和系统管理维护模块。其中会员功能模块包括会员注册及登录及电影票订购处理等,管理维护模块是系统管理员对影院信息、售票信息、影片信息及会员信息等的管理维护功能。
[Abstract]:With the trend of promoting information technology and Internet construction in our country, all industries in our country are moving towards the Internet, and the film and television industry is also facing such a mission and challenge. The online booking system for cinemas introduced in this paper is an effective measure to solve the problems existing in the traditional cinema ticket selling methods and to make the distribution and sale of films conform to the Internet and e-commerce. The main design goal of this paper is a cinema online booking system. The main innovation is SSH integration framework technology and My SQL query optimization. On the basis of studying the characteristics of SSH framework in detail and analyzing the merits and demerits of different integration methods, this paper summarizes the best technical solution of SSH framework integration which fits the three layers of Web application (presentation layer, business logic layer and data persistence layer) structure. On this basis, a cinema online booking system based on SSH integrated framework is designed and implemented. In the system database design, this paper focuses on the My SQL query optimization technology from the two aspects of My SQL configuration parameter tuning and My SQL query reuse function. The optimization measures of database query are put forward, including tuning the parameters of My SQL data buffer and log buffer. The algorithm is designed to eliminate the redundant characters in SQL statements and the keywords in the normalized SQL statements to improve the probability of reusing My SQL query results. Thus the query performance of My SQL is improved and the relevant tests are carried out. This paper finally determines that the system adopts the B / S development framework and the design conforms to the MVC design pattern. The function is divided into front-end member ticket purchase module and system management and maintenance module. The member function module includes member registration, login and film ticket order processing, and the management and maintenance module is the management and maintenance function of the system administrator to the cinema information, ticket sales information, film information and member information.
【学位授予单位】：河北科技大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.52

【参考文献】