Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. if (Objects.isNull(conn)) {
  2. Class.forName("com.mysql.cj.jdbc.Driver");
  3. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?serverTimezone=UTC", dbUser, dbPass);
  4. }
  5. return conn;
  6. }
  7.  
  8. Connection conn = getDbConnection();
  9. List<Student> result = new ArrayList<>();
  10.  
  11. String sql = "SELECT * FROM student s " +
  12. "INNER JOIN university u ON s.university_fk_id = u.university_id
  13. WHERE u.university_name = 'Moscow Technical University'";
  14. PreparedStatement stmt = conn.prepareStatement(sql);
  15. ResultSet rs = stmt.executeQuery(sql);
  16.  
  17. try (conn; stmt; rs) {
  18. while (rs.next()) {
  19. Student student = new Student();
  20. String firstName = rs.getString("first_name");
  21. student.setFirst_name(firstName);
  22. student.setLast_name(rs.getString("last_name"));
  23. student.setUniversity_fk_id(rs.getInt("university_fk_id"));
  24.  
  25. University university = new University();
  26. university.setUniversity_id(rs.getInt("university_id"));
  27. university.setUniversity_name(rs.getString("university_name"));
  28. result.add(student);
  29. }
  30.  
  31. for (Student st : result) {
  32. System.out.println(st);
  33. }
  34. }
  35. return result;
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement