Java最新基于jsp+springboot的易卖网商城源码(1)，我总结了所有面试题

最新推荐文章于 2024-06-30 00:23:33 发布

2401_84691757

最新推荐文章于 2024-06-30 00:23:33 发布

阅读量665

点赞数 19

分类专栏：程序员文章标签： java 面试学习

本文链接：https://blog.csdn.net/2401_84691757/article/details/138728467

版权

程序员专栏收录该内容

109 篇文章

订阅专栏

这次面试我也做了一些总结，确实还有很多要学的东西。相关面试题也做了整理，可以分享给大家，了解一下面试真题，想进大厂的或者想跳槽的小伙伴不妨好好利用时间来学习。学习的脚步一定不能停止！

薪酬缩水，“裸辞”奋战25天三面美团，交叉面却被吊打，我太难了

Spring Cloud实战

薪酬缩水，“裸辞”奋战25天三面美团，交叉面却被吊打，我太难了

Spring Boot实战

薪酬缩水，“裸辞”奋战25天三面美团，交叉面却被吊打，我太难了

面试题整理（性能优化+微服务+并发编程+开源框架+分布式）

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

serialNumber varchar(255) DEFAULT NULL COMMENT ‘订单号’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=54 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 (‘6’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:02’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘7’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:06’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘8’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:08’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘10’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘11’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘12’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘13’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘14’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:25’, ‘456’, null);

INSERT INTO easybuy_order VALUES (‘38’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:43:58’, ‘304’, null);

INSERT INTO easybuy_order VALUES (‘39’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:53:28’, ‘304’, null);

INSERT INTO easybuy_order VALUES (‘40’, ‘2’, ‘admin’, ‘weq’, ‘2018-11-10 03:57:56’, ‘608’, null);

INSERT INTO easybuy_order VALUES (‘41’, ‘2’, ‘admin’, ‘asdfd’, ‘2018-11-10 04:03:12’, ‘304’, null);

INSERT INTO easybuy_order VALUES (‘42’, ‘2’, ‘admin’, ‘asdfd’, ‘2018-11-10 04:03:15’, ‘304’, null);

INSERT INTO easybuy_order VALUES (‘43’, ‘2’, ‘admin’, ‘zxcvzxcv’, ‘2018-11-10 04:04:55’, ‘152’, null);

INSERT INTO easybuy_order VALUES (‘44’, ‘2’, ‘admin’, ‘23423’, ‘2018-11-10 06:38:17’, ‘912’, ‘34e6dd23-e4b3-11e8-8eba-089e0140db8a’);

INSERT INTO easybuy_order VALUES (‘45’, ‘2’, ‘admin’, ‘213’, ‘2018-11-10 07:00:58’, ‘308’, ‘60129552-e4b6-11e8-8eba-089e0140db8a’);

INSERT INTO easybuy_order VALUES (‘46’, ‘2’, ‘admin’, ‘213’, ‘2018-11-10 07:07:13’, ‘304’, ‘3fd7b5d7-e4b7-11e8-8eba-089e0140db8a’);

INSERT INTO easybuy_order VALUES (‘47’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:09:44’, ‘152’, null);

INSERT INTO easybuy_order VALUES (‘48’, ‘2’, ‘admin’, ‘123asdf’, ‘2018-11-10 07:13:33’, ‘589’, null);

INSERT INTO easybuy_order VALUES (‘49’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:17:38’, ‘158’, null);

INSERT INTO easybuy_order VALUES (‘50’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:17:38’, ‘158’, ‘b437d747e4b811e88eba089e0140db8a’);

INSERT INTO easybuy_order VALUES (‘51’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:57:15’, ‘152’, ‘3cb15fed-e4be-11e8-8eba-089e0140db8a’);

INSERT INTO easybuy_order VALUES (‘52’, ‘2’, ‘admin’, ‘123’, ‘2018-11-11 11:51:30’, ‘152’, ‘12fd2175-e565-11e8-a1f1-089e0140db8a’);

INSERT INTO easybuy_order VALUES (‘53’, ‘2’, ‘admin’, ‘2312’, ‘2018-11-11 20:11:47’, ‘11028’, ‘f5b66747-e5aa-11e8-a1f1-089e0140db8a’);

