/TravelAgencyService

Example of a service side of an application for a travel agency

Primary LanguageJavaMIT LicenseMIT

Commit-activity Issues Repo-size License
Forks LinkedIn

TravelAgencyService

Example of a service side of an application for a travel agency.

About The Project

The application allows the user to search the database of travel arrangements of the travel agency. Search data includes travel type (winter, summer, trip, etc.), country, city, and search keyword. Maven Java Web application was build for working with TravelAgencyDB, as well as expose the data through the REST API so that it can be accessed from Android client application. Access to databases is performed via the JDBC API.

The operation of the service has been confirmed by the Postman client.

Built With

This are the major frameworks that are used to built this project.

Design

Database Scheme

Database scheme

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

1. Download and install Apache NetBeans and Wamp Server,

2. Run Wamp server on your local machine,

3. In Apache NetBeans IDE add a GlassFish server instance on localhost on HTTP port 8080.

Running the app

1. Clone the repository

git clone https://github.com/StokicDusan/TravelAgencyService.git

2. Launch the server and import the test database from

src\main\resources\database

3. Open Apache NetBeans IDE and import the project as a Maven Java Web Application

4. Go to com.etf.zadatak2.dao\ResourcesManager.java and edit the JDBC_CONNECTION_STRING

JDBC_CONNECTION_STRING = "jdbc:mysql://localhost:<PORT_USED_BY_MYSQL>/<NAME_OF_DB>?user=root&password=";
<PORT_USED_BY_MYSQL>: should be checked on the server (usually 3306 or 3308)
<NAME_OF_DB>: should be travelagencydb1 if database imported as is.

5. Launch

  1. Start the GlassFish server
  2. Build the project with dependencies
  3. Run project

6. Verify

Go to http://localhost:8080/TravelAgencyService to check that the app is up and running.

In the postman directory are collections of tests for all functionalities provided by the service.

Provide Feedback

If you encounter any bugs or have suggestions, please file an issue in the Issues section of the project.