報錯:Could not locate ordinal parameter [0], expecting one of []
public?class?EmployeeDaoImpl?extends?HibernateDaoSupport?implements?EmployeeDao{ ???? ????//DAO中根據用戶名和密碼查詢用戶的方法(HQL查詢) ????@Override ????public?Employee?findByUsernameAndPassword(Employee?employee)?{ ????????String?hql="from?Employee?where?username?=?:username?and?password?=?:password"; ????????List<?>?list=this.getHibernateTemplate().find(hql,?employee.getUsername(),employee.getPassword()); ????????if?(list.size()>0)?{ ????????????return?(Employee)?list.get(0); ????????}else?{ ????????????return?null; ????????} ???????? ????} }
代碼如上,報500錯誤……實在解決不來,求各位幫幫忙
使用的hibernate版本是5.3.2
2018-10-13
2020-02-25
String?hql=
"from?Employee?where?username?=?:username?and?password?=?:password"
;
改String?hql=
"from?Employee?where?username?= ?0 and?password?= ?1
;
2018-09-20
"from?Employee?where?username?=???and?password?= ?" 這樣寫試試?