package com.zt.life.modules.mainPart.sys.controller;
|
|
|
import com.zt.common.annotation.LogOperation;
|
import com.zt.common.annotation.QueryParam;
|
import com.zt.common.constant.Constant;
|
import com.zt.common.db.query.QueryFilter;
|
import com.zt.common.servlet.Result;
|
import com.zt.common.validator.AssertUtils;
|
import com.zt.common.validator.ValidatorUtils;
|
import com.zt.common.validator.group.AddGroup;
|
import com.zt.common.validator.group.DefaultGroup;
|
import com.zt.common.validator.group.UpdateGroup;
|
import com.zt.life.modules.mainPart.sys.model.SysChangeLog;
|
import com.zt.life.modules.mainPart.sys.model.SysMysql;
|
import com.zt.life.modules.mainPart.sys.service.SysChangeLogService;
|
import com.zt.life.modules.mainPart.sys.service.SysMysqlService;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiImplicitParam;
|
import io.swagger.annotations.ApiImplicitParams;
|
import io.swagger.annotations.ApiOperation;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.web.bind.annotation.*;
|
import springfox.documentation.annotations.ApiIgnore;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.*;
|
import java.nio.charset.StandardCharsets;
|
import java.util.LinkedList;
|
import java.util.List;
|
|
|
/**
|
* sys_change_log
|
*
|
* @author zt generator
|
* @since 1.0.0 2024-10-09
|
*/
|
@RestController
|
@RequestMapping("/sys/mysql/")
|
public class SysMysqlController {
|
@Autowired
|
private SysMysqlService sysMysqlService;
|
|
@GetMapping("check")
|
@ApiOperation("查询")
|
public Result<SysMysql> check(String sql){
|
SysMysql data = sysMysqlService.check(sql);
|
|
return Result.ok(data);
|
}
|
|
@GetMapping("execute")
|
@ApiOperation("修改")
|
public Result execute(String sql){
|
sysMysqlService.execute(sql);
|
|
return Result.ok();
|
}
|
|
@GetMapping("logDownload")
|
@ApiOperation("日志下载")
|
public Result logDownload(HttpServletRequest request, HttpServletResponse response){
|
sysMysqlService.logDownload(request,response);
|
|
return Result.ok();
|
}
|
}
|