Пример #1
0
  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();
      }
    }
  }
Пример #2
0
  // Para obtener una conexion.
  private Connection getConnection() {

    DBConn cnx = new DBConn();
    return cnx.getConnection();
  }