hibernateuserdao.java

OBPM是一个开源

package cn.myapps.core.user.dao;

import java.util.Collection;
import java.util.List;

import org.hibernate.Query;

import cn.myapps.base.action.ParamsTable;
import cn.myapps.base.dao.HibernateBaseDAO;
import cn.myapps.core.user.ejb.UserVO;

public class HibernateUserDAO extends HibernateBaseDAO implements UserDAO {
	public HibernateUserDAO(String voClassName) {
		super(voClassName);
	}

	public UserVO login(String loginno) throws Exception {
		String hql = "FROM " + _voClazzName + " vo WHERE vo.loginno='"
				+ loginno + "'";
		Query query = currentSession().createQuery(hql);
		List list = query.list();
		if (list.isEmpty()) {
			return null;
		} else {
			return (UserVO) list.get(0);
		}
	}

	public UserVO login(String loginno, String applicationid) throws Exception {
		String hql = "FROM " + _voClazzName + " vo WHERE vo.loginno='"
				+ loginno + "' AND (vo.applicationid='" + applicationid
				+ "' or vo.applicationid is null)";
		Query query = currentSession().createQuery(hql);
		List list = query.list();
		if (list.isEmpty()) {
			return null;
		} else {
			return (UserVO) list.get(0);
		}
	}

	public Collection getDatasByRoleid(String parent, String application) throws Exception {

		String hql = "FROM " + _voClazzName + " vo WHERE vo.roleids like '%"
				+ parent + "%'";

		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}

	public Collection getDatasByDept(String parent, String application) throws Exception {

		String hql = "FROM " + _voClazzName + " vo WHERE vo.deptid like '%"
				+ parent + ";%'";

		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}

}