@RequestMapping("/queryView") public String toQueryView(HttpServletRequest request, HttpServletResponse response, Model model) throws IOException { DataBaseQuery query = new DataBaseQuery(); Result<List<DataBaseDO>> ret = dataBaseService.find(query); if (ret != null && ret.isSuccess() && ret.getValue() != null) { model.addAttribute("ret", ret.getValue()); } return "/websql/queryView"; }
@RequestMapping(value = "/query", method = RequestMethod.POST) @ResponseBody public DynamicColumnResult toExeSqlForQuery( @RequestParam("id") long id, @RequestParam("sql") String sql) throws IOException { try { Profiler.enter("start exe query"); DynamicColumnResult result = null; if (id <= 0) { result = DynamicColumnResult.getErrorResult(Errors.ERROR_NOT_EXIST.toString()); return result; } Result<DataBaseDO> dataBaseRet = dataBaseService.get(id); if (dataBaseRet != null && dataBaseRet.isSuccess() && dataBaseRet.getValue() != null) { if (isSingleSql(sql)) { result = webSqlService.executeQuery( sql, dataBaseRet.getValue(), UserContextHolder.getUserId(), UserContextHolder.getName()); } else { result = DynamicColumnResult.getErrorResult(Errors.ERROR_SQL_COUNT.toString()); } } else { result = DynamicColumnResult.getErrorResult(Errors.ERROR_NOT_EXIST.toString()); } return result; } finally { Profiler.release(); } }