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

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

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

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 RegisterUtil {

	private static Log log = LogFactory.getLog(AuthUtil.class);

	private RegisterUtil(){
		
	}
	
	private static class RegisterUtilHolder{
		static final RegisterUtil authUtil = new RegisterUtil();
	}
	
	public static RegisterUtil getInstance(){
		return RegisterUtilHolder.authUtil;
	}
	
	public boolean register(LoginUser user)throws AirException{
		int result = 0;
		boolean bResult = false;
		String sSql = "insert users(username,pwd,name,sex,certification_type,certification_code,question,answer) values('"+user.getUsername()+"','"+user.getPassword()+"','"+user.getName()+"','"+user.getSex()+"','"+user.getCertificationType()+"','"+user.getCertificationCode()+"','"+user.getQuestion()+"','"+user.getAnswer()+"')"; 
		IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
		Connection conn = null;
		try
		{
			conn = src.getConnection();
			Statement stmt = conn.createStatement();
			result = src.executeUpdate(stmt,sSql);
		}
		catch(SQLException se)
		{
			se.printStackTrace();
			log.error("register() caught SQLException: " + se);
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			log.error("register() caught Exception: " + ex);
		}
		finally
		{
			src.closeConn(conn);
		}
		if(result>0){
			bResult = true;
		}
		return bResult;
	}
}