SET FOREIGN_KEY_CHECKS=0;
– Table structure for admin_user
DROP TABLE IF EXISTS admin_user
;
CREATE TABLE admin_user
(
id
int(11) NOT NULL AUTO_INCREMENT,
password
varchar(255) DEFAULT NULL,
username
varchar(255) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
– Records of admin_user
INSERT INTO admin_user
VALUES (‘1’, ‘admin’, ‘admin’);
INSERT INTO admin_user
VALUES (‘2’, ‘hfb’, ‘hfb’);
– Table structure for classification
DROP TABLE IF EXISTS classification
;
CREATE TABLE classification
(
id
int(11) NOT NULL AUTO_INCREMENT,
cname
varchar(255) DEFAULT NULL,
parent_id
int(11) DEFAULT NULL,
type
int(11) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of classification
INSERT INTO classification
VALUES (‘1’, ‘服装’, ‘0’, ‘1’);
INSERT INTO classification
VALUES (‘2’, ‘电脑’, null, ‘1’);
INSERT INTO classification
VALUES (‘3’, ‘手机’, null, ‘1’);
INSERT INTO classification
VALUES (‘4’, ‘食品’, null, ‘1’);
INSERT INTO classification
VALUES (‘5’, ‘笔记本’, ‘2’, ‘2’);
INSERT INTO classification
VALUES (‘6’, ‘平板’, ‘2’, ‘2’);
INSERT INTO classification
VALUES (‘7’, ‘台式机’, ‘2’, ‘2’);
INSERT INTO classification
VALUES (‘9’, ‘家居’, ‘0’, ‘1’);
INSERT INTO classification
VALUES (‘10’, ‘饮料’, ‘4’, ‘2’);
INSERT INTO classification
VALUES (‘11’, ‘智能手机’, ‘3’, ‘2’);
– Table structure for order
DROP TABLE IF EXISTS order
;
CREATE TABLE order
(
id
int(11) NOT NULL AUTO_INCREMENT,
addr
varchar(255) DEFAULT NULL,
name
varchar(255) DEFAULT NULL,
order_time
datetime DEFAULT NULL,
phone
varchar(255) DEFAULT NULL,
state
int(11) DEFAULT NULL,
total
double DEFAULT NULL,
user_id
int(11) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
– Records of order
INSERT INTO order
VALUES (‘1’, ‘fjsdakl’, ‘小明’, ‘2017-11-25 19:23:48’, ‘12345654’, ‘4’, ‘8888’, ‘1’);
INSERT INTO order
VALUES (‘2’, ‘kdls;ajfklafkasld’, ‘tom’, ‘2017-11-25 22:10:39’, ‘123456894’, ‘3’, ‘17998’, ‘1’);
INSERT INTO order
VALUES (‘3’, ‘ffggghhhhfdfhjhff’, ‘Catalina’, ‘2017-11-25 22:52:44’, ‘1234322313’, ‘2’, ‘6077’, ‘1’);
INSERT INTO order
VALUES (‘4’, ‘fdsakldfjasl;’, ‘tomcat’, ‘2017-11-25 23:35:01’, ‘1234567878’, ‘4’, ‘8999’, ‘1’);
INSERT INTO order
VALUES (‘5’, ‘Gggggggg’, ‘Hfb’, ‘2017-11-26 02:53:14’, ‘18679658549’, ‘2’, ‘5999’, ‘1’);
INSERT INTO order
VALUES (‘6’, ‘11’, ‘11’, ‘2020-09-16 11:19:40’, ‘11’, ‘1’, ‘222’, ‘1’);
INSERT INTO order
VALUES (‘7’, ‘大连’, ‘大连’, ‘2020-09-16 11:26:16’, ‘111’, ‘2’, ‘444’, ‘1’);
– Table structure for order_item
DROP TABLE IF EXISTS order_item
;
CREATE TABLE order_item
(
id
int(11) NOT NULL AUTO_INCREMENT,
count
int(11) DEFAULT NULL,
order_id
int(11) DEFAULT NULL,
product_id
int(11) DEFAULT NULL,
sub_total
double DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
– Records of order_item
INSERT INTO order_item
VALUES (‘1’, ‘1’, ‘1’, ‘10’, ‘8888’);
INSERT INTO order_item
VALUES (‘2’, ‘2’, ‘2’, ‘9’, ‘17998’);
INSERT INTO order_item
VALUES (‘3’, ‘2’, ‘3’, ‘11’, ‘78’);
INSERT INTO order_item
VALUES (‘4’, ‘1’, ‘3’, ‘13’, ‘5999’);
INSERT INTO order_item
VALUES (‘5’, ‘1’, ‘4’, ‘9’, ‘8999’);
INSERT INTO order_item
VALUES (‘6’, ‘1’, ‘5’, ‘13’, ‘5999’);
INSERT INTO order_item
VALUES (‘7’, ‘1’, ‘6’, ‘10’, ‘222’);
INSERT INTO order_item
VALUES (‘8’, ‘2’, ‘7’, ‘10’, ‘444’);
– Table structure for product
DROP TABLE IF EXISTS product
;
CREATE TABLE product
(
id
int(11) NOT NULL AUTO_INCREMENT,
csid
int(11) DEFAULT NULL,
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数同学面临毕业设计项目选题时,很多人都会感到无从下手,尤其是对于计算机专业的学生来说,选择一个合适的题目尤为重要。因为毕业设计不仅是我们在大学四年学习的一个总结,更是展示自己能力的重要机会。
因此收集整理了一份《2024年计算机毕业设计项目大全》,初衷也很简单,就是希望能够帮助提高效率,同时减轻大家的负担。
既有Java、Web、PHP、也有C、小程序、Python等项目供你选择,真正体系化!
由于项目比较多,这里只是将部分目录截图出来,每个节点里面都包含素材文档、项目源码、讲解视频
如果你觉得这些内容对你有帮助,可以添加VX:vip1024c (备注项目大全获取)
外链图片转存中…(img-48Tu8WMY-1712567273830)]
[外链图片转存中…(img-G3BxY39v-1712567273830)]
既有Java、Web、PHP、也有C、小程序、Python等项目供你选择,真正体系化!
由于项目比较多,这里只是将部分目录截图出来,每个节点里面都包含素材文档、项目源码、讲解视频
如果你觉得这些内容对你有帮助,可以添加VX:vip1024c (备注项目大全获取)
[外链图片转存中…(img-pxKPx1ap-1712567273830)]