-- MySQL dump 10.11
--
-- Host: localhost Database: bookstore
-- ------------------------------------------------------
-- Server version 5.0.67-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bargain`
--
DROP TABLE IF EXISTS `bargain`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `bargain` (
`bargainId` int(11) NOT NULL auto_increment,
`bookId` int(11) NOT NULL,
`bookNewPrice` double(10,2) NOT NULL,
PRIMARY KEY (`bargainId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `bargain`
--
LOCK TABLES `bargain` WRITE;
/*!40000 ALTER TABLE `bargain` DISABLE KEYS */;
INSERT INTO `bargain` VALUES (1,1,10.00),(2,6,12.00),(3,5,11.00);
/*!40000 ALTER TABLE `bargain` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `book`
--
DROP TABLE IF EXISTS `book`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `book` (
`bookId` int(11) NOT NULL auto_increment,
`bookNumber` varchar(21) default NULL,
`bookName` varchar(20) NOT NULL,
`bookAuthor` varchar(20) NOT NULL,
`bookPress` varchar(20) NOT NULL,
`bookPicture` varchar(100) NOT NULL,
`bookAmount` int(11) NOT NULL,
`typeId` int(11) NOT NULL,
`bookShelveTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`bookPrice` double(10,2) NOT NULL,
`bookRemark` varchar(200) default NULL,
`bookSales` int(11) NOT NULL,
PRIMARY KEY (`bookId`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `book`
--
LOCK TABLES `book` WRITE;
/*!40000 ALTER TABLE `book` DISABLE KEYS */;
INSERT INTO `book` VALUES (1,'12345678912345678','红楼梦','曹雪芹','XXX出版社','hlm001.jpg',123,1,'2009-03-25 06:42:22',15.00,'披阅十年,增删五次',2),(5,'12345612345612345','西游记','吴承恩','XXX出版社','xyj001.jpg',32,1,'2009-03-05 07:09:00',12.00,'漫漫取经路',3),(6,'12345612345612345','水浒传','施耐庵','XXX出版社','shz001.jpg',325,1,'2009-03-05 07:16:24',23.00,'替天行道',1),(7,'12345612345612345','三国演义','罗贯中','XXX出版社','sgyy001.jpg',666,1,'2009-03-05 07:24:05',20.00,'天下三分',5),(9,'12345612345612345','红楼梦之史湘云','小起','汇智出版社','hlm003.jpg',65,1,'2009-03-16 07:36:05',30.00,'其实没有这本书',0),(12,'12345612345612345','史记','司马迁','XXX出版社','sj.jpg',123,2,'2009-03-16 07:36:05',23.00,'史家之绝唱,无韵之离骚',0),(13,'TSBH09031709422379373','大秦帝国','孙皓晖','XXX出版社','dqdg.jpg',654,1,'2009-03-17 01:42:23',56.00,'纠纠老秦,共赴国难',0);
/*!40000 ALTER TABLE `book` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `manager`
--
DROP TABLE IF EXISTS `manager`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `manager` (
`managerId` int(11) NOT NULL auto_increment,
`managerName` varchar(16) NOT NULL,
`managerPassword` varchar(12) NOT NULL,
PRIMARY KEY (`managerId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `manager`
--
LOCK TABLES `manager` WRITE;
/*!40000 ALTER TABLE `manager` DISABLE KEYS */;
INSERT INTO `manager` VALUES (1,'admin','admin');
/*!40000 ALTER TABLE `manager` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `orders` (
`ordersId` int(11) NOT NULL auto_increment,
`userId` int(11) NOT NULL,
`ordersTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`isDeal` char(1) NOT NULL,
`ordersNumber` varchar(21) default NULL,
`totalMoney` double(10,2) NOT NULL,
PRIMARY KEY (`ordersId`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (5,1,'2009-03-16 03:01:53','1','DDBH09031310105125045',21.00),(6,1,'2009-03-16 03:01:53','0','DDBH09031316034936676',20.00),(7,1,'2009-03-13 08:04:09','0','DDBH09031316040936406',31.00),(8,1,'2009-03-13 08:04:20','0','DDBH09031316042081836',41.00),(9,1,'2009-03-16 03:01:53','0','DDBH09031316042681842',53.00),(10,1,'2009-03-16 03:01:53','1','DDBH09031316043280000',73.00),(11,1,'2009-03-16 03:01:53','1','DDBH09031316045277898',84.00),(12,1,'2009-03-16 03:01:53','0','DDBH09031316061638196',104.00),(13,1,'2009-03-16 03:01:53','0','DDBH09031316064167108',20.00),(14,1,'2009-03-13 08:06:46','1','DDBH09031316064632612',20.00),(15,1,'2009-03-13 08:06:51','0','DDBH09031316065131785',11.00),(16,1,'2009-03-13 08:06:58','0','DDBH09031316065881351',10.00),(17,1,'2009-03-16 09:19:49','1','DDBH09031617194991827',83.00);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ordersbook`
--
DROP TABLE IF EXISTS `ordersbook`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ordersbook` (
`ordersBookId` int(11) NOT NULL auto_increment,
`ordersId` int(11) NOT NULL,
`bookId` int(11) NOT NULL,
`bookAmount` int(11) NOT NULL,
PRIMARY KEY (`ordersBookId`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `ordersbook`
--
LOCK TABLES `ordersbook` WRITE;
/*!40000 ALTER TABLE `ordersbook` DISABLE KEYS */;
INSERT INTO `ordersbook` VALUES (5,2,12,1),(6,2,7,1),(7,3,7,1),(8,3,5,1),(9,4,1,1),(10,5,5,1),(11,5,1,1),(12,6,7,1),(13,7,5,1),(14,8,1,1),(15,9,6,1),(16,10,7,1),(17,11,5,1),(18,12,7,1),(19,13,7,1),(20,14,7,1),(21,15,5,1),(22,16,1,1),(23,17,1,1),(24,17,5,1),(25,17,7,1),(26,17,6,1),(27,17,9,1);
/*!40000 ALTER TABLE `ordersbook` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `recommended`
--
DROP TABLE IF EXISTS `recommended`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `recommended` (
`recommendedId` int(11) NOT NULL auto_increment,
`bookId` int(11) NOT NULL,
PRIMARY KEY (`recommendedId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `recommended`
--
LOCK TABLES `recommended` WRITE;
/*!40000 ALTER TABLE `recommended` DISABLE KEYS */;
INSERT INTO `recommended` VALUES (1,1),(2,7),(3,5);
/*!40000 ALTER TABLE `recommended` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sex`
--
DROP TABLE IF EXISTS `sex`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sex` (
`sexId` int(11) NOT NULL auto_increment,
`sexType` varchar(4) NOT NULL,
PRIMARY KEY (`sexId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `sex`
--
LOCK TABLES `sex` WRITE;
/*!40000 ALTER TABLE `se
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
Struts2+Hibernate+Spring整合开发技术详解19章网上书店完整源码 (232个子文件)
applicationContext.xml.bak 5KB
struts.xml.bak 4KB
struts.xml.bak 4KB
UpdateBookAction.class 6KB
BookAction.class 5KB
BookManage.class 5KB
OrdersManage.class 4KB
Book.class 4KB
UserManageAction.class 4KB
OrdersManageAction.class 4KB
ShoppingCartAction.class 3KB
OneTypeAction.class 3KB
PersonManage.class 3KB
UpdateCartAction.class 3KB
User.class 3KB
SingleOrdersAction.class 3KB
EnrollAction.class 3KB
LoginAction.class 2KB
OrdersAction.class 2KB
Orders.class 2KB
AllBookAction.class 2KB
AllOrdersAction.class 2KB
OrdersManage$2.class 2KB
DealOrdersAction.class 2KB
ManagerLoginCheck.class 2KB
SingleBookAction.class 2KB
ManagerLoginCheck.class 2KB
Ordersbook.class 1KB
OrdersManage$1.class 1KB
UserInformationAction.class 1KB
UserExitAction.class 1KB
Bargain.class 1KB
Manager.class 1KB
LeftAction.class 1KB
UserLoginCheck.class 1KB
Recommended.class 903B
Type.class 888B
Sex.class 879B
.classpath 7KB
org.eclipse.wst.jsdt.ui.superType.container 49B
styles.css 3KB
style.css 3KB
Thumbs.db 31KB
logo.gif 5KB
body.gif 3KB
bottom.html 574B
error.html 551B
bottom.html 424B
struts2-core-2.0.14.jar 2.22MB
hibernate3.jar 2.15MB
jasperreports-2.0.5.jar 1.87MB
aspectjweaver.jar 1.82MB
jgroups-2.2.8.jar 1.54MB
iText-2.0.7.jar 1.15MB
poi-3.0.1.jar 888KB
freemarker.jar 843KB
freemarker-2.3.8.jar 784KB
jxl.jar 704KB
mysql.jar 687KB
c3p0-0.9.1.2.jar 596KB
c3p0-0.9.1.jar 594KB
jboss-jmx.jar 578KB
jboss-common.jar 570KB
commons-collections.jar 546KB
struts.jar 537KB
jboss-cache.jar 505KB
spring-beans.jar 473KB
proxool-0.8.3.jar 465KB
javassist.jar 460KB
spring-context.jar 458KB
xwork-2.0.7.jar 449KB
antlr-2.7.6.jar 433KB
jboss-archive-browsing.jar 404KB
spring-webmvc.jar 393KB
velocity-1.5.jar 383KB
log4j-1.2.15.jar 383KB
spring-orm.jar 364KB
log4j-1.2.11.jar 342KB
spring-aop.jar 318KB
cglib-nodep-2.1_3.jar 317KB
spring-jdbc.jar 310KB
dom4j-1.6.1.jar 307KB
commons-httpclient.jar 298KB
spring-core.jar 279KB
cglib-2.1.3.jar 276KB
hibernate-annotations.jar 259KB
commons-lang.jar 237KB
spring-tx.jar 222KB
jaxen-1.1-beta-7.jar 222KB
jboss-system.jar 218KB
ehcache-1.2.3.jar 203KB
spring-web.jar 183KB
concurrent-1.3.2.jar 167KB
ognl-2.6.11.jar 164KB
spring-webmvc-portlet.jar 146KB
jotm.jar 121KB
commons-dbcp.jar 119KB
hibernate-entitymanager.jar 114KB
velocity-tools-view-1.4.jar 113KB
aspectjrt.jar 112KB
共 232 条
- 1
- 2
- 3
cloverfan
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
- 6
前往页