org.hibernate.hql.ast.QuerySyntaxException:unexpected token错误public Aadmin quaryUserNames(String name) {String sql = "select * from Eadmin a where a.Aname = ";Query query = sessionFactory.getCurrentSession().createQuery(sql);query.setString(0,nam
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 05:40:37
![org.hibernate.hql.ast.QuerySyntaxException:unexpected token错误public Aadmin quaryUserNames(String name) {String sql =](/uploads/image/z/14754331-19-1.jpg?t=org.hibernate.hql.ast.QuerySyntaxException%3Aunexpected+token%E9%94%99%E8%AF%AFpublic+Aadmin+quaryUserNames%28String+name%29+%7BString+sql+%3D+%22select+%2A+from+Eadmin+a+where+a.Aname+%3D+%22%3BQuery+query+%3D+sessionFactory.getCurrentSession%28%29.createQuery%28sql%29%3Bquery.setString%280%2Cnam)
org.hibernate.hql.ast.QuerySyntaxException:unexpected token错误public Aadmin quaryUserNames(String name) {String sql = "select * from Eadmin a where a.Aname = ";Query query = sessionFactory.getCurrentSession().createQuery(sql);query.setString(0,nam
org.hibernate.hql.ast.QuerySyntaxException:unexpected token错误
public Aadmin quaryUserNames(String name) {
String sql = "select * from Eadmin a where a.Aname = ";
Query query = sessionFactory.getCurrentSession().createQuery(sql);
query.setString(0,name);
Aadmin a = (Aadmin)query.uniqueResult();
return a;
}
提示错误:org.hibernate.hql.ast.QuerySyntaxException:unexpected token:* near line 1,column 8 [select * from Eadmin a where a.Aname = ]
但上面的sql语句直接拿到数据库(oracle)中是对的,问怎么改
org.hibernate.hql.ast.QuerySyntaxException:unexpected token错误public Aadmin quaryUserNames(String name) {String sql = "select * from Eadmin a where a.Aname = ";Query query = sessionFactory.getCurrentSession().createQuery(sql);query.setString(0,nam
String sql = "select * from Eadmin a where a.Aname = ";
Query query = sessionFactory.getCurrentSession().createQuery(sql);
query.setString(0,name);
sql = "select * from Eadmin a where a.Aname = "; 你这句话是标准的sql语句,但是你在这里sessionFactory.getCurrentSession().createQuery(sql);开启的是hibernate的面向对象的语句所以不可以,你改成sessionFactory.getCurrentSession().createSQL(sql);就可以了