java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;

最新推荐文章于 2024-05-28 14:19:30 发布
最新推荐文章于 2024-05-28 14:19:30 发布
阅读量2.3k 收藏
点赞数 1
文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_38134627/article/details/103724562
版权

编译器 错误 情况如下：

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 'member where id=1' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy42.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.loader.ResultLoader.selectList(ResultLoader.java:81)
	at org.apache.ibatis.executor.loader.ResultLoader.loadResult(ResultLoader.java:70)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNestedQueryMappingValue(DefaultResultSetHandler.java:768)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:460)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:436)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:399)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:351)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:326)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:299)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:192)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
	at com.sun.proxy.$Proxy22.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy27.findById(Unknown Source)
	at com.hello.service.impl.OrdersServiceImpl.findById(OrdersServiceImpl.java:37)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy28.findById(Unknown Source)
	at com.hello.controller.OrdersController.findById(OrdersController.java:54)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:871)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:777)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:870)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:830)
2019-12-27 00:28:49,149 28633  [nio-8080-exec-6] DEBUG    com.mchange.v2.sql.SqlUtils  - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: 42000; errorCode: 1064]

memeber类

public class member {
    /*
     *功能描述 会员表
     * @author daxin
     * @date 2019-12-12
     * @param  * @param null
     * @return
     */
    private Integer id;
    private String name;
    private String nickName;// 昵称
    private String phoneNumber;//手机号
    private String email;
    
｝

dao接口如下

public interface IMemberDao {
    @Select("select * from member where id=#{id}")
    public member findById(Integer id) throws Exception;
}

通过查找MySQL关键词 发现name 属于MySQL关键词（看过很多相关博客 大部分都是因为关键词的问题，不过我的除了关键词还有点别的问题）

修改为memberName过后 发现 还是存在这个错误
之后纠结了很久 看了很多博客还是没能解决 放了一段时间
某一天突然心血来潮 把数据库名称改了一下 改成member1
之后 突然发现问题没了 很奇怪
所以有时候想解决办法的时候 还是得脑子活泛一点 不能太纠结
如果之后有别的朋友遇到这个问题 可以试试 给数据库改改名字试试看

daxinhh
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java SQLSyntaxErrorException: You have an error in your SQL syntax问题4种情况解决(SQL、JPA、MyBatis)
旭东怪的博客
02-03 2万+
问题描述： Caused 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 'insert into t_salary_2021_01( DETAILID) values('52dd5ce4a5794573b9b20
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax；报错解决方式
weixin_53165734的博客
03-09 7473
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;报错解决方式
服务器报如下错误：Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the ma
最新发布
Kirihara_Yukiho的博客
05-28 302
今天写完sql之后，利用postman进行测试接口的时候，服务器给我报了如下的错误：Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;我看自己sql语句也没有语法错误，为什么报了如下错误呢，后来检查发下是自己的注释出现了问题。在sql文件中的注释必须以 – 注释，–之后必须有空格才可以。那么希望大家以后写注释的时候也要注意这些细节。
MySQL java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax 关键字异常处理
Yeats_Liao的博客
06-21 1万+
MySQL java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax 关键字异常处理
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the manual
weixin_46214579的博客
01-18 4954
项目场景： Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version 原因分析： 设计的数据库表中的某个字段和 MySql中的字段冲突了，导致报错，所以这个报错，就是sql语句出现的问题 解决方案： 找到对应报错的字段，将字段重新命名，仔细看报错，sql执行到那个字段开始
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; 解决方案
热门推荐
chibibiao1541的博客
05-19 4万+
SQL语法错误异常原因有很多种，这里是因为字段名使用关键字。 异常信息： Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that cor...
数据库疑难杂症 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual tha
12-14
数据库疑难杂症 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 ‘order’ at line...
java.sql.SQLSyntaxErrorException:
01-21
java.sql.SQLSyntaxErrorException: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size….. 解决方式： 从报错信息看是因为innodb_log_file_size太小，至于原因，在 ...
java.sql.SQLSyntaxErrorException Unknown column 'name' in 'field list'.md
06-04
java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list'看上去好像是name这个列是未知的，搞得我一度怀疑我是不是哪个语句写错了，然后修修改改了很久，也在网上找了资料，但是并没有解决我的...
MySQL中Multiple primary key defined报错的解决办法
09-09
```sql CREATE TABLE 表名 ( 字段名1 类型, 字段名2 类型, ... PRIMARY KEY (name) ); ``` 2. 在特定字段定义时直接指定`primary key`： ```sql CREATE TABLE 表名 ( 字段名1 类型 PRIMARY KEY, 字段名2 类型...
各服务器部署war
03-19
【标题】"各服务器部署WAR"涉及的知识点主要围绕Java Web应用的部署，特别是将WAR（Web ARchive）文件部署到不同的服务器环境。WAR文件是Java Web应用程序的标准打包格式，它包含所有必要的资源，如Java类、HTML、...
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
weixiao_xiayigeyuji的博客
03-19 6135
启动MyBatis报错问题 Caused 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 'order ...
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax 解决方法
weixin_45266856的博客
05-11 3096
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax 解决方法
Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax
qq_34302802的博客
06-30 1万+
这种错误，是入库时候导致的报错，具体错误还是要看在入库的时候是如何入库，导致这样的报错 就拿我出现这种错误示例：其实再找错的时候，错误可能都是不相同的，只是希望别人的出现的错误能得到借鉴 1、示例：扫描本地D：目录下的所有.xls文件 2、代码：重点看标红部分 // 结尾为_1.xls文件 public void xlsCurrenF(String path){ //初始化File File excel = new File(path);
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to yo
liuyishou
06-28 2万+
java报语法问题，除了市面上那些普通的回答之外，还有一个caodan的原因，如下： 额外踩过的坑及总结： 经验：对了，在java开发中，想要快速的找到bug一个很好的办法就是将两段基本一样的代码进行对比，不断简化，最钟就是在saibi的问题也能找到。 另外，我的eclipse真滴无语，由于各种版本的问题（eclipse版本，mysql版本，c3p0版本），在javase的...
【解决问题】Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your S
君琴 的博客
04-11 1万+
解决问题Error updating 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 'order'' at line 4
java.sql.SQLException: You have an error in your SQL syntax； check the manual that corresponds to yo
m0_63309946的博客
08-11 1758
自己在数据库中原来使用的是order作为表名，而order是mySQL数据库系统的关键字，所以才会一直报语法错误，后面才改为orders为表名，别忘记在代码里也需要修改哦，这里希望大家不要入这个坑，希望给大家带来帮助，有喜欢的小伙伴可以关注下，后续也会继续更新！今天踩了一个坑，报这种错误首先你可能会想到先去检查自己的SQL有没有写错，如果发现自己的SQL语句没有写错，那么就要注意了！......
操作MySQL数据库后端报错：java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax；
小JAVA千的博客
01-06 3877
操作MySQL数据库后端报错：java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; 这个问题是在我写项目的过程中进行添加方法发生后端报错； 看到这个报错内容应该是SQL语句写的有问题，但是后端的SQL语句都是利用工具生成的。并且生成的SQL语句都没有问题，最后发现是我在设计数据库表的时候，表的字段用到了rank函数的关键字了，这才导致我的插入语句报错。 将关键字的字段修改以后，重新生成SQL语句
at com.sun.proxy.$Proxy200.
03-31
Without additional context, it is difficult to determine the specific meaning or purpose of this code snippet. However, it appears to be referencing a Java proxy object with an identifier of "200". This object may be used to interact with another object or service in a remote or distributed system.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值