package cn.music.dao.impl;

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

import cn.music.dao.UserDao;
import cn.music.entity.User;
import cn.music.utils.BaseDao;

public class UserDaoImpl implements UserDao {
	/**
	 * 分页显示所有客户信息
	 * @param start 当前页
	 * @param size  显示条数
	 * @return
	 */
	public List<User> findAllUser(int start,int size){
	
		List<User> userList = null;
		
		try {
			String sql ="select * from user limit ?,?";
			
		} catch (Exception e) {
			
			e.printStackTrace();
		}
		return userList;
		
	}
	
	/**
	 * 取得客户总人数
	 * @return 总人数
	 */
	public int getAllRecordNo(){
		int sum = 0;
		
		try {
			String sql = "select count(*) from user";
		} catch (Exception e) {
			
			e.printStackTrace();
		}
		
		return sum;
	}
	
	@Override
	public int insertUser(User user) {
		String sql="insert into user(userName,userEmail,userPwd) values(?,?,?);";
		int count = BaseDao.executeUpdate(sql,user.getUserName(),user.getUserEmail(),user.getUserPwd());
		return count;
	}

	@Override
	public User loginUser(User user) {
		String sql="select * from user where userName=? and userPwd=?;";
		ResultSet rs=BaseDao.executeQuery(sql,user.getUserName(),user.getUserPwd());
		User us=null;
		if(rs!=null){
			try {
				if(rs.next()) {
					us=new User(rs.getInt("userId"), rs.getString("userName"), rs.getString("userEmail"), rs.getString("userPwd"), rs.getString("nickName"), rs.getString("gender"), rs.getString("birthday"), rs.getString("desc"), rs.getString("head"), rs.getString("scSong"), rs.getString("scAlbum"));
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return us;
	}

	@Override
	public int updatePwd(String newPwd,String userName,String oldPwd) {
		String sql="update user set userPwd=? where userName=? and userPwd=?";
		int count = BaseDao.executeUpdate(sql, newPwd,userName,oldPwd);
		return count;
	}

	@Override
	public int updateText(String nickName, String gender, String birthday,
			String desc, String userName) {
		String sql="update  user set nickName=?,gender=?,birthday=?,user.desc =? where userName=?;";
		int count = BaseDao.executeUpdate(sql, nickName,gender,birthday,desc,userName);
		return count;
	}

	@Override
	public int updateImg(String head,String userName) {
		String sql="update user set head=? where userId=?";
		int count = BaseDao.executeUpdate(sql, head,userName);
		return count;
	}

	@Override
	public int updateEmail(String email, String userName, String userPwd) {
		String sql="update user set userEmail=? where userName=? and userPwd=?";
		int count = BaseDao.executeUpdate(sql, email,userName,userPwd);
		return count;
	}
}