<if test="submitTime!=null and submitTime!=''">
AND DATE_FORMAT(sc.submit_time, '%Y-%m-%d') = DATE_FORMAT(#{submitTime}, '%Y-%m-%d')
</if>
<if test="correctTime!=null and correctTime!=''">
AND DATE_FORMAT(sc.correct_time, '%Y-%m-%d') = DATE_FORMAT(#{correctTime}, '%Y-%m-%d')
</if>
转载于:https://www.cnblogs.com/tangyouwei/p/10180205.html