mybatis相关*mapper.xml传值

1.传实体 当mapper配置文件中没有相对应的数据库字段,或是实体与数据库不同时,可以直接使用实体类进行传值,如 parameterType="java.com.entity"//对应实体类

<select id="queryByNameAndSex" parameterType="java.com.entity.Student" resultMap="student">

2.传多个参数

1. 使用@Param注解(不需要些parameterType)

public List<Student> queryByNameAndSex(@Param("name")String name,@Param("age")String age);

<select id="queryByNameAndSex" resultMap="student">
    select * from student where 1=1
    <if test="null != name and '' != name">
       and  name like CONCAT('%','${name}','%' )
    </if>
     <if test="null != age and '' != age">
       and  sex = #{age}
    </if>
</selcet>

1. 直接使用下标

public List<Student> queryByNameAndSex(String name,String sex);

<select id="queryByNameAndSex" resultMap="student">
    select * from student where 1=1
    <if test="null != name and '' != name">
       and  name like CONCAT('%','${0}','%' )
    </if>
     <if test="null != age and '' != age">
       and  sex = #{1}
    </if>
</selcet>

转载于:https://my.oschina.net/iovuMi/blog/1576739