上次讲到hibernate的简单配置,这里在讲一下在hibernate中数据之间的关联问题。直接上代码:
1对n的情况:
POJO类:Customer和Order类
public class Customer {
private Integer CustomerId;
private String CustomerName;
public Integer getCustomerId() {
return CustomerId;
}
public void setCustomerId(Integer customerId) {
CustomerId = customerId;
}
public String getCustomerName() {
return CustomerName;
}
public void setCustomerName(String customerName) {
CustomerName = customerName;
}
@Override
public String toString() {
return "Customer [CustomerId=" + CustomerId + ", CustomerName=" + CustomerName + "]";
}
}
public class Order {
private Integer OrderId;
private String OrderName;
private Customer customer;
public Integer getOrderId() {
return OrderId;
}
public void setOrderId(Integer orderId) {
OrderId = orderId;
}
public String getOrderName() {
return OrderName;
}
public void setOrderName(String orderName) {
OrderName = orderName;
}
public Customer getCustomer() {
return customer;
}
public void setCustomer(Customer customer) {
this.customer = customer;
}
@Override
public String toString() {
return "Order [OrderId=" + OrderId + ", OrderName=" + OrderName + ", customer=" + customer + "]";
}
}
hibernate基本配置文件:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 配置连接数据库的信息 -->
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">123456</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql:///hibernettest</property>
<!--配置hibernate基本信息 -->
<!-- sql方言 -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<!-- 是否打印sql语句 -->
<property name="hibernate.show_sql">true</property>
<!-- 格式化sql语句 -->
<property name="format_sql">true</property>
<!-- 生成数据表的策略 -->
<property name="hbm2ddl.auto">update</property>
<!-- 映射 -->
<mapping resource="hibernatetomanlytoman/Customer.hbm.xml"/>
<mapping resource="hibernatetomanlytoman/Order.hbm.xml"/>
</session-factory>
</hibernate-configuration>
实体类与数据库的映射配置文件:
<?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 2017-8-21 19:16:59 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="hibernatetomanly.Customer" table="CUSTOMERS">
<id name="CustomerId" type="java.lang.Integer">
<column name="Customer_ID" />
<generator class="native" />
</id>
<property name="CustomerName" type="java.lang.String">
<column name="NAME" />
</property>
</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 2017-8-21 19:16:59 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="hibernatetomanly.Order" table="ORDERS">
<id name="OrderId" type="java.lang.Integer">
<column name="ORDER_ID" />
<generator class="native" />
</id>
<property name="OrderName" type="java.lang.String">
<column name="NAME" />
</property>
<many-to-one name="customer" class="hibernatetomanly.Customer">
<column name="Customer_ID" />
</many-to-one>
</class>
</hibernate-mapping>
测试类:
import static org.junit.Assert.*;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
public class test {
private SessionFactory sessionfactory=null;
private Session session=null;
private Transaction transaction=null;
@Before
public void Init()
{
Configuration configuration=new Configuration().configure();
sessionfactory=configuration.buildSessionFactory();
session=sessionfactory.openSession();
transaction=session.beginTransaction();
}
@After
public void destroy()
{
transaction.commit();
session.close();
sessionfactory.close();
}
@Test
public void test() {
Customer customer=new Customer();
customer.setCustomerName("aaa");
Order o=new Order();
o.setOrderName("o");
o.setCustomer(customer);
Order oo=new Order();
oo.setOrderName("oo");
oo.setCustomer(customer);
session.save(o);
session.save(oo);
session.save(customer);
}
@Test
public void delete()
{
Order order=session.get(Order.class, 1);
session.delete(order);
}
@Test
public void find()
{
Customer customer=session.get(Customer.class, 1);
customer.setCustomerName("bbbbbbb");
session.update(customer);
}
}
双向映射情况:
在Customer实体类中添加一个属性:
private Set<Order> orders=new HashSet<Order>();
public Set<Order> getOrders() {
return orders;
}
public void setOrders(Set<Order> orders) {
this.orders = orders;
}
在Customer.hbm.xml配置文件中,添加orders属性的映射
<set name="orders" table="ORDERS" inverse="true">
<key column="Customer_ID"></key>
<one-to-many class="hibernatetomanlytoman.Order"/>
</set>
测试类:
@Test
public void tomanlyupdate()
{
Customer customer=session.get(Customer.class, 1);
customer.getOrders().iterator().next().setOrderName("testupdate");
session.update(customer);
}