import java.sql.*;
public class PgJdbcNgExample {
public static void main(String[] args) {
String url = "jdbc:pgsql://localhost:5432/mydb";
String username = "myuser";
String password = "mypassword";
try (Connection connection = DriverManager.getConnection(url, username, password)) {
String query = "SELECT * FROM employees";
try (Statement statement = connection.createStatement()) {
try (ResultSet resultSet = statement.executeQuery(query)) {
while (resultSet.next()) {
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
}
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
<dependencies>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.24</version>
</dependency>
</dependencies>
dependencies {
implementation 'org.postgresql:postgresql:42.2.24'
}
