Skip to main content


Showing posts from November 26, 2010

Connecting to postgres database in java code

To connect you java program with postgres driver, add the postgres library jar (postgresql-jdbc3-8.2.jar or any current jar file) file in the libraries. Then the following code can be modified for your particular database and table.

package javaapplication1;
import java.sql.*;
 * @author shankar
public class Main {

     * @param args the command line arguments
    public static void main(String[] args) {
        // TODO code application logic here
          System.out.println("-------- PostgreSQL JDBC Connection Testing ------------");

      try {
            Connection connection = null;

             connection = DriverManager.getConnection("jdbc:postgresql://","postgres", "postgres");
       if (connection != null)

                  Statement s=connection.createStatement();
                  String query="select ad_a…