create table users(
usid varchar2(32) primary key not null,
uname varchar2(20) not null,
upwd varchar2(8) not null,
usex number not null,
did varchar2(32) not null
)
/
create table dept(
did varchar2(32) primary key not null,
dname varchar2(20)
)
/
create table myrole(
rid varchar(32) primary key not null,
rname varchar2(20) not null
)
/
create table users_myrole(
usid varchar2(32) not null,
rid varchar2(32) not null
)
/
pojo对象
dept---pojo
private String did;
private String dname;
private Set<Users> userses = new HashSet<Users>();
myrole---pojo
private String rid;
private String rname;
private Set<Users> userses = new HashSet<Users>();
users--pojo
private String usid;
private String uname;
private String upwd;
private Integer usex;
private Dept dep;
private Set<Myrole> myrolees = new HashSet<Myrole>();
XML文件
dept --xml
<hibernate-mapping>
<class name="com.yysoft.pojos.Dept" table="DEPT" schema="TEST">
<id name="did" type="java.lang.String">
<column name="DID" length="32" />
<generator class="uuid.hex" />
</id>
<property name="dname" type="java.lang.String">
<column name="DNAME" length="20" />
</property>
<set name="userses" inverse="true" cascade="delete">
<key>
<column name="DID" length="32"></column>
</key>
<one-to-many class="com.yysoft.pojos.Users"/>
</set>
</class>
</hibernate-mapping>
myrole---xml
<hibernate-mapping>
<class name="com.yysoft.pojos.Myrole" table="MYROLE" schema="TEST">
<id name="rid" type="java.lang.String">
<column name="RID" length="32" />
<generator class="uuid.hex" />
</id>
<property name="rname" type="java.lang.String">
<column name="RNAME" length="20" not-null="true" />
</property>
<set name="userses" table="users_myrole" inverse="true">
<key>
<column name="RID" length="32"></column>
</key>
<many-to-many column="USID" class="com.yysoft.pojos.Users"></many-to-many>
</set>
</class>
</hibernate-mapping>
users---xml
<hibernate-mapping>
<class name="com.yysoft.pojos.Users" table="USERS" schema="TEST">
<id name="usid" type="java.lang.String">
<column name="USID" length="32" />
<generator class="uuid.hex" />
</id>
<property name="uname" type="java.lang.String">
<column name="UNAME" length="20" not-null="true" />
</property>
<property name="upwd" type="java.lang.String">
<column name="UPWD" length="8" not-null="true" />
</property>
<property name="usex" type="java.lang.Integer">
<column name="USEX" not-null="true" />
</property>
<many-to-one name="dep" class="com.yysoft.pojos.Dept" cascade="all">
<column name="DID" length="32"></column>
</many-to-one>
<set name="myrolees" table="users_myrole" inverse="false">
<key>
<column name="USID" length="32"></column>
</key>
<many-to-many column="RID" class="com.yysoft.pojos.Myrole"></many-to-many>
</set>
</class>
</hibernate-mapping>
最新评论