JDBC - Connecting to PostgreSQL database

 Add the PostgreSQL JDBC driver dependency to your Maven pom.xml file:

 <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.5.0</version>
        </dependency>


DBConnection.class

package com.ict.dev;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {

private static final String DB_URL = "jdbc:postgresql://localhost:5432/postgres";	
private static final String USERNAME = "postgres";
private static final String PASSWORD = "root";
	
	public static Connection getConnection() {
		
		
		Connection conn = null;
		
		try {
			conn = DriverManager
					.getConnection(DB_URL, USERNAME, PASSWORD);
			System.out.println("Connected to Database");
			
		}catch(Exception e) {
			System.out.println(e);		
			}finally {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		return conn;
	}
	
	
}

Comments