Mybati SQL query statements within two dates

Loaded from:

Http://blog.csdn.net/u010442302/article/details/72902441?locationNum=9&fps=1

<select id= "Selectbyparamcount" resulttype= "Java.lang.Integer" parametertype= " Com.sss.fin.cif.vo.admin.BankCardAuditQuery ">select count (1) from Tablename<where><if test=" Operatordatestart! = null and Operatordatestart! = "" >operator_date >= #{operatordatestart,jdbctype=varchar} </if><if test= "Operatordateend! = null and Operatordateend! =" "><! [Cdata[and operator_date <= concat (#{operatordateend,jdbctype=varchar}, ' 235959 ')]]></if></where ></select>
<! [Cdata[]]> Escape < (less than) SQL statement, the default is to position the YYYYMMDD as 0 o'clock of that date.

Top

1

Mybati SQL query statements within two dates