public class Database {

    static Connection myConnection;
    static Statement stat;
    static PreparedStatement preparedStatement;
    static ResultSet results = null;

    public Database(String username, String password, String database, String host){
        try{

            Class.forName("com.mysql.jdbc.Driver").newInstance();
            myConnection = DriverManager.getConnection
                    ("jdbc:mysql://" + host + "/" + database + "?user=" + username + "&password=" + password);
        }catch( Exception e) {
                System.out.println("Error: "+e.getMessage() );

         }
    }


    public static ResultSet read(String selectQuery){

        try {
            //stat = myConnection.createStatement();
            preparedStatement = myConnection.prepareStatement(selectQuery);
            results = preparedStatement.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return results;
    }
// other methods go here
}

// in the constructor
 new Database ("root", "", "westerosdb", "localhost");

public static void addHousesToRegionMenu(List<Menu> theRegions){
        for(Menu region: theRegions){
            ResultSet houses = Database.read("SELECT name FROM `House` WHERE region =""+ region.getId()+"";");
            try {
                while(houses.next()){
                    String houseName = houses.getString("name");
                    Menu house = new Menu(houseName);
                    house.setId(houseName);
                    ResultSet members = Database.read("SELECT memberName FROM `Member` WHERE houseName =""+ houseName+"";");

                    while(members.next()){
                        String memberName = members.getString("memberName");
                        //System.out.println(memberName);
                        MenuItem member = new MenuItem(memberName);
                        member.setId(memberName);
                        house.getItems().add(member);
                    }
                    region.getItems().add(house);
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }