arrangedatedaoimpl.java

一段很有意义的源码,看了就知道,不信试一试啊!

package com.wondersgroup.basemodule.arrangedate.dao.impl;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.criterion.Expression;

import com.wondersgroup.basemodule.arrangedate.bo.ArrangeDateBo;
import com.wondersgroup.basemodule.arrangedate.dao.ArrangeDateDAO;
import com.wondersgroup.framework.core.dao.impl.AbstractHibernateDAOImpl;

public class ArrangeDateDAOImpl extends AbstractHibernateDAOImpl implements ArrangeDateDAO {
    public List findByStartTime(Date startDate,Date endDate,long person_id){
		Criteria criteria = getSession().createCriteria(getEntityClass());
		criteria.add(Expression.ge("start_time",startDate));
		criteria.add(Expression.le("end_time",endDate));
		criteria.add(Expression.eq("person_id",new Long(person_id)));
		List list = new ArrayList();
		list = criteria.list();
		return list;
    }
    public List findByEndTime(Date startDate,Date endDate,long person_id){
		Criteria criteria = getSession().createCriteria(getEntityClass());
		criteria.add(Expression.ge("end_time",startDate));
		criteria.add(Expression.le("end_time",endDate));
		criteria.add(Expression.eq("person_id",new Long(person_id)));
		List list = new ArrayList();
		list = criteria.list();
		return list;
    }
    
    public List findByDate(Date date,long person_id){
		return getSession().createQuery("from ArrangeDateBo a where days(a.start_time) >days('"+date.toLocaleString()+"')-1 " +
    			"	and days(a.end_time)<(days('"+date.toLocaleString()+"')+1) and a.removed=0 ").list();
	}
    
    /**
     * 按月查询
     * @param month
     * @param person_id
     * @return
     */
    public List findByMonth(int month,long person_id){
    	return getSession().createQuery("from ArrangeDateBo a where " +
    			" MONTH(a.start_time)="+month+"  and removed=0").list(); 	
    }
    
    public List findByWeekInfo(Date date,long id){
    	List list = getSession().createQuery("from ArrangeDateBo a where days(a.start_time) >days('"+date.toLocaleString()+"')-1 " +
    			"	and days(a.end_time)<(days('"+date.toLocaleString()+"')+1) and a.removed=0 ").list();
		return list;
    }
    
   
    
    public List findByHQL(String hql){
    	return getSession().createQuery(hql).list(); 	
    }
    
    public void flush(){
    	this.getSession().flush();
    }
   
    public Class getEntityClass(){
		return ArrangeDateBo.class;
	}
    
}