-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- 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 */;
/*!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' */;
--
-- Create schema db_database16
--
CREATE DATABASE IF NOT EXISTS db_database16;
USE db_database16;
--
-- Definition of table `tb_bbsinfo`
--
DROP TABLE IF EXISTS `tb_bbsinfo`;
CREATE TABLE `tb_bbsinfo` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '自动编号',
`title` varchar(50) character set utf8 NOT NULL COMMENT '标题',
`content` varchar(200) character set utf8 NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_bbsinfo`
--
/*!40000 ALTER TABLE `tb_bbsinfo` DISABLE KEYS */;
INSERT INTO `tb_bbsinfo` (`id`,`title`,`content`) VALUES
(1,'明日科技编程即将面市！','明日科技编程词典即将面市！'),
(2,'今明两天气温有所回升！','今明两天气温有所回升！'),
(3,'关于元旦放假的通知！','关于元旦放假的通知！');
/*!40000 ALTER TABLE `tb_bbsinfo` ENABLE KEYS */;
--
-- Definition of table `tb_book`
--
DROP TABLE IF EXISTS `tb_book`;
CREATE TABLE `tb_book` (
`id` int(11) NOT NULL auto_increment,
`bookName` varchar(50) NOT NULL,
`price` double NOT NULL,
`bookCount` int(11) default NULL,
`category` varchar(255) default NULL,
`description` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_book`
--
/*!40000 ALTER TABLE `tb_book` DISABLE KEYS */;
INSERT INTO `tb_book` (`id`,`bookName`,`price`,`bookCount`,`category`,`description`) VALUES
(1,'故事大全',10,90,'中小学图书','科幻故事。'),
(2,'作文1000篇',39,100,'中小学图书','中小学图书'),
(3,'散文集选',35,60,'文学图书','中学生散文集选'),
(4,'名师名讲100分',20,40,'中小学图书','小学三年级数学'),
(5,'JavaScript网页特效范例宝典',79,80,'计算机图书','适用于广大计算机爱好者和编程人员使用'),
(6,'Spring应用开发完全手册',59,35,'计算机图书','适合大中专院校师生学习参考');
/*!40000 ALTER TABLE `tb_book` ENABLE KEYS */;
--
-- Definition of table `tb_book_408`
--
DROP TABLE IF EXISTS `tb_book_408`;
CREATE TABLE `tb_book_408` (
`id` int(11) NOT NULL auto_increment,
`bookName` varchar(50) NOT NULL,
`price` double NOT NULL,
`bookCount` int(11) default NULL,
`author` varchar(255) default NULL,
`description` text,
`categoryId` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `FK78A412ED7E87FA75` (`categoryId`),
KEY `FK78A415977E87FA75` (`categoryId`),
CONSTRAINT `FK78A412ED7E87FA75` FOREIGN KEY (`categoryId`) REFERENCES `tb_category_408` (`id`),
CONSTRAINT `FK78A415977E87FA75` FOREIGN KEY (`categoryId`) REFERENCES `tb_category_408` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_book_408`
--
/*!40000 ALTER TABLE `tb_book_408` DISABLE KEYS */;
INSERT INTO `tb_book_408` (`id`,`bookName`,`price`,`bookCount`,`author`,`description`,`categoryId`) VALUES
(1,'JAVA程序设计标准教程',59,10,'明日科技','适用于从初学者。',1),
(2,'JAVA从入门到精通',59.8,20,'明日科技','适用于初学者。',1),
(3,'ASP.NET项目开发全程实录',59,15,'明日科技','ASP.NET项目开发全程实录',3),
(4,'Visual C++开发经验技巧宝典',89,30,'明日科技','本书附有配套光盘。',4),
(5,'Delphi函数参考大全',74,12,'明日科技','本书配套光盘中提供了书中所有实例的源代码',5),
(6,'PHP程序开发范例宝典',89,21,'明日科技','本书附有配套光盘。',6);
/*!40000 ALTER TABLE `tb_book_408` ENABLE KEYS */;
--
-- Definition of table `tb_category_408`
--
DROP TABLE IF EXISTS `tb_category_408`;
CREATE TABLE `tb_category_408` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`createTime` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_category_408`
--
/*!40000 ALTER TABLE `tb_category_408` DISABLE KEYS */;
INSERT INTO `tb_category_408` (`id`,`name`,`createTime`) VALUES
(1,'JAVA','2009-03-09 15:39:19'),
(3,'ASP.NET','2009-03-09 15:42:13'),
(4,'VC','2009-03-09 15:44:18'),
(5,'Delphi','2009-03-09 15:45:23'),
(6,'PHP','2009-03-09 15:46:07');
/*!40000 ALTER TABLE `tb_category_408` ENABLE KEYS */;
--
-- Definition of table `tb_dept`
--
DROP TABLE IF EXISTS `tb_dept`;
CREATE TABLE `tb_dept` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_dept`
--
/*!40000 ALTER TABLE `tb_dept` DISABLE KEYS */;
INSERT INTO `tb_dept` (`id`,`name`) VALUES
(1,'账务部'),
(2,'销售部'),
(3,'设计部'),
(4,'人事部');
/*!40000 ALTER TABLE `tb_dept` ENABLE KEYS */;
--
-- Definition of table `tb_draw`
--
DROP TABLE IF EXISTS `tb_draw`;
CREATE TABLE `tb_draw` (
`id` int(11) NOT NULL auto_increment,
`person` varchar(50) NOT NULL,
`drawTime` datetime default NULL,
`materialId` int(11) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `materialId` (`materialId`),
KEY `FKA4F7AC752A9FE487` (`materialId`),
CONSTRAINT `FKA4F7AC752A9FE487` FOREIGN KEY (`materialId`) REFERENCES `tb_material` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_draw`
--
/*!40000 ALTER TABLE `tb_draw` DISABLE KEYS */;
INSERT INTO `tb_draw` (`id`,`person`,`drawTime`,`materialId`) VALUES
(1,'小李','2009-03-10 14:35:13',1),
(2,'小李','2009-03-10 14:41:47',2),
(3,'小刘','2009-03-09 14:42:15',3);
/*!40000 ALTER TABLE `tb_draw` ENABLE KEYS */;
--
-- Definition of table `tb_employee`
--
DROP TABLE IF EXISTS `tb_employee`;
CREATE TABLE `tb_employee` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`sex` int(11) default NULL,
`birthday` date default NULL,
`idCard` varchar(30) default NULL,
`nation` varchar(10) default NULL,
`schoolage` varchar(20) default NULL,
`salary` double default NULL,
`address` varchar(50) default NULL,
`deptId` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `FK4846655FD5316643` (`deptId`),
CONSTRAINT `FK4846655FD5316643` FOREIGN KEY (`deptId`) REFERENCES `tb_dept` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_employee`
--
/*!40000 ALTER TABLE `tb_employee` DISABLE KEYS */;
INSERT INTO `tb_employee` (`id`,`name`,`sex`,`birthday`,`idCard`,`nation`,`schoolage`,`salary`,`address`,`deptId`) VALUES
(1,'小刘',1,'1984-02-02','123456789XX','汉','大专',1000,'吉林省长春市东盛大街XX号',1),
(2,'小王',1,'1985-02-27','123456789XX','汉','大专',1200,'吉林省长春市东盛大街XX号',2),
(3,'小张',0,'1980-02-24','123456789XX','汉','大专',1500,'吉林省长春市东盛大街XX号',3),
(4,'小李',0,'1982-01-16','123456789XX','汉','本科',2000,'吉林省长春市东盛大街XX号',1),
(5,'小井',0,'1979-02-09','123456789XX','汉','本科',1800,'吉林省长春市东盛大街XX号',1),
(6,'小潘',0,'1982-02-21','123456789XX','汉','本科',3000,'吉林省长春市东盛大街XX号',2),
(7,'小赵',1,'1983-01-29','123456789XX'
D:\books-technology\java\javaweb 1200\java web开发实战1200例 第二卷 源码.7...
4星 · 超过85%的资源 需积分: 16 45 浏览量
2014-09-30
18:09:05
上传
评论 2
收藏 131.74MB 7Z 举报 
D:\books-technology\java\javaweb 1200\java web开发实战1200例 第二卷 源码.7z （26307个子文件） 
DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 9KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB DojoExternalInterface.as 7KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB Storage.as 6KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB ExpressInstall.as 3KB
0.bmp 999KB 1220576675125.bmp 988KB 2.bmp 922KB 1.bmp 916KB 3.bmp 842KB 4.bmp 828KB 4.bmp 828KB 牙刷.bmp 64KB tryListen.bmp 2KB delete.bmp 824B update.bmp 824B UserInfoAction.class 19KB SongAction.class 13KB Email.class 12KB VoteServlet.class 12KB ShopcarServlet.class 12KB PhotoServlet.class 10KB ReceiveEmailDAO.class 10KB MessagesAction.class 9KB DefaultDaoImpl.class 8KB GoodsServlet.class 8KB EmailServlet.class 8KB ArticleAction.class 8KB ReceiveEmailServlet.class 8KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB BothDHClientFile.class 7KB SongDAO.class 7KB共 26307 条
- 1
- 2
- 3
- 4
- 5
- 6
- 264
资源评论
StevenMuKwok2018-02-05好人啊，这真是人间自有真情在，所有需要的资源都有了，谢谢。- Klao_ail2014-11-18好资源,很全
- sijidehaishui2015-06-09压缩包打不开，不知道怎么回事
- Monster4y2015-11-20好资源，多谢分享
