HQL查询问题

[dreamporsche]

Hibernate对数据库操作的程序如下:
public List getMatchProcessOrders(String keyword) throws HibernateException {
//创建一个查询语句,按关键字查询
String strSql = "from Order where tag=1 and orderno like '%" + keyword + "%' ";
List list=getList(strSql);
return list; //返回数据集
}
运行后的提示:
org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.loader.Loader.doList(Loader.java:2148)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
.....................
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order order0_ where order0_.tag=1 and (order0_.orderno like '%%')' at line 1
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
我将程序中的查询语句改为:
String strSql = "from Order as o where o.tag=1 and (o.orderno like '%"+keyword+"%')";
运行后提示:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order order0_ where order0_.tag=1 and (order0_.orderno like '%%')' at line 1
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
..........................
不知道什么原因.

[gongyali2005]

String hql="from Order where tag=? and orderno like ?"
Query q=session.create..........
q.setInteger(0,1);
q.setString(1,"%"+keyword+"%");

[Shine_Panda]

String strSql = "from Order as o where o.tag=1 and o.orderno like '%"+keyword+"%'";
试试。。。