springboot 通过配置文件执行sql语句

1 配置

2contorller代码 

@RestController
@RequestMapping(value = "/sql")
public class SqlController {

    @Value("${test.sql.findList}")
    private  String userSql;


    @Autowired
    private EntityManager entityManager;

    @PostMapping("testSql")
    public Object testSql(@RequestBody FileInfo fileInfo) {

        Query query = entityManager.createNativeQuery(userSql);
        query.setParameter("fileName","%"+fileInfo.getFileName()+"%");
        List resultList = query.getResultList();
        List<Map> result = new ArrayList<>();
        for (Object o : resultList) {
            //转为map
            Object[] cells = (Object[]) o;
            Map map = new HashMap();
            //sql字段顺序
            map.put("id", cells[0] != null?cells[0].toString():"");
            map.put("fileName", cells[1] != null?cells[1].toString():"");
            map.put("suffixName", cells[2] != null?cells[2].toString():"");
            map.put("fileSize", cells[3] != null?cells[3].toString():"");
            map.put("filePath", cells[4] != null?cells[4].toString():"");

            result.add(map);
        }
        return result;
    }
}