SQLException: Parameter index out of range (3 > number of parameters, which is 2).

关注

原创最新推荐文章于 2026-06-04 15:15:55 发布 1.5k 阅读 AI 写同款· GEO 优化 ›

Upwork数据战争：用爬虫与AI预测垄断订单当普通自由职业者还在“等客户发需求”时，顶尖玩家已用数据预测客户明天需要什么；当竞争对手熬夜抢单时，你的爬虫早已自动提交提案—— 这不是科幻，而是2025年的现实！本文将手把手教你用合法工具搭建“数据战情室”，让每个决策都有万亿级数据支撑！阅读详情

一开始的思维想法： sql语句没有错，template那里也没有写错，在save打印时的id显示为0,但是数据库的结果是对的。所以考虑 1数据库的错误

信息: {dataSource-1} inited
java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
     at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3815)
     at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3797)
     at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3842)
     at com.mysql.jdbc.PreparedStatement.setLong(PreparedStatement.java:3859)
     at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:4056)
     at com.alibaba.druid.pool.DruidPooledPreparedStatement.setObject(DruidPooledPreparedStatement.java:476)
     at com._520it.shopping.template.JdbcTemplate.update(JdbcTemplate.java:24)
     at com._520it.shopping.dao.impl.ProductDirDAOImpl.update(ProductDirDAOImpl.java:29)
     at com._520it.shopping.test.ProductDirDAOImplTest.testUpdate(ProductDirDAOImplTest.java:27)
     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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
     at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
     at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
     at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
     at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
     at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
     at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
     at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
     at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
     at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
     at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
     at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
     at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
     at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
     at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)

原因：SQL语句写错了，dirName的问号?写成了中文的?好导致参数设置多了看一个。。。。。。优先考虑sql语句错误

收录于