Question

iBATIS sql语句怎么写

SELECT dataId,tm,value FROM dbo.spanData_His WHERE dataID =11283

AND (tm between '2008-07-07 16:00:00' AND '2008-07-10 16:00:00'

or tm between '2009-07-07 16:00:00' AND '2009-07-10 16:00:00'

or tm between '2010-07-07 16:00:00' AND '2010-07-10 16:00:00')

and spanId=1 ORDER BY dataID ASC ,tm ASC

如上语句如何在iBATIS配置中写，并且tm这个时间字段是不固定的，或许有一个，2个...，也许一个都没有！

Answer 1

参考下面这个写法
<dynamic prepend="where">
<isNull property="username"></isNull>
<isNotNull property="username">
orders.customer = #username#
</isNotNull>
</dynamic>

用isNull标签，你到google上再找找isNull的具体用法吧。