/*
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');
数据库课程设计大作业--网上商城（jsp）
5星 · 超过95%的资源 需积分: 20 70 浏览量
2017-06-22
14:51:59
上传
评论 2
收藏 2.83MB RAR 举报 
数据库课程设计大作业--网上商城（jsp）.rar （73个子文件） 
网上商城（jsp） petshop 
modify_password_save.jsp 2KB search_ware_result.jsp 3KB
user_reg_form.html 2KB WEB-INF web.xml 179B lib 
pop3.jar 20KB mailapi.jar 174KB activation.jar 54KB mail.jar 339KB mysql-connector-java-3.1.11-bin.jar 430KB smtp.jar 23KB serializer.jar 272KB xercesSamples.jar 162KB xml-apis.jar 190KB jspSmartUpload.jar 15KB xercesImpl.jar 1.17MB jdom.jar 150KB resolver.jar 82KB classes Goods.java 3KB Sort.java 2KB SplitPage.java 1KB Ware.java 5KB pet petshop SplitPage.class 2KB User.class 5KB ExecuteDB.class 1KB ConnectDB.class 1KB Goods.class 3KB Ware.class 5KB Sort.class 2KB Words.class 2KB ConnectDB.java 741B User.java 6KB ExecuteDB.java 1021B Words.java 3KB modify_info_save.jsp 1KB index.jsp 3KB manager add_ware_save.jsp 3KB add_sort_form.jsp 638B sort_management.jsp 2KB add_sort_save.jsp 1KB user_detail.jsp 2KB add_ware_form.jsp 2KB goods_management.jsp 4KB top.jsp 1KB modify_sort_form.jsp 978B main.jsp 616B modify_ware_save.jsp 3KB delete_goods.jsp 1KB modify_ware_form.jsp 3KB delete_ware.jsp 1KB delete_sort.jsp 1KB ware_management.jsp 4KB modify_sort_save.jsp 1KB
petshop.txt 3KB goods_management.jsp 3KB add_goods_save.jsp 1KB image.jsp 1KB ware_detail.jsp 5KB ware_list.jsp 4KB top.jsp 1KB get_password_do.jsp 3KB get_password_form.html 470B pic 
00000000000000.gif 1KB Thumbs.db 42KB main.jsp 615B counter.xml 117B info_management.jsp 3KB delete_goods.jsp 1KB search_ware_form.jsp 2KB user_reg_save.jsp 2KB logout.jsp 181B add_goods_form.jsp 2KB lib ware.css 446B user_login.jsp 1KB资源评论
qq_392833272017-06-23好用好用好用
