介绍:
技术: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
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!