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…