<select id = "selectRole" parameterType="sYsRole" resultType="sYsRole" >
select * from role
<where>
<if test = "r_id !=null and r_id != ''">
and r_id = #{r_id}
</if>
<if test = "r_name !=null and r_name != ''">
and r_name = #{r_name}
</if>
</where>
</select>