package dal;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import common.JdbcUtil;
import domain.User;

public class LoginDAO {
	private Log log = LogFactory.getLog(LoginDAO.class); 
	private int id;
	private String name;
	private String password;

	public LoginDAO() {
	}

	public LoginDAO(String name, String password, int id) {
		this.name = name;
		this.password = password;
		this.id = id;

	}

	public boolean checkUser() {
		Connection conn = null;
		PreparedStatement stat = null;
		ResultSet set = null;
		boolean flag = false;
		String sql = "select * from users t where username=? and userpwd=? and userlevel=?";
		try {
			conn = JdbcUtil.getConnection();
			stat = conn.prepareStatement(sql);
			stat.setString(1, name);
			stat.setString(2, password);
			stat.setInt(3, id);
			set = stat.executeQuery();
			if (set.next()) {
				flag = true;
			}
		} catch (SQLException e) {
			log.error(e);
			JdbcUtil.BackDb(conn);
			e.printStackTrace();
		} catch (Exception e) {
             log.fatal(e);
			JdbcUtil.BackDb(conn);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return flag;
	}

	public User getUser() {
		Connection conn = null;
		PreparedStatement stat = null;
		ResultSet set = null;
		String sql = "select * from users t where username=? and userpwd=? and userlevel=?";
		User user = null;
		try {
			conn = JdbcUtil.getConnection();
			stat = conn.prepareStatement(sql);
			stat.setString(1, name);
			stat.setString(2, password);
			stat.setInt(3, id);
			set = stat.executeQuery();
			while (set.next()) {
				user = new User();
				int user_id = set.getInt("user_id");
				int userlevel = set.getInt("userlevel");
				String userName = set.getString("username");
				String identity = set.getString("identity");
				String fullName = set.getString("fullname");
				int sex = set.getInt("sex");
				String address = set.getString("address");
				String phone = set.getString("phone");
				String userpwd = set.getString("userpwd");
				String position = set.getString("position");
				
				user.setUserlevel(userlevel);
				user.setUser_id(user_id);
				user.setAddress(address);
				user.setFullName(fullName);
				user.setIdentity(identity);
				user.setPassword(userpwd);
				user.setPosition(position);
				user.setUserName(userName);
				user.setSex(sex);
				user.setPhone(phone);
			}
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		} catch (Exception e) {
			log.fatal(e);
			e.printStackTrace();
		} finally {
			JdbcUtil.ShutDownDB(conn);
		}
		return user;
	}
}