MyBatis传递参数的各种方式以及获取方式

1、map
<select id="findRole" parametertype="map" resultMap="java.util.HashMap">
    SELECT
    id,role_name,note FROM t_role
    WHERE role_name like concat
    ('%',#{roleName},'%')
    and note like concat('%',#{note},'%')
</select>

public <T> List<T> findRole(Map<String, String> params);//接口

HashMap<String, String> paramsMap = new HashMap<String, String>();
        paramsMap.put("roleName", "me");
        paramsMap.put("note", "te");
        roleMapper.findRole(paramsMap);

2、@Param注解

public List<Role> findRole(@Param("roleName")String roleName,@Param("note")String note);//接口

<select id="findRole" resultMap="roleMap">
    SELECT
    id,role_name,note FROM t_role
    WHERE role_name like concat
    ('%',#{roleName},'%')
    and note like concat('%',#{note},'%')
</select>
3、JavaBean

<select id="findRole" parametertype="com.learn.params.RoleParam" resultMap="roleMap">
    SELECT
    id,role_name,note FROM t_role
    WHERE role_name like concat
    ('%',#{roleName},'%')
    and note like concat('%',#{note},'%')
</select>

public List<Role> findRole(RoleParam roleParam);//接口

@TableSeg(tableName = "ly_role", id="id")
public class RoleParam extends FormMap<String,Object>{

    private static final long serialVersionUID = 1L;

}