Question

Hibernate中query.setParameter加不上参数.....

String queryString = "select * Topic as model where model.boardId=? limit 1,6";
Query query = this.getSession().createSQLQuery(queryString);
query.setParameter(0, 1);//这句debug下好像没赋值
List list= query.list();

最后报错
org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2235)

请问这是怎么回事啊，总是搞不好

Answer 1

select * Topic as model where model.boardId=? limit 1,6 不是赋值的问题。而是你的hql语句错误。这里边没有from关键字。你要查哪个表的映射？

Answer 2

dfhdfhfgbhv