order (vo,xml)

最新推荐文章于 2021-09-01 13:54:27 发布

原创最新推荐文章于 2021-09-01 13:54:27 发布 · 321 阅读

0 ·

CC 4.0 BY-SA版权

多表关联专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个订单系统的数据库设计及对应的Java实体类定义。详细解释了订单表的字段含义，并展示了如何通过Java类映射到数据库表，包括订单状态、时间、用户关联等属性。

package cn.itcast.shop.order.vo;

import java.util.Date;
import java.util.HashSet;
import java.util.Set;

import cn.itcast.shop.user.vo.User;

/*CREATE TABLE `orders` (
`oid` int(11) NOT NULL AUTO_INCREMENT,
`total` double DEFAULT NULL,
`ordertime` datetime DEFAULT NULL,
`state` int(11) DEFAULT NULL,
`name` varchar(21) DEFAULT NULL,
`addr` varchar(60) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
PRIMARY KEY (`oid`),
KEY `FKC3DF62E5AA3D9C7` (`uid`),
CONSTRAINT `FKC3DF62E5AA3D9C7` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
*/
public class Order {
   private Integer oid;
   private Double total;
   private Date ordertime;
   private Integer state;// 1:未付款   2:订单已经付款   3:已经发货   4:订单结束
   private String name;
   private String phone;
   private String addr;
   //订单的外键
   private User user;
   // 配置订单项的集合
   private Set<OrderItem> orderItems=new HashSet<OrderItem>();
   public Integer getOid() {
       return oid;
   }
   public void setOid(Integer oid) {
       this.oid = oid;
   }
   public Double getTotal() {
       return total;
   }
   public void setTotal(Double total) {
       this.total = total;
   }
   public Date getOrdertime() {
       return ordertime;
   }
   public void setOrdertime(Date ordertime) {
       this.ordertime = ordertime;
   }
   public Integer getState() {
       return state;
   }
   public void setState(Integer state) {
       this.state = state;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getPhone() {
       return phone;
   }
   public void setPhone(String phone) {
       this.phone = phone;
   }
   public String getAddr() {
       return addr;
   }
   public void setAddr(String addr) {
       this.addr = addr;
   }
   public User getUser() {
       return user;
   }
   public void setUser(User user) {
       this.user = user;
   }
   public Set<OrderItem> getOrderItems() {
       return orderItems;
   }
   public void setOrderItems(Set<OrderItem> orderItems) {
       this.orderItems = orderItems;
   }


}

<?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.Order" table="orders">
           <id name="oid">
                   <generator class="native"></generator>
           </id>
           <property name="total"></property>
           <property name="ordertime"></property>
           <property name="state"></property>
           <property name="name"></property>
           <property name="phone"></property>
           <property name="addr"></property>

           <many-to-one name="user" class="cn.itcast.shop.user.vo.User" column="uid"></many-to-one>
       
       
           <set name="orderItems">
               <key column="oid"></key>
               <one-to-many class="cn.itcast.shop.order.vo.OrderItem" />
               
           </set>
       </class>
    </hibernate-mapping>