– Table structure for easybuy_order_detail

DROP TABLE IF EXISTS easybuy_order_detail;

CREATE TABLE easybuy_order_detail (

id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,

orderId int(10) NOT NULL COMMENT ‘订单主键’,

productId int(10) NOT NULL COMMENT ‘商品主键’,

quantity int(10) NOT NULL COMMENT ‘数量’,

cost float NOT NULL COMMENT ‘消费’,

PRIMARY KEY (id),

UNIQUE KEY PK__EASYBUY___66E1BD8E2F10007B (id)

) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

– Records of easybuy_order_detail

INSERT INTO easybuy_order_detail VALUES (‘1’, ‘1’, ‘733’, ‘5’, ‘760’);

INSERT INTO easybuy_order_detail VALUES (‘2’, ‘1’, ‘734’, ‘4’, ‘608’);

INSERT INTO easybuy_order_detail VALUES (‘3’, ‘1’, ‘735’, ‘1’, ‘152’);

INSERT INTO easybuy_order_detail VALUES (‘4’, ‘1’, ‘738’, ‘1’, ‘45’);

INSERT INTO easybuy_order_detail VALUES (‘5’, ‘1’, ‘739’, ‘1’, ‘156’);

INSERT INTO easybuy_order_detail VALUES (‘6’, ‘2’, ‘755’, ‘1’, ‘8596’);

INSERT INTO easybuy_order_detail VALUES (‘7’, ‘3’, ‘733’, ‘1’, ‘152’);

INSERT INTO easybuy_order_detail VALUES (‘8’, ‘3’, ‘734’, ‘1’, ‘152’);

INSERT INTO easybuy_order_detail VALUES (‘9’, ‘3’, ‘735’, ‘1’, ‘152’);

– Table structure for easybuy_product

DROP TABLE IF EXISTS easybuy_product;

CREATE TABLE easybuy_product (

id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,

name varchar(20) NOT NULL COMMENT ‘名称’,

description varchar(1024) DEFAULT NULL COMMENT ‘描述’,

price float NOT NULL COMMENT ‘价格’,

stock int(10) NOT NULL COMMENT ‘库存’,

categoryLevel1Id int(10) DEFAULT NULL COMMENT ‘分类1’,

categoryLevel2Id int(10) DEFAULT NULL COMMENT ‘分类2’,

categoryLevel3Id int(10) DEFAULT NULL COMMENT ‘分类3’,

fileName varchar(200) DEFAULT NULL COMMENT ‘文件名称’,

isDelete int(1) DEFAULT ‘0’ COMMENT ‘是否删除(1：删除 0：未删除)’,

PRIMARY KEY (id),

UNIQUE KEY PK__EASYBUY___94F6E55132E0915F (id)

) ENGINE=InnoDB AUTO_INCREMENT=772 DEFAULT CHARSET=utf8;

– Records of easybuy_product

