j2ee+SQL网上书店

-- 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