81,094
社区成员
发帖
与我相关
我的任务
分享
<select id="myTest" resultMap="BaseResultMap" parameterType="java.lang.String" >
select
*
from scm_producttype pt
<if test='value!="" and value!=null'>
where TypeNameCN='test'
</if>
order by pt.ProductTypeID
</select>
<if test="value!='' and value!=null">
也是不行<select id="myTest" resultMap="BaseResultMap" parameterType="java.lang.String" >
select
*
from scm_producttype pt
<if test='value!="" and value!=null'>
where TypeNameCN='test'
</if>
order by pt.ProductTypeID
</select>
改成
<select id="myTest" resultMap="BaseResultMap" parameterType="java.lang.String" >
select
*
from scm_producttype pt
<if test='_parameter!="" and _parameter!=null'>
where TypeNameCN='test'
</if>
order by pt.ProductTypeID
</select>
能行不
<if test="value!=null and value!=''">