actiondaoimpl.java

这是一个用java三层框架做的ISS学员管理系统

package com.isoftstone.isscrmweb.web.dao.frame;

import java.sql.SQLException;
import java.util.List;
import java.util.Set;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;
import org.pontifex.orm.hibernate3.DaoImpl;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.isoftstone.isscrmweb.web.mapping.Action;
import com.isoftstone.isscrmweb.web.mapping.Menuinfo;

/**
 * Created by IntelliJ IDEA.
 * User: Songzou
 * Date: 2007-4-10
 * Time: 22:23:48
 */
public class ActionDaoImpl extends DaoImpl implements ActionDao{
    
    public void saveActioninfo(Action actioninfo) {
        this.getHibernateTemplate().save(actioninfo) ;
    }

    /**
	 * 获取指定菜单的详细请求动作列表
	 */
	
	public List getActioninfoByMenuid(final Menuinfo menu) {
		return this.getHibernateTemplate().executeFind(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException, SQLException {			
				return session.createCriteria(Action.class).add(Expression.eq("menuinfo.menuid",menu.getMenuid())).addOrder(Order.asc("actionid")).list();
			}
		});
	}

	/**
	 * 删除请求动作
	 */
	public void deleteActioninfo(Action actioninfo) {
		this.getHibernateTemplate().delete(actioninfo);
	}

	public List getActioninfoByMenuidSet(final Set menuidset) {
		
		return this.getHibernateTemplate().executeFind(new HibernateCallback(){
			
			public Object doInHibernate(Session session) throws HibernateException, SQLException {	
				Criteria criteria = session.createCriteria(Action.class);
				criteria.add(Expression.in("menuinfo.menuid", menuidset));
				return criteria.list();
			}
		});
	}
}