ToolController.java

package com.viontech.storage.controller;

import cn.hutool.json.JSONObject;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;

/**
 * .
 *
 * @author 谢明辉
 * @date 2021/12/15
 */

@RestController
@RequestMapping("/tool")
public class ToolController {

    @Resource
    private JdbcTemplate jdbcTemplate;

    @PostMapping("execSQL")
    public Object execSQL(@RequestBody JSONObject jsonObject) {
        String sql = jsonObject.getStr("sql");
        jdbcTemplate.execute(sql);
        return "sdfsd";
    }


}