Question

如何定义问号字符串

Answer 1

select * from
<dynamic>
<isNotEmpty property="table">
#table:VARCHAR#
</isNotEmpty>
</dynamic>
<dynamic prepend="where">
<isNotEmpty prepend="and" property="fpdm">
t.send_fpdm = #fpdm:VARCHAR#
</isNotEmpty>
<isNotEmpty prepend="and" property="begin">
to_number(t.send_begin_fphm)<![CDATA[ >= ]]>to_number(#begin:VARCHAR#)
</isNotEmpty>
<isNotEmpty prepend="and" property="end">
to_number(t.send_end_fphm)<![CDATA[ <= ]]>to_number(#end:VARCHAR#)
</isNotEmpty>
</dynamic>