基于JavaWeb的库存管理系统（源码+数据库）

部分数据库：
CREATE TABLE t_export (
id int(11) NOT NULL auto_increment,
goodsId int(20) default NULL,
expoPrice varchar(20) default NULL,
expoDate datetime default NULL,
expoNum varchar(20) default NULL,
expoDesc varchar(1000) default NULL,
PRIMARY KEY (id),
KEY FK_t_export (goodsId),
CONSTRAINT FK_t_export FOREIGN KEY (goodsId) REFERENCES t_goods (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table t_export */

insert into t_export(id,goodsId,expoPrice,expoDate,expoNum,expoDesc) values (2,2,‘1001’,‘2014-04-01 12:12:12’,‘100’,‘java01’),(3,3,‘1002’,‘2014-04-02 12:12:12’,‘200’,‘java02’),(4,4,‘1003’,‘2014-04-03 12:12:12’,‘300’,‘java03’),(5,5,‘1004’,‘2014-04-04 12:12:12’,‘400’,‘java04’),(6,6,‘1005’,‘2014-04-05 12:12:12’,‘500’,‘java05’),(7,7,‘1006’,‘2014-04-06 12:12:12’,‘600’,‘java06’),(8,8,‘1007’,‘2014-04-07 12:12:12’,‘120’,‘java07’),(9,9,‘1008’,‘2014-04-08 12:12:12’,‘130’,‘java08’),(10,12,‘10091’,‘2014-04-10 00:00:00’,‘10091’,‘java091’);

/*Table structure for table t_goods */

DROP TABLE IF EXISTS t_goods;

CREATE TABLE t_goods (
id int(11) NOT NULL auto_increment,
goodsId int(20) default NULL,
goodsName varchar(20) default NULL,
proId int(20) default NULL,
typeId int(20) default NULL,
goodsDesc varchar(1000) default NULL,
PRIMARY KEY (id),
KEY FK_t_goods (typeId),
KEY FK_t1_goods (proId),
CONSTRAINT FK_t1_goods FOREIGN KEY (proId) REFERENCES t_provider (id),
CONSTRAINT FK_t_goods FOREIGN KEY (typeId) REFERENCES t_goodstype (id)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;