- 普通表操作
普通操作莫过于CRUD，建好表了之后对表的数据进行操作。详见代码。
package package2; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration; public class HibernateExecute { public static void main(String[] args) {
HibernateController hc=new HibernateController();
persion toadd=new persion();
toadd.setId(6);
toadd.setName("lkxj");
hc.update(toadd);
} }
class HibernateUtil{
private static SessionFactory ssf;
static{
Configuration cfg=new Configuration().configure();
ssf=cfg.buildSessionFactory();
}
public static Session getSession(){
Session session=ssf.openSession();
return session;
}
public static void closeSession(Session session){
session.close();
}
}
class HibernateController implements DAOInterface{ // 添加信息
@Override
public void add(persion p) {
Session session=HibernateUtil.getSession();
Transaction transaction=session.beginTransaction();
try{
session.save(p);
transaction.commit();
}catch (Exception e) {
// TODO: handle exception
transaction.rollback();
}finally {
HibernateUtil.closeSession(session);
}
}
// 删除信息
@Override
public void delete(persion p) {
// TODO Auto-generated method stub
Session session=HibernateUtil.getSession();
Transaction transaction=session.beginTransaction();
try{
session.delete(p);
transaction.commit();
}catch (Exception e) {
// TODO: handle exception
transaction.rollback();
}finally {
HibernateUtil.closeSession(session);
}
}
// 搜寻信息
@Override
public persion search(int id) {
// TODO Auto-generated method stub
Session session=HibernateUtil.getSession();
Transaction transaction=session.beginTransaction();
persion p=null;
try{
p=(persion)session.get(persion.class, id);
transaction.commit();
}catch (Exception e) {
// TODO: handle exception
transaction.rollback();
}finally {
HibernateUtil.closeSession(session);
}
return p;
}
// 更新信息
@Override
public void update(persion p) {
// TODO Auto-generated method stub
Session session=HibernateUtil.getSession();
Transaction transaction=session.beginTransaction();
try{
session.update(p);
transaction.commit();
}catch (Exception e) {
// TODO: handle exception
transaction.rollback();
}finally {
HibernateUtil.closeSession(session);
}
} }
bean类如下
package package2;
public class persion {
int id;
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;
}
}
persion.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-7-20 15:57:35 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="package2.persion" table="PERSION">
<id name="id" type="int">
<column name="id" />
<generator class="assigned" />
</id>
<property name="name" type="java.lang.String">
<column name="name" />
</property>
</class>
</hibernate-mapping>
在hiberna.cfg.xml末尾添加一行
<mapping resource="package2/persion.hbm.xml" />
- 映射关系
一对一映射：比如一个用户只有一个地址。实现的方式有两种，一，主键关联；二，外键关联。
主键关联就是两个表的主键其中一个为另外一个表的外键。比如user表的主键，为address表的外键，这个address的外键正好就是它这个表的主键。user为主表，address为从表。address的外键引用的时user的主键。在下面的设计中，是user类为address的从表，user的生成策略为foreign，表示主键由关联类产生。
User.java
package HibernateRelation;
//一个用户只有一个地址
public class User {
private int userid;
private String name;
private String password;
private Address address;
public User(){ }
public User(String name,String password,Address address){
this.name=name;
this.password=password;
this.address=address; }
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Address getAddress() {
return address;
}
public void setAddress(Address address) {
this.address = address;
} }
Address.java
package HibernateRelation;
public class Address {
private int addressid;
private String addressinfo;
public Address(int addressid,String addressinfo){
this.addressid=addressid;
this.addressinfo=addressinfo;
}
public Address(){
}
public int getAddressid() {
return addressid;
}
public void setAddressid(int addressid) {
this.addressid = addressid;
}
public String getAddressinfo() {
return addressinfo;
}
public void setAddressinfo(String addressinfo) {
this.addressinfo = addressinfo;
}
}
User.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 14:48:03 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.User" table="USER">
<id name="userid" type="int" access="field">
<column name="USERID" />
<!--由关联类来生成主键 -->
<generator class="foreign" >
<param name="property">address</param>
</generator>
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="password" type="java.lang.String">
<column name="PASSWORD" />
</property>
<!--基于主键的一对一映射-->
<one-to-one name="address" class="HibernateRelation.Address" constrained="true">
</one-to-one>
</class>
</hibernate-mapping>
Address.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 14:48:03 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.Address" table="ADDRESS">
<id name="addressid" type="int" access="field">
<column name="ADDRESSID" />
<generator class="identity" /><!--主键生成策略-->
</id>
<property name="addressinfo" type="java.lang.String">
<column name="ADDRESSINFO" />
</property>
</class>
</hibernate-mapping>
惯例，在总配置文件中添加映射，和自动建表配置。
<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="HibernateRelation/User.hbm.xml" />
<mapping resource="HibernateRelation/Address.hbm.xml" />
在这里可以先建表，也可以不用建表，表结构和你写的类关系类似。遇到一个错误，在one-to-one的标签里添加了column这个属性，会导致一个异常。因为是工具自动产生的。
外键关联：一个表中有主键也有外键，外键是另外一个表的主键的引用。
package HibernateRelation;
public class User2 {
private int userid;
private String name;
private String password;
private Address2 address2;
public Address2 getAddress2() {
return address2;
}
public void setAddress2(Address2 address2) {
this.address2 = address2;
}
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
package HibernateRelation;
public class Address2 {
private int addressid;
private String addressinfo;
public int getAddressid() {
return addressid;
}
public void setAddressid(int addressid) {
this.addressid = addressid;
}
public String getAddressinfo() {
return addressinfo;
}
public void setAddressinfo(String addressinfo) {
this.addressinfo = addressinfo;
}
}
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 16:49:52 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.User2" table="USER2">
<id name="userid" type="int">
<column name="USERID" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="password" type="java.lang.String">
<column name="PASSWORD" />
</property>
<many-to-one name="address2" class="HibernateRelation.Address2" fetch="join" unique="true">
<column name="ADDRESS2" />
</many-to-one>
</class>
</hibernate-mapping>
这个配置文件，主要是写成many-to-one，unique设置为true。column的name为属性名，关联类配置在class中，在表中建立的外键名column中可以设置。
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 16:49:52 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.Address2" table="ADDRESS2">
<id name="addressid" type="int">
<column name="ADDRESSID" />
<generator class="identity" />
</id>
<property name="addressinfo" type="java.lang.String">
<column name="ADDRESSINFO" />
</property>
</class>
</hibernate-mapping>
一对多映射：一个用户可以有多个收货地址，在这个设计中，官方说法是在多的一方加入外键，并指向一的一方。就是在address表中加入一个用户id，user的id为地址的识别码，id=2的用户在address表中可以有多条地址记录，他们隶属于外键id=2这个用户之下。
实现方法就是在bean类中加入一个集合set，然后生成xml的时候会自动配置。
package HibernateRelation; import java.util.HashSet;
import java.util.Set;
//一个用户对应多个地址
public class User1 {
private int userid;
private String name;
private String password;
private Set<Address1> addresses=new HashSet<Address1>();
public User1(){ }
public User1(int userid,String name,String password){
this.userid=userid;
this.name=name;
this.password=password;
}
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Set<Address1> getAddresses() {
return addresses;
}
public void setAddresses(Set<Address1> addresses) {
this.addresses = addresses;
} }
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 15:56:52 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.User1" table="USER1">
<id name="userid" type="int">
<column name="USERID" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="password" type="java.lang.String">
<column name="PASSWORD" />
</property>
<set name="addresses" table="ADDRESS1" inverse="false" lazy="true">
<key>
<column name="USERID" />
</key>
<one-to-many class="HibernateRelation.Address1" />
</set>
</class>
</hibernate-mapping>
package HibernateRelation;
public class Address1 {
private int addressid;
private String addressinfo;
public int getAddressid() {
return addressid;
}
public void setAddressid(int addressid) {
this.addressid = addressid;
}
public String getAddressinfo() {
return addressinfo;
}
public void setAddressinfo(String addressinfo) {
this.addressinfo = addressinfo;
}
}
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 15:56:52 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.Address1" table="ADDRESS1">
<id name="addressid" type="int">
<column name="ADDRESSID" />
<generator class="identity" />
</id>
<property name="addressinfo" type="java.lang.String">
<column name="ADDRESSINFO" />
</property>
</class>
</hibernate-mapping>
多对多映射：多个用户对应多个地址，这里是单向的多对多，也就是一个用户对应多个地址，一个地址对应多个用户，他们需要有一个中间表，来转换映射。
package HibernateRelation; import java.util.HashSet;
import java.util.Set; public class User3 {
private int userid;
private String name;
private String password;
private Set<Address3> address3s=new HashSet<Address3>();
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Set<Address3> getAddress3s() {
return address3s;
}
public void setAddress3s(Set<Address3> address3s) {
this.address3s = address3s;
} }
package HibernateRelation;
public class Address3 {
private int addressid;
private String addressinfo;
public int getAddressid() {
return addressid;
}
public void setAddressid(int addressid) {
this.addressid = addressid;
}
public String getAddressinfo() {
return addressinfo;
}
public void setAddressinfo(String addressinfo) {
this.addressinfo = addressinfo;
}
}
在这个配置中，需要修改set标签的table属性，改为一个新表，它会生成一个中间表。自动生成时候没有修改报了一个映射异常。
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 18:35:47 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.User3" table="USER3">
<id name="userid" type="int">
<column name="USERID" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="password" type="java.lang.String">
<column name="PASSWORD" />
</property>
<set name="address3s" table="USER3_ADDRESS3" inverse="false" lazy="true">
<key>
<column name="USERID" />
</key>
<many-to-many class="HibernateRelation.Address3" column="ADDRESSID"/>
</set>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-8-16 18:35:47 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="HibernateRelation.Address3" table="ADDRESS3">
<id name="addressid" type="int">
<column name="ADDRESSID" />
<generator class="identity" />
</id>
<property name="addressinfo" type="java.lang.String">
<column name="ADDRESSINFO" />
</property>
</class>
</hibernate-mapping>
- 后记
余下细节以后补充。