public static Units getUnitForName(String unitNameRequested) {
		
		Units unit = null;
		try {

			Statement s1 = conn.createStatement();
			ResultSet rs = s1
					.executeQuery("Exec getUnitData @unitName = '" + unitNameRequested + "'");

			if (rs != null) {
				while (rs.next()) {
					String unitName = rs.getString("unitName");
					int ability = rs.getInt("ability");
					int attack = rs.getInt("attack");
					int defense = rs.getInt("defense");
					int attackRange = rs.getInt("attackRange");
					int type = rs.getInt("type");
					String name = rs.getString("name");
					String genName = rs.getString("genName");
					int mobility = rs.getInt("mobility");
					int life = rs.getInt("life");
					
					unit = new Units(unitName, ability, attack, defense, attackRange, type, name, genName, mobility, life);

				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return unit;
		
	}