private void demo5()throws SQLException{
    try(Connection conn=DriverManager.getConnection(System.getenv("HP_JDBC_URL"),
                                                        System.getenv("HP_JDBC_USER"),
                                                        System.getenv("HP_JDBC_PW"))) {
        System.out.print("Find a reservation\n Enter your first name: ");
        String firstName = scanner.nextLine();
        System.out.print("Enter your last name: ");
        String lastName = scanner.nextLine();
        System.out.print("Enter your first date of stay (yyyy-mm-dd): ");
        String checkin = scanner.nextLine();
        System.out.print("Enter your last date of stayn(yyyy-mm-dd): ");
        String checkin = scanner.nextLine();
        System.out.print("Enter your number of children: ");
        Double nChildren = Double.valueOf(scanner.nextLine());
        System.out.print("Enter your number of adults: ");
        Double nAdults = Double.valueOf(scanner.nextLine());

        List<Object> params=new ArrayList<Object>();
        params.add(price);
        StringBuilder sb=new StringBuilder("SELECT * FROM hp_goods WHERE price <= ?");
        if(!"any".equalsIgnoreCase(flavor)) {
            sb.append(" AND Flavor = ?");
            params.add(flavor);
        }

        try(PreparedStatement pstmt=conn.prepareStatement(sb.toString())) {
            int i=1;
            for(Object p:params) {
                pstmt.setObject(i++,p);
            }

            try(ResultSet rs=pstmt.executeQuery()){
                System.out.println("Matching Pastries:");
                int matchCount=0;
                while(rs.next()) {
                    System.out.format("%s %s ($%.2f) %n",rs.getString("Flavor"),rs.getString("Food"),rs.getDouble("price"));
                    matchCount++;
                }
            System.out.format("----------------------%nFound %d match%s %n",matchCount,matchCount==1?"":"es");
            }
        }
    }
}