介绍:
技术:java、jsp
数据库:mysql
web服务器:Tomcat
集成开发工具:myeclipse
截图:
数据库表:
CREATE TABLE admin
(
id
int(4) NOT NULL auto_increment,
name
varchar(50) NOT NULL,
pwd
varchar(50) default NULL,
quanxian
int(4) default NULL,
PRIMARY KEY (name
),
UNIQUE KEY id
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
/*Data for the table admin
*/
insert into admin
(id
,name
,pwd
,quanxian
) values (2,‘111’,‘111’,-1),(1,‘admin’,‘024admin’,-1);
/*Table structure for table dingdan
*/
DROP TABLE IF EXISTS dingdan
;
CREATE TABLE dingdan
(
id
int(4) NOT NULL auto_increment,
supplierid
varchar(50) default NULL,
zuangtai
int(4) default ‘0’,
times
varchar(50) default ‘2008-5-20’,
UNIQUE KEY id
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;
/*Data for the table dingdan
*/
insert into dingdan
(id
,supplierid
,zuangtai
,times
) values (1,‘3’,0,‘2008-5-20’),(2,‘3’,1,‘2008-5-20’),(3,‘2’,0,‘2008-5-20’);
/*Table structure for table leibie
*/
DROP TABLE IF EXISTS leibie
;
CREATE TABLE leibie
(
id
int(4) NOT NULL auto_increment,
leibie
varchar(50) NOT NULL,
PRIMARY KEY (leibie
),
UNIQUE KEY id
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;
/*Data for the table leibie
*/
insert into leibie
(id
,leibie
) values (1,‘方便面类’),(2,‘服装类’),(3,‘玻璃产品类’),(4,‘qq’),(5,‘aa’),(6,‘2222’);
/*Table structure for table sandd
*/
DROP TABLE IF EXISTS sandd
;
CREATE TABLE sandd
(
id
int(4) NOT NULL auto_increment,
dingdanid
int(4) default NULL,
shangpinid
int(4) default NULL,
sums
int(4) default NULL,
UNIQUE KEY id
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;
源码下载地址:http://www.bycxy123.com/
本文地址:https://blog.csdn.net/weixin_37971904/article/details/107676128
如对本文有疑问, 点击进行留言回复!!
网友评论