functiondaoimpl.java

来自「JEECSM是JavaEE版网站管理系统（Java Enterprise Edi」· Java 代码 · 共 38 行

package com.jeecms.core.dao.impl;

import java.util.List;

import com.jeecms.core.JeeCoreDaoImpl;
import com.jeecms.core.dao.FunctionDao;
import com.jeecms.core.entity.Function;

public class FunctionDaoImpl extends JeeCoreDaoImpl<Function> implements
		FunctionDao {
	@SuppressWarnings("unchecked")
	@Override
	public List<Function> getFunctions(Long adminId) {
		String hql = "select func from Function func where func.id in"
				+ " (select f1.id from Admin admin join admin.roles role join role.functions f1 where admin.id = ?) or func.id in "
				+ " (select f2.id from Admin admin join admin.functions f2 where admin.id = ?)"
				+ " order by func.priority asc";
		List<Function> list = getHibernateTemplate().find(hql,
				new Object[] { adminId, adminId });
		return list;
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Function> getRoots() {
		String hql = "select func from Function func where func.parent.id is null order by func.priority asc";
		List<Function> list = getHibernateTemplate().find(hql);
		return list;
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Function> getChild(Long pid) {
		String hql = "select func from Function func where func.parent.id = ? order by func.priority asc";
		List<Function> list = getHibernateTemplate().find(hql, pid);
		return list;
	}
}