testdaohibernate.java

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

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

import org.springframework.orm.ObjectRetrievalFailureException;

import java.util.List;

import biz.bluesky.pts.model.TTest;
import biz.bluesky.pts.service.dao.ITestDAO;


public class TestDAOHibernate extends BaseDAOHibernate implements ITestDAO {

    //根据测试编号查询测试
    public TTest findTest(int testId) {
        TTest test = (TTest)getHibernateTemplate().get(TTest.class,new Integer(testId));
        
        if(test == null) {
            throw new ObjectRetrievalFailureException(TTest.class,new Integer(testId));
        }
        
        return test;
    }

    //根据教师编号查询测试
    public TTest findTest(String testType, int teacherId) {
        List list = getHibernateTemplate().find("from TTest t where t.type=? and t.teacherId=?",
                new Object []{testType,new Integer(teacherId)});
        
        if(list.size() < 1) {
            return null;
        }
        else {
            return (TTest)list.get(0);
        }
        
    }

    //根据教师编号模糊查询测试
    public List findTests(String testType, int teacherId) {
        StringBuffer sb = new StringBuffer(100);
        sb.append("from TTest t where t.teacherId=");
        sb.append(teacherId);
        sb.append(" and t.type like '%");
        sb.append(testType);
        sb.append("%'");
        
        return getHibernateTemplate().find(sb.toString());
    }

    //查询班级的测试
    public List findTestByClass(int classId) {
        StringBuffer sb = new StringBuffer(100);
        sb.append("from TTest t where t.testId in (select ts.testId from TTestClass ts where ts.classid=");
        sb.append(classId);
        sb.append(")");
        
        return getHibernateTemplate().find(sb.toString());
    }
    
    //根据教师编号查询测试
    public List findTestsByTeacher(int teacherId) {
        return getHibernateTemplate().find("from TTest t where t.teacherId=?",new Integer(teacherId));
    }

    //新增测试
    public void saveTest(TTest test) {
        getHibernateTemplate().saveOrUpdate(test);
        getHibernateTemplate().flush();
    }

    //删除测试
    public void removeTest(int testId) {
        TTest test = findTest(testId);
        getHibernateTemplate().delete(test);
    }

}