# 1801_4

**Repository Path**: yang_boyi/c1801_4

## Basic Information

- **Project Name**: 1801_4
- **Description**: 1801四组组员: 杨波    王鲲鹏   王高明     霍明兴      武康业
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-02-01
- **Last Updated**: 2023-08-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 1801_4

#### 介绍
1801四组
组员：杨波  王鲲鹏  王高明  霍明兴  武康业


#### 软件架构
软件架构说明



创建数据库和数据表，并添加测试数据：
/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.5.20 : Database - binke
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`binke` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `binke`;

/*Table structure for table `cart` */

DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `productCount` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2002 DEFAULT CHARSET=utf8;

/*Data for the table `cart` */

insert  into `cart`(`id`,`customerId`,`productId`,`productCount`) values (2001,101,301,1);

/*Table structure for table `category` */

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `category` */

insert  into `category`(`id`,`name`) values (301,'标准单间');

/*Table structure for table `customer` */

DROP TABLE IF EXISTS `customer`;

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `password` varchar(50) NOT NULL,
  `inBlackList` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `customer` */

insert  into `customer`(`id`,`name`,`address`,`phone`,`password`,`inBlackList`) values (1,'伊丽','河北省唐山市','15533089220','q11111111',0),(2,'尔莉','河南省安阳市','15533089320','q22222222',0),(3,'三笠','山西省大同市','15533089420','q33333333',0),(4,'思礼','河北省邯郸市','15533089520','q44444444',0),(5,'武立','安徽省合肥市','15533089620','q55555555',0),(6,'琉璃','安徽省安庆市','15533089720','q66666666',0),(7,'绮丽','安徽省铜陵市','15533089820','q77777777',0),(8,'八力','河北省辛集市','15533089920','q88888888',0),(9,'九黎','河北省邢台市','15133089120','q99999999',0),(10,'司立','河北省承德市','15233089120','q00000000',0);

/*Table structure for table `manager` */

DROP TABLE IF EXISTS `manager`;

CREATE TABLE `manager` (
  `name` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `manager` */

insert  into `manager`(`name`,`password`) values ('周升','88888888'),('周杰','88888888'),('张龙','88888888'),('李海','88888888');

/*Table structure for table `order` */

DROP TABLE IF EXISTS `order`;

CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `address` varchar(200) NOT NULL,
  `state` varchar(10) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8;

/*Data for the table `order` */

insert  into `order`(`id`,`customerId`,`date`,`address`,`state`,`total`) values (101,1,'2020-02-09 16:10:21','河北省唐山市','待付款','100.00'),(102,2,'2020-02-09 16:11:15','河南省安阳市','已付款','200.00'),(103,3,'2020-02-09 16:12:46','山西省大同市','未入住','100.00'),(104,4,'2020-02-09 16:13:23','河北省邯郸市','已入住','200.00'),(105,5,'2020-02-09 16:13:50','安徽省合肥市','订单完成','100.00'),(106,6,'2020-02-09 16:14:41','安徽省安庆市','待付款','100.00'),(107,7,'2020-02-09 16:15:23','安徽省铜陵市','已付款','100.00'),(108,8,'2020-02-09 16:16:03','河北省辛集市','未入住','200.00'),(109,9,'2020-02-09 16:16:43','河北省邢台市','已入住','100.00'),(110,10,'2020-02-09 16:17:17','河北省承德市','订单完成','200.00');

/*Table structure for table `orderdetial` */

DROP TABLE IF EXISTS `orderdetial`;

CREATE TABLE `orderdetial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `productCount` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1010 DEFAULT CHARSET=utf8;

/*Data for the table `orderdetial` */

insert  into `orderdetial`(`id`,`orderId`,`productId`,`productCount`) values (1001,101,201,1),(1002,102,202,2),(1003,103,203,1),(1004,104,204,2),(1005,105,205,1),(1006,106,206,2),(1007,107,207,1),(1008,108,208,2),(1009,109,209,1);

/*Table structure for table `product` */

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryId` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `discripe` text NOT NULL,
  `images` varchar(500) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `state` varchar(10) NOT NULL DEFAULT '在售',
  `balance` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;

/*Data for the table `product` */

insert  into `product`(`id`,`categoryId`,`name`,`address`,`discripe`,`images`,`price`,`state`,`balance`) values (211,301,'标准单间','河北省唐山市','??鼸xif','？？赚xif','100.00','在售',1),(212,302,'标准双人间','河北省唐山市','??鼸xif','？？赚xif','200.00','在售',2),(213,301,'标准单间','河北省唐山市','??鼸xif','？？赚xif','100.00','在售',1),(214,302,'标准双人间','河北省唐山市','??鼸xif','？？赚xif','200.00','在售',2),(215,301,'标准单间','河北省唐山市','??鼸xif','？？赚xif','100.00','在售',1);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;



#### 安装教程

1.  xxxx
2.  xxxx
3.  xxxx

#### 使用说明

1.  xxxx
2.  xxxx
3.  xxxx

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 码云特技

1.  使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2.  码云官方博客 [blog.gitee.com](https://blog.gitee.com)
3.  你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解码云上的优秀开源项目
4.  [GVP](https://gitee.com/gvp) 全称是码云最有价值开源项目，是码云综合评定出的优秀开源项目
5.  码云官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6.  码云封面人物是一档用来展示码云会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)