<if test="djsj!=null and djsj!=''">
and DJSJ <![CDATA[>=]]> (to_date(#{djsj, jdbcType=VARCHAR},'yyyy-MM-dd'))
</if>
<if test="djsj!=null and djsj!=''">
and DJSJ <![CDATA[<]]> (to_date(#{djsj, jdbcType=VARCHAR},'yyyy-MM-dd'))+1
</if>
对应的字段数据库中保存的类型是 Data
<if test="cysjkssj != null and cysjkssj != ''">
and cysj <![CDATA[>=]]> DATE_FORMAT(#{cysjkssj,jdbcType=VARCHAR},'%Y%m%d')
</if>
<if test="cysjjssj != null and cysjjssj != ''">
and cysj <![CDATA[>=]]> DATE_FORMAT(#{cysjjssj,jdbcType=VARCHAR},'%Y%m%d')
</if>
对应的字段数据库中保存的类型是 Data