如何从页面SQL语句进行相关后台查询

2025年03月23日 05:21
有1个网友回答
网友(1):

@RequestMapping(value = "transactionFlow/informationQuery1", method = RequestMethod.GET)public String informationQuery1(@RequestParam(value = "sql", required = false) String sql, Model model) { List list3 = new LinkedList<>(); String query1 = customerLedgersService.query(sql); Map map = new HashMap(); if (query1 != null) { String[] key = query1.split(";"); for (int i = 0, len = key.length; i < len; i++) { list3.add(key[i]); } model.addAttribute("sql", sql); model.addAttribute("list3", list3); return "/complement/informationQuery"; } else { model.addAttribute("sql", sql); return "/complement/informationQuery"; } }