Koneksi Java dan PostgreSQL menggunakan ODBC

1. Dari control panel, administratif tools, disitu ada data source odbc

2. Install driver postgree SQL

3. Tambahin hostname,port,database,sama userid

4. Odbc sudah beres

5. Untuk keberhasilan koneksi, download aplikasi, http://om4gus.blogspot.com/2008/04/appquery-akses-java-ke-semua-jenis.html

6. Jalankan aplikasinya

7. Code koneksi
   
   

public void testDriver(){
//String dbDrv = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//String dbUrl = "jdbc:microsoft:sqlserver://localhost;DatabaseName="+db;
try{
Class.forName(tDriver.getText());
con = DriverManager.getConnection(tKoneksi.getText(),tUser.getText(),tPass.getText());
stmt=con.createStatement();
lStatus.setText("Driver Connected");
}catch(Exception ce){
System.out.println(ce.toString()+"1");
lStatus.setText(ce.toString());//lStatus.getText()+"\n"+
cbTabel.setModel(new DefaultComboBoxModel());
}
}

8. Fungsi Tes Driver

testDriver();
String perintah="select * from tMhs";
ResultSet hasil=stmt.executeQuery(perintah);
System.out.println(hasil.getObject());

Sumber : (http://om4gus.blogspot.com/2008/07/appquery-in-action-koneksi-java.html)