INSERT INTO easybuy_product VALUES (‘733’, ‘香奈儿’, ‘订单’, ‘152’, ‘94’, ‘548’, ‘654’, ‘655’, ‘27A1789ED5764D82A5506DF3DC3933F9.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘734’, ‘洗面奶’, ‘’, ‘152’, ‘995’, ‘548’, ‘654’, ‘655’, ‘D6C9BD438C5643D6B1A6C52E5426FE22.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘735’, ‘啫喱水’, ‘’, ‘152’, ‘998’, ‘548’, ‘654’, ‘655’, ‘1A836D2B3A3348DDAB19807E6CEA8028.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘736’, ‘香水5852’, ‘’, ‘152’, ‘1000’, ‘548’, ‘654’, ‘655’, ‘4D9499BAD92A42D291094E797BA2EA3F.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘737’, ‘香水’, ‘’, ‘152’, ‘111’, ‘548’, ‘654’, ‘655’, ‘A9924F9DB68B4DF99FDBF05902075AF0.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘738’, ‘润肤露’, ‘’, ‘45’, ‘109’, ‘548’, ‘654’, ‘655’, ‘3B059EDB5237407980458CE9EA9D3204.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘739’, ‘洁面装’, ‘’, ‘156’, ‘99’, ‘548’, ‘654’, ‘655’, ‘A62C6DF55116440CA3DE9DB37901ED4F.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘740’, ‘电饭锅’, ‘’, ‘158’, ‘100’, ‘628’, ‘656’, ‘659’, ‘40C3B76BA31246618E3CFC8723D33517.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘741’, ‘婴儿喂奶装’, ‘’, ‘569’, ‘100’, ‘632’, ‘637’, ‘653’, ‘401004B3D47C4C6FB1BC5EF19C21FC77.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘742’, ‘坚果套餐’, ‘’, ‘158’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘E03D74145A034F6D909879829CB99D80.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘743’, ‘超甜蜜崭’, ‘’, ‘589’, ‘1000’, ‘660’, ‘661’, ‘663’, ‘7121E55099FC477680B1229205CE3D29.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘744’, ‘华为2566’, ‘’, ‘589’, ‘1000’, ‘670’, ‘671’, ‘672’, ‘F24B4140A2284B3788A38F3B5AD1809A.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘745’, ‘荣耀3C’, ‘’, ‘589’, ‘100’, ‘670’, ‘671’, ‘672’, ‘F3921E12552A4D0AA3F75467B146A959.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘746’, ‘小米手环’, ‘’, ‘963’, ‘100’, ‘670’, ‘674’, ‘675’, ‘72F75A371B0B4C26A7F72FAAEF96FC68.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘747’, ‘华为2265’, ‘’, ‘896’, ‘1000’, ‘670’, ‘671’, ‘673’, ‘161F355A8A8549BA8F7F4CE3B4F07E40.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘748’, ‘越南坚果’, ‘’, ‘520’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘CBC98D3C9E544830821632F5C313D93E.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘749’, ‘日本进口马桶’, ‘’, ‘5866’, ‘100’, ‘628’, ‘657’, ‘0’, ‘A5AF40825E6940B2A59A040100E181A8.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘750’, ‘联想Y系列’, ‘’, ‘569’, ‘1000’, ‘670’, ‘690’, ‘691’, ‘956DB0BEC41B41B8A06C05C950130E23.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘751’, ‘脑白金1号’, ‘’, ‘589’, ‘1000’, ‘676’, ‘677’, ‘680’, ‘66E96AF9E9714A5C9EA901811173D662.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘752’, ‘莫里斯按’, ‘’, ‘589’, ‘1000’, ‘676’, ‘678’, ‘0’, ‘A7436BC607E74C81B392DCFE69D4AEAB.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘753’, ‘三鹿好奶粉’, ‘’, ‘859’, ‘100’, ‘676’, ‘679’, ‘0’, ‘3C465E7B8A324A8DA2A2EEE202E36166.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘754’, ‘儿童牛奶’, ‘’, ‘5896’, ‘100’, ‘676’, ‘679’, ‘0’, ‘D1AC9AE71ED348FA8D880FD4279D3422.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘755’, ‘软沙发’, ‘’, ‘8596’, ‘99’, ‘628’, ‘696’, ‘0’, ‘ED7921DE40FC47E18365754709A21194.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘756’, ‘收纳盒’, ‘’, ‘5966’, ‘100’, ‘628’, ‘696’, ‘0’, ‘DB86CA25CA4F4B4AA906F46BE542C6A6.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘757’, ‘洗衣液’, ‘’, ‘58’, ‘1000’, ‘628’, ‘696’, ‘0’, ‘E6CCDC343ACC471C908E9748776C6421.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘758’, ‘红短沙发’, ‘’, ‘596’, ‘123’, ‘628’, ‘696’, ‘0’, ‘BD5C77465DC2466BBCE7F95FB9764392.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘759’, ‘新西兰奶粉’, ‘’, ‘5896’, ‘100’, ‘676’, ‘679’, ‘0’, ‘9ED375098D42497B8FC33167E06D0EE8.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘760’, ‘婴儿车’, ‘’, ‘11000’, ‘100’, ‘681’, ‘682’, ‘687’, ‘1DBC0930641D43C29D74A9E1B40FEEBB.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘761’, ‘夏款婴儿车’, ‘’, ‘963’, ‘100’, ‘681’, ‘682’, ‘688’, ‘16290C4DBEAC4F00A636667019621468.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘762’, ‘抗压旅行箱’, ‘12’, ‘569’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘c4ca4238a0b923820dcc509a6f75849b.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘763’, ‘透明手提箱’, ‘’, ‘8596’, ‘1000’, ‘681’, ‘683’, ‘684’, ‘EAA8E66259BF4239B4A2237B62520EF1.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘764’, ‘婴儿果粉’, ‘’, ‘5896’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘08BE30BF7B5F4930B0093D8CC4056057.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘765’, ‘椰子粉’, ‘’, ‘5963’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘9C006B8BD1AD45398F474A8471ADC50B.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘766’, ‘坚果蛋糕’, ‘’, ‘200’, ‘100’, ‘660’, ‘661’, ‘663’, ‘2E5A16E21E0640E0BAE03E9B995DCD28.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘767’, ‘编制手提箱’, ‘’, ‘5896’, ‘1000’, ‘681’, ‘682’, ‘688’, ‘2E1D2A5E65A94FEEA17C72E47C530057.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘768’, ‘去玩儿无若’, ‘空间规划局’, ‘126’, ‘100’, ‘660’, ‘661’, ‘662’, ‘c4ca4238a0b923820dcc509a6f75849b.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘769’, ‘健胃液’, ‘’, ‘152’, ‘1000’, ‘676’, ‘679’, ‘0’, ‘30B5547CD7384DAA8A2F4F4D8C0BBF89.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘770’, ‘联想NTC’, ‘’, ‘8596’, ‘100’, ‘670’, ‘671’, ‘673’, ‘48BC371A85A548B7A7589E3F542D911D.jpg’, ‘0’);

