Guest User

Untitled

a guest
Apr 15th, 2019
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.61 KB | None | 0 0
  1. import java.sql.*;
  2.  public class oracle
  3. {
  4.     public static void main(String s[])                      
  5.     {
  6.         try
  7.         {
  8.             Class.forName("oracle.jdbc.driver.OracleDriver");
  9.            
  10.             Connection c= DriverManager.getConnection("Jdbc:oracle:thin:@localhost:1521:xe","system","aimca");
  11.             Statement stmt= c.createStatement();
  12.             ResultSet rs=stmt.executeQuery("select * from student_info");
  13.             while(rs.next())
  14.             {
  15.                 System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getInt(3));
  16.             }
  17.             c.close();
  18.         }
  19.         catch(Exception e)
  20.         {
  21.             System.out.println("Error"+e);
  22.         }
  23.    
  24.     }
  25. }
Add Comment
Please, Sign In to add comment