求一个Hibernate多对多自身关联的例子代码
求一个Hibernate多对多自身关联的例子代码

------解决方案--------------------
1.建表

 create table student
(sid varchar ( 32 ) not null primary key ,
 sname varchar ( 16 ),
 sage varchar ( 16 ),
)

 create table course
(cid varchar ( 32 ) not null primary key ,
cname varchar ( 16 )
)

 create table student_course_link
(sid varchar ( 32 ) not null ,
cid varchar ( 32 ) not null ,
 primary key (sid,cid)
)
 2.写VO
StudentVO
package com.test;
import java.util.Set;
public class Student
{
private String sid;
private String sname;
private String sage;

private Set course;
public Student()
{
}
//写上get setCourse vo
package com.test;

import java.util.Set;

public class Course
{
private String cid;
private String cname;
private Set student;
//写上get set
写配置文件
Student.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="com.test.Student" table="student" >

<id name="sid" type="string" unsaved-value="null" >
<column name="sid" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name="sname">
<column name="sname" sql-type="varchar(16)" not-null="true"/>
</property>

<property name="sage">
<column name="sage" sql-type="varchar(16)" not-null="true"/>
</property>

<set name="course" table="student_course_link" cascade="all" outer-join="false">
<key column="sid"/>
<many-to-many class="com.test.Course" column="cid"/>
</set>
 
</class>

</hibernate-mapping>
Course.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="com.test.Course" table="course" >

<id name="cid" type="string" unsaved-value="null" >
<column name="cid" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name="cname">
<column name="cname" sql-type="varchar(16)" not-null="true"/>
</property>

<set name="student" table="student_course_link" lazy="false" cascade="all">
<key column="cid"/>
<many-to-many class="com.test.Student" column="sid"/>
</set>
 
</class>

</hibernate-mapping>
接着把下面的hibernate.properties文件拷到classes目录下。。这里用的是mysql
hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'
## MySQL
hibernate.dialect net.sf.hibernate.dialect.MySQLDialect