基于jsp的電子商城論文-展示頁
2025-07-05 21:49本頁面
【正文】 LL AUTO_INCREMENT, `Member` int(4) NOT NULL, `Cart` int(4) NOT NULL, `OrderNO` char(20) DEFAULT NULL, `OrderDate` datetime DEFAULT NULL, `OrderStatus` int(4) DEFAULT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312。CREATE TABLE `merchandise` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `Category` int(4) NOT NULL, `MerName` char(40) DEFAULT NULL, `Price` decimal(8,2) DEFAULT NULL, `SPrice` decimal(8,2) DEFAULT NULL, `MerModel` char(40) DEFAULT NULL, `Picture` varchar(100) DEFAULT NULL, `MerDesc` text, `Manufacturer` char(60) DEFAULT NULL, `LeaveFactoryDate` datetime DEFAULT NULL, `Special` int(4) DEFAULT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312。CREATE TABLE `memberlevel` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `LevelName` char(20) DEFAULT NULL, `Favourable` int(4) DEFAULT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312。CREATE TABLE `member` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `Memberlevel` int(4) NOT NULL, `LoginName` char(12) DEFAULT NULL, `LoginPwd` char(12) DEFAULT NULL, `MemberName` char(20) DEFAULT NULL, `Phone` char(15) DEFAULT NULL, `Address` varchar(100) DEFAULT NULL, `Zip` char(10) DEFAULT NULL, `RegDate` datetime DEFAULT NULL, `LastDate` datetime DEFAULT NULL, `LoginTimes` int(4) DEFAULT NULL, `EMail` varchar(100) DEFAULT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312。CREATE TABLE `leaveword` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `Member` int(4) NOT NULL, `Admin` int(4) DEFAULT NULL, `Title` char(60) DEFAULT NULL, `Content` text, `LeaveDate` datetime DEFAULT NULL, `AnswerContent` text, `AnswerDate` datetime DEFAULT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312。CREATE TABLE `category` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `CateName` char(40) DEFAULT NULL, `CateDesc` text, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312。, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=gb2312。, `Money` decimal(9,2) NOT NULL DEFAULT 39。, `Price` decimal(8,2) NOT NULL DEFAULT 39。CREATE TABLE `cartselectedmer` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `Cart` int(4) NOT NULL, `Merchandise` int(4) NOT NULL, `Number` int(4) NOT NULL DEFAULT 39。CREATE TABLE `cart` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `Member` int(4) NOT NULL, `Money` decimal(9,2) DEFAULT NULL, `CartStatus` int(4) DEFAULT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312。CREATE TABLE `admin` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `AdminType` int(4) DEFAULT NULL, `AdminName` char(12) DEFAUL
試題試卷相關推薦
鄂ICP備17016276號-1