SELECT a.fullName ,a.emergencyPlanType ,a.content ,a.dispose FROM sp_activity_emergency_plan a where a.activityId = #{activityId} SELECT * FROM sp_activity_emergency_plan a where a.activityId = #{activityId} and emergencyPlanType = #{emergencyPlanType} limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab SELECT CONCAT(a.id,'') AS id ,a.fullName ,a.emergencyPlanType ,a.content ,a.dispose ,DATE_FORMAT(a.updateTime,'%Y-%m-%d %H:%i:%s') AS updateTime FROM sp_activity_emergency_plan a LEFT JOIN sp_activity c ON a.activityId = c.id WHERE c.activityNo = #{activityNo} AND ( a.fullName like CONCAT('%', #{keywords}, '%') OR a.content like CONCAT('%', #{keywords}, '%') OR a.dispose like CONCAT('%', #{keywords}, '%') ) AND a.emergencyPlanType = #{emergencyPlanType} AND a.updateTime >= CONCAT(#{startDate}," 00:00:00") AND CONCAT(#{endDate}," 23:59:59") >= a.updateTime