import com.opentable.db.postgres.embedded.EmbeddedPostgres;
import java.sql.*;
public class Main {
public static void main(String[] args) throws Exception {
EmbeddedPostgres embeddedPostgres = EmbeddedPostgres.builder()
.setPort(5432)
.start();
String url = "jdbc:postgresql:postgres";
String username = "postgres";
String password = "";
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
while (resultSet.next()) {
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println(name + " - " + age);
}
resultSet.close();
statement.close();
connection.close();
embeddedPostgres.close();
}
}
