018——hibernate外置命名查询

实体类以及映射文件请参考015篇

修改Student映射文件为：

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.java.hibernate.Student" table="t_student">
		<id name="id">
			<generator class="native"></generator>
		</id>
		<property name="name"></property>
		<property name="createTime"></property>
		<many-to-one name="classes" column="classesid" />
	</class>
	
	<query name="itachi">
		<![CDATA[
			select s from Student s where s.id <?
		]]>
	</query>
</hibernate-mapping>

测试类：

package test;

import java.util.Iterator;
import java.util.List;

import junit.framework.TestCase;

import org.hibernate.Session;

import com.java.hibernate.HibernateUtils;
import com.java.hibernate.Student;

public class NameQueryTest extends TestCase {
	
	public void testQuery() {
		Session session = null;
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			
			List students = session.getNamedQuery("itachi").setParameter(0, 10).list();
			for(Iterator iter = students.iterator(); iter.hasNext();) {
				Student student = (Student) iter.next();
				System.out.println(student.getId() + "------" + student.getName());
			}
			
			session.getTransaction().commit();
		} catch (Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		} finally {
			HibernateUtils.closeSession(session);
		}
	}

}