public class ClassroomDAO extends HibernateDaoSupport implements IClassroomDAO {
public List query() {
List classroom = getHibernateTemplate().find(
" from Classroom t order by no");
if (classroom.size() > 0) {
return classroom;
}
return null;
}
/**
* 得到每个教室安排的班级数和考试科目数列表
*/
public List findArrangeThings() {
String hql = "select a.pk, a.no, a.teachingBuilding, a.floor,a.seatAmount, b.classAmount, b.subjectAmount "
+ " from Classroom a,ExaminationRoomPlanRule b "
+ " where a.seatAmount >= b.seatRangeBegin and a.seatAmount < b.seatRangeEnd";
List classroom = getHibernateTemplate().find(hql);
if (classroom.size() > 0) {
return classroom;
}
return null;
}
/**
* 得到教学楼
*
* @return 教学楼
*/
public List findBuilding() {
String hql = "select distinct teachingBuilding as tb from Classroom ";
List building = getHibernateTemplate().find(hql);
if (building.size() > 0) {
return building;
}
return null;
}
/**
* 得到教学楼的所有教室
*/
public List findClassrooms(String building) {
String hql = "select a.pk, a.no, a.teachingBuilding, a.floor, a.seatAmount, b.classAmount, b.subjectAmount "
+ " from Classroom a,ExaminationRoomPlanRule b "
+ " where a.seatAmount >= b.seatRangeBegin and a.seatAmount <= b.seatRangeEnd and a.teachingBuilding = ?"
+ " order by b.classAmount desc,a.no ";
List classRooms = getHibernateTemplate().find(hql, building);
String hql = " from Classroom where " + conditions;
List result = getHibernateTemplate().find(hql);
if (result.size() > 0) {
return result;
}
return null;
}