ToolController.java
801 Bytes
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";
}
}