- This is a Car Rental App made in Netbeans using Java and Mysql
- For using the project fork the project and clone it in your local repository.
- Open the project in Netbeans IDE.
git clone https://github.com/afrozchakure/Car-Rental-Java-DBMS-Project.git
- carregistration.
- customer.
- rental.
- login.
- returncar.
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| car_no | varchar(255) | YES | NULL | ||
| make | varchar(255) | YES | NULL | ||
| model | varchar(255) | YES | NULL | ||
| available | varchar(255) | YES | NULL |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| cust_id | varchar(255) | YES | NULL | ||
| name | varchar(255) | YES | NULL | ||
| address | tinytext | YES | NULL | ||
| mobile | int(13) | YES | NULL |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| car_id | varchar(255) | YES | NULL | ||
| cust_id | varchar(255) | YES | NULL | ||
| fee | int(11) | YES | NULL | ||
| date | varchar(255) | YES | NULL | ||
| due | varchar(255) | YES | NULL |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| login_id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(255) | YES | NULL | ||
| password | varchar(255) | YES | NULL |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) | NO | PRI | NULL | auto_increment |
| carid | varchar(255) | YES | NULL | ||
| custid | varchar(255) | YES | NULL | ||
| return_date | varchar(255) | YES | NULL | ||
| elap | int(11) | YES | NULL | ||
| fine | int(11) | YES | NULL |
- This repository is open to contributions 😄. Feel free to raise issues and contribute.