Abstract In the 21st century, the application of Internet technology in life has become more and more mature,which is not only related to our life but also to office,after all, the traditional management and recording work has many shortcomings obviously,such as:low efficiency, poor confidentiality,heavy recording task ,inconvenience of manual query and so on。Therefore,in order to help modern people work more effectively,manage more simply,even more effective maintenance and management,on this basis, I finish the hotel management system。
This hotel management system uses the JSP, server,browser and other related technology。 To make the connection time to be shorter,database connection uses the c3p0 connection pool,which is also a lot faster than the traditional query speed。I aslo also use the third party framework to make it easier exporting recent income execl。The system uses the MySQL database connection, convenient, better to write and modify。but MySQL needs to build the table on the console,once you write something wrong, you need to re-enter your all data again,it is too messy。so here the use of SQLyog graphics chemical tools to manage the MySQL database, so that the database connection, build tables are more convenient。
Key words: hotel management system;c3p0;third party framework;MySQL database;SQLyog