今天测试Hibernate映射的结果。 -

woodpeckerboy
浏览: 81834 次
性别:
来自: 广州
最近访客更多访客>>

sliu123
pengshuo1981
liangzi_001
MyDicta
博主相关

博客
微博
相册
留言
关于我
文章分类

社区版块

存档分类

今天测试Hibernate映射的结果。

博客分类：
MySQL

/***************************************************************************************************************************************************/

/*******************                           情况 1,2,3   之情况1（单向）       ------- 【让Product做主表去参照Dividend】

/***************************************************************************************************************************************************/


即：由


//我们发现是product参照dividend表。所以这里product是主表。set的时候要用 product.setDividend(dividend);

@Entity
@Table(name="wxsc_product")
public class Product extends EntitySupport{

	@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)
	@JoinColumn(name="dividend_id",referencedColumnName="id")
	private Dividend dividend;//赠品



@Entity
@Table(name="wxsc_dividend")
public class Dividend extends EntitySupport {

	@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="dividend")
	private Product product;



以及：
Dividend dividend = new Dividend();
		dividend.setAttribute("玩具类");
		//dividend.setDividendId("DJFOIWEFILDJFOWFEjo-DJFWOE");
		dividend.setDividendName("赠品:自行车");
		dividend.setDividendNumber("484545488");
		dividend.setQuantity(2);
		dividend.setCreateTime(date);
		dividend.setUpdateTime(date);
	
	//下面让这两个商品p1,p2都赠送这一个赠品,另外一个商品p3则没有赠品
	Product p1 = new Product();
		p1.setArticleNumber("03558866-24-22");
		p1.setProductAttribute("湖南纸业出品");
		p1.setProductName("卫生纸");
		p1.setUnitPrice(14.32d);
		p1.setCreateTime(date);
		p1.setUpdateTime(date);
		p1.setDividend(dividend);
	Product p2 = new Product();
		p2.setArticleNumber("0694412548522");
		p2.setProductAttribute("广东阳江");
		p2.setProductName("水果刀");
		p2.setUnitPrice(6.5d);
		p2.setCreateTime(date);
		p2.setUpdateTime(date);
		p2.setDividend(dividend);
	
	Product p3 = new Product();
		p3.setArticleNumber("8754515484522");
		p3.setProductAttribute("广州经济开发区");
		p3.setProductName("茉莉蜜茶");
		p3.setUnitPrice(3.0d);
		p3.setCreateTime(date);
		p3.setUpdateTime(date);
		p3.setDividend(null);
	this.merge(p1);
	this.merge(p2);
	this.merge(p3);

生成的表关系是：


mysql> show create table wxsc_product;
+--------------+---------------------------------------------------------------------------------
| Table        | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+--------------+---------------------------------------------------------------------------------
| wxsc_product | CREATE TABLE `wxsc_product` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `article_number` varchar(255) DEFAULT NULL,
  `order_quantity` int(11) DEFAULT NULL,
  `product_attribute` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `unit_price` double DEFAULT NULL,
  `dividend_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKEC59DBA19367CD45` (`dividend_id`),
  CONSTRAINT `FKEC59DBA19367CD45` FOREIGN KEY (`dividend_id`) REFERENCES `wxsc_dividend` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk |
