基于手机的旅游路线查询系统数据库及查询接口设计毕业论文.doc

本科毕业论文 (科研训练、毕业设计) 题 目：基于手机的旅游路线查询系统 数据库及查询接口设计 姓 名： 学 院：软件学院 系：软件学院 专 业：软件工程 年 级：级转专业 学 号： 指导教师（校内）： 职称：副教授 年 月 日 基于手机的旅游路线查询系统 数据库及查询接口设计 [引言] 本文通过程序段、图表、文字，对手机查询旅游路线所需的数据库进行了描述，剖析了这个程序的流程概况：后台使用Microsoft Access作为数据源，前台使用WAP语言来对数据库进行访问操作。JAVA语言成为数据操作的载体，进行数据库数据的调用、添加、修改。由于只是供实验用的小程序，选择用Tomcat5.0做服务器，不支持太多用户同时访问，数据库则采用小型的Microsoft Access。数据库的取用采用节约资源的原则，每次取用完，自动将内存回收，提高再次访问的速度。数据库接口的提供采用了多层结构，将数据库连接、关闭封装在底层的类中，上层的类只要用sql语句，就能返回结果。并以此为基础，提供旅游路线查询系统所需要的各种接口及对数据库管理的各种接口。有的功能由于数据的原因或实用性不大，只提供接口，功能可根据需要进行必要的扩展。 [关键词] 数据库连接池 Servlet Java Server Page Tourism Line Query System By MobilePhone —Design of database and query interface [Abstract] The paper describe the database which are needed by the mobile phone tourism line query by programs , graphs and characters .It analyzed the general situation of this program .The Microsoft Access is used as the database resource in the background , and then the on the stage we use WAP language to visit the database . The JAVA language is used as the carrier of the data operation.It can be used for loading,adding changing the database . For the reason that the programs is only a small program used for experiment , we chose the Tomcat 5.0 as server. It could not be able to serve too many users at the same time. Then the database we chose the Microsoft Access, known as a good database for small sums of users. We believe a principle at the process of using the database that the less computer resource we used , the better we could performed. So after every time we finished the fetch of the data ,the program give the memory resource back to the computer automatically. It makes the next fetching faster.The database interface used multilayer structure . It makes the connection and the closure of the database at the class of ground floor . It is only need for the class of the upper floor to use sql language to get the result .