mapper层;
public interface CompanyMapper extends BaseMapper<Company> {
@Select("select id from company where tel = #{map.tel} or name = #{map.company_name}")
List<Integer> getIdByNameOrTel(@Param("map")Map<String, Object> map);
@Select("select id from company where tel = #{map.tel} or name = #{map.company_name}")
Map<String, Object> getId(@Param("map") Map<String, Object> map);
}
test 方法,都存入一个空的map,查询不出结果:
@Test
public void test05() {
Map<String, Object> map1 = new HashMap<>();
List<Integer> list = companyMapper.getIdByNameOrTel(map1);
Map<String, Object> map = companyMapper.getId(map1);
System.out.println("list: " + list);
System.out.println("map: " + map);
}
sql语句打印为;
DEBUG==> Preparing: select id from company where tel = ? or name = ?
DEBUG==> Parameters: null, null
DEBUG<== Total: 0
DEBUG==> Preparing: select id from company where tel = ? or name = ?
DEBUG==> Parameters: null, null
DEBUG<== Total: 0
输出结果是:
list: []
map: null