public void findHiddenPrice() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            System.out.println("Where is your MySQL JDBC Driver?");
            e.printStackTrace();

        }
        PreparedStatement ps = null;
        Connection con = null;
        ResultSet rs;
        try {

            con = DriverManager.getConnection("jdbc:mysql://mysql2.cs.stonybrook.edu:3306/mlavina", "mlavina", "108262940");
            if (con != null) {
                con.setAutoCommit(false);
                String sql = "SELECT Fare FROM mlavina.fare where FareType = 'Hidden' AND AirlineID = ? AND FlightNo = ? and Class =  ? ;";

                ps = con.prepareStatement(sql);
                ps.setString(1, selectedFlight.airlineID);
                ps.setInt(2, selectedFlight.flightNo);
                ps.setString(3, selectedFlight.seatClass);

                try {
                    ps.execute();

                    rs = ps.getResultSet();

                    if (rs.next()) {
                        this.hiddenPrice = rs.getDouble(1);
                    }
                    System.out.println("Hidden Price" + hiddenPrice);
                    con.commit();
                } catch (Exception e) {
                    con.rollback();
                }

                if (flightDirection.equals("Round-Trip")) {
                    sql = "SELECT Fare FROM mlavina.fare where FareType = 'Hidden' AND AirlineID = ? AND FlightNo = ? and Class =  ? ;";

                    ps = con.prepareStatement(sql);
                    ps.setString(1, selectedReturnFlight.airlineID);
                    ps.setInt(2, selectedReturnFlight.flightNo);
                    ps.setString(3, selectedReturnFlight.seatClass);

                    try {
                        ps.execute();

                        rs = ps.getResultSet();

                        if (rs.next()) {
                            this.hiddenReturningPrice = rs.getDouble(1);
                        }
                        con.commit();
                    } catch (Exception e) {
                        con.rollback();
                    }
                }
            }

        } catch (Exception e) {
            System.out.println(e);
        } finally {
            try {
                con.setAutoCommit(true);
                con.close();
                ps.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

    }