try {
String username = request.getParameter("username");
String password = request.getParameter("password");
SessionFactory sf = DefaultDataUtil.getSessionFactory();
Session s = sf.openSession();
Query query = s.createQuery("from Users where username=:name");
query.setParameter("name", username);
List list = query.list();
if(list.size() == 1)
{
Object o = list.get(0);
Users user = (Users)o;
if(user.getPassword().equals(password) )
{
out.print("驗證成功。");
}
else
{
out.print("密碼錯誤。");
}
}
else
{
out.print("用戶名錯誤。");
}
}
catch(Exception ex){
out.print(ex.getMessage());
}
finally {
out.close();
}
HQL語句對于表名有大小寫匹配的關系，匹配的映射過來的類名。否則會報xxx not mapped....錯誤。其它的還是很簡單的。