select t.*,x.mc from whxj_base t left join xjzt x on t.sslx = x.id where 1=1
and to_char(t.xjksrq,'yyyy') = #{0}
and to_char(t.xjksrq,'MM') = #{1}
我的if判断代码呢 ? 谁给我屏蔽了???test = "#{1}!=null and #{1} !=''“
select t.*,x.mc from whxj_base t left join xjzt x on t.sslx = x.id
where 1=1
and to_char(t.xjksrq,'yyyy') = #{0}
and to_char(t.xjksrq,'MM') = #{1}
请指点?????
<select id="count" parameterType="Roles" resultType="int">
select count(0) from role
<where>
<if test="name != null and name != ''">
name like '%${name}%'
</if>
</where>
</select>