{"id":839,"date":"2022-02-27T22:11:49","date_gmt":"2022-02-28T06:11:49","guid":{"rendered":"https:\/\/ligai.cn\/blog\/?p=839"},"modified":"2022-02-27T22:11:51","modified_gmt":"2022-02-28T06:11:51","slug":"%e4%b8%ba%e4%bb%80%e4%b9%88%e6%88%91%e7%9a%84-order-by-create_time-asc-%e5%8f%98%e6%88%90%e4%ba%86-order-by-asc","status":"publish","type":"post","link":"https:\/\/ligai.cn\/blog\/sharing\/839.html","title":{"rendered":"\u4e3a\u4ec0\u4e48\u6211\u7684 ORDER BY create_time ASC \u53d8\u6210\u4e86 order by ASC"},"content":{"rendered":"\n

\u7f16\u8005\u8bf4\uff1a<\/p>\n\n\n\n

\u5f00\u53d1\u662f\u4e00\u4ef6\u201c\u5347\u7ea7\u6253\u602a\u201d\u7684\u4e8b\uff0c\u5728\u5f00\u53d1\u5404\u4e2a\u73af\u5883\u4e0b\uff0c\u5996\u602a\u9891\u51fa\uff0c\u6218\u672f\u4e0d\u65ad\u5347\u7ea7\u3002 \u7a0b\u5e8f\u5458\u60f3\u8981\u629b\u5f00\u8ff7\u96fe\uff0c\u7aa5\u5f97\u771f\u76f8\uff0c\u987b\u5f97\u5148\u53c2\u900f\u4e2a\u4e2d\u62db\u5f0f\uff0c\u7136\u540e\u9010\u4e00\u89e3\u51b3\u3002<\/p>\n\n\n\n

\u672c\u671f\u6587\u7ae0\u7684\u5185\u5bb9\u201c\u5c31\u5730\u53d6\u6750\u201d\uff0c\u6765\u6e90\u81ea LigaAI \u5de5\u4f5c\u4e2d\u5e38\u89c1\u7684\u5f00\u53d1\u95ee\u9898\uff0c\u5e76\u901a\u8fc7\u300c\u573a\u666f\u6d4b\u8bd5\u2014\u5206\u6790\u533a\u522b\u2014\u63d0\u51fa\u89e3\u51b3\u65b9\u6848\u300d\u7684\u65b9\u6cd5\u5e2e\u6211\u4eec\u89c4\u907f\u548c\u5c3d\u65e9\u8bc6\u522b\u8fd9\u79cd\u9677\u9631~\u8bdd\u4e0d\u591a\u8bf4\uff0c\u8ba9\u6211\u4eec\u4e00\u8d77\u6765\u770b\u770b\u5427\uff01<\/p>\n\n\n\n

\u9047\u5230\u7684\u95ee\u9898\uff1a<\/p>\n\n\n\n

\u201c \u4e24\u6761\u4e00\u6bdb\u4e00\u6837\u7684sql\uff0c\u5206\u9875\u7684sql\u6267\u884c\u6ca1\u95ee\u9898\uff0c\u4e0d\u5206\u9875\u7684sql\u6267\u884c\u5c31\u6709\u95ee\u9898\uff1f\u201d<\/strong><\/p>\n\n\n\n

01 \u573a\u666f\u51c6\u5907<\/strong><\/em><\/h2>\n\n\n\n
\n\n\n\n

>> \u6d4b\u8bd5\u573a\u666f<\/strong><\/p>\n\n\n\n

CREATE TABLE `test_page_or_not` (\r\n  `id` bigint(20) NOT NULL COMMENT '\u4e3b\u952e\u7f16\u53f7',\r\n  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '\u540d\u79f0',\r\n  `create_time` datetime(3) NOT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\r\n  `create_by` bigint(20) NOT NULL COMMENT '\u521b\u5efa\u4eba',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='\u6d4b\u8bd5\u5206\u9875\u4e0e\u4e0d\u5206\u9875';\r\n\r\nINSERT INTO `test_page_or_not` (`id`, `name`, `create_time`, `create_by`) VALUES (1, 'name1', '2022-02-17 22:25:04.000', 0);\r\nINSERT INTO `test_page_or_not` (`id`, `name`, `create_time`, `create_by`) VALUES (2, 'name2', '2022-02-17 22:25:04.000', 0);\r\nINSERT INTO `test_page_or_not` (`id`, `name`, `create_time`, `create_by`) VALUES (3, 'name3', '2022-02-18 22:25:04.000', 0);\r\nINSERT INTO `test_page_or_not` (`id`, `name`, `create_time`, `create_by`) VALUES (4, 'name4', '2022-02-19 22:25:04.000', 0);\r\n<\/code><\/pre>\n\n\n\n
\u4e00\u4e9bJava\u7c7b\u6587\u4ef6\uff1a<\/p>\n\n\n\n
public class TestWithPageDTO extends PageDTO {\r\n\r\n    private static final long serialVersionUID = -970059691509424681L;\r\n\r\n    private String name;\r\n\r\n    private String orderBy;\r\n\r\n    public String getName() {\r\n        return name;\r\n    }\r\n\r\n    public void setName(String name) {\r\n        this.name = name;\r\n    }\r\n\r\n    public String getOrderBy() {\r\n        return orderBy;\r\n    }\r\n\r\n    public void setOrderBy(String orderBy) {\r\n        this.orderBy = orderBy;\r\n    }\r\n\r\n    @Override\r\n    public String toString() {\r\n        return \"TestWithPageDTO{\" +\r\n                \"name='\" + name + '\\'' +\r\n                \", orderBy='\" + orderBy + '\\'' +\r\n                '}';\r\n    }\r\n}\r\n<\/code><\/pre>\n\n\n\n
\r\npublic class PageDTO extends BaseDTO {\r\n\r\n    private static final long serialVersionUID = 2572899663737669356L;\r\n\r\n    private Integer pageSize = 10;\r\n\r\n    private Integer pageNum = 1;\r\n\r\n    public Integer getPageSize() {\r\n        return pageSize;\r\n    }\r\n\r\n    public void setPageSize(Integer pageSize) {\r\n        this.pageSize = pageSize;\r\n    }\r\n\r\n    public Integer getPageNum() {\r\n        return pageNum;\r\n    }\r\n\r\n    public void setPageNum(Integer pageNum) {\r\n        this.pageNum = pageNum;\r\n    }\r\n\r\n    @Override\r\n    public String toString() {\r\n        return \"PageDTO{\" +\r\n                \"pageSize=\" + pageSize +\r\n                \", pageNum=\" + pageNum +\r\n                '}';\r\n    }\r\n}\r\n\r\n<\/code><\/pre>\n\n\n\n
\r\npublic class BaseDTO implements Serializable {\r\n\r\n    private static final long serialVersionUID = 9055050419546393543L;\r\n}\r\n\r\n<\/code><\/pre>\n\n\n\n
\r\n\r\npublic class TestWithoutPageDTO extends BaseDTO {\r\n\r\n    private static final long serialVersionUID = 7862152821778815456L;\r\n\r\n    private String name;\r\n\r\n    private String orderBy;\r\n\r\n    public String getName() {\r\n        return name;\r\n    }\r\n\r\n    public void setName(String name) {\r\n        this.name = name;\r\n    }\r\n\r\n    public String getOrderBy() {\r\n        return orderBy;\r\n    }\r\n\r\n    public void setOrderBy(String orderBy) {\r\n        this.orderBy = orderBy;\r\n    }\r\n\r\n    @Override\r\n    public String toString() {\r\n        return \"TestWithoutPageDTO{\" +\r\n                \"name='\" + name + '\\'' +\r\n                \", orderBy='\" + orderBy + '\\'' +\r\n                '}';\r\n    }\r\n}\r\n\r<\/code><\/pre>\n\n\n\n
>> \u5206\u9875\u573a\u666f<\/strong><\/p>\n\n\n\n
\u5148\u6765\u770b\u770b\u5206\u9875\u573a\u666f\u7684\u53c2\u6570\u3001\u4ee3\u7801\u548c\u65e5\u5fd7\u6253\u5370\uff0c\u4ece\u65e5\u5fd7\u53ef\u4ee5\u770b\u51faSQL\u7684\u6700\u540e\u6267\u884c\u662f\u6ca1\u6709\u95ee\u9898\u7684\u3002
\u8bf7\u6c42\u53c2\u6570\uff1a<\/p>\n\n\n\n
{\r\n  \"name\": \"name\",\r\n  \"orderBy\": \"ASC\"\r\n}\r\n\r<\/code><\/pre>\n\n\n\n
sql\u6587\u4ef6\uff1a<\/p>\n\n\n\n
<!--\u5206\u9875\u67e5\u8be2\u6570\u636e-->\r\n<select id=\"selectWithPage\" parameterType=\"com.peng.java_study.api.dto.TestWithPageDTO\" resultMap=\"BaseResultMap\">\r\n    SELECT * FROM test_page_or_not tpon\r\n    WHERE\r\n        tpon.name LIKE CONCAT(\"%\", #{name, jdbcType=VARCHAR}, \"%\")\r\n    <if test=\"orderBy != null and orderBy != ''\">\r\n        ORDER BY tpon.create_time ${orderBy}\r\n    <\/if>\r\n<\/select>\r\n<\/code><\/pre>\n\n\n\n
\u65e5\u5fd7\uff1a<\/p>\n\n\n\n
2022-02-18 16:39:09.217 DEBUG 18036 --- [nio-8080-exec-3] c.p.j.c.m.T.selectWithPage_COUNT         : ==>  Preparing: SELECT count(0) FROM test_page_or_not tpon WHERE tpon.name LIKE CONCAT(\"%\", ?, \"%\")\r\n2022-02-18 16:39:09.218 DEBUG 18036 --- [nio-8080-exec-3] c.p.j.c.m.T.selectWithPage_COUNT         : ==> Parameters: name(String)\r\n2022-02-18 16:39:09.234 DEBUG 18036 --- [nio-8080-exec-3] c.p.j.c.m.T.selectWithPage_COUNT         : <==      Total: 1\r\n2022-02-18 16:39:09.236 DEBUG 18036 --- [nio-8080-exec-3] c.p.j.c.m.T.selectWithPage               : ==>  Preparing: SELECT * FROM test_page_or_not tpon WHERE tpon.name LIKE CONCAT(\"%\", ?, \"%\") ORDER BY tpon.create_time ASC LIMIT ?\r\n2022-02-18 16:39:09.236 DEBUG 18036 --- [nio-8080-exec-3] c.p.j.c.m.T.selectWithPage               : ==> Parameters: name(String), 10(Integer)\r\n2022-02-18 16:39:09.238 DEBUG 18036 --- [nio-8080-exec-3] c.p.j.c.m.T.selectWithPage               : <==      Total: 4\r\n<\/code><\/pre>\n\n\n\n
>> \u4e0d\u5206\u9875\u573a\u666f<\/strong><\/p>\n\n\n\n
\u518d\u6765\u770b\u770b\u6b63\u5e38\u573a\u666f\u7684\u53c2\u6570\u3001\u4ee3\u7801\u548c\u65e5\u5fd7\u6253\u5370\uff1a\u4ece\u65e5\u5fd7\u53ef\u4ee5\u770b\u51fa SQL \u7684\u6267\u884c\u62a5\u9519\u4e86\uff0c\u56e0\u4e3a SQL \u4ece ORDER BY tpon.create_time ASC \u53d8\u6210\u4e86 order by ASC\u3002<\/p>\n\n\n\n
\u8bf7\u6c42\u53c2\u6570\uff1a<\/p>\n\n\n\n
\r\n{\r\n  \"name\": \"name\",\r\n  \"orderBy\": \"ASC\"\r\n}\r\n\r<\/code><\/pre>\n\n\n\n
sql \u6587\u4ef6\uff1a<\/p>\n\n\n\n
\r\n<!--\u4e0d\u5206\u9875\u67e5\u8be2\u6570\u636e-->\r\n<select id=\"selectWithoutPage\" parameterType=\"com.peng.java_study.api.dto.TestWithoutPageDTO\" resultMap=\"BaseResultMap\">\r\n    SELECT * FROM test_page_or_not tpon\r\n    WHERE\r\n        tpon.name LIKE CONCAT(\"%\", #{name, jdbcType=VARCHAR}, \"%\")\r\n    <if test=\"orderBy != null and orderBy != ''\">\r\n        ORDER BY tpon.create_time ${orderBy}\r\n    <\/if>\r\n<\/select>\r\n\r<\/code><\/pre>\n\n\n\n
\u65e5\u5fd7:<\/p>\n\n\n\n
\r\n2022-02-18 16:52:24.684 DEBUG 18036 --- [nio-8080-exec-5] c.p.j.c.m.T.selectWithoutPage            : ==>  Preparing: SELECT * FROM test_page_or_not tpon WHERE tpon.name LIKE CONCAT(\"%\", ?, \"%\") order by ASC\r\n2022-02-18 16:52:24.684 DEBUG 18036 --- [nio-8080-exec-5] c.p.j.c.m.T.selectWithoutPage            : ==> Parameters: name(String)\r\n2022-02-18 16:52:24.687 ERROR 18036 --- [nio-8080-exec-5] c.p.java_study.rest.test.TestController  : TestController.list(TestWithoutPageDTO) exception: \r\n\r\norg.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1\r\n### The error may exist in file [D:\\file\\project\\1\\java-study\\java-study-provider\\target\\classes\\mapper\\TestPageOrNotMapper.xml]\r\n### The error may involve com.peng.java_study.core.mapper.TestPageOrNotMapper.selectWithoutPage-Inline\r\n### The error occurred while setting parameters\r\n### SQL: SELECT * FROM test_page_or_not tpon WHERE tpon.name LIKE CONCAT(\"%\", ?, \"%\") order by ASC\r\n### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1\r\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1\r\n        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.6.jar:2.0.6]\r\n        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar:2.0.6]\r\n        at com.sun.proxy.$Proxy92.selectList(Unknown Source) ~[na:na]\r\n        at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.6.jar:2.0.6]\r\n        at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at com.sun.proxy.$Proxy93.selectWithoutPage(Unknown Source) ~[na:na]\r\n        at com.peng.java_study.core.manager.impl.TestPageOrNotManagerImpl.selectWithoutPage(TestPageOrNotManagerImpl.java:36) ~[classes\/:na]\r\n        at com.peng.java_study.rest.test.TestController.list(TestController.java:150) ~[classes\/:na]\r\n        at java.base\/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]\r\n        at java.base\/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]\r\n        at java.base\/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]\r\n        at java.base\/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]\r\n        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at com.peng.java_study.config.LanguageFilter.doFilter(LanguageFilter.java:39) ~[classes\/:na]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.4.RELEASE.jar:5.2.4.RELEASE]\r\n        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at java.base\/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]\r\n        at java.base\/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]\r\n        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.31.jar:9.0.31]\r\n        at java.base\/java.lang.Thread.run(Thread.java:834) ~[na:na]\r\nCaused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1\r\n        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.23.jar:8.0.23]\r\n        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.23.jar:8.0.23]\r\n        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.23.jar:8.0.23]\r\n        at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370) ~[mysql-connector-java-8.0.23.jar:8.0.23]\r\n        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.2.jar:na]\r\n        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar:na]\r\n        at java.base\/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]\r\n        at java.base\/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]\r\n        at java.base\/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]\r\n        at java.base\/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]\r\n        at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at com.sun.proxy.$Proxy132.execute(Unknown Source) ~[na:na]\r\n        at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at com.github.pagehelper.util.ExecutorUtil.pageQuery(ExecutorUtil.java:177) ~[pagehelper-5.1.11.jar:na]\r\n        at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:104) ~[pagehelper-5.1.11.jar:na]\r\n        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at com.sun.proxy.$Proxy130.query(Unknown Source) ~[na:na]\r\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.6.jar:3.5.6]\r\n        at java.base\/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]\r\n        at java.base\/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]\r\n        at java.base\/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]\r\n        at java.base\/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]\r\n        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar:2.0.6]\r\n        ... 62 common frames omitted\r\n\r<\/code><\/pre>\n\n\n\n
02\u3001\u5206\u6790<\/strong><\/em><\/h2>\n\n\n\n
\n\n\n\n
\u4e24\u4e2a sql \u7684\u8bed\u53e5\u548c\u5165\u53c2\u662f\u4e00\u6bdb\u4e00\u6837\u7684\uff0c\u552f\u4e00\u7684\u533a\u522b\u5728\u4e8e\u4e00\u4e2a\u4f7f\u7528\u4e86\u5206\u9875\uff0c\u53e6\u4e00\u4e2a\u6ca1\u6709\u4f7f\u7528\u5206\u9875\u3002\u56e0\u6b64\u6211\u4eec\u6765\u4ed4\u7ec6\u5206\u6790\u4e0b\u62a5\u9519\u65e5\u5fd7\uff0c\u67e5\u627e sql \u88ab\u4fee\u6539\u7684\u539f\u56e0\u3002<\/p>\n\n\n\n
>> \u5206\u6790\u5177\u4f53\u7684\u4ee3\u7801\u8c03\u7528\u94fe<\/strong><\/p>\n\n\n\n
\u5728\u65e5\u5fd7\u768499\u884c\uff0c\u6211\u4eec\u53d1\u73b0\u6709\u4e00\u4e2a PageHelper \u7684\u8c03\u7528\u6808\u3002<\/p>\n\n\n\n
 at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:104) ~[pagehelper-5.1.11.jar:na]\r\n \r<\/code><\/pre>\n\n\n\n
\u8fdb\u5165\u8be5\u884c\u4ee3\u7801\uff0c\u53d1\u73b0\u5b83\u8fdb\u5165\u4e86\u5206\u9875\u67e5\u8be2\u3002\u90a3\u4e48\uff0c\u95ee\u9898\u6765\u4e86\uff1a<\/p>\n\n\n\n
\u660e\u660e\u6211\u4eec\u4f7f\u7528\u7684\u5bf9\u8c61\u662f TestWithoutPageDTO.class\uff0c\u8c03\u7528\u7684 sql \u4e5f\u662f selectWithoutPage\uff0c\u4e3a\u5565\u8fd8\u662f\u4f1a\u8fdb\u5165\u5206\u9875\u67e5\u8be2\u5462\uff1f<\/p>\n\n\n\n
\u8ba9\u6211\u4eec\u6765\u4e00\u63a2\u7a76\u7adf\uff1a<\/p>\n\n\n\n
\u4e0b\u56fe\u76841\u53f7\u7ea2\u8272\u5708\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u5224\u65ad\u5f53\u524dsql\u662f\u5426\u9700\u8981\u8fdb\u884c\u5206\u9875\u3002\u6839\u636e\u56fe\u6570\u636e\u663e\u793a\uff0c\u672c\u5e94\u8be5\u8d70 else \u7684\u5206\u652f\uff08\u4e0d\u5206\u9875\uff0c3\u53f7\u7eff\u8272\u5708\uff09\u7684\uff0c\u4f46\u6700\u540e\u8fdb\u4e86 if \u5206\u652f\uff08\u5206\u9875\uff0c2\u53f7\u7ea2\u8272\u5708\uff09\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u7ee7\u7eed\u4f7f\u7528 skip \u65b9\u6cd5\u67e5\u770b\u3002\u6309\u7167\u8be5\u4ee3\u7801\u7684\u903b\u8f91\uff0c4\u53f7\u7ea2\u8272\u5708\u7684 page \u5e94\u4e3a null \u624d\u4e0d\u4f1a\u5206\u9875\uff1b\u65e2\u7136\u5206\u9875\u4e86\uff0c\u90a3\u5c31\u8bf4\u660e page \u4e0d\u4e3a null \u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u5229\u7528 getPage \u65b9\u6cd5\uff0c\u5728\u7ecf\u8fc7\u8c03\u8bd5\u540e\u6211\u4eec\u53d1\u73b0\uff0c\u4ee3\u7801\u8fdb\u5165\u4e865\u53f7\u7ea2\u8272\u5708\u4f4d\u7f6e\u3002\u8fd9\u8868\u660e\uff0c\u8981\u4e48\uff0c\u53c2\u6570\u5bf9\u8c61\u5df2\u5b9e\u73b0\u4e86 IPage \u63a5\u53e3\uff0c\u8981\u4e48\uff0csupportMethodsArguments \u53c2\u6570\u4e3a true\u3002
\u6839\u636e\u4e0a\u9762 sql \u53c2\u6570\uff0c\u6211\u4eec\u5f97\u77e5\u53c2\u6570\u662f TestWithoutPageDTO.class \u7684\u5b9e\u4f8b\uff0c\u5b83\u7684\u7c7b\u7ee7\u627f\u56fe\u5982\u4e0b\u3002\u8be5\u7c7b\u5e76\u6ca1\u6709\u7ee7\u627f\u6216\u5b9e\u73b0 IPage \u63a5\u53e3\uff0c\u56e0\u6b64\u80af\u5b9a\u662f supportMethodsArguments \u53c2\u6570\u4e3a true \u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
\u8fdb\u5165PageHelper\u5b98\u7f51<\/a>\uff0c\u67e5\u770b supportMethodsArguments \u53c2\u6570\u4ecb\u7ecd\uff1a\u6839\u636e\u53c2\u6570\u5bf9\u8c61\u4e2d\u7684\u5c5e\u6027\u81ea\u52a8\u8bc6\u522b\u662f\u5426\u9700\u8981\u5206\u9875\u3002<\/p>\n\n\n\n
\u518d\u67e5\u770b\u5f53\u524d\u9879\u76ee\u7684\u914d\u7f6e\uff0c\u53d1\u73b0\u5f53\u524d\u9879\u76ee\u786e\u5b9e\u914d\u7f6e\u4e86\u8be5\u53c2\u6570\uff0c\u65e2\u7136\u5b83\u786e\u5b9e\u53ef\u4ee5\u7b80\u5316\u4e00\u4e9b\u64cd\u4f5c\uff0c\u90a3\u8fd9\u4e2a\u5c5e\u6027\u8fd8\u4e0d\u80fd\u6539\u52a8\u3002<\/p>\n\n\n\n
\r\nsupportMethodsArguments\uff1a\u652f\u6301\u901a\u8fc7 Mapper \u63a5\u53e3\u53c2\u6570\u6765\u4f20\u9012\u5206\u9875\u53c2\u6570\uff0c\u9ed8\u8ba4\u503cfalse\uff0c\u5206\u9875\u63d2\u4ef6\u4f1a\u4ece\u67e5\u8be2\u65b9\u6cd5\u7684\u53c2\u6570\u503c\u4e2d\uff0c\u81ea\u52a8\u6839\u636e\u4e0a\u9762 params \u914d\u7f6e\u7684\u5b57\u6bb5\u4e2d\u53d6\u503c\uff0c\u67e5\u627e\u5230\u5408\u9002\u7684\u503c\u65f6\u5c31\u4f1a\u81ea\u52a8\u5206\u9875\u3002\u4f7f\u7528\u65b9\u6cd5\u53ef\u4ee5\u53c2\u8003\u6d4b\u8bd5\u4ee3\u7801\u4e2d\u7684 com.github.pagehelper.test.basic \u5305\u4e0b\u7684 ArgumentsMapTest \u548c ArgumentsObjTest\u3002\r\n\r<\/code><\/pre>\n\n\n\n
pagehelper:\r\n  helperDialect: mysql\r\n  reasonable: true\r\n  supportMethodsArguments: true\r\n  params: count=countSql\r\n  \r<\/code><\/pre>\n\n\n\n
\u7ee7\u7eed\u8fdb\u51655\u53f7\u7ea2\u8272\u5708\u5185\u90e8\u7684 getPageFromObject \u65b9\u6cd5\uff0c\u91cd\u70b9\u770b\u4e00\u4e0b13\u53f7\u9ec4\u8272\u5708\uff0c\u8fd9\u4e2a\u5708\u4f7f\u7528\u53cd\u5c04\u7684\u65b9\u5f0f\u53bb\u83b7\u53d6\u53c2\u6570\u5bf9\u8c61\u7684orderBy\u5c5e\u6027\u3002<\/p>\n\n\n\n
\u5f88\u5feb\uff0c\u95ee\u9898\u627e\u5230\u4e86\uff1a<\/p>\n\n\n\n
\u7b14\u8005\u4e3a\u4e86\u6392\u5e8f\u5728\u5b9e\u4f53\u4e2d\u589e\u52a0\u4e86 orderBy \u5c5e\u6027\uff0c\u56e0\u6b64 hasOrderBy \u4e3a true\uff1b\u8fdb\u51659\u53f7\u7ea2\u8272\u5708\u7684\u4ee3\u7801\u5757\u540e\uff0c\u521b\u5efa\u4e86\u5206\u9875\u7684\u5bf9\u8c61\uff0c\u5bfc\u81f4 PageHelper \u63d2\u4ef6\u628a\u8be5 sql \u8bed\u53e5\u4f5c\u4e3a\u5206\u9875\u67e5\u8be2\u6765\u5bf9\u5f85\uff0c\u81ea\u7136\u4e5f\u5c31\u628aORDER BY create_time ASC \u8bed\u53e5\u5077\u6881\u6362\u67f1\u4e86\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u627e\u51fa\u95ee\u9898\u6240\u5728\uff0c\u63a5\u4e0b\u6765\u5c31\u662f\u89e3\u51b3\u4e86\u3002<\/p>\n\n\n\n
03\u3001\u89e3\u51b3<\/strong><\/em><\/h2>\n\n\n\n
\n\n\n\n
>> \u65b9\u6848\u4e00\uff1a<\/strong><\/p>\n\n\n\n
\u5c06 supportMethodsArguments \u5c5e\u6027\u6539\u4e3a false \uff0c\u4f46\u8fd9\u4e2a\u6539\u52a8\u5f88\u6709\u53ef\u80fd\u4f1a\u5bf9\u73b0\u6709\u7684sql\u67e5\u8be2\u8bed\u53e5\u9020\u6210\u4e00\u5b9a\u7684\u5f71\u54cd\uff0c\u56e0\u6b64\u4e0d\u63a8\u8350\u3002<\/p>\n\n\n\n
pagehelper:\r\n  helperDialect: mysql\r\n  reasonable: true\r\n  supportMethodsArguments: false\r\n  params: count=countSql\r\n  \r<\/code><\/pre>\n\n\n\n
>> \u65b9\u6848\u4e8c\uff1a<\/strong><\/p>\n\n\n\n
\u5c06\u5b9e\u4f53\u7c7b\u4e2d\u7684 orderBy \u6539\u4e3a\u53e6\u4e00\u4e2a\u53d8\u91cf\u540d\uff0c\u6bd4\u5982 orderByCreateTime \uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u907f\u514d PageHelper \u8ba4\u9519\u5206\u9875\u53c2\u6570\u4e86\u3002<\/p>\n\n\n\n
public class TestWithoutPageDTO extends BaseDTO {\r\n\r\n    private static final long serialVersionUID = 7862152821778815456L;\r\n\r\n    private String name;\r\n\r\n    private String orderByCreateTime;\r\n\r\n    public String getName() {\r\n        return name;\r\n    }\r\n\r\n    public void setName(String name) {\r\n        this.name = name;\r\n    }\r\n\r\n    public String getOrderByCreateTime() {\r\n        return orderByCreateTime;\r\n    }\r\n\r\n    public void setOrderByCreateTime(String orderByCreateTime) {\r\n        this.orderByCreateTime = orderByCreateTime;\r\n    }\r\n\r\n    @Override\r\n    public String toString() {\r\n        return \"TestWithoutPageDTO{\" +\r\n                \"name='\" + name + '\\'' +\r\n                \", orderByCreateTime='\" + orderByCreateTime + '\\'' +\r\n                '}';\r\n    }\r\n}\r\n\r<\/code><\/pre>\n\n\n\n
\r\n<!--\u4e0d\u5206\u9875\u67e5\u8be2\u6570\u636e-->\r\n<select id=\"selectWithoutPage\" parameterType=\"com.peng.java_study.api.dto.TestWithoutPageDTO\" resultMap=\"BaseResultMap\">\r\n    SELECT * FROM test_page_or_not tpon\r\n    WHERE\r\n        tpon.name LIKE CONCAT(\"%\", #{name, jdbcType=VARCHAR}, \"%\")\r\n    <if test=\"orderByCreateTime != null and orderByCreateTime != ''\">\r\n        ORDER BY tpon.create_time ${orderByCreateTime}\r\n    <\/if>\r\n<\/select>\r\n\r<\/code><\/pre>\n\n\n\n
\u4fee\u6539\u540e\u7684\u65e5\u5fd7\uff0c\u65e0\u5f02\u5e38\u4ea7\u751f\uff1a<\/p>\n\n\n\n
\r\n2022-02-18 21:00:58.928 DEBUG 9768 --- [nio-8080-exec-1] c.p.j.c.m.T.selectWithoutPage            : ==>  Preparing: SELECT * FROM test_page_or_not tpon WHERE tpon.name LIKE CONCAT(\"%\", ?, \"%\") ORDER BY tpon.create_time ASC\r\n2022-02-18 21:00:58.944 DEBUG 9768 --- [nio-8080-exec-1] c.p.j.c.m.T.selectWithoutPage            : ==> Parameters: name(String)\r\n2022-02-18 21:00:58.960 DEBUG 9768 --- [nio-8080-exec-1] c.p.j.c.m.T.selectWithoutPage  \r\n\r<\/code><\/pre>\n\n\n\n
\n\n\n\n
LigaAI \u65b0\u4e00\u4ee3\u667a\u80fd\u7814\u53d1\u534f\u4f5c\u5e73\u53f0<\/strong><\/a>\u00a0\u8ba9 AI \u4e3a\u60a8\u7684\u7814\u53d1\u56e2\u961f\u63d0\u4f9b\u4e2a\u6027\u5316\u3001\u667a\u80fd\u5316\u7684\u9879\u76ee\u534f\u4f5c\u4f53\u9a8c\uff0c\u5316\u7e41\u5c31\u7b80\uff0c\u5e2e\u52a9\u5f00\u53d1\u8005\u4e13\u6ce8\u3001\u9ad8\u6548\u7684\u521b\u4f5c\uff01\u5173\u6ce8\u6211\u4eec\uff0cLigaAI <\/strong>\u8fd8\u4f1a\u5206\u4eab\u66f4\u591a\u4e0e\u654f\u6377\u5f00\u53d1\u3001\u9879\u76ee\u7ba1\u7406\u76f8\u5173\u7684\u6587\u7ae0~<\/p>\n\n\n\n
\u672c\u6587\u4f5c\u8005\uff1arookie0peng<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7f16\u8005\u8bf4\uff1a \u5f00\u53d1\u662f\u4e00\u4ef6\u201c\u5347\u7ea7\u6253\u602a\u201d\u7684\u4e8b\uff0c\u5728\u5f00\u53d1\u5404\u4e2a\u73af\u5883\u4e0b\uff0c\u5996\u602a\u9891\u51fa\uff0c\u6218\u672f\u4e0d\u65ad\u5347\u7ea7\u3002 \u7a0b\u5e8f\u5458\u60f3\u8981\u629b\u5f00\u8ff7\u96fe\uff0c\u7aa5\u5f97\u771f\u76f8 … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[],"_links":{"self":[{"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/posts\/839"}],"collection":[{"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/comments?post=839"}],"version-history":[{"count":1,"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/posts\/839\/revisions"}],"predecessor-version":[{"id":846,"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/posts\/839\/revisions\/846"}],"wp:attachment":[{"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/media?parent=839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/categories?post=839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ligai.cn\/blog\/wp-json\/wp\/v2\/tags?post=839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}