categorydaoimpl.java

来自「一个基本的图书馆管理系统」· Java 代码 · 共 96 行

package c18.dao;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;

import c18.entity.Category;

public class CategoryDaoImpl extends PageDao implements CategoryDao {
	/**
	 * 日志操作对象
	 */
    private static final Log log = LogFactory.getLog(CategoryDaoImpl.class);

    /**
	 * 以会话对象作参数的构造器
	 * @param session
	 */
	public CategoryDaoImpl(Session session){
		this.session = session;
	}
    
	public Category get(int categoryNo) throws HibernateException {
		//得到对象
		return (Category)session.get(Category.class, new Integer(categoryNo));
	}

	public List getCategorys() throws HibernateException {
		//组成查询sql
		String sql = "from Category category";
		
		//输出日志信息
		log.debug("getCategorys:" + sql);
		
		//生成查询对象
		Query query = session.createQuery(sql);
		
		//得到查询列表
		return query.list();
	}

	public void remove(Category category) throws HibernateException {
		//删除对象
		session.delete(category);

	}

	public void save(Category category) throws HibernateException {
		//保存对象
		session.save(category);
	}

	public void update(Category category) throws HibernateException {
		//更新对象
		session.update(category);

	}

	public List getCategorys(int categoryNo) throws HibernateException {
		//组成查询sql
		String sql = "from Category category where category.parentNo=?";
		
		//输出日志信息
		log.debug("getCategorys:" + sql);
		log.debug("categoryNo:" + categoryNo);
		
		//生成查询对象
		Query query = session.createQuery(sql);
		query.setInteger(0, new Integer(categoryNo));
		
		//得到查询列表
		return query.list();
	}

	public List findByName(String name) throws HibernateException {
		//组成查询sql
		String sql = "from Category category where category.name=?";
		
		//输出日志信息
		log.debug("findByname:" + sql);
		log.debug("name:" + name);
		
		//生成查询对象
		Query query = session.createQuery(sql);
		//设置参数
		query.setString(0, name);
		//得到查询列表
		return query.list();
	}

}