JavaWeb项目开发案例精粹-第4章博客网站系统-001设计

  1 # MySQL-Front 5.0  (Build 1.0)
  2 
  3 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
  4 /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
  5 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
  6 /*!40103 SET SQL_NOTES='ON' */;
  7 
  8 
  9 # Host: localhost    Database: db_blog
 10 # ------------------------------------------------------
 11 # Server version 5.0.67-community-nt
 12 
 13 DROP DATABASE IF EXISTS `db_blog`;
 14 CREATE DATABASE `db_blog` /*!40100 DEFAULT CHARACTER SET gb2312 */;
 15 USE `db_blog`;
 16 
 17 #
 18 # Table structure for table article
 19 #
 20 
 21 CREATE TABLE `article` (
 22   `Id` int(11) NOT NULL auto_increment,
 23   `title` varchar(50) default NULL,
 24   `content` text,
 25   `username` varchar(50) default NULL,
 26   `date` datetime default NULL,
 27   `hasread` int(11) default '0',
 28   PRIMARY KEY  (`Id`),
 29   KEY `username` (`username`)
 30 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312 COMMENT='文章表';
 31 INSERT INTO `article` VALUES (1,'SSH整合方案（一）','<p>这段时间准备写一下SSH的整合方法<img alt="" src="http://localhost:8080/JavaPrj_4/user/fckeditor/editor/images/smiley/qq/017.jpg" /></p>','xiaoxiao','2009-12-27 10:58:50',2);
 32 INSERT INTO `article` VALUES (2,'SSH整合方案（二）','<p>让我们一起感受SSH整合的魅力吧！！！！！</p>','xiaoxiao','2009-12-27 10:59:41',1);
 33 INSERT INTO `article` VALUES (3,'今天好冷啊！','<p>外面下雪了，今年的冬天来得太早了。<img alt="" src="http://localhost:8080/JavaPrj_4/user/fckeditor/editor/images/smiley/qq/005.gif" /></p>','xiaoxiao','2009-12-27 11:00:22',1);
 34 INSERT INTO `article` VALUES (4,'继续更新我的SSH整合方案！','','xiaoxiao','2009-12-27 11:08:43',1);
 35 INSERT INTO `article` VALUES (5,'测试日志！！','<p>测试日志！！<img alt="" src="http://localhost:8080/JavaPrj_4/user/fckeditor/editor/images/smiley/qq/004.gif" /></p>','xiaoxiao','2010-01-27 18:05:06',1);
 36 
 37 #
 38 # Table structure for table bloginfo
 39 #
 40 
 41 CREATE TABLE `bloginfo` (
 42   `username` varchar(20) NOT NULL default '',
 43   `blogtitle` varchar(50) default NULL,
 44   `idiograph` varchar(50) default NULL,
 45   PRIMARY KEY  (`username`)
 46 ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='个性设置表';
 47 INSERT INTO `bloginfo` VALUES ('xiaoxiao','我是小小','我喜欢写博客');
 48 
 49 #
 50 # Table structure for table critique
 51 #
 52 
 53 CREATE TABLE `critique` (
 54   `Id` int(11) NOT NULL auto_increment,
 55   `AId` int(11) default NULL,
 56   `content` text,
 57   `username` varchar(50) default NULL,
 58   PRIMARY KEY  (`Id`),
 59   KEY `AId` (`AId`)
 60 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312 COMMENT='评论表';
 61 INSERT INTO `critique` VALUES (1,3,'<p>是啊，太冷了，我还好！！！</p>','xiaoxiao');
 62 INSERT INTO `critique` VALUES (2,3,'<p>我们公司的暖气坏了，好冷啊！！</p>','xiaoxiao');
 63 INSERT INTO `critique` VALUES (3,2,'<p>测试一下！</p>','xiaoxiao');
 64 INSERT INTO `critique` VALUES (4,5,'<p>评论！！</p>','xiaoxiao');
 65 INSERT INTO `critique` VALUES (5,1,'<p>测试一下！！</p>','xiaoxiao');
 66 INSERT INTO `critique` VALUES (6,5,'<p><a href="http://localhost:8080/JavaPrj_4/">http://localhost:8080/JavaPrj_4/</a></p>','匿名');
 67 
 68 #
 69 # Table structure for table dianjiliang
 70 #
 71 
 72 CREATE TABLE `dianjiliang` (
 73   `Id` int(11) NOT NULL auto_increment,
 74   `AId` int(11) default NULL,
 75   `ip` varchar(255) default NULL,
 76   `time` date default NULL,
 77   PRIMARY KEY  (`Id`),
 78   KEY `AId` (`AId`)
 79 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312 COMMENT='点击量表';
 80 INSERT INTO `dianjiliang` VALUES (1,1,'0:0:0:0:0:0:0:1','2009-12-27');
 81 INSERT INTO `dianjiliang` VALUES (2,3,'0:0:0:0:0:0:0:1','2009-12-27');
 82 INSERT INTO `dianjiliang` VALUES (3,1,'0:0:0:0:0:0:0:1','2010-01-27');
 83 INSERT INTO `dianjiliang` VALUES (4,2,'0:0:0:0:0:0:0:1','2010-01-27');
 84 INSERT INTO `dianjiliang` VALUES (5,5,'0:0:0:0:0:0:0:1','2010-01-27');
 85 INSERT INTO `dianjiliang` VALUES (6,4,'0:0:0:0:0:0:0:1','2010-01-27');
 86 
 87 #
 88 # Table structure for table user
 89 #
 90 
 91 CREATE TABLE `user` (
 92   `username` varchar(20) NOT NULL default '',
 93   `password` varchar(20) default NULL,
 94   `nickname` varchar(20) default NULL,
 95   `question` varchar(50) default NULL,
 96   `answer` varchar(50) default NULL,
 97   PRIMARY KEY  (`username`)
 98 ) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='用户表';
 99 INSERT INTO `user` VALUES ('xiaoxiao','xiaoxiao','厉风行','你的家乡','湖南益阳市');
100 
101 #
102 #  Foreign keys for table article
103 #
104 
105 ALTER TABLE `article`
106 ADD CONSTRAINT `article_ibfk_1` FOREIGN KEY (`username`) REFERENCES `user` (`username`);
107 
108 #
109 #  Foreign keys for table bloginfo
110 #
111 
112 ALTER TABLE `bloginfo`
113 ADD CONSTRAINT `bloginfo_ibfk_1` FOREIGN KEY (`username`) REFERENCES `user` (`username`);
114 
115 #
116 #  Foreign keys for table critique
117 #
118 
119 ALTER TABLE `critique`
120 ADD CONSTRAINT `critique_ibfk_1` FOREIGN KEY (`AId`) REFERENCES `article` (`Id`);
121 
122 #
123 #  Foreign keys for table dianjiliang
124 #
125 
126 ALTER TABLE `dianjiliang`
127 ADD CONSTRAINT `dianjiliang_ibfk_1` FOREIGN KEY (`AId`) REFERENCES `article` (`Id`);
128 
129 
130 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
131 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4.运行效果