/**
 * 
 */
package com.air.backend.util;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

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

import com.air.constants.AppConstants;
import com.air.exceptions.AirException;
import com.air.model.LoginUser;
import com.air.persistence.DataSrcUtil;
import com.air.persistence.IsqlDataSource;
import com.air.util.ValHelper;

/**
 * @author jelly_yang
 *
 */
public class FindPassUtil {

	/**
	 * 
	 */
	private static Log log = LogFactory.getLog(FindPassUtil.class);
	public FindPassUtil() {
		// TODO Auto-generated constructor stub
	}
	public static class FindPassUtilHolder{
		static FindPassUtil findPassUtil = new FindPassUtil();
	}
	
	public static FindPassUtil getInstance(){
		return FindPassUtilHolder.findPassUtil;
	}
	
	public LoginUser searchUserByUserName(String uname)throws AirException{
		LoginUser user = null;
		Map<String, String> result = new HashMap<String, String>();
		String sSql = "select username,question,answer from users where username='"+uname+"'";
		   
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			result = src.retrieveSingleRow(conn, sSql);
		}
		catch(SQLException se)
		{
			se.printStackTrace();
			log.error("searchUserByUserName() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			log.error("searchUserByUserName() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(!result.isEmpty())
		{
			String username = ValHelper.getInstance().getValue(result, "username");
			String question = ValHelper.getInstance().getValue(result, "question");
			String answer = ValHelper.getInstance().getValue(result, "answer");
			user = new LoginUser(username,question,answer);
		}
		return user;
	}
	
	public String getAnswerByUserAndAnswer(String username,String answer)throws AirException{
		Map<String, String> result = new HashMap<String, String>();
		String sSql = "select pwd from users where username='"+username+"' and answer='"+answer+"'";
		System.out.println("haha"+username+","+answer);
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			result = src.retrieveSingleRow(conn, sSql);
		}
		catch(SQLException se)
		{
			se.printStackTrace();
			log.error("getAnswerByUser() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			log.error("getAnswerByUser() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		String password = AppConstants.EMPTY_STR;
		if(!result.isEmpty())
		{
			password = ValHelper.getInstance().getValue(result, "pwd");
		}
		return password;
	}

}