hibernateimagerepositorydao.java

OBPM是一个开源

package cn.myapps.core.image.repository.dao;

import java.util.Collection;

import cn.myapps.base.action.ParamsTable;
import cn.myapps.base.dao.HibernateBaseDAO;
import cn.myapps.core.image.repository.ejb.ImageRepositoryVO;

public class HibernateImageRepositoryDAO extends HibernateBaseDAO implements
		ImageRepositoryDAO {
	public HibernateImageRepositoryDAO(String voClassName) {
		super(voClassName);
	}

	public ImageRepositoryVO getImageRepositoryByName(String name,
			String application) throws Exception {
		String hql = "from ImageRepositoryVO rp where rp.name=" + "'" + name
				+ "'";

		if (application != null && application.length() > 0) {
			hql += (" and rp.applicationid = '" + application + "' ");
		}

		return (ImageRepositoryVO) this.getData(hql);
	}

	public Collection getImageRepositoryByModule(String moduleid,
			String application) throws Exception {

		String hql = "from ImageRepositoryVO sp where sp.module.id='"
				+ moduleid + "'";
		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}

	public Collection getImageRepositoryByApplication(String applicationid,
			String application) throws Exception {

		String hql = "from ImageRepositoryVO sp where (sp.applicationid='"
				+ applicationid + "'" + " ) "
				+ " and sp.module is null";
		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}

	public ImageRepositoryVO getImageRepositoryByIconURl(String IconURl,
			String application) throws Exception {
		String hql = "from ImageRepositoryVO rp where content=" + "'" + IconURl
				+ "'";
		
		if (application != null && application.length()>0) {
			hql+=(" and rp.applicationid = '"+application+"' ");
		}
		
		return (ImageRepositoryVO) this.getData(hql);
	}
}