報錯: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
getHibernateTemplate().findByNamedParam(hql,{"username","password"},{第一個值,第二個值}) 順便提一句更新后的?變為?1?風格變了需要在后邊加上序號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?= ?" 這樣寫試試?