Method userCreate

src/main/java/dbProcs/Setter.java:870–926

Used by many functions to create players or admins @param ApplicationRoot @param classId Cannot be null, relationship depending @param userName Cannot be null @param userPass Cannot be null @param userRole Cannot be null, must be "player" or "admin" @param userAddress Must be unique @param tempPass

(String ApplicationRoot, String classId, String userName, String userPass, String userRole, String userAddress, boolean tempPass)

	 * @throws SQLException If the creation fails, a Exception is thrown
	 */
	public static boolean userCreate (String ApplicationRoot, String classId, String userName, String userPass, String userRole, String userAddress, boolean tempPass)
	throws SQLException
	{
		boolean result = false;
		log.debug("*** Setter.userCreate ***");
		log.debug("classId = " + classId);
		log.debug("userName" + userName);
		log.debug("userRole" + userRole);
		log.debug("userAddress" + userAddress);
		Connection conn = Database.getCoreConnection(ApplicationRoot);
		try
		{
			log.debug("Executing userCreate procedure on Database");
			CallableStatement callstmt = conn.prepareCall("call userCreate(?, ?, ?, ?, ?, ?)");
			callstmt.setString(1, classId);
			callstmt.setString(2, userName);
			callstmt.setString(3, userPass);
			callstmt.setString(4, userRole);
			callstmt.setString(5, userAddress);
			callstmt.setBoolean(6, tempPass);
			ResultSet registerAttempt = callstmt.executeQuery();
			log.debug("Opening result set");
			boolean goOn = false;
			try
			{
				registerAttempt.next(); //Procedure Ran correctly
				goOn = true;
			}
			catch(Exception e)
			{
				log.fatal("Could not open result set for register...");
				result = false;
			}
			if(goOn)
			{
				if(registerAttempt.getString(1) == null) //Registration success
				{
					log.debug("Register Success");
					result = true;
				}
				else //Registration failure
				{
					result = false;
					log.debug("ResultSet contained -> " + registerAttempt.getString(1));
					throw new SQLException(registerAttempt.getString(1));
				}
			}
		}
		catch(SQLException e)
		{
			log.fatal("userCreate Failure: " + e.toString());
			throw new SQLException(e);
		}
		Database.closeConnection(conn);
		log.debug("*** END userCreate ***");	
		return result;
	}