Guest User

Untitled

a guest
Jun 20th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. using System;
  2. using oracle.jdbc.driver;
  3. using java.sql;
  4. using System.Diagnostics;
  5. using System.Collections.Generic;
  6.  
  7. namespace IKVMTest
  8. {
  9. class MainClass
  10. {
  11. public static void Main (string[] args)
  12. {
  13. Stopwatch s = new Stopwatch ();
  14. s.Start ();
  15. List<object> l = new List<object> ();
  16. java.sql.DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver ());
  17. Connection c = DriverManager.getConnection ("jdbc:oracle:thin:@database-host-on-vpn:1521:SID", "scott", "tiger");
  18. Statement stmt = c.createStatement ();
  19. ResultSet rset = stmt.executeQuery("select * from table");
  20. while (rset.next())
  21. l.Add (new { Number = rset.getInt (1) });
  22. stmt.close();
  23. s.Stop ();
  24. Console.WriteLine (l.Count);
  25. Console.WriteLine (s.Elapsed);
  26. }
  27. }
  28. }
Add Comment
Please, Sign In to add comment