public static void main(String args[]) { // get database connection try { conn = (Connection) DBConn.getConnection(); } catch (Exception e1) { System.out.println("Error: No Database Connection. Exiting..."); return; } System.out.println("Welcome to the Hotel Database"); while (true) { // console IO System.out.println( "\nMenu: \n(A) Add Guest \n(B) Delete Guest \n(C) Update Guest \n(D) Find Room " + "\n(E) Book a Room \n(F) Admin Menu"); try { bufferRead = new BufferedReader(new InputStreamReader(System.in)); String s = bufferRead.readLine(); char a = s.toUpperCase().charAt(0); System.out.println("Selected Option: " + a); switch (a) { case 'A': // add guest addGuest(); break; case 'B': // delete guest deleteGuest(); break; case 'C': // update guest updateGuest(); break; case 'D': // search hotels searchHotels(); break; case 'E': // book a room registerRoom(); break; case 'F': // admin menu - seperate adminMenu(); break; default: System.out.println("That option does not exist."); break; } } catch (Exception e) { e.printStackTrace(); } } }
// Para obtener una conexion. private Connection getConnection() { DBConn cnx = new DBConn(); return cnx.getConnection(); }