- 普通表操作
普通操作莫过于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>
- 后记
余下细节以后补充。