Mybatis执行前端传入的SQL语句
Mapper.xml文件
<select id="executeSql" parameterType="String" resultType="java.util.Map">
${sqlStr}
</select>
Mapper方法
List<Map<String, Object>> executeSql(@Param(value = "sqlStr") String sqlStr);
Controller层
/**
* 执行前端传入的sql语句
*
* @param sqlStr sql语句
* @return lsit
*/
@GetMapping("executeSql")
public List<Map<String, Object>> executeSql(@RequestParam(required = true, value = "sqlStr") String sqlStr) {
List<Map<String, Object>> list = iLaboratoryService.executeSql(sqlStr);
return list;
}
注:动态sql字段不确定,返回list<Map<String,Object>>数据结构