技术:springboot+mysql+java+eclipse
截图:
数据库表:
CREATE TABLE easybuy_news
(
id
int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
title
varchar(40) NOT NULL COMMENT ‘标题’,
content
varchar(1000) NOT NULL COMMENT ‘内容’,
createTime
varchar(10) NOT NULL COMMENT ‘创建时间’,
PRIMARY KEY (id
),
UNIQUE KEY PK__EASYBUY___C63B5EE724927208
(id
),
UNIQUE KEY UQ__EASYBUY___C12AD09D276EDEB3
(title
)
) ENGINE=InnoDB AUTO_INCREMENT=704 DEFAULT CHARSET=utf8;
– Records of easybuy_news
INSERT INTO easybuy_news
VALUES (‘531’, ‘会员特惠月开始了’, ‘会员特惠月开始了,亲们赶快下单啊,不到剁手誓不罢休啊,不到离婚誓不清空购物车啊。更多优惠,尽在易买网。’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘597’, ‘迎双旦促销大酬宾’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news
VALUES (‘649’, ‘加入会员,赢千万大礼包’, ‘加入会员,赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘650’, ‘新年不夜天,通宵也是开张了’, ‘新年不夜天,通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news
VALUES (‘651’, ‘积分兑换开始了’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘653’, ‘团购阿迪1折起’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘664’, ‘最新酷睿笔记本’, ‘IBME系列全场促销中,最新酷睿双核处理器,保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news
VALUES (‘675’, ‘aa’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news
VALUES (‘676’, ‘ResultR’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
INSERT INTO easybuy_news
VALUES (‘677’, ‘会员特惠月开始了1’, ‘会员特惠月开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘678’, ‘迎双旦促销大酬宾2’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news
VALUES (‘679’, ‘加入会员,赢千万大礼包3’, ‘加入会员,赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘680’, ‘新年不夜天,通宵也是开张了4’, ‘新年不夜天,通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news
VALUES (‘681’, ‘积分兑换开始了5’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘682’, ‘团购阿迪1折起6’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘683’, ‘最新酷睿笔记本7’, ‘IBME系列全场促销中,最新酷睿双核处理器,保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news
VALUES (‘684’, ‘aa8’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news
VALUES (‘685’, ‘ResultR9’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
INSERT INTO easybuy_news
VALUES (‘686’, ‘会员特惠月开始了11’, ‘会员特惠月开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘687’, ‘迎双旦促销大酬宾21’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news
VALUES (‘688’, ‘加入会员,赢千万大礼包31’, ‘加入会员,赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘689’, ‘新年不夜天,通宵也是开张了41’, ‘新年不夜天,通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news
VALUES (‘690’, ‘积分兑换开始了51’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘691’, ‘团购阿迪1折起61’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘692’, ‘最新酷睿笔记本71’, ‘IBME系列全场促销中,最新酷睿双核处理器,保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news
VALUES (‘693’, ‘aa81’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news
VALUES (‘694’, ‘ResultR91’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
INSERT INTO easybuy_news
VALUES (‘695’, ‘会员特惠月开始了111’, ‘会员特惠月开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘696’, ‘迎双旦促销大酬宾211’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news
VALUES (‘697’, ‘加入会员,赢千万大礼包311’, ‘加入会员,赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘698’, ‘新年不夜天,通宵也是开张了411’, ‘新年不夜天,通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news
VALUES (‘699’, ‘积分兑换开始了511’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘700’, ‘团购阿迪1折起611’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news
VALUES (‘701’, ‘最新酷睿笔记本711’, ‘IBME系列全场促销中,最新酷睿双核处理器,保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news
VALUES (‘702’, ‘aa811’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news
VALUES (‘703’, ‘ResultR911’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
– Table structure for easybuy_order
DROP TABLE IF EXISTS easybuy_order
;
CREATE TABLE easybuy_order
(
id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
userId
int(255) DEFAULT NULL COMMENT ‘用户主键’,
loginName
varchar(255) DEFAULT NULL,
userAddress
varchar(255) DEFAULT NULL COMMENT ‘用户地址’,
createTime
datetime DEFAULT NULL COMMENT ‘创建时间’,
cost
float DEFAULT NULL COMMENT ‘总消费’,
serialNumber
varchar(255) DEFAULT NULL COMMENT ‘订单号’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
– Records of easybuy_order
INSERT INTO easybuy_order
VALUES (‘1’, ‘18’, ‘shangzezhong’, ‘北京市花园路小区’, ‘2016-06-02 14:51:46’, ‘1721’, ‘60B7487F47F9434EAA5FD1D9E22CB06C’);
INSERT INTO easybuy_order
VALUES (‘2’, ‘18’, ‘shangzezhong’, ‘北京市海淀区成府路’, ‘2016-06-02 14:52:49’, ‘8596’, ‘8EF5E1557D55413781658A65FC301B8A’);
INSERT INTO easybuy_order
VALUES (‘3’, ‘2’, ‘admin’, ‘北京市海淀区大有庄’, ‘2016-06-03 11:41:09’, ‘456’, ‘51718726C1274CC59504AB4E6FD64BA0’);
INSERT INTO easybuy_order
VALUES (‘4’, ‘2’, ‘admin’, ‘ä¿¡å·å•Šå•Š’, ‘2018-07-07 00:29:47’, ‘158’, ‘05A0D516214E40DBB7F88614BC2B825B’);
INSERT INTO easybuy_order
VALUES (‘5’, ‘2’, ‘admin’, ‘北京市海淀区大有庄’, ‘2018-11-22 18:59:26’, ‘158’, ‘1730076A09934018B09E384274A06D4B’);