public List<TeacherDetails> getAllTeachersFromClass(int class_id) {
ArrayList<TeacherDetails> teachers = new ArrayList<TeacherDetails>();
Session session = null;
Transaction transaction = null;
List queryResultList = null;
String queryString = "from Teacher where class_id=:class_id";
try {
session = HibernateUtil.getSessionfactory().openSession();
transaction = session.beginTransaction();
Query query = session.createQuery(queryString);
query.setInteger("class_id", class_id);
queryResultList = query.list();
transaction.commit();
Iterator itr = queryResultList.iterator();
while (itr.hasNext()) {
Teacher entry = (Teacher) itr.next();
TeacherDetails teacherDetails = new TeacherDetails();
teacherDetails.setTeacherId(entry.getUser_id());
teacherDetails.setSubjectIds(entry.getSub_ids());
teacherDetails.setTeacherBean(getTeacherDetailsFromID(entry.getUser_id()));
if (entry.getSuffix() != null) {
teacherDetails.setSuffix(entry.getSuffix());
} else {
teacherDetails.setSuffix("");
}
if (!entry.getSub_ids().equals("")) {
teacherDetails.setSubjects(getAssignedSubjects(entry.getSub_ids().split(",")));
} else {
teacherDetails.setSubjects(new ArrayList<Subject>());
}
teachers.add(teacherDetails);
}
return teachers;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (null != session) {
session.close();
}
}
return null;
}
