java基于ssm乐轩公司订餐系统(计算机毕业设计)

技术:ssm+mysql+java+eclipse+tomcat

截图:在这里插入图片描述

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
部分数据库:
CREATE TABLE allusers (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL,
pwd varchar(50) DEFAULT NULL,
cx varchar(50) DEFAULT ‘普通管理员’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;


– Records of allusers


INSERT INTO allusers VALUES (‘2’, ‘hsg’, ‘hsg’, ‘超级管理员’, ‘2017-03-21 07:45:56’);
INSERT INTO allusers VALUES (‘3’, ‘111110’, ‘1’, ‘超级管理员’, ‘2019-03-02 03:07:18’);
INSERT INTO allusers VALUES (‘4’, ‘0000000’, ‘1’, ‘超级管理员’, ‘2019-03-20 22:33:05’);


– Table structure for caipinleibie


DROP TABLE IF EXISTS caipinleibie;
CREATE TABLE caipinleibie (
id int(11) NOT NULL AUTO_INCREMENT,
leibie varchar(50) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;


– Records of caipinleibie


INSERT INTO caipinleibie VALUES (‘5’, ‘D类’, ‘2019-03-02 01:19:47’);
INSERT INTO caipinleibie VALUES (‘6’, ‘Q类’, ‘2019-03-02 01:19:47’);
INSERT INTO caipinleibie VALUES (‘8’, ‘肉类’, ‘2019-03-02 03:09:24’);
INSERT INTO caipinleibie VALUES (‘9’, ‘鱼类’, ‘2019-03-20 22:33:37’);


– Table structure for caipinxinxi


DROP TABLE IF EXISTS caipinxinxi;
CREATE TABLE caipinxinxi (
id int(11) NOT NULL AUTO_INCREMENT,
caipinbianhao varchar(50) DEFAULT NULL,
caipinmingcheng varchar(50) DEFAULT NULL,
caipinleibie varchar(50) DEFAULT NULL,
chushoujiage varchar(50) DEFAULT NULL,
tupian varchar(50) DEFAULT NULL,
jieshao varchar(500) DEFAULT NULL,
tianjiaren varchar(50) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;


– Records of caipinxinxi


INSERT INTO caipinxinxi VALUES (‘5’, ‘017’, ‘清蒸水蛋’, ‘豆类’, ‘81’, ‘upload/1551467396385.jpg’, ‘的风格和发给好地方’, ‘021’, ‘2019-03-02 01:19:50’);
INSERT INTO caipinxinxi VALUES (‘6’, ‘001’, ‘家常肝片’, ‘肉类’, ‘100’, ‘upload/1551467384807.jpg’, ‘他人格的风格’, ‘001’, ‘2019-03-02 01:19:50’);
INSERT INTO caipinxinxi VALUES (‘7’, ‘32121321’, ‘蛋炒饭’, ‘肉类’, ‘200’, ‘upload/1553092469023.jpg’, ‘的风格的风格地方’, ‘0000001’, ‘2019-03-02 03:46:59’);
INSERT INTO caipinxinxi VALUES (‘8’, ‘2123123’, ‘a龙虾’, ‘鱼类’, ‘500’, ‘upload/1553092449810.jpg’, ‘地方个地方过得舒服’, ‘hsg’, ‘2019-03-20 22:34:15’);


– Table structure for dingdanxinxi


DROP TABLE IF EXISTS dingdanxinxi;
CREATE TABLE dingdanxinxi (
id int(11) NOT NULL AUTO_INCREMENT,
dingdanhao varchar(50) DEFAULT NULL,
jine varchar(50) DEFAULT NULL,
dingdanneirong varchar(500) DEFAULT NULL,
dizhi varchar(50) DEFAULT NULL,
xiadanren varchar(50) DEFAULT NULL,
lianxifangshi varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
iszf varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值