java网上购物商店源码

/* MySQL Data Transfer Source Host: localhost Source Database: petshop Target Host: localhost Target Database: petshop Date: 2009-2-13 13:35:33 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for goods -- ---------------------------- CREATE TABLE `goods` ( `GoodsID` bigint(20) NOT NULL AUTO_INCREMENT, `BuyNumber` bigint(20) DEFAULT '1', `UserID` bigint(20) NOT NULL DEFAULT '0', `WareID` bigint(20) NOT NULL DEFAULT '0', `CreateTime` datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`GoodsID`), UNIQUE KEY `GoodsID` (`GoodsID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for sorts -- ---------------------------- CREATE TABLE `sorts` ( `SortID` bigint(20) NOT NULL AUTO_INCREMENT, `SortName` varchar(50) DEFAULT NULL, PRIMARY KEY (`SortID`), UNIQUE KEY `SortID` (`SortID`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for users -- ---------------------------- CREATE TABLE `users` ( `UserID` bigint(20) NOT NULL AUTO_INCREMENT, `UserName` varchar(50) DEFAULT NULL, `UserPassword` varchar(50) DEFAULT NULL, `RealName` varchar(30) DEFAULT NULL, `Telephone` varchar(20) DEFAULT NULL, `Email` varchar(30) DEFAULT NULL, `CreateTime` datetime DEFAULT '0000-00-00 00:00:00', `Role` char(1) DEFAULT '0', PRIMARY KEY (`UserID`), UNIQUE KEY `UserID` (`UserID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for wares -- ---------------------------- CREATE TABLE `wares` ( `WareID` bigint(20) NOT NULL AUTO_INCREMENT, `WareName` varchar(100) DEFAULT NULL, `Company` varchar(100) DEFAULT NULL, `Addr` varchar(50) DEFAULT NULL, `Price` float(20,3) DEFAULT NULL, `PicUrl` varchar(30) DEFAULT NULL, `SortID` bigint(20) NOT NULL DEFAULT '0', `Intro` text, `CreateTime` datetime DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`WareID`), UNIQUE KEY `WareID` (`WareID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk; -- ---------------------------- -- Table structure for words -- ---------------------------- CREATE TABLE `words` ( `WordsID` bigint(20) NOT NULL AUTO_INCREMENT, `Content` text, `UserID` bigint(20) NOT NULL DEFAULT '0', `CreateTime` datetime DEFAULT '0000-00-00 00:00:00', `WareID` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`WordsID`), UNIQUE KEY `WordsID` (`WordsID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `goods` VALUES ('1', '2', '2', '1', '2009-02-13 11:50:37'); INSERT INTO `sorts` VALUES ('1', '宠物0'); INSERT INTO `sorts` VALUES ('3', '宠物1'); INSERT INTO `sorts` VALUES ('4', '宠物2'); INSERT INTO `sorts` VALUES ('7', '宠物王'); INSERT INTO `users` VALUES ('1', 'admin', 'admin', '管理员', '1654651261564', 'guan.xuecheng.2008@163.com', '2009-02-13 11:46:15', '1');