<select id="searchProducts" parameterType="products" resultType="products">
select *from products
<where>
<if test="pname != null">
and pname like '%${pname}%'
</if>
<if test="cid != null">
and cid = #{cid}
</if>
</where>
</select>
相关文章
- 01-09【UVA - 10474 】Where is the Marble?(排序)
- 01-09导出数据子集:带where条件的exp导出
- 01-09SQL中WHERE子句中为什么不能使用聚合函数?
- 01-09Where Comes The Name "Softmax"?
- 01-09技术人生:Knowing when or where it’s appropriate to use a technique or tool is just as important as knowing how to use it.
- 01-09torch.where()函数解读
- 01-09torch.where()的用法以及例子
- 01-09where后一个条件和多个条件的查询速度
- 01-09INNER JOIN ON vs WHERE clause
- 01-09Where is ABAP Netweaver HTTP 304 not modified set