package com.dao;

import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.pojo.UserInfos;
@SuppressWarnings("unchecked")
public class UserDao extends SqlMapClientDaoSupport implements IUserDao {

	
	public List<UserInfos> findAll() {
		// TODO Auto-generated method stub
		
		return this.getSqlMapClientTemplate().queryForList("find_all");
	}

	public int delete(int id) {
		// TODO Auto-generated method stub
		
		 return this.getSqlMapClientTemplate().delete("delete_userbyId", id);
	}

	public int insert(UserInfos user) {
		// TODO Auto-generated method stub
		int a=0;
		this.getSqlMapClientTemplate().insert("insert", user);
		a=1;
		return a;
	}

	public int update(UserInfos user) {
		// TODO Auto-generated method stub
		return this.getSqlMapClientTemplate().update("update", user);
	}

	public UserInfos query(int id) {
		// TODO Auto-generated method stub
		UserInfos user=null;
		user=(UserInfos) this.getSqlMapClientTemplate().queryForObject("query", id);
		return user;
	}

	public List<UserInfos> findAll(int current, int maxResult) {
		// TODO Auto-generated method stub
		return this.getSqlMapClientTemplate().queryForList("find_all", (current-1)*maxResult, maxResult);
	}
}