Skip to main content

Posts

Showing posts with the label JDBC Connection in Java

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 (Class...