/*
 * Created on 2005-5-5
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.ug.sztz.dao.ibatis;

import java.util.List;

import org.ug.sztz.dao.UserDao;
import org.ug.sztz.domain.User;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

/**
 * @author 周劍
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class MySQLUserDaoImpl extends SqlMapClientDaoSupport implements UserDao {
	/* (non-Javadoc)
	 * @see org.ug.sztz.dao.UserDao#getUser(java.lang.String, java.lang.String)
	 */
	public User getUser(String name, String password, String grade) {
		// TODO Auto-generated method stub
		User user = new User();
		user.setName(name);
		user.setPassword(password);
		user.setGrade(grade);
		List userList = this.getAllUser();
		for(int i = 0; i < userList.size(); i++)
		{
			User usr = (User)userList.get(i);
			System.out.println("Username:" + usr.getName());
		}
		return (User) getSqlMapClientTemplate().queryForObject("getUserFromUser2000", user);
	}

	/* (non-Javadoc)
	 * @see org.ug.sztz.dao.UserDao#addUser(org.ug.sztz.domain.User)
	 */
	public User addUser(User user) {
		// TODO Auto-generated method stub
		return null;
	}

	/* (non-Javadoc)
	 * @see org.ug.sztz.dao.UserDao#deleteUserById(java.lang.String)
	 */
	public User deleteUserById(String id) {
		// TODO Auto-generated method stub
		return null;
	}

	/* (non-Javadoc)
	 * @see org.ug.sztz.dao.UserDao#deleteUser(org.ug.sztz.domain.User)
	 */
	public User deleteUser(User user) {
		// TODO Auto-generated method stub
		return null;
	}

	/* (non-Javadoc)
	 * @see org.ug.sztz.dao.UserDao#updateUserInfo(org.ug.sztz.domain.User)
	 */
	public User updateUserInfo(User user) {
		// TODO Auto-generated method stub
		return null;
	}

	/* (non-Javadoc)
	 * @see org.ug.sztz.dao.UserDao#getAllUser()
	 */
	public List getAllUser() {
		// TODO Auto-generated method stub
		return getSqlMapClientTemplate().queryForList("getAllUser", null);
	}

}