+--------------+----------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql> show create table wxsc_dividend;
+---------------+---------------------------------------------------------------------------------
| Table         | Create Table                                                                                                                                                                                                                                                                                                                                                                                                              |
+---------------+---------------------------------------------------------------------------------
| wxsc_dividend | CREATE TABLE `wxsc_dividend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `attribute` varchar(255) DEFAULT NULL,
  `dividend_name` varchar(255) DEFAULT NULL,
  `dividend_number` varchar(255) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk |
+---------------+---------------------------------------------------------------------------------
1 row in set (0.00 sec)

会得到下面的结果。


mysql> select * from wxsc_dividend;
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
| id | createTime          | updateTime          | version | attribute | dividend_name | dividend_number | quantity |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
|  1 | 2014-04-05 16:45:31 | 2014-04-05 16:45:31 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |
|  2 | 2014-04-05 16:45:31 | 2014-04-05 16:45:31 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
2 rows in set (0.00 sec)

mysql> select * from wxsc_product;
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
| id | createTime          | updateTime          | version | article_number | order_quantity | product_attribute | product_name | unit_price | dividend_id |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
|  1 | 2014-04-05 16:45:31 | 2014-04-05 16:45:31 |       0 | 03558866-24-22 |              0 | 湖南纸业出品      | 卫生纸       |      14.32 |           1 |
|  2 | 2014-04-05 16:45:31 | 2014-04-05 16:45:31 |       0 | 0694412548522  |              0 | 广东阳江          | 水果刀       |        6.5 |           2 |
|  3 | 2014-04-05 16:45:31 | 2014-04-05 16:45:31 |       0 | 8754515484522  |              0 | 广州经济开发区    | 茉莉蜜茶     |          3 |        NULL |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
3 rows in set (0.00 sec)





/***************************************************************************************************************************************************/

/*******************                           情况 1,2,3   之情况2（单向）       ------- 【让Dividend做主表去参照Product】

/***************************************************************************************************************************************************/







修改为：(发现不能按下面这样子做，不然Product表的外键约束全是NULL)

//我们发现是 dividend 参照 product 表。所以这里 dividend 是主表。set的时候要用 dividend.setDividend(product);


@Entity
@Table(name="wxsc_product")
public class Product extends EntitySupport{

	@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="product")
	private Dividend dividend;//赠品


@Entity
@Table(name="wxsc_dividend")
public class Dividend extends EntitySupport {

	@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)
	@JoinColumn(name="product_id",referencedColumnName="id")//我让Dividend做主表去参照Product
	private Product product;



以及：

       Dividend dividend = new Dividend();
		dividend.setAttribute("玩具类");
		//dividend.setDividendId("DJFOIWEFILDJFOWFEjo-DJFWOE");
		dividend.setDividendName("赠品:自行车");
		dividend.setDividendNumber("484545488");
		dividend.setQuantity(2);
		dividend.setCreateTime(date);
		dividend.setUpdateTime(date);
	
	//下面让这两个商品p1,p2都赠送这一个赠品,另外一个商品p3则没有赠品
	Product p1 = new Product();
		p1.setArticleNumber("03558866-24-22");
		p1.setProductAttribute("湖南纸业出品");
		p1.setProductName("卫生纸");
		p1.setUnitPrice(14.32d);
		p1.setCreateTime(date);
		p1.setUpdateTime(date);
		p1.setDividend(dividend);
	Product p2 = new Product();
		p2.setArticleNumber("0694412548522");
		p2.setProductAttribute("广东阳江");
		p2.setProductName("水果刀");
		p2.setUnitPrice(6.5d);
		p2.setCreateTime(date);
		p2.setUpdateTime(date);
		p2.setDividend(dividend);
	
	Product p3 = new Product();
		p3.setArticleNumber("8754515484522");
		p3.setProductAttribute("广州经济开发区");
		p3.setProductName("茉莉蜜茶");
		p3.setUnitPrice(3.0d);
		p3.setCreateTime(date);
		p3.setUpdateTime(date);
		p3.setDividend(null);
	this.merge(p1);
	this.merge(p2);
	this.merge(p3);

生成的关系如下：

mysql> show create table wxsc_product;
+--------------+-------------------------------------------------------------------------------------------------------------------
| Table        | Create Table
+--------------+-------------------------------------------------------------------------------------------------------------------
| wxsc_product | CREATE TABLE `wxsc_product` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `article_number` varchar(255) DEFAULT NULL,
  `order_quantity` int(11) DEFAULT NULL,
  `product_attribute` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `unit_price` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk |
+--------------+-------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql> show create table wxsc_dividend;
+---------------+------------------------------------------------------------------------------------------------------------------
| Table         | Create Table
+---------------+------------------------------------------------------------------------------------------------------------------
| wxsc_dividend | CREATE TABLE `wxsc_dividend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `attribute` varchar(255) DEFAULT NULL,
  `dividend_name` varchar(255) DEFAULT NULL,
  `dividend_number` varchar(255) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKF06C177DE93A980F` (`product_id`),
  CONSTRAINT `FKF06C177DE93A980F` FOREIGN KEY (`product_id`) REFERENCES `wxsc_product` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk |
+---------------+------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql>

插入数据试试看。结果如下：



mysql> select * from wxsc_product;
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+
| id | createTime          | updateTime          | version | article_number | order_quantity | product_attribute | product_name | unit_price |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+
|  1 | 2014-04-05 16:58:53 | 2014-04-05 16:58:53 |       0 | 03558866-24-22 |              0 | 湖南纸业出品      | 卫生纸       |      14.32 |
|  2 | 2014-04-05 16:58:53 | 2014-04-05 16:58:53 |       0 | 0694412548522  |              0 | 广东阳江          | 水果刀       |        6.5 |
|  3 | 2014-04-05 16:58:53 | 2014-04-05 16:58:53 |       0 | 8754515484522  |              0 | 广州经济开发区    | 茉莉蜜茶     |          3 |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+
3 rows in set (0.00 sec)

mysql> select * from wxsc_dividend;
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+------------+
| id | createTime          | updateTime          | version | attribute | dividend_name | dividend_number | quantity | product_id |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+------------+
|  1 | 2014-04-05 16:58:53 | 2014-04-05 16:58:53 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |       NULL |
|  2 | 2014-04-05 16:58:53 | 2014-04-05 16:58:53 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |       NULL |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+------------+
2 rows in set (0.00 sec)

mysql>

结果还是一样的。

eclipse生成如下的 Hibernate SQL 语句：

正在构造一些假数据.
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Dividend
        */ insert 
        into
            wxsc_dividend
            (createTime, updateTime, version, attribute, dividend_name, dividend_number, product_id, quantity) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Dividend
        */ insert 
        into
            wxsc_dividend
            (createTime, updateTime, version, attribute, dividend_name, dividend_number, product_id, quantity) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)




可见外键没参照到product表。这是因为写java代码的时候不可以继续使用上面那段了

//p1.setDividend(dividend); 特别说明：这种写法只适用于 product参照dividend表的情况下使用。如果参照关系反过来了。就要使用 dividend.setDividend(p1);

还有特别注意一个规律：

只要是mappBy=“product”
如果改成下面的Java语句试试看。参照关系仍然是 product 参照 dividend 





/***************************************************************************************************************************************************/

/*******************                           情况 1,2,3   之情况3（双向）       ------- 回到最初【让 Product 做主表去参照 Dividend】

/***************************************************************************************************************************************************/

set对象关系的时候一定要记住两个事情：
1.谁做主表？
2.单向还是双向映射？如果是双向就要两个对象都要互相set对方。这样级联更新的时候结果才是正确的。




@Entity
@Table(name="wxsc_product")
public class Product extends EntitySupport{

	@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)
	@JoinColumn(name="dividend_id",referencedColumnName="id")//我让 Product 做主表去参照 Dividend 
	private Dividend dividend;//赠品


@Entity
@Table(name="wxsc_dividend")
public class Dividend extends EntitySupport {

	@OneToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="dividend")
	private Product product;



以及：

       Dividend dividend = new Dividend();
		dividend.setAttribute("玩具类");
		//dividend.setDividendId("DJFOIWEFILDJFOWFEjo-DJFWOE");
		dividend.setDividendName("赠品:自行车");
		dividend.setDividendNumber("484545488");
		dividend.setQuantity(2);
		dividend.setCreateTime(date);
		dividend.setUpdateTime(date);
	
	//下面让这两个商品p1,p2都赠送这一个赠品,另外一个商品p3则没有赠品
	Product p1 = new Product();
		p1.setArticleNumber("03558866-24-22");
		p1.setProductAttribute("湖南纸业出品");
		p1.setProductName("卫生纸");
		p1.setUnitPrice(14.32d);
		p1.setCreateTime(date);
		p1.setUpdateTime(date);
		p1.setDividend(dividend);
	Product p2 = new Product();
		p2.setArticleNumber("0694412548522");
		p2.setProductAttribute("广东阳江");
		p2.setProductName("水果刀");
		p2.setUnitPrice(6.5d);
		p2.setCreateTime(date);
		p2.setUpdateTime(date);
		p2.setDividend(dividend);
	
	Product p3 = new Product();
		p3.setArticleNumber("8754515484522");
		p3.setProductAttribute("广州经济开发区");
		p3.setProductName("茉莉蜜茶");
		p3.setUnitPrice(3.0d);
		p3.setCreateTime(date);
		p3.setUpdateTime(date);
		p3.setDividend(null);
	
	//与上面的区别就是多加了下面这两句.
	dividend.setProduct(p1);
	dividend.setProduct(p2);

	this.merge(p1);
	this.merge(p2);
	this.merge(p3);

生成的关系如下：

mysql> show create table wxsc_product;
+--------------+-----------------------------------------------------------------------------------------------------
| Table        | Create Table
+--------------+-----------------------------------------------------------------------------------------------------
| wxsc_product | CREATE TABLE `wxsc_product` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `article_number` varchar(255) DEFAULT NULL,
  `order_quantity` int(11) DEFAULT NULL,
  `product_attribute` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `unit_price` double DEFAULT NULL,
  `dividend_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKEC59DBA19367CD45` (`dividend_id`),
  CONSTRAINT `FKEC59DBA19367CD45` FOREIGN KEY (`dividend_id`) REFERENCES `wxsc_dividend` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gbk |
+--------------+-----------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql> show create table wxsc_dividend;
+---------------+----------------------------------------------------------------------------------------------------
| Table         | Create Table
+---------------+----------------------------------------------------------------------------------------------------
| wxsc_dividend | CREATE TABLE `wxsc_dividend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime NOT NULL,
  `updateTime` datetime NOT NULL,
  `version` int(11) NOT NULL,
  `attribute` varchar(255) DEFAULT NULL,
  `dividend_name` varchar(255) DEFAULT NULL,
  `dividend_number` varchar(255) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk |
