@Override public List<StudentEntity> getByName(String surname) { List<StudentEntity> listOfStudent = new ArrayList<StudentEntity>(); try { Statement st = connection.createStatement(); ResultSet res = st.executeQuery("SELECT * FROM StudentEntity WHERE surname = " + surname + ""); StudentEntity studentEntity = new StudentEntity(); studentEntity.setId_student(res.getInt("id")); studentEntity.setName(res.getString("name")); studentEntity.setSurname(res.getString("surname")); listOfStudent.add(studentEntity); res.close(); st.close(); } catch (SQLException e) { System.out.println("Не вірний SQL запит на вибірку даних"); e.printStackTrace(); } return listOfStudent; }