package cn.user.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import cn.user.model.User;
import cn.user.util.BaseDao;

public class UserDao extends BaseDao {
	public int update(User user){
		String sql = "UPDATE `users`.`user` SET  `username`= ?, `pwd`= ?, `age`= ?, `sex`=?, `address`=?, `school`=?, `weight`=?, `height`=? WHERE `id`= ?";
		return this.executeUpdate1(sql, user.getUsername(),user.getPwd(),user.getAge(),user.getSex(),user.getAddress(),user.getSchool(),user.getWeight(),user.getHeight(),user.getId());
		
	}
	public User selectOne(Integer id){
		String sql = "select * from user where id = ?";
		ResultSet rs = null;
		Object[] params = {id};
		rs = this.executeQueryRs(sql, params);;
		try {
			if (rs.next()){
				User u =  new User(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getInt(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getDouble(8),rs.getDouble(9));
				return u;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			this.closeAll();
		}
		return null;
	}
	public int insert(User user){
		String sql = "INSERT INTO user(username,pwd,age,sex,address,school,weight,height) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
//		Object[] params = {user.getUsername(),user.getPwd(),user.getAge(),user.getSex(),user.getAddress(),user.getSchool(),user.getWeight(),user.getHeight()};
		return this.executeUpdate1(sql, user.getUsername(),user.getPwd(),user.getAge(),user.getSex(),user.getAddress(),user.getSchool(),user.getWeight(),user.getHeight());
	}
	
	public List<User> selectAll(){
		List<User> list = new ArrayList<User>();
		String sql = "select * from user";
		Object[] params = null;
		ResultSet rs = this.executeQueryRs(sql, params);
		try {
			while(rs.next()){
				list.add(new User(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getInt(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getDouble(8),rs.getDouble(9)));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			this.closeAll();
		}
		return list.size() > 0 ? list : null;
	}
	public int delete(Integer id){
		String sql = "delete from user where id = ?";
		Object[] params = {id};
		return this.executeUpdate(sql, params);
	}
}