Mybatis动态获取列数据
<select id="getColumnById" resultType="String">
SELECT
${column}
FROM
player
WHERE
player_id = #{playerId}
</select>
String getColumnById(@Param("playerId") int playerId, @Param("column") String column);
@Override
public String getFieldById(Integer playerId, String fieldName) {
String fieldVal = cacheService.getPlayerField(playerId, fieldName);
if (fieldVal == null) {
fieldVal = playerMapper.getColumnById(playerId, fieldName);
cacheService.setPlayerField(playerId, fieldName, fieldVal);
}
return fieldVal;
}