courseinfodaohibernate.java

来自「Spring+hibernate学生在线选课系统」· Java 代码 · 共 69 行

/*
 * Created on 2006-1-22
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.mmxbb.schoolelective.dao.hibernate;

import java.util.List;

import net.sf.hibernate.Hibernate;
import net.sf.hibernate.type.Type;

import org.mmxbb.schoolelective.dao.CourseinfoDao;
import org.mmxbb.schoolelective.model.Courseinfo;

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

/**
 * @teacher mmx
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class CourseinfoDaoHibernate extends HibernateDaoSupport implements CourseinfoDao {

	public Courseinfo load(Integer id){
		  Courseinfo courseinfo;
	        try{
	        	courseinfo = (Courseinfo)getHibernateTemplate().load(Courseinfo.class,id);
	        }catch(HibernateObjectRetrievalFailureException e){
	        	courseinfo = null;
	        }
	        return courseinfo;	
	
	}
    
    public void save(Courseinfo courseinfo){
	       
    	getHibernateTemplate().save(courseinfo);
    }
    public void update(Courseinfo courseinfo){
        getHibernateTemplate().update(courseinfo);
    }
    public void delete(Integer id){
        getHibernateTemplate().delete(load(id));
    }
    public List find(String query){
        return getHibernateTemplate().find(query);
    }
    public List findAll(){
	    
    	return getHibernateTemplate().find("from Courseinfo b order by b.regdate desc");
    }
    
    public List findSpecCourse(Courseinfo courseinfo){
	    
    	System.out.println(courseinfo.getName());
    	String[] args=new String[]{courseinfo.getName(),courseinfo.getTeacher(),courseinfo.getDepartment()};
    	for(int i=0;i<args.length;i++){
    		if(args[i]==null)args[i]="";
    	}
    	Type[] types=new Type[]{Hibernate.STRING,Hibernate.STRING,Hibernate.STRING};
    	return getHibernateTemplate().find("from Courseinfo b where b.name like '%"+courseinfo.getName()+"%' and b.teacher like '%"+courseinfo.getTeacher()+"%' and b.department like '%"+courseinfo.getDepartment()+"%' order by b.regdate desc");
    }
    
}