
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!
- Create a Zip file using Java Code programmatically
- Eclipse : A java Runtime Environment (JRE) or Java Development kit (JDK) must be available
- How to Sort a LinkedList in Java
- Loading class com.mysql.jdbc.Driver. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver
- How to declare and initialize Array in Java Programming
- [Fix] java: integer number too large compilation error
- Java JDBC Connection with MySQL Driver in VS Code + Troubleshooting
- Reading .xls and .xlsx Excel file using Apache POI Java Library
- IntelliJ: Error: Could not find or load main class, java.lang.ClassNotFoundException
- How to get Client IP address using Java Code Example
- Truncate table using Java JDBC Example
- Struts 2 : There is no Action mapped for namespace [/] and action name [form] associated with context path [/proj]
- How to get file path in Idea IntelliJ IDE
- Java Generics explained with simple definition and examples
- Java SE 8 Update 301 available with various bug fixes and security improvements
- Java: Collect Stream as ArrayList or LinkedList
- Java JDBC Connection with PostgreSQL Driver Example
- How to check if Java main thread is alive
- How to fix Java nio NoSuchFileException wile reading a file
- Java 8+ get Day of the Week Examples with LocalDateTime, DateTime, ZonalDateTime and Instant classes
- Ways to Convert Integer or int to Long in Java
- [Java] How to throws Exception using Functional Interface and Lambda code
- [Fix] Spring Boot: mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
- Java: The value of the local variable string is not used
- Java JDBC: Insert Java 8 LocalDate and Time using PreparedStatement
- What is Bootstrap Jumbotron and how to use it - Bootstrap
- Test internet speed using macOS Terminal command - MacOS
- Android Eclipse This version of the rendering library is more recent than your version of ADT plug-in. Please update ADT plug-in - Android
- Spring Boot: @RequestBody not applicable to method - Java
- 20 - Python - Print Colors for Text in Terminal - 1000+ Python Programs - Python-Programs
- Set width and height for the label in tkinter - Python
- Install AWS CLI using Brew Command - AWS
- How to fix Java HTTP java.net.UnknownHostException - Java