package com.david.dao;

import java.sql.Date;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.david.bo.Userinfo;
import com.david.bo.Userpoint;

public class UserinfoDao extends HibernateDaoSupport implements IUserinfoDao {

	
	
	public boolean addUserinfo(Userinfo userinfo) {
		// TODO Auto-generated method stub
		userinfo.setAddtime(new Date(System.currentTimeMillis()));
		try{
			this.getHibernateTemplate().save(userinfo);			
			return true;
		}catch(DataAccessException e){
			return false;
		}
		
	}
	
	/**
	 * 判斷用戶名是否存在
	 * 存在返回true
	 * 不存在返回false
	 */
	public boolean isExistUsername(String username) {
		// TODO Auto-generated method stub
		List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo as userinfo where userinfo.username=? Order by userinfo.id desc", username);
		return list.size()>=1;
	}

	public Userinfo login(Userinfo userinfo) {
		// TODO Auto-generated method stub
		String[] arr={userinfo.getUsername(),userinfo.getPassword()};
		try{
			//List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo userinfo where userinfo.username='"+userinfo.getUsername()+"' and userinfo.password='"+userinfo.getPassword()+"'");
			List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo as userinfo where userinfo.username=? and userinfo.password=?",arr);
			
			if(list.size()==1){
				//只取出一條記錄
				return list.get(0);
			}else{
				return null;
			}
		}catch(DataAccessException e){
			e.printStackTrace();
			return null;
		}
	}

	public List<Userinfo> getList() {
		// TODO Auto-generated method stub
		return this.getHibernateTemplate().find("from Userinfo as userinfo Order by userinfo.id desc");
	}

	public Userinfo getUserinfoById(int userId) {
		// TODO Auto-generated method stub
		List<Userinfo> list=this.getHibernateTemplate().find("from Userinfo as userinfo where userinfo.id=?", userId);
		if(list.size()==1){
			return list.get(0);
		}else{
			return null;
		}
	}

	
}