Design And Implementation Of The Cinemas Online Booking System Based On SSH Framework

China is now promoting to national's informational construction,and all walks of life are running for this promotion of information.At the same time,cinema enterprises also face the challenges and tasks of information technology.The cinemas online booking system which designed in this article is an effective attempt to solve the various problems existed in the traditional movie ticket booking,and also an attempt that make the film distribution more adaptive to the Internet technology and e-commerce maturity.The design goal of this project is a cinema online booking system.And the two key points in this article were SSH integration framework technology and My SQL query optimization.Firstly,the technical features of Spring,Struts and Hibernate framework were studied in detail.Then to fit the three layers(View Control Model)of the Web application program perfectly,a comparison between deferent integration ways of these three frameworks was made.And then,based on this framework,a cinemas online booking system has been designed and accomplished.Through the system database design process,the My SQL query optimization was specially studied at two aspects respectively included optimization of the My SQL parameter configuration and My SQL query results' reuse.Accordingly,some database query optimization measures of the online booking system were proposed,which included the optimization of the log buffer and data buffer parameters and the algorithms to clear redundant chars and normalize keywords in SQL statement.Then some verification test was made.Finally,the system adopt B/S development framework.Based on the MVC design pattern,the functions of this system were divided into front-end function module and admin module.The front-end functions used for members to register login and book,and the functions of the admin module are for the management of cinemas,movies,tickets and members.