<select id="queryInspectList" resultClass="inspectinfo">
select insp.* FROM inspectinfo1 insp
<dynamic prepend=" where ">
<isNotEmpty prepend=" and " property="reflectivity">reflectivity = 80 </isNotEmpty>
</dynamic>
</select>我这样写有问题吗?怎么查询出来的结果没有执行where啊<select id="queryInspectList" resultClass="inspectinfo">
select insp.* FROM inspectinfo1 insp where reflectivity = 80
</select> 这样写就没有问题
是不是<isNotEmpty>我用的不对啊,请高手指点
select insp.* FROM inspectinfo1 insp
<dynamic prepend=" where ">
<isNotEmpty prepend=" and " property="reflectivity">reflectivity = 80 </isNotEmpty>
</dynamic>
</select>我这样写有问题吗?怎么查询出来的结果没有执行where啊<select id="queryInspectList" resultClass="inspectinfo">
select insp.* FROM inspectinfo1 insp where reflectivity = 80
</select> 这样写就没有问题
是不是<isNotEmpty>我用的不对啊,请高手指点
改为where 1=1试试
|
|
<isNotEmpty property="reflectivity">reflectivity = '80' </isNotEmpty>
and 去掉、 参数值加引号、
select * from hpm_hotelpromotionrelease2
<dynamic prepend="where">
<isNotEmpty prepend="and" property="id">
id = #id#
</isNotEmpty>
后面跟着isnotempty。。就省去那个prepend="where"了
"<select id="queryInspectList" resultClass="inspectinfo">
select insp.* FROM inspectinfo1 insp
<dynamic prepend=" where ">
<isNotEmpty prepend=" and " property="reflectivity">
(insp.reflectivity = 80) </isNotEmpty>
</dynamic>
</select>"
你的参数类型呢?最好这样写property="#reflectivity" #reflectivity = 80