classdaohibernate.java.svn-base

菲律宾的一个大学的图书管理系统 spring+hibernate+velocity

/*
 * 创建日期 2005-4-14
 */
package biz.bluesky.pts.service.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import org.springframework.orm.ObjectRetrievalFailureException;

import biz.bluesky.pts.model.TClass;
import biz.bluesky.pts.model.TTeacherClass;
import biz.bluesky.pts.model.TTestClass;
import biz.bluesky.pts.service.dao.IClassDAO;


public class ClassDAOHibernate extends BaseDAOHibernate implements IClassDAO {

    //根据班级编号查询班级
    public TClass findClass(int classId) {
        TClass aClass = (TClass)getHibernateTemplate().get(TClass.class,new Integer(classId));
        
        if(aClass == null) {
            throw new ObjectRetrievalFailureException(TClass.class, new Integer(classId));
        }
        
        return aClass;
    }

    //根据班级名称和学校编号查询班级
    public TClass findClass(String className, int schoolId) {
        List list = getHibernateTemplate().find("from TClass class where class.className=? and class.schoolId=?",
                new Object []{className,new Integer(schoolId)});
        
        if(list.size() < 1) {
            return null;
        }
        else {
            return (TClass)list.get(0);
        }
      
    }

    //模糊查询学校内的班级
    public List findClasses(String className, int schoolId) {
        StringBuffer sb = new StringBuffer(100);
        sb.append("from TClass class where class.schoolId=");
        sb.append(schoolId);
        sb.append(" and class.className like '%");
        sb.append(className);
        sb.append("%'");
        
        List list = getHibernateTemplate().find(sb.toString());
        
        return list;
    }
    
    //根据学校编号查询班级
    public List findClasses(int schoolId) {
        return getHibernateTemplate().find("from TClass c where c.schoolId=?",new Integer(schoolId));
    }
    
    //根据教师编号查询班级*
    public List findClassesByTeacherId(int teacherId){
    	return getHibernateTemplate().find("from TTeacherClass tc where tc.teacherId=?",new Integer(teacherId));
    } 

    //新增班级
    public void saveClass(TClass aClass) {
        getHibernateTemplate().saveOrUpdate(aClass);
        getHibernateTemplate().flush();
    }

    //增加班级的测试    
    public void saveTestToClass(TTestClass testClass) {
        getHibernateTemplate().saveOrUpdate(testClass);        
    }
    
    //增加班级的教师
    public void saveTeacherToClass(TTeacherClass tc) {
        getHibernateTemplate().saveOrUpdate(tc);
    }
    
    //删除班级
    public void removeClass(int classId) {
        TClass aClass = findClass(classId);
        getHibernateTemplate().delete(aClass);
    }

    //删除班级的测试
    public void removeTestFromClass(int testId, int classId, String year) {        
        List list = getHibernateTemplate().find("from TTestClass ts where ts.testId=? and ts.classId=? and ts.year=?",
                new Object []{new Integer(testId),new Integer(classId),year});
        
        if(list.size() < 1) {
            throw new ObjectRetrievalFailureException(TTestClass.class,""	);
        }
        
        getHibernateTemplate().delete((TTestClass)list.get(0));
    }

    //删除班级的教师
    public void removeTeacherFromClass(int teacherId, int classId) {
        List list = getHibernateTemplate().find("from TTeacherClass tc where tc.teacherId=? and tc.classId=?",
                new Object []{new Integer(teacherId),new Integer(classId)});
        
        if(list.size() < 1) {
            throw new ObjectRetrievalFailureException(TTeacherClass.class,""	);
        }
        
        getHibernateTemplate().delete((TTeacherClass)list.get(0));
    }


    
}