private String getCustomersResults() throws SQLException {
log.info("The customer results will be printed");
String url = "jdbc:postgresql://10.233.1.40:5432/postgres";
Properties props = new Properties();
props.setProperty("user", "postgres");
props.setProperty("password", "postgres");
Connection conn = DriverManager.getConnection(url, props);
Statement statement = conn.createStatement();
log.info("select price from public.customer_rating");
ResultSet rs = statement.executeQuery("select price from public.customer_rating");
String price = "";
while (rs.next()) {
price = rs.getString("price");
}
log.info("The price is " + price);
rs.close();
conn.close();
return price;
}