Skip to main content

Posts

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 {
        Class.forName("org.postgresql.Driver");
            Connection connection = null;

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

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