mybatis中实现动态SQL的标签有:
- where
- if
- chose when otherwise
- set
- foreach
- include
- trim
- sql
- band
- where 标签:在拼写SQL语句的时候,where标签,可以自动添加where关键字,如果参数是两个,自动添加and连接。
<select id="selectMore3" resultType="flower" parameterType="java.lang.String">
SELECT id,name,price,product from flower
<where>
<if test="param1 != null and param1 !=''">
name = #{param1}
</if>
<if test="param2 != null and param2 != ''">
product = #{parma2}
</if>
</where>
</select>
- if标签:简单的逻辑判断,test是条件,具体实例如下:
<select id="selectMore2&