| The electronic tour guide is the all kinds of guide device use of electronic technology, signal processing technology.High-tech electronic tour products with high reliability, strong practicability,not only improve the quality of tourism service also stimulate the development of the tourism industry.Visitors can obtain the attractions and exhibits in detail by holding the electronic tour guide. As mobile intelligent terminal under the condition of rapid development, the traditional electronic guides is in the technical innovation.This article first introduces the development of the electronic guide on the theory and application of both at home and abroad, analyzes its advantages and disadvantages, and then introduced the technology this paper will be used such as Android development technology,bluetooth technology, multimedia technology, baidu map technology, mobile payment and qr code related technologies, etc. Then the xijiang scenic area as the backing, get the function of electronic guide by analysising of the needs of tourists, and describe the system function module design was in detail. Then focuses on the SQLite database, including the structure of the database design,program design, database and table creation, and all kinds of data in the database are introduced in detail the operation method, aiming at the problem of SQLite database security mechanism is particularly weak, do the database security design. Finally introduce the system how to achive function combining the bluetooth in detail, and do the system function and performance test.This article puts forward the solution, using bluetooth positioning can be timely and accurate position of the positioning of tourists and automatically guides, successfully transplanted electronic guide to intelligent mobile terminal platform, and solved the mobile intelligent terminals located in the scenic area by base station and GPS positioning is not accurate. To research the SQLite embedded database security in guarantee under the condition of the running speed, maximum limit to ensure their safety. In addition, the paper realized in the basic function of electronic guide, added qr code of the scenic spot electronic ticket purchase, information releaseand the expansion of the industry function of scenic spots, and final testing effect is good, the system has the certain promotion value. |