INSERT INTO easybuy_product VALUES (‘771’, ‘123’, ‘123’, ‘12’, ‘123’, ‘670’, ‘674’, ‘675’, ‘c4ca4238a0b923820dcc509a6f75849b.jpg’, null);

– Table structure for easybuy_product_category

DROP TABLE IF EXISTS easybuy_product_category;

CREATE TABLE easybuy_product_category (

id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,

name varchar(20) NOT NULL COMMENT ‘名称’,

parentId int(10) DEFAULT NULL COMMENT ‘父级目录id’,

type int(11) DEFAULT NULL COMMENT ‘级别(1:一级 2：二级 3：三级)’,

iconClass varchar(255) DEFAULT NULL COMMENT ‘图标’,

PRIMARY KEY (id),

UNIQUE KEY PK__EASYBUY___9EC2A4E236B12243 (id)

) ENGINE=InnoDB AUTO_INCREMENT=698 DEFAULT CHARSET=utf8;

– Records of easybuy_product_category

INSERT INTO easybuy_product_category VALUES (‘548’, ‘化妆品’, ‘0’, ‘1’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘628’, ‘家用商品’, ‘0’, ‘1’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘654’, ‘面部护理’, ‘548’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘655’, ‘少女派’, ‘654’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘656’, ‘餐具’, ‘628’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘657’, ‘卫具’, ‘628’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘658’, ‘叉子’, ‘656’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘659’, ‘锅’, ‘656’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘660’, ‘进口食品,生鲜’, ‘0’, ‘1’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘661’, ‘零食/糖果/巧克力’, ‘660’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘662’, ‘坚果’, ‘661’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘663’, ‘蜜饯’, ‘661’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘669’, ‘孕期教育’, ‘546’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘670’, ‘电子商品’, ‘0’, ‘1’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘671’, ‘手机’, ‘670’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘672’, ‘华为手机’, ‘671’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘673’, ‘联想手机’, ‘671’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘674’, ‘手环’, ‘670’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘675’, ‘小米手环’, ‘674’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘676’, ‘保健食品’, ‘0’, ‘1’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘677’, ‘老年保健品’, ‘676’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘678’, ‘中年营养品’, ‘676’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘679’, ‘儿童保健品’, ‘676’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘680’, ‘脑白金’, ‘677’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘681’, ‘箱包’, ‘0’, ‘1’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘682’, ‘旅行箱’, ‘681’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘683’, ‘手提箱’, ‘681’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘684’, ‘大型’, ‘683’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘685’, ‘小型’, ‘683’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘686’, ‘中型’, ‘683’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘687’, ‘大型’, ‘682’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘688’, ‘中型’, ‘682’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘689’, ‘小型’, ‘682’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘690’, ‘电脑’, ‘670’, ‘2’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘691’, ‘联想电脑’, ‘690’, ‘3’, ‘’);

