<statement id="queryNewTmpSIList" resultClass="siInfo"
parameterClass="siqry" >
<dynamic prepend="">
<isEqual property="qryFlag" compareValue="1">
select * from adc_spinfotmp a where a.status = 0
</isEqual>
<isEqual property="qryFlag" compareValue="2">
select * from adc_spinfo a where a.status = 7
</isEqual>
<isEqual property="qryFlag" compareValue="3">
select * from adc_spinfo a where 1=1
</isEqual>
<isEqual property="qryFlag" compareValue="4">
select a.* from adc_spinfo a,adc_sptype b where a.status = 1 and a.sptype=b.sptype
</isEqual>
<isEqual property="qryFlag" compareValue="5">
select a.* from adc_spinfo a where (a.status = 1 or a.status=7)
</isEqual>
<isEqual property="qryFlag" compareValue="6">
select * from adc_spinfotmp a where 1 = 1
</isEqual>
<isEqual property="qryFlag" compareValue="7">
select a.* from adc_spinfo a, adc_workbill b
where b.billtype<![CDATA[<]]>3 and a.spid=b.billkey
</isEqual>
<isEqual property="qryFlag" compareValue="7">
<isEqual property="status" compareValue="0">
and 1=1
</isEqual>
<isEqual property="status" compareValue="1">
and a.status = 1
</isEqual>
<isEqual property="status" compareValue="5">
and a.status = 5
</isEqual>
<isEqual property="status" compareValue="6">
and a.status = 6
</isEqual>
<isEqual property="status" compareValue="7">
and a.status = 7
</isEqual>
</isEqual>
<isNotEmpty prepend="AND" property="spid">
spid = #spid#
</isNotEmpty>
<isNotEmpty prepend="AND" property="spname">
spname like '%$spname$%' escape '/'
</isNotEmpty>
<isNotEmpty prepend="AND" property="spcode">
spcode like '%$spcode$%'
</isNotEmpty>
<isNotEmpty prepend="AND" property="sptype">
a.sptype =#sptype#
</isNotEmpty>
<isNotEmpty prepend="AND" property="begintime">
opentime <![CDATA[>=]]> to_date('$begintime$','yyyy-mm-dd hh:mi:ss')
</isNotEmpty>
<isNotEmpty prepend="AND" property="endtime">
endtime <![CDATA[<=]]> to_date('$endtime$','yyyy-mm-dd hh:mi:ss')
</isNotEmpty>
<isNotEmpty prepend="AND" property="areapath">
areapath like '%$areapath$%'
</isNotEmpty>
order by opentime desc
</dynamic>
</statement><!-- 查询临时SI表记录总数 -->
生成的sql语句没有问题 而跑出了数据库中没有某一个的异常时 在select 加上
remapResults="true"就可以了