updateByPrimaryKeySelective 关键字 ‘where‘ 附近有语法错误。

最新推荐文章于 2023-06-15 10:47:06 发布
最新推荐文章于 2023-06-15 10:47:06 发布
阅读量934 收藏
点赞数
文章标签： mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u013343616/article/details/120011102
版权

解决方法

检查mapper.xml有没有该字段，我自个人发现数据库表添加了新字段而没有更新mapper.xml里的updateByPrimaryKeySelective方法，导致更新失败，有些网上说要添加**@Id**对我没效果，我只是维护一个老项目。

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: java.sql.SQLException: 关键字 'where' 附近有语法错误。
### The error may involve com.myfun.repository.erpdb.dao.ErpFunAppointmentPhotographerMapper.updateByPrimaryKeySelective-Inline
### The error occurred while setting parameters
### SQL: update FUN_APPOINTMENT_PHOTOGRAPHER            where ID = ?
### Cause: java.sql.SQLException: 关键字 'where' 附近有语法错误。
; bad SQL grammar []; nested exception is java.sql.SQLException: 关键字 'where' 附近有语法错误。
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
	at com.sun.proxy.$Proxy191.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:295)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:65)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	at com.sun.proxy.$Proxy260.updateByPrimaryKeySelective(Unknown Source)
	at com.myfun.houseCustWeb.house.controller.BrokerPhotographerController.updateEvaluateStatus(BrokerPhotographerController.java:2059)
	at com.myfun.houseCustWeb.house.controller.BrokerPhotographerController$$FastClassBySpringCGLIB$$9f73befd.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:669)
	at com.myfun.houseCustWeb.house.controller.BrokerPhotographerController$$EnhancerBySpringCGLIB$$b9b7dc71.updateEvaluateStatus(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	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:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
	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 com.extension.framework.filter.cat.CatFilter.doFilter(CatFilter.java:72)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.extension.framework.filter.authentication.uu.UuAuthenticationFilter.doFilter(UuAuthenticationFilter.java:34)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.extension.framework.filter.authentication.dvlp.DvlpAuthenticationFilter.doFilter(DvlpAuthenticationFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.extension.framework.filter.authentication.systemApi.SystemApiAuthenticationFilter.doFilter(SystemApiAuthenticationFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.extension.framework.filter.authentication.openApi.OpenApiAuthenticationFilter.doFilter(OpenApiAuthenticationFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.extension.framework.filter.authentication.crm.CrmAuthenticationFilter.doFilter(CrmAuthenticationFilter.java:58)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.extension.framework.filter.authentication.broker.BrokerAuthenticationFilter.process(BrokerAuthenticationFilter.java:132)
	at com.extension.framework.filter.authentication.broker.BrokerAuthenticationFilter.doFilter(BrokerAuthenticationFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.myfun.framework.web.MockTestFilter.doFilter(MockTestFilter.java:67)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.myfun.framework.filter.CustFilter.doFilter(CustFilter.java:49)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
	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 com.extension.framework.filter.mqTransactionMessage.MqMessaegTransactionFilter.doFilter(MqMessaegTransactionFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:336)
	at com.dianping.cat.servlet.CatFilter$CatHandler$2.handle(CatFilter.java:124)
	at com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:334)
	at com.dianping.cat.servlet.CatFilter$CatHandler$3.handle(CatFilter.java:141)
	at com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:334)
	at com.dianping.cat.servlet.CatFilter$CatHandler$4.handle(CatFilter.java:270)
	at com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:334)
	at com.dianping.cat.servlet.CatFilter$CatHandler$1.handle(CatFilter.java:73)
	at com.dianping.cat.servlet.CatFilter$Context.handle(CatFilter.java:334)
	at com.dianping.cat.servlet.CatFilter.doFilter(CatFilter.java:40)
	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.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	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.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
	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.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	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.springframework.cloud.sleuth.instrument.web.TraceFilter.doFilter(TraceFilter.java:164)
	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:197)
	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.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
	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:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: 关键字 'where' 附近有语法错误。
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:89)
	at com.sun.proxy.$Proxy416.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy411.update(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.extension.framework.mybatis.plugin.SwitchDBHelper.intercept(SwitchDBHelper.java:84)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy411.update(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.extension.framework.mybatis.plugin.AccessReadonlyDbHelper.intercept(AccessReadonlyDbHelper.java:69)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy411.update(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.extension.framework.cat.mybatis.CatMybatisPlugin.intercept(CatMybatisPlugin.java:73)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy411.update(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy411.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
	... 122 more
A雄
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
浅析c#范型中的特殊关键字where default
01-20
在看源码的时候看见了where和default，虽说default很常见，但是它的用法我却是第一次看到，哎，基础不扎实啊！ 下面介绍下这两个特殊的关键字：一、Where关键字where 子句用于指定类型约束，这些约束可以作为泛型声明中定义的类型参数的变量。1.接口约束。例如，可以声明一个泛型类 MyGenericClass，这样，类型参数 T 就可以实现 IComparable<T> 接口： 代码如下:publicclassMyGenericClass<T>whereT:IComparable{}2.基类约束：指出某个类型必须将指定的类作为基类（或者就是该类本身），才能用作该泛型类型的类型参数
浅析c#范型中的特殊关键字where & default
09-05
以下是对c#范型中的特殊关键字where和default进行了详细的介绍，需要的朋友可以过来参考下
UserMapper.selectByPrimaryKey-Inline 报错的解决办法
weixin_34009794的博客
12-19 733
报错原因，及解决办法： 实体类id属性上少加了@Id 然后mybatis不知道哪个是主键了 我写了个demo public interface UserMapper extends Mapper<User> 注意是继承了Mapper，它里面已经有一个selectByPrimaryKey方法 然后我这么调用 User u = ...
关键字 ‘WHERE‘ 附近有语法错误。 Query: insert into users(id,username,password,email) values(?,?,?,?) Parameters
weixin_45872600的博客
08-05 3808
这个sql语句中标记的地方没空格，会报错 这个sql语句中标记的地方有1个空格 返回-1表示更新失败，返回其它表示更新影响的行数
DBUtils:java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'WHERE' 附近有语法错误。
浮梦一场
05-08 2379
使用dbutils插入语句的时候遇到异常java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'WHERE' 附近有语法错误。 Query: insert into dbo.mihuan(shopId,shopName,outerId,price,inventoryNum) values(?,?,?,...
关键字 where 附近有语法错误。_知识分享：SQL语句中where条件后面的1=1是
weixin_39856208的博客
02-06 2413
这段代码应该是由程序中生成的，where条件中 1＝1 之后的条件是通过 if 块动态变化的。例如: String sql="select * from table_name where 1=1";if( conditon 1) { sql=sql+" and var2=value2";}if(conditon 2) { sql=sql+" and var3=value3";}whe...
QueryRunner 解决 insert into报错:关键字 ‘WHERE‘ 附近有语法错误
qwer1154928613的博客
09-23 716
转自：https://blog.csdn.net/weixin_42153410/article/details/89638065 public int addManager(Manager manager){ //创建SQL语句 String SQL = "insert into tb_manager (managerid,mloginname," + "sex,loginpass,belong) values (?,?,?,?,?)"; Object[]
利用IDEA-sqljdbc调用数据库时，insert into报错:关键字 'WHERE' 附近有语法错误
吉吉国王的博客
03-19 918
利用IDEA-sqljdbc调用数据库时，遇到insert into报错:关键字 ‘WHERE’ 附近有语法错误 添加图书的代码 前提：sql代码在SQL Server Management Studio执行完没任何问题 public int addBook(Book book) { String sql="insert into t_book(name,author,price,...
System.Data.SqlClient.SqlException:““where”附近有语法错误。”
weixin_61697568的博客
06-15 146
求大佬看看，孩子实验报告，急急！
updatebyprimarykeyselective的where条件是全部字段_ArcGIS 字段计算器
weixin_39835792的博客
12-03 394
使用键盘输入值并不是编辑表中值的唯一方式。在某些情况下，为了设置字段值，可能要对单条记录甚至是所有记录执行数学计算。您可以对所有记录或选中记录执行简单计算和高级计算。此外，还可以在属性表中的字段上计算面积、长度、周长和其他几何属性。以下各部分包括使用字段计算器的若干示例。计算可以通过 Python 或 VBScript 执行。Python 是 ArcGIS 建议使用的脚本语言。如果要...
sql连接查询中,where关键字的位置讲解
09-10
最近遇到一个觉得很有趣的sql题，可能对初学者和我这种菜鸟会有帮助，所以小编决定分享给大家
ThinkPHP有变量的where条件分页实例
01-20
本文实例讲述了ThinkPHP有变量的where条件分页的实现方法。分享给大家供大家参考。 主要功能代码如下： 复制代码 代码如下: $Form= D(‘Announcement’); import(“ORG.Util.Page”); $count = $Form->count(); //...
使用方法updateByPrimaryKeySelective所踩的坑
erdong45684455的博客
06-16 3064
今天使用updateByPrimaryKeySelective方法实现修改时，发现怎么都修改不了，查看日志后看到在修改时，
利用QueryRunner解决 insert into报错:关键字 'WHERE' 附近有语法错误
李公子的博客
04-28 2461
转自：https://www.cnblogs.com/toohoo/p/7994078.html 1 2 3 4 5 6 7 8 9 10 11 12 13 14 publicintaddManager(Manager manager){ ...
com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 ‘WHERE‘ 附近有语法错误附近有语法错误
weixin_52476368的博客
06-25 630
今天测试 JDBC 连接 SQLServer 的时候更新表中内容报错：com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 ‘WHERE‘ 附近有语法错误附近有语法错误解决方法很奇妙：原文章链接： https://www.cnblogs.com/toohoo/p/7994078.html...
利用QueryRunner插入数据是报错:关键字 'WHERE' 附近有语法错误解决
weixin_30417487的博客
12-06 505
解决之后感叹，TMD好大的坑啊！ public int addManager(Manager manager){ //创建SQL语句 String SQL = "insert into tb_manager (managerid,mloginname," + "sex,loginpass,belong) values (?,?,?,?,?)"; Objec...
[SQLServer 2000 Driver for JDBC][SQLServer]关键字 'where' 附近有语法错误解决--Hibernate方言...
数据库天地
11-22 495
环境：MyEclipse6.5+Tomcat6.0.18+SQLServer+Strust2+Spring2.5.6+Hibernate3.2 问题：项目最开始数据库是Oracle，换成SQLServer后项目能跑起来，但是查询老是出错，它的各种版本的驱动都试过，均无果。 解决：查看配置文件 &lt;!-- 配置hibernate属性 --&gt; &lt;property name="...
scrapy练习 获取喜欢的书籍
最新发布
05-22
主要是根据网上大神做的 项目一 https://zhuanlan.zhihu.com/p/687522335
关键字 'IN' 附近有语法错误
06-11
很抱歉，可能是我之前的代码中有语法错误。以下是修改后的代码： ``` CREATE PROCEDURE Proc_Selesno ( IN student_id INT ) BEGIN SELECT s.*, c.course_name, sc.grade FROM S s INNER JOIN SC sc ON s.sno = sc.sno INNER JOIN C c ON sc.cno = c.cno WHERE s.sno = student_id; END ``` 这个代码应该可以在 MySQL 中执行，它创建了一个名为 Proc_Selesno 的储存过程，接受一个名为 student_id 的输入参数，并使用 INNER JOIN 连接 S、C 和 SC 表，以返回特定学生的信息和选课情况。 要执行此储存过程，请使用以下代码： ``` CALL Proc_Selesno(12345); ``` 请将 12345 替换为您要查询的学生的实际 ID 值。 希望这可以帮助您！

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值