customerorderhibernatedao.java

利用Java开发的网上书店系统

package com.ascent.dao.hibernate;

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

import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;

import com.ascent.bean.Customerorder;
import com.ascent.dao.ICustomerOrderDAO;

public class CustomerOrderHibernateDAO extends HibernateDaoSupport implements
		ICustomerOrderDAO {
	private static final Logger LOGGER = LogManager
			.getLogger(CustomerOrderHibernateDAO.class);

	private static final String LOAD_ALL = "from Customerorder custord order by custord.custorderId desc";

	private static final String LOAD_BY_NAME = "from Customerorder custord where custord.custorderName = ? order by custord.custorderId desc";

	private static final String LOAD_BY_ORDERID = "from Customerorder custord where custord.orderId = ? order by custord.custorderId desc";

	/**
	 * 
	 */
	public CustomerOrderHibernateDAO() {
		super();
	}

	/**
	 * 
	 * @param Customerorder
	 * @return Customerorder
	 */
	public Customerorder saveCustomerOrder(Customerorder customerorder) {
		try {
			this.getHibernateTemplate().save(customerorder);
			LOGGER.debug("保存用户发送信息到数据库成功！");
			return customerorder;
		} catch (Exception ex) {
			LOGGER.error("保存用户发送信息到数据库失败!");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id
	 *            Integer
	 * 
	 * @return Customerorder
	 */
	public Customerorder getCustomerOrder(Integer id) {
		LOGGER.debug("根据用户ID得到用户信息！");
		return (Customerorder) this.getHibernateTemplate().get(
				Customerorder.class, id);
	}

	/**
	 * 
	 * @return List
	 */
	public List findCustomerOrderAll() {
		try {
			LOGGER.debug("得到所有发送用户列表！");
			return this.getHibernateTemplate().find(LOAD_ALL);
		} catch (Exception ex) {
			LOGGER.error("获取所有发送用户列表失败！");
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findCustomerOrderByName(String name) {
		try {
			LOGGER.debug("根据用户姓名得到发送用户信息！");
			return this.getHibernateTemplate().find(LOAD_BY_NAME, name);
		} catch (Exception ex) {
			LOGGER.error("根据用户姓名获取发送用户信息失败！");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findCustomerOrderByOrderId(int id) {
		try {
			LOGGER.debug("根据订单id得到发送用户信息！");
			return this.getHibernateTemplate().find(LOAD_BY_ORDERID, id);
		} catch (Exception ex) {
			LOGGER.error("根据订单id获取发送用户信息失败！");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param Customer
	 * 
	 */
	public void removeCustomerOrder(Customerorder customerorder) {
		LOGGER.debug("从数据库中删除指定用户信息！");
		this.getHibernateTemplate().delete(customerorder);
	}
}