目录
1、安装
官网应有尽有(仅限基操)
http://www.h2database.com/html/advanced.html
依赖(20210325时候的最新版本)
<!--h2数据库-->
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.200</version>
</dependency>
2、目录结构
文件内容在备注中
3、单测示例(推荐使用第三种)
(1)启动容器,加载全部bean
(2)不启动容器,用jdbc连接
(3)启动容器,利用MybatisTest只加载部分的bean,大幅提高加载容器速度
附带的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter-test</artifactId>
<version>2.1.3</version>
<scope>test</scope>
</dependency>
可以同时用mock和连接内存数据库。
备注:建表语句和注意事项
double类型不能是两个数字的定义,只能double(n),不能double(n, m)
不能在字段里面设置字符类型如
`fund_type_name` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '经费类型名称',
没有多余的索引(或者有额外的索引构造语句)
下述红色箭头所指都是不符合规范的语句:
torder_master表用下述
schema.sql:
CREATE TABLE `torder_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ftbuyappid` int(11) DEFAULT NULL COMMENT '采购申请id',
`forderno` varchar(30) DEFAULT NULL COMMENT '订单号',
`forderdate` datetime NOT NULL COMMENT '订单签订日期',
`fbuyerid` int(11) NOT NULL COMMENT '购买者id',
`fbuyercode` varchar(50) DEFAULT NULL COMMENT '购买者代码',
`fbuyername` varchar(250) NOT NULL COMMENT '购买者名称',
`fbuyeremail` varchar(100) DEFAULT NULL COMMENT '采购人电邮',
`fbuyercontactman` varchar(50) DEFAULT NULL COMMENT '采购联系人',
`fbuyertelephone` varchar(100) DEFAULT NULL COMMENT '采购联系电话',
`fbuydepartmentid` int(11) DEFAULT NULL COMMENT '采购部门id',
`fbuydepartment` varchar(250) DEFAULT NULL COMMENT '采购部门',
`fsuppid` int(11) NOT NULL COMMENT '供应商id',
`fsuppcode` varchar(50) DEFAULT NULL COMMENT '供应商代码',
`fsuppname` varchar(250) NOT NULL COMMENT '供应商名称',
`fbiderdeliveryplace` varchar(400) DEFAULT NULL COMMENT '送货地点',
`forderamounttotal` decimal(18,2) DEFAULT NULL COMMENT '订单总价格',
`fund_status` int(1) DEFAULT '0' COMMENT '经费状态 2释放中,3释放失败,4释放成功',
`failed_reason` varchar(500) DEFAULT '' COMMENT '经费释放失败原因',
`status` int(11) DEFAULT NULL COMMENT '状态',
`fconfirmdate` datetime DEFAULT NULL COMMENT '确认日期',
`fconfirmmanid` varchar(30) DEFAULT NULL COMMENT '确认人id',
`fconfirmman` varchar(30) DEFAULT NULL COMMENT '确认人',
`fcanceldate` datetime DEFAULT NULL COMMENT '撤消日期',
`fcancelmanid` varchar(30) DEFAULT NULL COMMENT '撤消人id',
`fcancelman` varchar(250) DEFAULT NULL COMMENT '撤消人',
`fdeliverydate` datetime DEFAULT NULL COMMENT '送货日期',
`fdeliverymanid` varchar(30) DEFAULT NULL COMMENT '送货id',
`fdeliveryman` varchar(50) DEFAULT NULL COMMENT '送货人',
`flastreceivedate` datetime DEFAULT NULL COMMENT '最后收货日期',
`flastreceivemanid` varchar(30) DEFAULT NULL COMMENT '最后收货id',
`flastreceiveman` varchar(50) DEFAULT '' COMMENT '最后收货人',
`fassessdate` datetime DEFAULT NULL COMMENT '评价日期',
`fassessmanid` varchar(30) DEFAULT NULL COMMENT '评价id',
`fassessman` varchar(30) DEFAULT NULL COMMENT '评价人',
`piEmail` varchar(250) DEFAULT NULL,
`projectID` varchar(1000) DEFAULT NULL,
`projectnumber` varchar(1000) DEFAULT NULL,
`projecttitle` varchar(2000) DEFAULT NULL,
`fuserid` int(11) DEFAULT '2' COMMENT '医院ID',
`fusercode` varchar(200) DEFAULT '' COMMENT '医院CODE',
`fusername` varchar(250) DEFAULT 'xx大学附属肿瘤医院',
`statement_id` int(11) DEFAULT NULL COMMENT '结算单id',
`fcancelreason` varchar(220) DEFAULT '' COMMENT '撤销原因',
`frefuse_cancel_reason` varchar(220) DEFAULT '' COMMENT '拒绝取消原因',
`shut_down_date` datetime DEFAULT NULL COMMENT '订单关闭时间',
`delivery_info` varchar(200) DEFAULT NULL COMMENT '发货说明',
`delivery_no` varchar(50) DEFAULT NULL COMMENT '发货单号',
`return_amount` double(20) NOT NULL DEFAULT '0.00' COMMENT '退货金额',
`frefuse_cancel_date` datetime DEFAULT NULL COMMENT '拒绝撤销时间',
`fdeliveryid` int(11) DEFAULT NULL COMMENT '地址id',
`bid_order_id` varchar(36) DEFAULT NULL COMMENT '竞价单id',
`order_type` int(1) DEFAULT '0' COMMENT 'order类型,0:采购的,1:竞价单',
`receive_pic_urls` varchar(1500) DEFAULT NULL COMMENT '验收时图片',
`tpi_project_id` varchar(50) DEFAULT NULL COMMENT '项目记录id',
`original_amount` decimal(18,2) NOT NULL COMMENT '订单原价',
`inventory_status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '出入库状态',
`species` tinyint(4) NOT NULL DEFAULT '0' COMMENT '流程种类 0:正常, 1:线下',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`in_state_time` datetime NOT NULL DEFAULT '1970-10-10 10:00:00' COMMENT '结算中开始时间',
`purchase_RootIn_Type` int(2) NOT NULL DEFAULT '0' COMMENT '''采购来源:0PC;1 小程序''',
`carry_fee` decimal(18,2) DEFAULT NULL COMMENT '运费',
`invoice_title_id` bigint(20) DEFAULT '0' COMMENT '发票抬头id',
`invoice_title` varchar(100) DEFAULT '' COMMENT '发票抬头名称',
`invoice_title_number` varchar(100) DEFAULT '' COMMENT ' 发票抬头纳税人识别号',
`fmasterguid` varchar(36) DEFAULT NULL COMMENT '订单id',
`fund_type` int(4) DEFAULT NULL COMMENT '经费类型',
`fund_type_name` varchar(64) DEFAULT NULL COMMENT '经费类型名称',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '订单创建时间',
`payment_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
`statement_status` int(4) NOT NULL DEFAULT '-1' COMMENT '结算子状态',
PRIMARY KEY (`id`))
data.sql(示例):
INSERT INTO `torder_master` VALUES (1, 8, 'DC201612046507201', '2016-12-4 14:33:11', 1550, NULL, '洪玲玲', '0126@126.com', '张涵予', '18800112233', 829, '林毅采购部门', 655, 'S0655', '宏兴生物科技有限公司', '广东省广州市海珠区琶洲新村11栋 ', 701.00, 4, '', 10, '2016-12-4 14:34:22', '655', 'S0655', NULL, NULL, NULL, '2016-12-4 14:34:31', '655', 'S0655', '2016-12-4 14:43:45', '1550', '洪玲玲', NULL, NULL, NULL, NULL, '22;24', '2016001;2016003', '1;3', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '', '20161204001', 0.00, NULL, 112, NULL, 0, NULL, NULL, 701.00, 9, 0, '2021-3-17 10:17:07', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:33:11', 0.00, -1);
INSERT INTO `torder_master` VALUES (2, 9, 'DC201612042473001', '2016-12-4 14:37:17', 1561, NULL, '萧何', '2365219766@qq.co', '李小姐', '18510543639', 831, '张良课题组', 655, 'S0655', '宏兴生物科技有限公司', '广东省广州市海珠区新港东路42号 ', 210.00, 0, '', 3, NULL, NULL, NULL, '2019-7-24 20:20:03', '-1', '系统', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '供应商超时确认订单,系统自动取消订单', NULL, '2019-7-24 20:20:03', NULL, NULL, 0.00, NULL, 113, NULL, 0, NULL, NULL, 210.00, 0, 0, '2021-2-25 11:23:20', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:37:17', 0.00, -1);
INSERT INTO `torder_master` VALUES (3, 10, 'DC201612049603701', '2016-12-4 14:38:38', 1561, NULL, '萧何', '2365219766@qq.co', '李小姐', '18510543639', 831, '张良课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区新港东路42号 ', 600.00, 0, '', 11, '2016-12-4 14:39:34', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 14:39:48', '658', 'S0658', '2016-12-4 14:40:20', '1561', '萧何', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '啊实打实京东啊时间冻结啥都奥实打实大师的杰拉德奖励卡收到啦可视对讲达拉斯的啦', '001', 0.00, NULL, 113, NULL, 0, NULL, NULL, 600.00, 0, 0, '2020-9-10 11:21:42', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:38:38', 0.00, -1);
INSERT INTO `torder_master` VALUES (4, 11, 'DC201612048712501', '2016-12-4 14:41:49', 1560, NULL, '钱多多', '13300010001@qq.com', '我是收货人', '13300010002', 832, '钱多多课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 9600.99, 0, '', 11, '2016-12-4 14:57:20', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 14:57:56', '658', 'S0658', '2016-12-4 15:11:15', '1560', '钱多多', NULL, NULL, NULL, NULL, '21;20', '7111822293330444;6222833301112333', '第二张经费卡;第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '发货', '321456', 300.00, NULL, 111, NULL, 0, NULL, NULL, 9600.99, 0, 0, '2020-12-29 18:21:12', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:41:49', 9300.99, -1);
INSERT INTO `torder_master` VALUES (5, 13, 'DC201612046833801', '2016-12-4 14:49:36', 1550, NULL, '洪玲玲', '0126@126.com', '孟格格', '18099006600', 829, '林毅采购部门', 655, 'S0655', '宏兴生物科技有限公司', '浙江省杭州市拱墅区西湖南路 ', 1050.00, 4, '', 11, NULL, NULL, NULL, '2016-12-4 14:49:53', '1550', 'erdkma7k3n5mpm5t66jz6qwu', '2016-12-4 14:49:53', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, '2016-12-4 14:49:53', NULL, NULL, 0.00, NULL, 114, NULL, 0, NULL, NULL, 1050.00, 0, 0, '2021-3-10 13:45:30', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:49:36', 0.00, -1);
INSERT INTO `torder_master` VALUES (6, 14, 'DC201612049991701', '2016-12-4 14:51:25', 1550, NULL, '洪玲玲', '0126@126.com', '孟格格', '18099006600', 829, '林毅采购部门', 655, 'S0655', '宏兴生物科技有限公司', '浙江省杭州市拱墅区西湖南路 ', 560.00, 0, '', 10, '2016-12-4 14:51:35', '655', 'S0655', '2016-12-4 14:52:27', '1550', 'erdkma7k3n5mpm5t66jz6qwu', '2016-12-4 14:54:23', '655', 'S0655', '2016-12-4 15:10:00', '1550', '洪玲玲', NULL, NULL, NULL, NULL, '22;23;24;25', '2016001;2016002;2016003;2016004', '1;2;3;4', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '不买了', '无理请求', NULL, '', '20161204001', 210.00, NULL, 114, NULL, 0, NULL, NULL, 560.00, 0, 0, '2021-3-10 13:45:30', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:51:25', 0.00, -1);
INSERT INTO `torder_master` VALUES (7, 15, 'DC201612048463001', '2016-12-4 14:54:58', 1561, NULL, '萧何', '2365219766@qq.co', '李小姐', '18510543639', 831, '张良课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区新港东路42号 ', 12947.18, 0, '', 11, '2016-12-4 14:55:13', '658', 'S0658', '2016-12-4 15:00:46', '1561', 'jwexcggqwy2iw2utoomr5bmz', '2016-12-4 15:11:03', '658', 'S0658', NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '取消', '清清', NULL, '阿萨德拉丝机的撒到家啦卡死的', 'asf', 3004.70, NULL, 113, NULL, 0, NULL, NULL, 12947.18, 0, 0, '2020-9-13 17:16:09', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 14:54:58', 0.00, -1);
INSERT INTO `torder_master` VALUES (8, 16, 'DC201612041175001', '2016-12-4 15:17:01', 1550, NULL, '洪玲玲', '0126@126.com', '张涵予', '18800112233', 829, '林毅采购部门', 655, 'S0655', '宏兴生物科技有限公司', '广东省广州市海珠区琶洲新村11栋 ', 1050.00, 0, '', 3, NULL, NULL, NULL, '2019-7-24 20:20:03', '-1', '系统', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '供应商超时确认订单,系统自动取消订单', NULL, '2019-7-24 20:20:03', NULL, NULL, 0.00, NULL, 112, NULL, 0, NULL, NULL, 1050.00, 0, 0, '2021-3-10 13:45:30', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 15:17:01', 0.00, -1);
INSERT INTO `torder_master` VALUES (9, 17, 'DC201612048046801', '2016-12-4 15:23:32', 1560, NULL, '钱多多', '13300010001@qq.com', '我是收货人', '13300010002', 832, '钱多多课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 900.00, 0, '', 6, '2016-12-4 15:26:50', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 15:26:53', '658', 'S0658', '2016-12-4 15:32:23', '1560', '钱多多', NULL, NULL, NULL, NULL, '20', '6222833301112333', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, 'ccc', 'ssss', 600.00, NULL, 111, NULL, 0, NULL, NULL, 900.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 15:23:32', 0.00, -1);
INSERT INTO `torder_master` VALUES (10, 18, 'DC201612046052201', '2016-12-4 15:35:32', 1560, NULL, '钱多多', '13300010001@qq.com', '我是收货人', '13300010002', 832, '钱多多课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 300.00, 0, '', 15, '2016-12-4 15:35:58', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 15:36:02', '658', 'S0658', '2016-12-4 15:36:28', '1560', '钱多多', NULL, NULL, NULL, NULL, '20', '\n 6222833301112333\n ', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '发货啦', '4556879545', 0.00, NULL, 111, NULL, 0, NULL, NULL, 300.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 15:35:32', 0.00, -1);
INSERT INTO `torder_master` VALUES (11, 19, 'DC201612047155201', '2016-12-4 15:37:40', 1560, NULL, '钱多多', '13300010001@qq.com', '我是收货人', '13300010002', 832, '钱多多课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 12001.32, 0, '', 6, '2016-12-4 15:43:20', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 15:43:31', '658', 'S0658', '2016-12-4 15:47:36', '1560', '钱多多', NULL, NULL, NULL, NULL, '20', '6222833301112333', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, 'sdczxc', 'xxx', 6000.66, NULL, 111, NULL, 0, NULL, NULL, 12001.32, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 15:37:40', 0.00, -1);
INSERT INTO `torder_master` VALUES (12, 20, 'DC201612040141301', '2016-12-4 16:09:01', 1561, NULL, '萧何', '2365219766@qq.co', '李小姐', '18510543639', 831, '张良课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区新港东路42号 ', 299.37, 0, '', 3, NULL, NULL, NULL, '2016-12-4 16:14:13', '1561', 'jwexcggqwy2iw2utoomr5bmz', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, '2016-12-4 16:14:13', NULL, NULL, 0.00, NULL, 113, NULL, 0, NULL, NULL, 299.37, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 16:09:01', 0.00, -1);
INSERT INTO `torder_master` VALUES (13, 21, 'DC201612040018301', '2016-12-4 16:11:55', 1561, NULL, '萧何', '2365219766@qq.co', '李小姐', '18510543639', 831, '张良课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区新港东路42号 ', 299.37, 0, '', 10, '2016-12-4 17:38:57', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 17:39:02', '658', 'S0658', '2016-12-7 10:17:18', '1561', '萧何', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '1', '111', 0.00, NULL, 113, NULL, 0, NULL, NULL, 299.37, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 16:11:55', 0.00, -1);
INSERT INTO `torder_master` VALUES (14, 23, 'DC201612047204601', '2016-12-4 17:44:29', 1561, NULL, '萧何3', '2365219766@qq.co', '李小姐', '18510543639', 831, '张良课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区新港东路42号 ', 3001.00, 0, '', 5, '2016-12-4 17:44:34', '658', 'S0658', NULL, NULL, NULL, '2016-12-4 17:44:38', '658', 'S0658', NULL, NULL, '', NULL, NULL, NULL, NULL, '', '', '', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '2222', '22222', 0.00, NULL, 113, NULL, 0, NULL, NULL, 3001.00, 0, 0, '2021-1-27 17:59:01', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-4 17:44:29', 0.00, -1);
INSERT INTO `torder_master` VALUES (15, 25, 'DC201612051031301', '2016-12-5 09:58:41', 1550, NULL, '洪玲玲', '0126@126.com', '孟格格', '18099006600', 829, '林毅采购部门', 655, 'S0655', '宏兴生物科技有限公司', '浙江省杭州市拱墅区西湖南路 ', 700.00, 0, '', 7, '2016-12-5 09:58:59', '655', 'S0655', NULL, NULL, NULL, '2016-12-5 09:59:09', '655', 'S0655', '2016-12-5 09:59:43', '1550', '洪玲玲', '2016-12-5 10:09:55', '1550', '洪玲玲', NULL, '22;23', '2016001;2016002', '1;2', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '', '20161205001', 0.00, NULL, 114, NULL, 0, NULL, NULL, 700.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-5 09:58:41', 0.00, -1);
INSERT INTO `torder_master` VALUES (16, 26, 'DC201612057972901', '2016-12-5 10:24:46', 1560, NULL, '钱多多', '13100010001@163.com', '我是收货人', '13300010002', 832, '钱多多课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 299.37, 0, '', 3, NULL, NULL, NULL, '2019-7-24 20:20:03', '-1', '系统', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '20', '6222833301112333', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '供应商超时确认订单,系统自动取消订单', NULL, '2019-7-24 20:20:03', NULL, NULL, 0.00, NULL, 111, NULL, 0, NULL, NULL, 299.37, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-5 10:24:46', 0.00, -1);
INSERT INTO `torder_master` VALUES (17, 29, 'DC201612056691601', '2016-12-5 10:30:00', 1550, NULL, '洪玲玲', '0126@126.com', '张涵予', '18800112233', 829, '林毅采购部门', 655, 'S0655', '宏兴生物科技有限公司', '广东省广州市海珠区琶洲新村11栋 ', 630.00, 0, '', 11, '2016-12-5 11:09:33', '655', 'S0655', NULL, NULL, NULL, '2016-12-5 11:11:51', '655', 'S0655', '2016-12-5 11:16:37', '1550', '洪玲玲', NULL, NULL, NULL, NULL, '22', '2016001', '1', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, NULL, NULL, NULL, '', '20161205001', 0.00, NULL, 112, NULL, 0, NULL, NULL, 630.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-5 10:30:00', 0.00, -1);
INSERT INTO `torder_master` VALUES (18, 31, 'DC201612054401301', '2016-12-5 10:33:11', 1560, NULL, '钱多多', '13100010001@163.com', '我是收货人', '13300010002', 832, '钱多多课题组', 658, 'S0658', '石墨生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 3001.00, 0, '', 3, NULL, NULL, NULL, '2019-7-24 20:20:03', '-1', '系统', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '20', '6222833301112333', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '供应商超时确认订单,系统自动取消订单', NULL, '2019-7-24 20:20:03', NULL, NULL, 0.00, NULL, 111, NULL, 0, NULL, NULL, 3001.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-5 10:33:11', 0.00, -1);
INSERT INTO `torder_master` VALUES (19, 35, 'DC201612054724401', '2016-12-5 11:32:11', 1560, NULL, '钱多多', '13100010001@163.com', '我是收货人', '13300010002', 832, '钱多多课题组', 655, 'S0655', '宏兴生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 210.00, 2, '123', 3, NULL, NULL, NULL, '2019-7-24 20:20:03', '-1', '系统', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '20', '6222833301112333', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '供应商超时确认订单,系统自动取消订单', NULL, '2019-7-24 20:20:03', NULL, NULL, 0.00, NULL, 111, NULL, 0, NULL, NULL, 210.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-5 11:32:11', 0.00, -1);
INSERT INTO `torder_master` VALUES (20, 38, 'DC201612055421001', '2016-12-5 11:35:41', 1560, NULL, '钱多多', '13100010001@163.com', '我是收货人', '13300010002', 832, '钱多多课题组', 655, 'S0655', '宏兴生物科技有限公司', '广东省广州市海珠区我是详细地址 ', 210.00, 0, '', 3, NULL, NULL, NULL, '2019-7-24 20:20:03', '-1', '系统', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '20', '6222833301112333', '第一张经费卡', 7, 'KE_YAN_SHI_JI_HAO_CAI_CAI_GOU_PING_TAI', '演示医院', NULL, '供应商超时确认订单,系统自动取消订单', NULL, '2019-7-24 20:20:03', NULL, NULL, 0.00, NULL, 111, NULL, 0, NULL, NULL, 210.00, 0, 0, '2020-8-27 18:20:21', '1970-10-10 10:00:00', 0, 0.00, 0, '', '', NULL, NULL, NULL, '2016-12-5 11:35:41', 0.00, -1);
application.yml文件
appkey: order
deployenv: uat
spring:
datasource:
platform: h2
driver-class-name: org.h2.Driver
schema: classpath:schema.sql
data: classpath:data.sql