Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (Objects.isNull(conn)) {
- Class.forName("com.mysql.cj.jdbc.Driver");
- conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?serverTimezone=UTC", dbUser, dbPass);
- }
- return conn;
- }
- Connection conn = getDbConnection();
- List<Student> result = new ArrayList<>();
- String sql = "SELECT * FROM student s " +
- "INNER JOIN university u ON s.university_fk_id = u.university_id
- WHERE u.university_name = 'Moscow Technical University'";
- PreparedStatement stmt = conn.prepareStatement(sql);
- ResultSet rs = stmt.executeQuery(sql);
- try (conn; stmt; rs) {
- while (rs.next()) {
- Student student = new Student();
- String firstName = rs.getString("first_name");
- student.setFirst_name(firstName);
- student.setLast_name(rs.getString("last_name"));
- student.setUniversity_fk_id(rs.getInt("university_fk_id"));
- University university = new University();
- university.setUniversity_id(rs.getInt("university_id"));
- university.setUniversity_name(rs.getString("university_name"));
- result.add(student);
- }
- for (Student st : result) {
- System.out.println(st);
- }
- }
- return result;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement