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("驗(yàn)證成功。");
}
else
{
out.print("密碼錯(cuò)誤。");
}
}
else
{
out.print("用戶名錯(cuò)誤。");
}
}
catch(Exception ex){
out.print(ex.getMessage());
}
finally {
out.close();
}
HQL語(yǔ)句對(duì)于表名有大小寫(xiě)匹配的關(guān)系，匹配的映射過(guò)來(lái)的類名。否則會(huì)報(bào)xxx not mapped....錯(cuò)誤。其它的還是很簡(jiǎn)單的。