Java JDBC Connection with PostgreSQL Driver Example


Post Banner

In this Tutorial, we will take a look at how to do Java JDBC Connection with PostgreSQL Driver Example,

Step 1: Download PostgreSQL Driver Jar File

Go to https://jdbc.postgresql.org/download.html and download the jar file, PostgreSQL JDBC 4.2 Driver, 42.5.0 is the latest one to download

PostgreSQL JDBC 4.2 Driver, 42.5.0
PostgreSQL JDBC 4.1 Driver, 42.2.26.jre7
PostgreSQL JDBC 4.0 Driver, 42.2.26.jre6

Step 2: Add the PostgreSQL Driver Jar to Java Classpath:

For Eclipse:
 - Right-Click on your Project Folder,
 - Now Select Build Path,
 - Now Click on Configure Build Path,
 - Now Click on Libraries -> Add External JARs,
 - Now select the Oracle JDBC jar.
 - Finally, click Apply and Ok.

Step 2: Java Code JDBC Connection using PostgreSQL Database

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class JavaJDBCExampleWith PostgreSQLeDB {

    private static String PostgreSQL_DB_URL = "jdbc:postgresql://localhost:5432/postgresql_db";
    private static String PostgreSQL_DB_USER = "root";
    private static String PostgreSQL_DB_USER_PASSWORD = "root1234";

    private static String SQL_QUERY = "Select * from employees";


    public static void main(String[] args) {
            
        try(Connection connection = DriverManager.getConnection(PostgreSQL_DB_URL, PostgreSQL_DB_USER, PostgreSQL_DB_USER_PASSWORD)) {
            Statement statement =connection.createStatement();  
            ResultSet resultSet = statement.executeQuery(SQL_QUERY); 
            while(resultSet.next())  {
                System.out.println(resultSet.getInt(1)+"  "+resultSet.getString(2));
            }     
                
        } catch (SQLException e) {
            System.out.println("Error occured while executing query: " + SQL_QUERY);
            e.printStackTrace();
        } 
    }

}


Have Questions? Post them here!
Advertisements
Try Out Code2care Dev Tools:

Advertisements

Advertisements
Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and software developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include learnings, tutorials, trouble-shooting steps, video tutorials, code snippets, how-to, blogs, articles, etc.

🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.