websitedaoimpl.java

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

package com.jeecms.core.dao.impl;

import java.util.List;

import com.jeecms.core.JeeCoreDaoImpl;
import com.jeecms.core.dao.WebsiteDao;
import com.jeecms.core.entity.Website;

public class WebsiteDaoImpl extends JeeCoreDaoImpl<Website> implements
		WebsiteDao {
	@SuppressWarnings("unchecked")
	@Override
	public List<Website> getListByUserUnited(Long userId) {
		String hql = "select web from Admin admin inner join admin.website web where admin.user.id in"
				+ "(select user.id from User user where user.id= :userId)";
		return findByHql(hql, "userId", userId, 0, 200);
	}
}