hibernate写的native SQL话语

hibernate写的native SQL语句

public int updateAirIdByID(String passengerName, String airId,String NL_OrderId) {
		String hql = "update  nl_passengerinformation pi set pi.NL_AIRID=:airId where pi.NL_NAME_ENFIRST=:name_ENFirst and pi.NL_NAME_ENSECOND=:name_ENSecond and pi.NL_ORDERID=:NL_OrderId";
		Query query = this.getSession().createSQLQuery(hql).addEntity("pi", PassengerInformation.class);
		String names[]=passengerName.split("/");//拆分英文名
		if(names.length<2){
			return 0;//
		}
		query.setParameter("airId", airId);
		query.setParameter("name_ENFirst", names[0]);
		query.setParameter("name_ENSecond", names[1]);
		query.setParameter("NL_OrderId", NL_OrderId);
		return query.executeUpdate();
	}