Skip to main content

Posts

Showing posts from July, 2018

oracle database connectivity

//note: must be include a jar file ojdbc14.jar //include in c:\programfiles \java\jdk1.7.0\jre\lib\ext import java.sql.*; import java.io.*; public class prac2 { public static void main(String args[])a     { try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con =DriverManager.getConnection("jdbc:oracle:thin:@localhost:1000:xe","system","abc"); Statement sta=con.createStatement(); ResultSet rs=sta.executeQuery("select * from student"); while(rs.next()) System.out.println(rs.getInt(1)+" "+rs.getString(2)); con.close(); } catch(Exception e) { System.out.println("error generated"+e); }    } }