Mybatis动态获取列数据

• 先修改xml

<select id="getColumnById" resultType="String">
    SELECT
      ${column}
    FROM
      player
    WHERE
      player_id = #{playerId}
</select>

• 修改Mapper

String getColumnById(@Param("playerId") int playerId, @Param("column") String column);

• 修改service

	@Override
	public String getFieldById(Integer playerId, String fieldName) {
		String fieldVal = cacheService.getPlayerField(playerId, fieldName);
		if (fieldVal == null) { // 不在redis上
			fieldVal = playerMapper.getColumnById(playerId, fieldName);
			cacheService.setPlayerField(playerId, fieldName, fieldVal);
		}

		return fieldVal;
	}