Taxi-Service

⚡ Project description:

A simple web-application that supports authentication, registration and other CRUD operations.

Demo link - deployed on hosting with Tomcat 8.5.89 and Java 11.0.19

🎯 Features:

• registration like a driver;
• authentication like a driver;
• create/remove a manufacturer;
• create/remove a car;
• create/remove a driver;
• display list of all manufacturers;
• display list of all cars;
• display list of all drivers;
• display list of my cars;
• add driver to car.

Used technologies

Java 11, Servlet, JDBC, JSP, JSTL, Maven, HTML, CSS

⚙️Installation:

To run this project you need to install:

• IntelliJ IDEA Ultimate
• Java 11
• Tomcat 9.0.50
• MySQL Installer
• MySQL Workbench

🧬 Settings

After installation, you should do the following:

• Add this project to IntelliJ IDEA Ultimat
• Configure Tomcat
• Connecting to the database with MySQL Workbench
• To get the actual parameters of the database tables, run script from the resources/init_db.sql file in the Workbench
• Insert sql query to have registered user (Login: root Password: 1234)

INSERT INTO drivers (name, license_number, login, password) VALUE ('Admin', 'ABB123456', 'root', '1234');

• Establish a database connection using the file java/taxi/util/ConnectionUtil, replace with your settings

Example:

private static final String URL = "YOUR_URL";
private static final String USERNAME = "YOUR_USERNAME";
private static final String PASSWORD = "YOUR_PASSWORD";
private static final String JDBC_DRIVER = "YOUR_JDBC_DRIVER";

• Run the project using Tomcat 9.0.50

☕ P.S. To create a car, you must first create a manufacturer

Enjoy 💛💙