+---------------+----------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

mysql>

插入的数据如下：

mysql> select * from wxsc_product;
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
| id | createTime          | updateTime          | version | article_number | order_quantity | product_attribute | product_name | unit_price | dividend_id |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
|  1 | 2014-04-05 17:33:59 | 2014-04-05 17:33:59 |       0 | 0694412548522  |              0 | 广东阳江          | 水果刀       |        6.5 |           1 |
|  2 | 2014-04-05 17:33:59 | 2014-04-05 17:33:59 |       0 | 03558866-24-22 |              0 | 湖南纸业出品      | 卫生纸       |      14.32 |           1 |
|  3 | 2014-04-05 17:33:59 | 2014-04-05 17:33:59 |       0 | 0694412548522  |              0 | 广东阳江          | 水果刀       |        6.5 |           2 |
|  4 | 2014-04-05 17:33:59 | 2014-04-05 17:33:59 |       0 | 8754515484522  |              0 | 广州经济开发区    | 茉莉蜜茶     |          3 |        NULL |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
4 rows in set (0.00 sec)

mysql> select * from wxsc_dividend;
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
| id | createTime          | updateTime          | version | attribute | dividend_name | dividend_number | quantity |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
|  1 | 2014-04-05 17:33:59 | 2014-04-05 17:33:59 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |
|  2 | 2014-04-05 17:33:59 | 2014-04-05 17:33:59 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
2 rows in set (0.00 sec)

mysql>



太悲剧了。更加乱。


eclipse的输出如下：

正在构造一些假数据.
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Dividend
        */ insert 
        into
            wxsc_dividend
            (createTime, updateTime, version, attribute, dividend_name, dividend_number, quantity) 
        values
            (?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, dividend_id, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, dividend_id, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Dividend
        */ insert 
        into
            wxsc_dividend
            (createTime, updateTime, version, attribute, dividend_name, dividend_number, quantity) 
        values
            (?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, dividend_id, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, dividend_id, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)




/***************************************************************************************************************************************************/

/*******************                           情况 1,2,3   之情况4（双向）       ------- 回到最初【让 Product 做主表去参照 Dividend】

/***************************************************************************************************************************************************/

我再次修改java语句为：


	Date date = new Date();
	Dividend dividend = new Dividend();
		dividend.setAttribute("玩具类");
		//dividend.setDividendId("DJFOIWEFILDJFOWFEjo-DJFWOE");
		dividend.setDividendName("赠品:自行车");
		dividend.setDividendNumber("484545488");
		dividend.setQuantity(2);
		dividend.setCreateTime(date);
		dividend.setUpdateTime(date);
	
	//下面让这两个商品p1,p2都赠送这一个赠品,另外一个商品p3则没有赠品
	Product p1 = new Product();
		p1.setArticleNumber("03558866-24-22");
		p1.setProductAttribute("湖南纸业出品");
		p1.setProductName("卫生纸");
		p1.setUnitPrice(14.32d);
		p1.setCreateTime(date);
		p1.setUpdateTime(date);
		p1.setDividend(dividend);
	Product p2 = new Product();
		p2.setArticleNumber("0694412548522");
		p2.setProductAttribute("广东阳江");
		p2.setProductName("水果刀");
		p2.setUnitPrice(6.5d);
		p2.setCreateTime(date);
		p2.setUpdateTime(date);
		p2.setDividend(dividend);
	
	Product p3 = new Product();
		p3.setArticleNumber("8754515484522");
		p3.setProductAttribute("广州经济开发区");
		p3.setProductName("茉莉蜜茶");
		p3.setUnitPrice(3.0d);
		p3.setCreateTime(date);
		p3.setUpdateTime(date);
		p3.setDividend(null);
	
	dividend.setProduct(p1);
	dividend.setProduct(p2);
	
	this.merge(dividend);

得到如下数据：


mysql> select * from wxsc_product;
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
| id | createTime          | updateTime          | version | article_number | order_quantity | product_attribute | product_name | unit_price | dividend_id |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
|  1 | 2014-04-05 17:41:58 | 2014-04-05 17:41:58 |       0 | 0694412548522  |              0 | 广东阳江          | 水果刀       |        6.5 |           1 |
+----+---------------------+---------------------+---------+----------------+----------------+-------------------+--------------+------------+-------------+
1 row in set (0.00 sec)

mysql> select * from wxsc_dividend;
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
| id | createTime          | updateTime          | version | attribute | dividend_name | dividend_number | quantity |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
|  1 | 2014-04-05 17:41:58 | 2014-04-05 17:41:58 |       0 | 玩具类    | 赠品:自行车   | 484545488       |        2 |
+----+---------------------+---------------------+---------+-----------+---------------+-----------------+----------+
1 row in set (0.00 sec)

mysql>

可见这样做更加错。




后台eclipse的输出是：

正在构造一些假数据.
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Dividend
        */ insert 
        into
            wxsc_dividend
            (createTime, updateTime, version, attribute, dividend_name, dividend_number, quantity) 
        values
            (?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Product
        */ insert 
        into
            wxsc_product
            (createTime, updateTime, version, article_number, dividend_id, order_quantity, product_attribute, product_name, unit_price) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert com.kington.wxsc.model.db.shop.Subscriber
        */ insert 
        into
            wxsc_subscriber
            (createTime, updateTime, version, city, country, headimgurl, language, local_headimg_url, nickname, open_id, parent_subscriber_id, payment_type, province, sex, subscribe_number, subscribe_time, telephone_number) 
        values
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)






/***************************************************************************************************************************************************/

/*******************                                                   情况 4,5,6    之情况4                                    **********************/

/***************************************************************************************************************************************************/


这个情况可以忽略。
分享到：
JQuery中$.ajax()方法参数详解 | 数据库映射只@OneToMany的两个区别
2014-04-05 17:47
浏览 497
评论(0)
分类:数据库
查看更多
发表评论

您还没有登录,请您登录后再发表评论
最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

今天测试Hibernate映射的结果。

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

今天测试Hibernate映射的结果。

评论

发表评论

相关推荐

mysql忘记密码

Mysql创建新用户方法以及修改密码

MySQL中文乱码

MYSQL导入导出.sql文件

最近访客更多访客>>
