
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!
More Posts related to Java,
- Add two numbers using Java Generics
- Convert Java List to Json String using Jackson
- Convert Java Object to JSON using Jackson Library
- Java SE JDBC: Insert with PreparedStatement Example
- [Program] How to read three different values using Scanner in Java
- Java JDBC Batch Update Example with PreparedStatement
- Java Stream flatmap() Examples
- Save Java Object as JSON file using Jackson Library
- Java get day of the week as an int using DayOfWeek
- Create Nested Directories using Java Code
- Java JDBC Delete a Record in Database Table using PreparedStatement
- List of jars required for Struts2 project
- Convert Java Object to XML using Jackson Library
- Struts2 : java.lang.ClassNotFoundException: org.apache.commons.fileupload.RequestContext
- Java JDBC Get Id of the Inserted Record with AutoIncrement
- How to list all tables using Java JDBC
- Java Jackson ObjectMapper Class with Examples
- Fix: Maven - Failed to execute goal - Compilation failure - Source/Target option 5 is no longer supported. Use 7 or later
- Eclipse : The type java.lang.CharSequence cannot be resolved. Indirectly referenced from required .class files
- Formatting Double in Java [Examples]
- How to run Java Unit Test cases with Apache Maven?
- [fix] NullPointerException Cannot Invoke findById because Repository is null - Java Spring
- [Fix] java: integer number too large compilation error
- [Java] Read a File with UTF-8 Encoding
- How to detect Operating System using Java code
More Posts:
- Get the current timestamp in Java - Java
- Change Terminal Cursor Type in Mac (MacOS Shell) - MacOS
- How to remove unwanted Java imports in IntelliJ (alternative of eclipse Ctrl + Shift + O) - Eclipse
- Take input argument from command line in Python Programming - Python
- [Fix] Connect to Minecraft Remote Connect URL via https //aka.ms/remoteconnect - Microsoft
- Install Python on Alpine Linux - Docker - Docker
- macOS Ventura Login Item Added Google Chrome Notification - MacOS
- Pdf Text to Speech option in Mac OS X Preview App - Mac-OS-X