@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;
}
