package com.lovo.cq.candy.daoimpl;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.lovo.cq.candy.common.DbUtil;
import com.lovo.cq.candy.dao.AdminLoginDao;
import com.lovo.cq.candy.exception.NameNotFound;
import com.lovo.cq.candy.exception.PasswordError;
import com.lovo.cq.candy.po.Admin;

public class AdminLoginDaoImpl implements AdminLoginDao {

	public boolean login(Admin admin) {
		DbUtil db = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			db = new DbUtil();
			String sql = "select * from tb_admin where name=?";
			ps = db.getCon().prepareStatement(sql);
			ps.setString(1, admin.getName());
			rs = ps.executeQuery();
			if(rs.next()) {
				if(rs.getString("password").equals(admin.getPassword())) {
					return true;
				} else {
					throw new PasswordError("密码错误!");
				}
			} else {
				throw new NameNotFound("账号错误!");
			}
		} catch(NameNotFound nnf) {
			throw nnf;
		} catch (PasswordError pe) {
			throw pe;
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				ps.close();
				db.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return false;
	}

	public boolean updatePassword(Admin admin) {
		DbUtil daoUtil = null;
		PreparedStatement ps = null;
		String sql = "update tb_admin set password=? where name=?";
		try {
			daoUtil = new DbUtil();
			ps = daoUtil.getCon().prepareStatement(sql);
			ps.setString(1, admin.getPassword());
			ps.setString(2, admin.getName());
			int i = ps.executeUpdate();
			if(i != 0) {
				return true;
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				ps.close();
				daoUtil.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return false;
	}
}