Advertisement
Guest User

Untitled

a guest
Jan 4th, 2017
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.PreparedStatement;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5.  
  6. public class Test2 {
  7.  
  8. private String driver = "jdbc:ucanaccess://";
  9. private String dBase = "/home/oprsec/Downloads/Database/Assignment2.accdb";
  10. private String url = driver + dBase;
  11. protected Connection connection = null;{
  12. driver = "jdbc:ucanaccess://";
  13. dBase = "/home/oprsec/Downloads/Database/Assignment2.accdb";
  14. url = driver + dBase;
  15. }
  16.  
  17. public Test2(){
  18. try {
  19. connection = java.sql.DriverManager.getConnection (url);
  20. } catch (SQLException e1) {
  21. // TODO Auto-generated catch block
  22. e1.printStackTrace();
  23. }
  24.  
  25. try {
  26. PreparedStatement statement = (this.connection.prepareStatement("your sql here"));
  27. statement.execute();
  28. } catch (SQLException e) {
  29. // TODO Auto-generated catch block
  30. e.printStackTrace();
  31. }
  32.  
  33.  
  34. }
  35.  
  36. public static void main(String[] args){
  37. Test2 test = new Test2();
  38. }
  39.  
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement