Mybits中根据姓名查询和模糊查询sql语句的编写
<Husband.xml>配置文件中内容:
<mapper namespace="Husband">
<resultMap type="com.sram.entity.Husband" id="husResult">
<id column="id" jdbcType="INTEGER" property="hid"/>
<result column="name" jdbcType="VARCHER" property="name"/>
<result column="age" jdbcType="INTEGER" property="age"/>
</resultMap>
<!--编写相关操作-->
<select id="findByName" parameterType="STRING" resultMap ="husResult">
select id,name,age from husband where name=#{_parameter};
</select>
</mapper>
查询sql语句的编写,需要注意的地方:
sql语句编写可以有以下方式:
(1)select id,name,age from husband where name=#{_parameter};
(2)select id,name,age from husband where name = #{_parameter};(注意空格的添加)
(3)select id,name,age from husband where name like '%' #{_parameter} '%';(注意单引号的添加)
(4)select id,name,age from husband where 1=1
<if test="_parameter!=null and !"".equals(#{_parameter})">
and name like '%' #{_parameter} '%';
</if>
(5)select id,name,age from husband where 1=1
<if test="_parameter!=null and !"".equals(_parameter.trim())">
and name like '%' #{_parameter} '%';
</if>
(6)select id,name,age from husband
<where>
<if test="_parameter!=null and !"".equals(_parameter.trim())">
and name like '%' #{_parameter} '%';
</if>
</where>