daizuojian

org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r

最近在做项目，使用到了Mybatis-plus，页面上需要对某些字段进行排序，原来是固定好哪些字段需要排序，然后在Controller里接收参数，如下代码所示。 @LogOperation(name = "query urpOfi", objType = "Config") @GetMapping public ResponseEntity<DtoResponse<OfiDto>> queryOfi( @RequestParam(name =