9951 explained code solutions for 126 technologies


postgresqlHow can I use PostgreSQL with Java?


PostgreSQL can be used with Java through the JDBC API. To do this, you will need to add the PostgreSQL JDBC driver to your classpath. You can then use the DriverManager class to create a connection to your PostgreSQL database. An example of this is shown below:

// Load the PostgreSQL driver
Class.forName("org.postgresql.Driver");

// Connect to the database
String url = "jdbc:postgresql://localhost/mydatabase";
Connection conn = DriverManager.getConnection(url,"username","password");

Once you have a connection to the database, you can use the Statement and PreparedStatement classes to execute SQL queries and updates. For example, the following code shows how to execute a SELECT query and print out the results:

// Execute a SELECT query
String sql = "SELECT * FROM mytable";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);

// Print out the results
while (rs.next()) {
    System.out.println(rs.getString("column1"));
}

You can also use the JDBC API to create, drop, and modify tables and other database objects.

The following links provide more information on using PostgreSQL with Java:

Edit this code on GitHub