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

最新推荐文章于 2024-07-30 16:45:57 发布

原创最新推荐文章于 2024-07-30 16:45:57 发布 · 894 阅读

CC 4.0 BY-SA版权

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;

}