錯(cuò)誤如下：

java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!

at org.hibernate.engine.query.ParameterMetadata.getOrdinalParameterDescriptor(ParameterMetadata.java:79)
at org.hibernate.engine.query.ParameterMetadata.getOrdinalParameterExpectedType(ParameterMetadata.java:85)
at org.hibernate.impl.AbstractQueryImpl.determineType(AbstractQueryImpl.java:421)
at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:393)
at org.dao.impl.EmpDaoImpl.queryInfoByName(EmpDaoImpl.java:118)
at org.service.impl.EmpServiceImpl.queryInfoByName(EmpServiceImpl.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy6.queryInfoByName(Unknown Source)
at org.service.impl.EmpServiceImplTest.testQueryInfoByName(EmpServiceImplTest.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

相關(guān)代碼如下：

/**(非 Javadoc)* <p>Description(描述):根據(jù)員工的姓名查詢員工信息 </p>* <p>Title: queryInfoByName</p>* @param name* @return* @see org.dao.IEmpDao#queryInfoByName(java.lang.String)*/@Overridepublic Emp queryInfoByName(String name) {Emp emp = null;String hql = " from Emp where ename = ?";Session session = this.getSession();List<Emp> empList = session.createQuery(hql).setParameter(1, name).list();if(empList.size()!=0){emp = empList.get(0);}return emp;}

注意看這里：

setParameter(1, name)

很明顯，這個(gè)地方的1應(yīng)該改成0，但是我原來(lái)就是0來(lái)著，網(wǎng)上有人說(shuō)要改成1.。。。。。。我以為我記錯(cuò)了？想著反正也是個(gè)錯(cuò)，何不試試呢。于是就二了起來(lái)試了試，也許之前越界是其他的原因，改到后面居然忘了到底改哪里了，于是乎把1重新改成了0之后終于可以用了。

setParameter(1, name)

正確詳細(xì)代碼如下：

/**(非 Javadoc)* <p>Description(描述):根據(jù)員工的姓名查詢員工信息 </p>* <p>Title: queryInfoByName</p>* @param name* @return* @see org.dao.IEmpDao#queryInfoByName(java.lang.String)*/@Overridepublic Emp queryInfoByName(String name) {Emp emp = null;String hql = " from Emp where ename = ?";Session session = this.getSession();List<Emp> empList = session.createQuery(hql).setParameter(0, name).list();if(empList.size()!=0){emp = empList.get(0);}return emp;}

總結(jié)

以上是生活随笔為你收集整理的ssh根据姓名查询的时候报错java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。