Hibernate中多对多关系映射 、查询

模型 课程表

package com.stu.model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="_course")
public class Course {
	private int id;
	private String name;
 
	
	@Id
	@GeneratedValue
	
	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;
	}
	
}

考试表

package com.stu.model;

import java.util.HashSet;
import java.util.Set;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.Table;

@Entity
@Table(name="_exam")
public class Exam {
	private int id;
	private String name;
	private Set<Course> course = new HashSet<Course>();
 
	
	@Id
	@GeneratedValue
	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;
	}
	
	@ManyToMany
	@JoinTable(name="_course_exam",
			joinColumns = @JoinColumn(name="examid"),
	            inverseJoinColumns = @JoinColumn(name="courseid")		
	)
	public Set<Course> getCourse() {
		return course;
	}
	public void setCourse(Set<Course> course) {
		this.course = course;
	}
 
	
	
	

}

班级表
package com.stu.model;

import java.util.HashSet;
import java.util.Set;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.Table;


@Entity
@Table(name="_mclass")
public class Mclass {
	private int id;
	private String name;
	private Grade grade;
	private Set<Exam>  exam = new HashSet<Exam>();
	
	@Id
	@GeneratedValue
	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;
	}
	
	@ManyToOne
	@JoinColumn(name="gradeid")
	public Grade getGrade() {
		return grade;
	}
	public void setGrade(Grade grade) {
		this.grade = grade;
	}
	@ManyToMany
	@JoinTable(name="_mclass_exam",
			joinColumns = @JoinColumn(name="mclassid"),
	            inverseJoinColumns = @JoinColumn(name="examid")		
	)
	public Set<Exam> getExam() {
		return exam;
	}
	public void setExam(Set<Exam> exam) {
		this.exam = exam;
	}
 
	
	

}


hibernate 实例
package com.stu.tools;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
 

public class HibernateUtil {

    private static final SessionFactory sessionFactory = buildSessionFactory();

    private static SessionFactory buildSessionFactory() {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
        	 Configuration cfg = new Configuration();  
             cfg.configure();          
             ServiceRegistry  sr = new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry();           
             return cfg.buildSessionFactory(sr);  

        }
        catch (Throwable ex) {
            // Make sure you log the exception, as it might be swallowed
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
    
    public static Session getSession(){
    	return sessionFactory.getCurrentSession();
    }

}




junit 测试

package junit;


import java.util.List;
import org.junit.Test;
import com.stu.dao.StudentDao;
import com.stu.model.Exam;
import com.stu.model.Student;
import com.stu.tools.HibernateUtil;

public class Junit {

Session s = HibernateUtil.getSession();
s.beginTransaction();
List<Exam> list = s.createQuery("SELECT e from Mclass m join m.exam e join e.course c where m.id=1").list();
s.getTransaction().commit(); 

}
 

比较懒，就直接粘上代码了o(∩_∩)o 哈哈