Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. String url = "jdbc:ucanaccess:\C:/Access.ACCDB";
  2. String query = "select * from [Donations]";
  3. try
  4. {
  5. java.sql.Connection con =DriverManager.getConnection(url, "","");
  6. Statement stmt = con.createStatement();
  7. ResultSet rs = stmt.executeQuery(query);
  8. while (rs.next())
  9. {
  10.  
  11. System.out.println("Account No: " + rs.getString(1));
  12. System.out.println("Surname: " + rs.getString(2));
  13. System.out.println("First Name: " + rs.getString(3));
  14. }
  15. }
  16. catch(SQLException ex)
  17. {
  18. while (ex!=null)
  19. {
  20. System.out.println ("SQL Exception: " + ex.getMessage ());
  21. ex = ex.getNextException();
  22. }
  23. }
  24. catch(java.lang.Exception ex)
  25. {
  26. ex.printStackTrace();
  27. }
  28.  
  29. String url = "jdbc:ucanaccess://www.filetolink.com/download/?h=eaa4aab688d25e270539868d712961ab&t=1467140283&f=3ca9ad1869;";
  30. String query = "select * from [Donations]";
  31. try
  32. {
  33. java.sql.Connection con =DriverManager.getConnection(url, "","");
  34. Statement stmt = con.createStatement();
  35. ResultSet rs = stmt.executeQuery(query);
  36. while (rs.next())
  37. {
  38.  
  39. System.out.println("Account No: " + rs.getString(1));
  40. System.out.println("Surname: " + rs.getString(2));
  41. System.out.println("First Name: " + rs.getString(3));
  42. }
  43. }
  44. catch(SQLException ex)
  45. {
  46. while (ex!=null)
  47. {
  48. System.out.println ("SQL Exception: " + ex.getMessage ());
  49. ex = ex.getNextException();
  50. }
  51. }
  52. catch(java.lang.Exception ex)
  53. {
  54. ex.printStackTrace();
  55. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement