<resultMapid="getLogInfo"type="com.kinth.sys.model.entity.LogEntity"><resultproperty="createTime"column="createTime"javaType="string"/><collectionproperty="operationInfo"ofType="com.kinth.sys.model.entity.LogInfo"><idproperty="id"javaType="long"column="id"/><resultproperty="logInfo"javaType="string"column="logInfo"/></collection></resultMap><selectid="getAll"resultMap="getLogInfo">
SELECT
id,
DATE_FORMAT(create_time,'%Y-%m-%d') createTime,
operation_info AS logInfo
FROM
user_operation_log
WHERE
operation_info IS NOT NULL
ORDER BY
create_time DESC
</select>