<!-- 查询单个活动信息 -->
<select id="selectActivity" parameterType="com.iqb.onigiri.bgfront.server.activity.manage.bean.ActivityBean" resultType="com.iqb.onigiri.bgfront.server.activity.manage.bean.ActivityBean"> SELECT id, name, code, activity_type AS activityType, FROM_UNIXTIME(start_time, '%Y-%m-%d %H:%i') AS startTime, FROM_UNIXTIME(end_time, '%Y-%m-%d %H:%i') AS endTime, description FROM qb_activity_info WHERE id = #{id} </select>
end_time = UNIX_TIMESTAMP(#{endTime}),