这是一种基于别名的查询 username = :username , :的作用是用于声明后面的字是别名
/**
* 检查用户是否存在
* */
public TSUser getUserByUserIdAndUserNameExits(TSUser user) {
String password = PasswordUtil.encrypt(user.getUserName(), user.getPassword(), PasswordUtil.getStaticSalt());
String query = "from TSUser u where u.userName = :username and u.password=:passowrd";
Query queryObject = getSession().createQuery(query);
queryObject.setParameter("username", user.getUserName());
queryObject.setParameter("passowrd", password);
List<TSUser> users = queryObject.list();
if (users != null && users.size() > 0) {
return users.get(0);
}
return null;
}