|
This paper analyzes and implements a database management system based on B / S ( browser / server ) , it is a sales management system for the Civil Aviation agent . Civil Aviation agent daily ticket processing , including ticket entry , ticket changes , ticket inquiries delete ticket ticket refund system functionality . The system also provides reporting and statistical functions , according to the ticket number , leg , airlines , time , salesperson statistics and generate a variety of reports , financial work to help . In addition, the system provides staff management , you can set up different users and the appropriate permissions of the administrator , ticketing , financial statisticians , makes a variety of staff carry out their duties not ultra vires other work . Security , set up a user name and password authentication to prevent unauthorized users from logging and unauthorized operation . The system is technically based on three - tier architecture of B / S ( browser / server ) architecture is about application is divided into three layers: the user interface layer , business logic layer , database layer . Database using Microsoft ACCESS, connect through JDBC and database with JAVA language programming . Software design patterns Model 2 Model of the MVC pattern , such as the JSP, JAVABEAN and SERVLET technology to view in the MVC pattern , the model and control program . The system to achieve a variety of business the day - to - day work of the Civil Aviation agent , provided the treatment and management of the day - to - day ticketing , reports, and personnel management software, electronic and automation of the normal operations of the Civil Aviation agent , to solve the the shortcomings of past human management process . Technically advanced MVC pattern applied to the system , a breakthrough software architecture model . System has important practical significance for the agent 's work and will be applied in practical work .
|