INSERT INTO easybuy_product_category VALUES (‘692’, ‘刀叉’, ‘656’, ‘3’, null);

INSERT INTO easybuy_product_category VALUES (‘693’, ‘碗筷’, ‘656’, ‘3’, null);

INSERT INTO easybuy_product_category VALUES (‘697’, ‘as’, null, ‘628’, null);

– Table structure for easybuy_user

DROP TABLE IF EXISTS easybuy_user;

CREATE TABLE easybuy_user (

id int(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,

loginName varchar(255) NOT NULL COMMENT ‘登录名’,

userName varchar(255) NOT NULL COMMENT ‘用户名’,

password varchar(255) NOT NULL COMMENT ‘密码’,

sex int(2) NOT NULL DEFAULT ‘1’ COMMENT ‘性别(1:男 0：女)’,

identityCode varchar(60) DEFAULT NULL COMMENT ‘身份证号’,

email varchar(80) DEFAULT NULL COMMENT ‘邮箱’,

mobile varchar(11) DEFAULT NULL COMMENT ‘手机’,

type int(2) DEFAULT ‘0’ COMMENT ‘类型（1：后台 0:前台）’,

PRIMARY KEY (id),

UNIQUE KEY PK__EASYBUY___C96109CC3A81B327 (loginName)

) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

– Records of easybuy_user

INSERT INTO easybuy_user VALUES (‘2’, ‘admin’, ‘系统管理员’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘130406198302141869’, ‘hello11@bdqn.com’, ‘1583233515’, ‘1’);

INSERT INTO easybuy_user VALUES (‘10’, ‘cgn’, ‘程广宁’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225189987854589’, ‘1044732267@qq.com’, ‘13366055011’, ‘0’);

INSERT INTO easybuy_user VALUES (‘11’, ‘hyl’, ‘韩语良’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225198874584539’, ‘1044732267@qq.com’, ‘13366055010’, ‘0’);

最后

ActiveMQ消息中间件面试专题

什么是ActiveMQ?
ActiveMQ服务器宕机怎么办？
丢消息怎么办？
持久化消息非常慢怎么办？
消息的不均匀消费怎么办？
死信队列怎么办？
ActiveMQ中的消息重发时间间隔和重发次数吗？

ActiveMQ消息中间件面试专题解析拓展：

BAT面试文档：ActiveMQ+redis+Spring+高并发多线程+JVM

redis面试专题及答案

支持一致性哈希的客户端有哪些？
Redis与其他key-value存储有什么不同？
Redis的内存占用情况怎么样？
都有哪些办法可以降低Redis的内存使用情况呢？
查看Redis使用情况及状态信息用什么命令？
Redis的内存用完了会发生什么？
Redis是单线程的，如何提高多核CPU的利用率？

BAT面试文档：ActiveMQ+redis+Spring+高并发多线程+JVM

Spring面试专题及答案

谈谈你对 Spring 的理解
Spring 有哪些优点？
Spring 中的设计模式
怎样开启注解装配以及常用注解
简单介绍下 Spring bean 的生命周期

Spring面试答案解析拓展

BAT面试文档：ActiveMQ+redis+Spring+高并发多线程+JVM

高并发多线程面试专题

现在有线程 T1、T2 和 T3。你如何确保 T2 线程在 T1 之后执行，并且 T3 线程在 T2 之后执行？
Java 中新的 Lock 接口相对于同步代码块（synchronized block）有什么优势？如果让你实现一个高性能缓存，支持并发读取和单一写入，你如何保证数据完整性。
Java 中 wait 和 sleep 方法有什么区别？
如何在 Java 中实现一个阻塞队列？
如何在 Java 中编写代码解决生产者消费者问题？
写一段死锁代码。你在 Java 中如何解决死锁？

高并发多线程面试解析与拓展

BAT面试文档：ActiveMQ+redis+Spring+高并发多线程+JVM