Advertisement
Guest User

NullPointerException

a guest
Oct 23rd, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.14 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6. public class DBConnection {
  7. private Connection conn;
  8. private Statement st;
  9. private ResultSet rs;
  10. // JDBC driver name and database URL
  11. static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  12. static final String DB_URL = "jdbc:mysql://localhost/javatest";
  13. // Database credentials
  14. static final String USER = "root";
  15. static final String PASS = "";
  16. public void DBConnection() {
  17. try {
  18. Class.forName("com.mysql.jdbc.Driver");
  19. conn = DriverManager.getConnection(DB_URL, USER, PASS);
  20. st = conn.createStatement();
  21. } catch (ClassNotFoundException | SQLException ex) {
  22. System.out.println("Error : " + ex);
  23. }
  24. }
  25. public void getData() {
  26. try {
  27. String query = "select * from person";
  28. rs = st.executeQuery(query);
  29. System.out.println("Records from the database");
  30. while (rs.next()) {
  31. int id = rs.getInt("id");
  32. String name = rs.getString("name");
  33. String age = rs.getString("age");
  34. System.out.println("Id: " + id + "Name : " + name + "Age : " + age);
  35. }
  36. } catch (Exception ex) {
  37. System.out.println(ex);
  38. }
  39. }
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement