orderItem (vo,item)

最新推荐文章于 2023-06-12 11:00:24 发布

原创最新推荐文章于 2023-06-12 11:00:24 发布 · 2.2k 阅读

0 ·

CC 4.0 BY-SA版权

多表关联专栏收录该内容

6 篇文章

订阅专栏

package cn.itcast.shop.order.vo;

import cn.itcast.shop.product.vo.Product;

public class OrderItem {
   /*CREATE TABLE `orderitem` (
              `itemid` int(11) NOT NULL AUTO_INCREMENT,
              `count` int(11) DEFAULT NULL,
              `subtotal` double DEFAULT NULL,
              `pid` int(11) DEFAULT NULL,
              `oid` int(11) DEFAULT NULL,
              PRIMARY KEY (`itemid`),
              KEY `FKE8B2AB6166C01961` (`oid`),
              KEY `FKE8B2AB6171DB7AE4` (`pid`),
              CONSTRAINT `FKE8B2AB6166C01961` FOREIGN KEY (`oid`) REFERENCES `orders` (`oid`),
              CONSTRAINT `FKE8B2AB6171DB7AE4` FOREIGN KEY (`pid`) REFERENCES `product` (`pid`)
           ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
*/
       private Integer itemid;
       private Integer count;
       private Double subtotal;
       // 商品外键:对象
       private Product product;
       //订单的外键
       private Order order;
       public Integer getItemid() {
           return itemid;
       }
       public void setItemid(Integer itemid) {
           this.itemid = itemid;
       }
       public Integer getCount() {
           return count;
       }
       public void setCount(Integer count) {
           this.count = count;
       }
       public Double getSubtotal() {
           return subtotal;
       }
       public void setSubtotal(Double subtotal) {
           this.subtotal = subtotal;
       }
       public Product getProduct() {
           return product;
       }
       public void setProduct(Product product) {
           this.product = product;
       }
       public Order getOrder() {
           return order;
       }
       public void setOrder(Order order) {
           this.order = order;
       }

}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
        <class name="cn.itcast.shop.order.vo.OrderItem" table="orderitem">
                <id name="itemid">
                    <generator class="native"></generator>
                </id>
                <property name="count"></property>
                <property name="subtotal"></property>
        
               <many-to-one name="product" class="cn.itcast.shop.product.vo.Product" column="pid"></many-to-one>
               <many-to-one name="order" class="cn.itcast.shop.order.vo.Order" column="oid"></many-to-one>
        </class>
</hibernate-mapping>