［请教］HQL占位符？的问题

[w1sw]

测试的时候出现的异常：
org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1
at org.hibernate.engine.query.spi.ParameterMetadata.getOrdinalParameterDescriptor(ParameterMetadata.java:72)
at org.hibernate.engine.query.spi.ParameterMetadata.getOrdinalParameterExpectedType(ParameterMetadata.java:92)
at org.hibernate.internal.AbstractQueryImpl.determineType(AbstractQueryImpl.java:496)
at org.hibernate.internal.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:468)
at cqu.edu.serviceImpl.UsersDAOImpl.usersLogin(UsersDAOImpl.java:26)
at cqu.edu.serviceImpl.TestUsersDAOImpl.testUsersLogin(TestUsersDAOImpl.java:16)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
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)
相关的类：

Transaction transaction = null;
String hql="";
try {
Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession();
transaction = session.beginTransaction();
hql = "from cqu.edu.entity.Users u where u.username=? and u.password=? ";
Query query = session.createQuery(hql);
query.setParameter(0,user.getUsername());
query.setParameter(1,user.getPassword());
List list = query.list();
//List<Users> list = this.find(hql, new Object[]{user.getUsername(), user.getPassword()});
transaction.commit();
if(list.size()>0){
return true;
}else{
return false;
}
我想请问一下，我的占位符这样写有错吗？为什么提示我出错了，谢谢大家了！

[dracularking]

相当奇怪，貌似程序探测出来你只有一个占位符，你可以各种试 把占位符先删掉一个，或者试试 named parameter 方式

[dracularking]

query.setParameter(1,user.getUsername()); query.setParameter(2,user.getPassword()); 这样呢？

[w1sw]

引用 1 楼 dracularking 的回复:

query.setParameter(1,user.getUsername()); query.setParameter(2,user.getPassword()); 这样呢？

这样的话，又弹出以下错误： org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 2 我的Users.hbm.xml文件配置如下： <hibernate-mapping> <class name="cqu.edu.entity.Users" table="USERS"> <id name="uid" type="int"> <generator class="native"/> </id> <property name="username" type="java.lang.String"></property> <property name="password" type="java.lang.String"></property> </class> </hibernate-mapping>

[w1sw]

引用 3 楼 dracularking 的回复:

相当奇怪，貌似程序探测出来你只有一个占位符，你可以各种试 把占位符先删掉一个，或者试试 named parameter 方式

还是不行，不过还是谢谢你了！