The Tour Guide is a java based website that helps the tourists in planning their tour of a completely anonymous place he wants to explore. This website plans the tour such that the user can save more time in exploring maximum places rather than wasting time in reaching his destinations. It takes the information such as location, the list of places the user wants to visit, the start and end place of the tour to make the plan.
Initially, it takes the information about the location the user is in. Then it will show the list of places of attractions of that place from which the user can opt the places of his choice according to his priority. Then it takes the start and the end place of the tour. After making an analysis of the distances between all the places into account a route map with the shortest possible path is displayed.
This website is very useful to all the people who love to travel in planning a time efficient trips where he or she can save time to visit new places rather than getting lost in an unaware place.
PROPOSED AND EXISTING COMPARISION
For people who want the trip planned entirely, who don’t want to use the filtering method of pen and paper or trace filtering tour guide helps them completely. The tour guide is a website that helps vacation goers plan out where to go and what to see based on their interests.
The website like Trip advisor shows only the places to visit in a city but not with an appropriate plan. Some other existing websites like Inspirock, Make My Trip shows the plan on its own basis but not with customer’s priority. The tour guide shows the best plan that matches with your interest of places to visit in a city.
Software Requirements:
NetBeans7.4, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript and CSS.
UML Diagrams:
UseCase Diagram:
Sequence Diagram:
Class Diagram:
Activity Diagram:
Home Page:
User Login Page:
Get Location Page:
Load Map Page:
Multiple Locations Page:
[code lang=”sql”]
DB Scripts
CREATE TABLE `locations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
`address` varchar(80) NOT NULL,
`lat` float(10,6) NOT NULL,
`lng` float(10,6) NOT NULL,
`city` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `userdetails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstName` varchar(255) NOT NULL,
`lastName` varchar(255) NOT NULL,
`emailAddress` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`mobile` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (1,’Charminar’,’Charminar, Hyderabad, Telangana, India’,17.361431,78.474533,’Hyderabad’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (2,’Golkonda’,’Golconda Fort, Hyderabad, Telangana, India’,17.382330,78.401604,’Hyderabad’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (3,’Hussain Sagar’,’Hussain Sagar, Hyderabad, Telangana’,17.423880,78.473824,’Hyderabad’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (4,’Ramoji Film City’,’Ramoji Film City, Telangana, India’,17.255827,78.682419,’Hyderabad’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (5,’Chowmahalla Palace’,’Chowmahalla Palace, Telangana, India’,17.357725,78.471703,’Hyderabad’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (6,’Salar Jung Museum’,’Salar Jung Museum, Telangana, India’,17.371201,78.479797,’Hyderabad’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (7,’Lal Bagh’,’Lal Bagh, Karnataka, India’,12.949859,77.583282,’Bangalore’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (8,’Bannerghatta National Park’,’Bannerghatta National Park, Bannerughatta, Bengaluru, Karnataka 560083′,12.800359,77.577606,’Bangalore’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (9,’Cubbon Park’,’Vasanth Nagar, Bengaluru, Karnataka 560001, India’,12.981182,77.596886,’Bangalore’);
INSERT INTO `locations` (`id`,`name`,`address`,`lat`,`lng`,`city`) VALUES (10,’Bangalore Palace’,’Palace Road, Bengaluru, Karnataka 560052, India’,12.998696,77.592026,’Bangalore’);
[/code]
Download Tour Guide Java Project Source Code, Database, Project Report Documentation, PPT, UML Diagrams