orderinfodao.java

来自「一套自己原先在学校作的CRM,大家指点下」· Java 代码 · 共 200 行

package com.crm.dao;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.crm.pojo.OrderInfo;

/**
 * Data access object (DAO) for domain model class OrderInfo.
 * 
 * @see com.crm.pojo.OrderInfo
 * @author MyEclipse Persistence Tools
 */

public class OrderInfoDAO extends HibernateDaoSupport {
	private static final Log log = LogFactory.getLog(OrderInfoDAO.class);

	// property constants
	public static final String ORDER_TIME = "orderTime";

	public static final String ORDER_ADDRESS = "orderAddress";

	public static final String ORDER_STATE = "orderState";

	public static final String ORDER_HAVING_MONEY = "orderHavingMoney";

	protected void initDao() {
		// do nothing
	}

	public void save(OrderInfo transientInstance) {
		log.debug("saving OrderInfo instance");
		try {
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

	public void delete(OrderInfo persistentInstance) {
		log.debug("deleting OrderInfo instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	public OrderInfo findById(java.lang.Integer id) {
		log.debug("getting OrderInfo instance with id: " + id);
		try {
			OrderInfo instance = (OrderInfo) getHibernateTemplate().get(
					"com.crm.pojo.OrderInfo", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(OrderInfo instance) {
		log.debug("finding OrderInfo instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding OrderInfo instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from OrderInfo as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List findByOrderTime(Object orderTime) {
		return findByProperty(ORDER_TIME, orderTime);
	}

	public List findByOrderAddress(Object orderAddress) {
		return findByProperty(ORDER_ADDRESS, orderAddress);
	}

	public List findByOrderState(Object orderState) {
		return findByProperty(ORDER_STATE, orderState);
	}

	public List findByOrderHavingMoney(Object orderHavingMoney) {
		return findByProperty(ORDER_HAVING_MONEY, orderHavingMoney);
	}

	public List findAll() {
		log.debug("finding all OrderInfo instances");
		try {
			String queryString = "from OrderInfo";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public OrderInfo merge(OrderInfo detachedInstance) {
		log.debug("merging OrderInfo instance");
		try {
			OrderInfo result = (OrderInfo) getHibernateTemplate().merge(
					detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	public void attachDirty(OrderInfo instance) {
		log.debug("attaching dirty OrderInfo instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public void attachClean(OrderInfo instance) {
		log.debug("attaching clean OrderInfo instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public List find(OrderInfo order, int pageNo, int pageSize) {
		String sql = "select sum(o.orderHavingMoney) from OrderInfo  as o where 1=1 ";
		Session s = this.getSessionFactory().openSession();
		if (!(order.getClient().getClientName().equals("") || order.getClient().getClientName()==null)) {
			sql +="and o.client.clientId="+order.getClient().getClientId();
		}
		if(!(order.getOrderTime().equals("") || order.getOrderTime()==null || order.getOrderTime().equals("0"))){
			sql+=" and o.orderTime like '"+order.getOrderTime()+"' ";
		}
		sql+=" group by o.client.clientId";
		Query query = s.createQuery(sql);
		int fri = pageSize * (pageNo - 1);
		query.setFirstResult(fri);
		query.setMaxResults(pageSize);
		List list = query.list();
		s.close();
		return list;
	}
	public List find(int id, int pageNo, int pageSize) {
		String sql = "select o from OrderInfo  as o where o.client.clientId="+id;
		Session s = this.getSessionFactory().openSession();
		Query query = s.createQuery(sql);
		int fri = pageSize * (pageNo - 1);
		query.setFirstResult(fri);
		query.setMaxResults(pageSize);
		List list = query.list();
		s.close();
		return list;
	}
	public List find(int id) {
		String sql = "select o from OrderInfo  as o where o.client.clientId="+id;
		Session s = this.getSessionFactory().openSession();
		Query query = s.createQuery(sql);
		List list = query.list();
		s.close();
		return list;
	}
	
	public static OrderInfoDAO getFromApplicationContext(ApplicationContext ctx) {
		return (OrderInfoDAO) ctx.getBean("OrderInfoDAO");
	}
}