Mybatis传入多个参数

一、单个参数

mapper

1
public List<Test> getTestList(String id);

xml

1
2
3
<select id = "getTestList" parameterType = "java.lang.String" resultType = "com.test.Test">
  select t.* from test t where t.id = #{id}
</select>

二、多个参数
1、使用索引

mapper

1
public List<Test> getTestList(String id, String name);

xml

1
2
3
<select id = "getTestList" resultType = "com.test.Test">
  select t.* from test t where t.id = #{0} and t.name = #{1}
</select>

2、使用Map封装多参数

mapper

1
public List<Test> getTestList(HashMap map);

xml

1
2
3
<select id = "getTestList" parameterType = "hashmap" resultType = "com.test.Test">
  select t.* from test t where t.id = #{id} and t.name= #{name}
</select>

#{}中的变量名要和map中的key对应。

3、使用注解

mapper

1
public List<Test> getTestList(@Param("id")int id, @Param("name")int name);

xml

1
2
3
<select id = "getTestList" resultMap = "com.test.Test">
select t.* from test t where t.id = #{id} and t.name = #{name}
</select>

坚持原创技术分享,您的支持将鼓励我继续创作!