-- 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
Struts 2+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
评论1
最新资源