Advertisement
Guest User

connection class

a guest
Jul 3rd, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. class connection{
  2. private String server = MyDBInfo.MYSQL_DATABASE_SERVER;
  3. private String username = MyDBInfo.MYSQL_USERNAME;
  4. private String password = MyDBInfo.MYSQL_PASSWORD;
  5. private String database = MyDBInfo.MYSQL_DATABASE_NAME;
  6.  
  7. private Connection con;
  8.  
  9. private ResultSet rs;
  10.  
  11. private Statement statement;
  12.  
  13. public void call() {
  14. try {
  15. Class.forName("com.mysql.jdbc.Driver");
  16.  
  17. con = DriverManager.getConnection("jdbc:mysql://" + server, username, password);
  18. Statement stmt = (Statement) con.createStatement();
  19. stmt.executeQuery("USE " + database);
  20. } catch (SQLException e) {
  21. System.out.println("fuck me");
  22. e.printStackTrace();
  23. } catch (ClassNotFoundException e) {
  24. System.out.println("fuck me now");
  25. e.printStackTrace();
  26. }
  27. }
  28.  
  29. public void sendStatement(String statementString) {
  30. try {
  31. statement = (Statement) con.createStatement();
  32. rs = statement.executeQuery(statementString);
  33. } catch (SQLException e) {
  34. e.printStackTrace();
  35. }
  36. }
  37.  
  38. public boolean isNext() {
  39. boolean isThereNext = false;
  40. try {
  41. isThereNext = rs.next();
  42. } catch (SQLException e) {
  43. e.printStackTrace();
  44. }
  45.  
  46. return isThereNext;
  47. }
  48.  
  49. public String getString(int index) {
  50. String res = null;
  51.  
  52. try {
  53. res = rs.getString(index);
  54. } catch (SQLException e) {
  55. e.printStackTrace();
  56. }
  57.  
  58. return res;
  59. }
  60.  
  61. public void close() {
  62. try {
  63. con.close();
  64. } catch (SQLException e) {
  65. e.printStackTrace();
  66. }
  67. }
  68. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement