一:基于xml实现
dao层
@MapKey("executeSql")
List
mybatis的xml文件
${sqlStr}
二:基于注解实现
dao层
@Select("${sqlStr}")
// @MapKey("executeSql")
List
controller层:
@GetMapping("executeSql")
public List
postman测试:
测试类:
@SpringBootTest
@RunWith(SpringJUnit4ClassRunner.class)
public class Test {
@Autowired
private AutoMapper autoMapper ;
@Test
public void get1(){
String sqlStr= "select id,age,name from user where id = 1";
List> list = publicMapper.executeSql(sqlStr);
}
Mybatis官方文档的对该注解的解释



