Guest User

Untitled

a guest
Mar 14th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. class DatabaseHandling {
  2. Connection conn;
  3.  
  4. public DatabaseHandling() {
  5. try {
  6. Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
  7. } catch (Exception e1) {
  8. System.err.println("Got an exception! ");
  9. e1.printStackTrace();
  10. }
  11.  
  12. }
  13. Boolean establishConnection(String _url, String _login, String _password) {
  14.  
  15. String dbFeed = "jdbc:sybase:Tds:" + _url;
  16. try {
  17. conn = DriverManager.getConnection(dbFeed,_login,_password);
  18. } catch (Exception e2) {
  19. System.err.println("Got an exception! ");
  20. e2.printStackTrace();
  21. }
  22. return true;
  23. }
  24. void closeConnection() {
  25. try {
  26. conn.close();
  27. } catch (Exception e3) {
  28. System.err.println("Got an exception! ");
  29. e3.printStackTrace();
  30. }
  31. }
  32. ResultSet executeQuery(String _query) throws java.sql.SQLException {
  33. ResultSet rs = null;
  34. Statement stmt = null;
  35. try {
  36. stmt = conn.createStatement();
  37. rs = stmt.executeQuery(_query);
  38.  
  39. } finally {
  40. stmt.close();
  41. }
  42. return rs;
  43. }
  44.  
  45. }
Add Comment
Please, Sign In to add comment