Guest User

Untitled

a guest
Mar 11th, 2019
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. import java.sql.*;
  2. import java.io.*;
  3. class second
  4. {
  5. public static void main(String arg[])throws Exception
  6. {
  7. Class.forName("oracle.jdbc.driver.OracleDriver");
  8. System.out.println("driver loaded");
  9. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","oracle");
  10. System.out.println("connection established");
  11. Statement st=con.createStatement();
  12. System.out.println("statement created");
  13. st.executeUpdate("create table cse(no number,name varchar)");
  14. System.out.println("table created");
  15. st.executeUpdate("insert into cse values(1,'kevin')");
  16. st.executeUpdate("insert into cse values(2,'john')");
  17. st.executeUpdate("insert into cse values(3,'alvin')");
  18. System.out.println("3 rows inserted");
  19. ResultSet rs=st.executeQuery("select *from cse");
  20. while(rs.next())
  21. {
  22. System.out.println(rs.getInt(1)+" "+rs.getString(2));
  23. }
  24. rs.close();
  25. st.close();
  26. con.close();
  27. }
  28. }
Add Comment
Please, Sign In to add comment