Hibernate中的查询方法

               /**
	 * get address list
	 */
	public List findAllByUsername(final String username) {
		return (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException {
				List result = session.createCriteria(Address.class).add(
						Restrictions.eq("username", username)).list();
				return result;
			}
		});
	}





public Address findById(String id) {
		return (Address) getHibernateTemplate().get(Address.class,
				new Integer(id));
	}




public boolean isValid(final String username, final String password) {
		List list = (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException {
				List result = session.createCriteria(User.class).add(
						Restrictions.eq("username", username)).add(
						Restrictions.eq("password", password)).list();
				return result;
			}
		});
		if (list.size() > 0) {
			return true;
		} else {
			return false;
		}
	}








public User getUser(String userid) {
		return (User) getHibernateTemplate().get(User.class,
				new Integer(userid));
	}



public List getUsers() {
		return getHibernateTemplate().find("from User");
	}

 

 

/**     * 根据id查找用户     * @param id 需要查找的用户id     */      public User get(int id)    {        return (User)getHibernateTemplate().get(User.class , id);    }   /**
     * 根据用户名，密码查找用户
     * @param username 查询所需的用户名
     * @param pass 查询所需的密码
     * @return 对应的用户
     */ 
    public User findUserByNameAndPass(String user , String pass)
    {
        List ul = getHibernateTemplate()
.find("from User au where au.user = ? and au.pass = ?" , 
new String[]{user , pass});
        if (ul != null && ul.size() >= 1)
        {
            return (User)ul.get(0);
        }
        return null;
    }
 
 
/**
     * 根据用户名查找用户
     * @param user 查询所需的用户名
     * @return 对应的用户
     */ 
    public User findUserByName(String user)
{
        List ul = getHibernateTemplate()
.find("from User au where au.user = ?" , 
user);
        if (ul != null && ul.size() >= 1)
        {
            return (User)ul.get(0);
        }
        return null;
}