Hotel Reservation System using JDBC

A simple java console based application using JDBC(Java Database Connectivity) & MySQL
With The features

• 1.Reserve a room
• 2.View reservation
• 3.Get room number
• 4.Update reservation
• 5.Delete reservation
• 0.Exit

Cretate Table using this query (mySQL):

CREATE TABLE reservations (
  reservation_id INT AUTO_INCREMENT,
  guest_name VARCHAR(255) NOT NULL,
  room_number INT NOT NULL,
  contact_number VARCHAR(10) NOT NULL,
  reservation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (reservation_id)
);

Configure the database settings in the in.manage package using your specific database credentials.

private static final String url = "jdbc:mysql://localhost:3306/DB_Name";
private static final String user = "SQL_userName";
private static final String password = "SQL_Password";

Now dynamically use database:

1) Use those as instance variable

private   String url ="jdbc:mysql://${DB_HOST}:${DB_PORT}/${DB_NAME}";
private   String user ="${DB_USER}";
private   String password="${DB_PASSWORD}";

2) Use this code in Constructor

System.setProperty("DB_HOST", "localhost");
System.setProperty("DB_PORT", "3306");
System.setProperty("DB_NAME", "hotel_db");
System.setProperty("DB_USER","root");
System.setProperty("DB_PASSWORD", "sql@24");

url = replacePlaceholders(url);
user = replacePlaceholders(user);
password = replacePlaceholders(password);

3) Create method to replace Database properties

private String replacePlaceholders(String input) {
  Properties props = System.getProperties(); // Get system properties

  for (String key : props.stringPropertyNames()) {
    input = input.replace("${" + key + "}", props.getProp(key));
  }
return input;
}