moduledaoimpl.java

来自「SSH 的分页...是新手的一个不错例子.」· Java 代码 · 共 34 行

package com.placard.usermanage.dao.impl;

import java.util.HashSet;
import java.util.List;
import java.util.Set;

import org.hibernate.Query;

import com.placard.core.common.hibernate.BaseHibernateDAO;
import com.placard.usermanage.dao.ModuleDAO;
import com.placard.usermanage.model.Module;

public class ModuleDAOImpl extends BaseHibernateDAO implements ModuleDAO {

	public Set<Module> getModulesByPlacard(int placardId) {
		String hql = "select m.id,m.moduleName from Module m join m.placards p where p.id=?";
		Query query = super.getSession().createQuery(hql);
		query.setParameter(0, placardId);
		List tempList = query.list();
		Set<Module> moduleList = new HashSet<Module>(0);
		if(tempList != null){
			for(int i=0;i<tempList.size();i++){
				Object[] tempObj = (Object[])tempList.get(i);
				Module module = new Module();
				module.setId((Integer)tempObj[0]);
				module.setModuleName((String)tempObj[1]);
				moduleList.add(module);
			}
		}
		return moduleList;
	}

}