JDBC Without Creating DSN
&import java.sql.*; public class FirstJDBC { public static void main(String arg[]) { try { /*Registering Driver*/ DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); /*Creating Connection*/ Connection con= DriverManager.getConnection("jdbc:oracle:thin:@hostname:1521:database","Username","Password"); Statement st=con.createStatement(); ResultSet result=st.executeQuery("Select * from table_name"); while(result.next()) { System.out.println(result.getInt(1)); System.out.println(result.getString(2)); System.out.println(result.getString(3)); } } catch(Exception expObj) {System.out.print(expObj);} } }