Guest User

Untitled

a guest
Oct 23rd, 2016
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.51 KB | None | 0 0
  1.  
  2. import java.io.IOException;
  3. import java.sql.*;
  4. import java.util.ArrayList;
  5.  
  6. /**
  7. * Created by Natan on 23.10.2016..
  8. */
  9. public class Practice
  10. {
  11. static String mysql = "jdbc:mysql://localhost:3306/travel?autoReconnect=true&useSSL=false";
  12. static String username = "root";
  13. static String password = "student";
  14. Connection conn;
  15. boolean var;
  16.  
  17. public Practice(String mysql, String username, String password)
  18. {
  19. this.mysql = mysql;
  20. this.username = username;
  21. this.password = password;
  22. }
  23.  
  24. public boolean connect()
  25. {
  26. boolean var = false;
  27. try
  28. {
  29. conn = DriverManager.getConnection(mysql, username, password);
  30. if(conn == null)
  31. {
  32. var = false;
  33. }
  34. else
  35. {
  36. var = true;
  37. }
  38. }
  39. catch(SQLException sqle)
  40. {
  41. System.out.println("fdssdf");
  42. }
  43. return var;
  44. }
  45.  
  46. public boolean close()
  47. {
  48. boolean var = false;
  49. try
  50. {
  51. conn.close();
  52. if(conn.isClosed())
  53. {
  54. System.out.println("Connection closed");
  55. var = true;
  56. }
  57. else
  58. {
  59. System.out.println("Connection not closed");
  60. var = false;
  61. }
  62. }
  63. catch(SQLException sqle)
  64. {
  65.  
  66. }
  67. return var;
  68. }
  69.  
  70. public ArrayList<Student> getData(String sql)
  71. {
  72. ArrayList<Student> list = null;
  73. int passengerid = 0;
  74. String fname = null;
  75. String lname = null;
  76. try
  77. {
  78. Statement statement = conn.createStatement();
  79. ResultSet rs = statement.executeQuery(sql);
  80.  
  81. while(rs.next())
  82. {
  83. passengerid = rs.getInt(1);
  84. fname = rs.getString(2);
  85. lname = rs.getString(3);
  86. }
  87.  
  88. System.out.println("PassengerID " + passengerid + "\n");
  89. System.out.println("PassengerID " + fname + "\n");
  90. System.out.println("PassengerID " + lname + "\n");
  91. }
  92. catch(SQLException sqle)
  93. {
  94.  
  95. }
  96. return list;
  97. }
  98.  
  99. public static void main(String[] args)
  100. {
  101. Practice obj = new Practice(mysql, username, password);
  102. obj.connect();
  103. System.out.println("Connected");
  104. obj.close();
  105. }
  106. }
Add Comment
Please, Sign In to add comment