技术: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;