Guest User

Untitled

a guest
Sep 27th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. import java.sql.*;
  2. public class UserLogin2
  3. {
  4. public static void main(String args[])
  5. {
  6. try
  7. {
  8. //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  9. //String url = "jdbc:odbc:Driver={MicrosoftAccessDriver(*.mdb,*.accdb)};DBQ=+"C:\Users\RONITA DEBNATH\Documents\Student.accdb";
  10. Connection conn;
  11. conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Chandni\\Documents\\Student.accdb");
  12.  
  13. System.out.println("Connection Successfull");
  14. Statement stmt;
  15. stmt = conn.createStatement();
  16. ResultSet rs=stmt.executeQuery("select * from Stu");
  17. if(rs!=null)
  18. {
  19. while(rs.next())
  20. {
  21. System.out.println("ID:"+rs.getString(1)+"Name:"+rs.getString(2));
  22. }
  23. }
  24. stmt.close();
  25. conn.close();
  26. }
  27. catch(Exception e)
  28. {
  29. System.err.println("got an exception");
  30. System.err.println(e.getMessage());
  31. }
  32. }
  33. }
Add Comment
Please, Sign In to add comment