Hibernate 参数查询

第一种：

public User validate(String userName, String password) {
		String hql = "from User where userName =:userName and password =:password";
		User user = null;
		Object[] values = {userName, password};
		String[] paramNames = {"userName", "password"};
		List<User> list = ht.findByNamedParam(hql, paramNames, values);
		if (list.size()!=0){
			user = list.get(0);
		}
		return user;
	}

第二种：

public User validate(String userName, String password) {
		String hql = "from User u where u.userName = ? and u.password = ?";
		User user = null;
 		List<User> list = ht.find(hql, new Object[]{userName, password});
		if (list.size()!=0){
			user = list.get(0);
		}
		return user;
	}

两种方法：find() 和 findByNameParam()  

from User u ...... u可写可不写

总结：

当用"?"的时候，必须 ht.***("", new Object(*));  否则会出现异常：

org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1

当用"=:"的时候，必须定义参数 parameters，values。ht.***("", parameters, values);