xiaoshoudingdandaoimpl.java

自己写的一个java购销系统

package com.yuanjin.mtgx.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.yuanjin.mtgx.dao.XiaoShouDingDanDAO;
import com.yuanjin.mtgx.entity.XiaoShouDingDan;
import com.yuanjin.mtgx.util.HbnUtil;

public class XiaoShouDingDanDAOImpl implements XiaoShouDingDanDAO {

	public void delete(XiaoShouDingDan xsdd) {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		if(session!=null){
			session.delete(xsdd);
		}
	}

	public List<XiaoShouDingDan> findALL() {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		List list=null;
		if(session!=null){
			list=session.createQuery("from XiaoShouDingDan x").list();
		}
		return list;
	}

	public XiaoShouDingDan findByNo(String no) {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		XiaoShouDingDan xsdd=null;
		if(session!=null){
			Query q=session.createQuery("from XiaoShouDingDan x where x.xsddbh=:xsddbh");
			q.setString("xsddbh", no);
			xsdd=(XiaoShouDingDan) q.uniqueResult();
		}
		return xsdd;
	}

	public void save(XiaoShouDingDan xsdd) {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		if(session!=null){
			session.save(xsdd);
		}
	}

	public void update(XiaoShouDingDan xsdd) {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		if(session!=null){
			session.saveOrUpdate(xsdd);
		}
	}

	public List findGroupedByMonth(String month) {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		List list=null;
		if(session!=null){
			Query q=session.createQuery("select new com.yuanjin.mtgx.entity.YueXiaoShouZhangDan(x.dgpz,sum(x.dgsl),sum(x.dgsl*x.dgjg)) from XiaoShouDingDan x where month(x.dgrq)=:month group by x.dgpz");
			q.setString("month", month);
			list=q.list();
		}
		return list;
	}

	public List<XiaoShouDingDan> findAllByMonth(String month) {
		// TODO Auto-generated method stub
		Session session=HbnUtil.getCurrentSession();
		List list=null;
		if(session!=null){
			Query q=session.createQuery("from XiaoShouDingDan x where month(x.dgrq)=:month");
			q.setString("month", month);
			list=q.list();
		}
		return list;
	}

}