9.JDBC CONNECTIVITY

  import java.sql.*; public class database { public static void main(String args[]) { try { Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println("Oracle Database Connectivity"); System.out.println("############################\n\n"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@192.168.23.237:1521:orcl", "scott","tiger"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("SELECT * FROM Login"); System.out.println("Username\tPassword"); System.out.println("********\t********"); while(rs.next()) System.out.println(rs.getString(1)+"\t\t"+rs.getString(2)); con.close(); } catch(Exception e) { System.out.println(e); } } } Output: Oracle Database Connectivity ############################ Username Password ******** ******** Anitha 123 James 456 George 789

Comments