关于Hibernate注解的使用（命名查询 本地查询）

配置Weapon.java，代码如下：

package com.hibernate.annotations.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityResult;
import javax.persistence.FieldResult;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedNativeQuery;
import javax.persistence.NamedQuery;
import javax.persistence.SequenceGenerator;
import javax.persistence.SqlResultSetMapping;
import javax.persistence.Table;

@Entity
@Table(name = "WEAPON")
//通过注解的方式使用命名查询
@NamedQuery(name = "namedQuery",query="from Weapon where id < :id")

//通过注解的方式使用本地查询
@SqlResultSetMapping(name = "all_fields",entities={
		@EntityResult(entityClass= com.hibernate.annotations.entity.Weapon.class,
				fields={
					@FieldResult(name = "id",column="ID"),
					@FieldResult(name = "name",column="NAME"),
				}
		)
	}
)
@NamedNativeQuery(name = "nameeNativeQuery", query = "select * from WEAPON where id < :id",
		resultSetMapping="all_fields")

		
public class Weapon {

	@SequenceGenerator(name = "seq",allocationSize = 1,initialValue = 1,sequenceName = "seq_weapon_pk")
	@Id
	@Column(name = "ID")
	@GeneratedValue(strategy=GenerationType.SEQUENCE,generator = "seq")
	private int id;
	private String name;
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	
}

关于注解的测试举例，TestAnnotations.java，代码如下：

package com.hibernate.annotations.entity;

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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;

public class TestAnnotations {

	public static AnnotationConfiguration config = new AnnotationConfiguration();
	public static SessionFactory sessionFactory ;
	public static String config_file = "/hibernate.cfg.xml";
	
	public static void main(String[] args) {
//		annotationTest1();
//		annotationTest2();
		annotationTest3();
	}
	
	public static void annotationTest1(){
		//获得配置文件信息
		config.configure(config_file);
		//创建session工厂
		sessionFactory = config.buildSessionFactory();
		//创建Session对象（注意：正常开发环境下，应该优先当前进程中的session）
		Session session = sessionFactory.openSession();
		
		//开启事务
		Transaction tran = session.beginTransaction();
		Weapon weapon = new Weapon();
		weapon.setName("屠鹰刀");
		session.save(weapon);
		tran.commit();
		
		session.close();
		
	}
	//使用命名查询进行数据查询
	public static void annotationTest2(){
		//获得配置文件信息
		config.configure(config_file);
		//创建session工厂
		sessionFactory = config.buildSessionFactory();
		//创建Session对象（注意：正常开发环境下，应该优先当前进程中的session）
		Session session = sessionFactory.openSession();
		

		Query query = session.getNamedQuery("namedQuery");
		query.setParameter("id", 100);
		List<Weapon> list = query.list();
		Iterator<Weapon> it = list.iterator();
		while(it.hasNext()){
			Weapon w = it.next();
			System.out.println(w.getId() + "\t" + w.getName());
		}
		session.close();
		
	}
	
	//使用本地查询进行数据查询
	public static void annotationTest3(){
		//获得配置文件信息
		config.configure(config_file);
		//创建session工厂
		sessionFactory = config.buildSessionFactory();
		//创建Session对象（注意：正常开发环境下，应该优先当前进程中的session）
		Session session = sessionFactory.openSession();
		

		Query query = session.getNamedQuery("nameeNativeQuery");
		query.setParameter("id", 100);
		List<Weapon> list = query.list();
		Iterator<Weapon> it = list.iterator();
		while(it.hasNext()){
			Weapon w = it.next();
			System.out.println(w.getId() + "\t" + w.getName());
		}
		session.close();
		
	}
}