JDBC Connection in Java

JDBC Connection in Java? 

Supporting library download link : http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc3.jar 



package com.pukhraj.blog;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseConnection {

public static void main(String[] args){

try {

Class.forName("org.postgresql.Driver");//"com.mysql.jdbc.Driver"
String url = "jdbc:postgresql://localhost:5432/postgres";//+"jdbc:mysql://localhost/test";
Connection conn = DriverManager.getConnection(url,"username","password");
Statement stmtSelect = conn.createStatement();
String query = "SELECT *  FROM table "; //here you write your SQL query
ResultSet rsSelect = stmtSelect.executeQuery(query);
while(rsSelect.next()){
   long temp = rsSelect.getLong(1);
}
 } catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
 
}

}