package com.briup.common.dao.impl;

import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateTemplate;

import com.briup.common.dao.ICommonDao;
import com.briup.common.dao.pojo.Admin;
import com.briup.common.dao.pojo.Role;
import com.briup.common.dao.pojo.User;
import com.briup.common.exception.DataAccessException;

public class CommonDaoImpl  extends HibernateTemplate implements ICommonDao {

	public Admin getAdminByLoginName(String loginName) throws DataAccessException {
		Query query = null;
		if(loginName!=null){
			Session session = this.getSession();
			query = session.createQuery("from Admin where loginName=?");
			query.setString(0, loginName);
			return (Admin) query.uniqueResult();
		}else{
			throw new DataAccessException("請輸入用戶名");
		}
		
	}

	public User getUserByLoginName(String loginName) throws Exception {
		
		Query query = null;
		if(StringUtils.isNotEmpty(loginName)){
			Session session = this.getSession();
			query = session.createQuery("from User where loginName=?");
			query.setString(0, loginName);
		}
		return (User) query.uniqueResult();
	}

	public List getAllRoles() throws Exception {
		List<Role> roles = null;
		String hql  = "from Role";
		roles = super.find(hql);
		return roles;
	}
	
}