What is the method for querying multiple parameters in MyBatis?

9 months ago

Liam

2 minutes

In MyBatis, you can pass multiple parameters for querying by using either the @Param annotation or a Map object. Next, we will explain these two methods individually.

Could you provide information about the parameter?

@Select("SELECT * FROM table_name WHERE column1 = #{param1} AND column2 = #{param2}")
List<YourEntity> selectByParams(@Param("param1") String param1, @Param("param2") String param2);

Chart

@Select("SELECT * FROM table_name WHERE column1 = #{param1} AND column2 = #{param2}")
List<YourEntity> selectByParams(Map<String, Object> params);

When calling these two methods, you need to pass in the corresponding parameters as shown below:

List<YourEntity> result = yourMapper.selectByParams("value1", "value2");

// 或者使用Map对象
Map<String, Object> params = new HashMap<>();
params.put("param1", "value1");
params.put("param2", "value2");
List<YourEntity> result = yourMapper.selectByParams(params);