-- MySQL dump 10.11
--
-- Host: localhost Database: forum
-- ------------------------------------------------------
-- 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 `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 `post`
--
DROP TABLE IF EXISTS `post`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `post` (
`postId` int(11) NOT NULL auto_increment,
`userId` int(11) NOT NULL,
`topic` varchar(100) NOT NULL,
`matter` varchar(1000) NOT NULL,
`postTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`postId`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `post`
--
LOCK TABLES `post` WRITE;
/*!40000 ALTER TABLE `post` DISABLE KEYS */;
INSERT INTO `post` VALUES (12,1,'不要问我为什么迟到','\r\n不要问我为什么迟到?\r\n\r\n我也不过是茫茫红尘中一粒浮尘而已,这个世界上有很多东西我无法解释!','2009-03-23 07:16:36'),(13,1,'我是一滴远方孤星的泪水','藏在你身上已几万年!所有你的心事都被我发现,让我温暖你的脸!\r\n','2009-03-19 01:45:14'),(14,1,'不要问我,一生曾经恨过多少人',' 你不懂我恨有多深!\r\n哎!这是为什么呢!','2009-03-19 02:24:01'),(15,1,'有过多少往事','仿佛就在昨天!','2009-03-19 02:59:54'),(16,2,'雪花飘','雪花飘,飘起了多少爱恋。雪花飞,飞起了多少情缘。烟花开在雪中间!','2009-03-23 07:36:24'),(17,2,'在那遥远的小山村','在那遥远的小山村,小呀小山村!','2009-03-23 07:35:24'),(18,1,'等了好久终于等到今天','等了好久终于把梦实现,前途茫茫任我闯,幸亏还有你,在身旁!','2009-03-23 07:34:10'),(19,1,'曾经年少爱追梦','一心只想入前飞,行遍千山和万水,一路走来不能回!','2009-03-23 07:33:24'),(20,1,'如果有一天','如果有一天,汽车与飞机再不足够,别害怕,你拥有的,天赋的,一对双脚伴你可漫游!','2009-03-19 09:05:26'),(21,1,'难道','难道,出生当天我已给归类做坏人。难道,爱我会毁了你一生!','2009-03-19 09:06:32'),(22,1,'爱火烧不尽','爱火为你烧呀烧不尽,泪水为你一生流也流不停!','2009-03-23 07:13:57'),(23,1,'爱你等你到最后','虽然我知道你心中从不曾爱过我,对你没有怨尤,能够陪在你的左右,做痴心的朋友,也是一种快乐!','2009-03-19 09:11:34'),(24,1,'给我一点时间','给我一点时间,我可以吃光整个地球!','2009-03-23 07:15:30'),(48,1,'我有一个梦','我有一个梦,梦见我来生,是一个很有钱的人!','2009-03-23 07:15:46'),(50,1,'为什么迟到的总是你',' 今天堵车了,我上车的时候才8:29,还没到8:30上班时间。','2009-03-20 02:16:40'),(51,1,'浪子心声','难分真与假,人面多险诈,几许有共享荣华,檐畔水滴不分差。\r\n无知井里蛙,徒望添声价,空得意目光如麻,谁料金屋变败瓦。\r\n命里有时终须有,命里无时莫强求!\r\n雷声风雨打,何用多惊怕,心公正白璧无瑕,行善积德最乐也。\r\n命里有时终须有,命里无时莫强求!\r\n人比海里沙,何用多牵挂,君可见漫天落霞,名利息间似雾化!','2009-03-23 08:04:16'),(52,1,'跟我两辈子','你可否啊,跟我一辈子啊,把那昨天的恩和怨,丢进东江水啊。\r\n你可否啊,跟我一辈子啊,不再夜里空守在孤灯旁呀,跟我去个好地方!','2009-03-23 07:29:53');
/*!40000 ALTER TABLE `post` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user` (
`userId` int(11) NOT NULL auto_increment,
`userName` varchar(16) NOT NULL,
`userPassword` varchar(12) NOT NULL,
`userEmail` varchar(100) NOT NULL,
`userNickname` varchar(20) NOT NULL,
`userBirthday` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`sex` int(11) NOT NULL,
`userPoints` int(11) NOT NULL,
`userRemark` varchar(200) default NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'xiaoqi','xiaoqi0101','xiaoqi@163.com','小起','1985-08-31 16:00:00',1,102,'为什么!'),(2,'xiaoxue','010101','xiaoqi@163.com','小雪','1985-01-23 16:00:00',2,12,'雪花飘'),(3,'asdasd','asdasd','xiaoqi@163.com','asdasd','2008-03-16 16:00:00',1,0,NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2009-04-02 2:01:41
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
Struts 2+Hibernate+Spring整合开发技术详解 6~11章 (559个子文件)
struts.xml.bak 5KB
ExitAction.java.bak 500B
gen.bat 94B
gen.bat 94B
gen.bat 94B
gen.bat 94B
ForumDao.class 6KB
UsersDAO.class 6KB
AccountsDAO.class 5KB
StudentDAO.class 5KB
StudentDAO.class 5KB
AdminDAO.class 5KB
AccountDAO.class 5KB
AlbumDAO.class 5KB
ScoreDAO.class 5KB
ScoreDAO.class 5KB
AlbumDAO.class 5KB
StudentScoreDAO.class 5KB
T9.class 5KB
AdminDAO.class 4KB
T3.class 4KB
T9.class 4KB
T82.class 4KB
UpdateAction.class 3KB
RegisterAction.class 3KB
User.class 3KB
Test.class 3KB
PersonalPostAction.class 3KB
HibernateSessionFactory.class 2KB
OGNLAction.class 2KB
HibernateSessionFactory.class 2KB
HibernateSessionFactory.class 2KB
UpdatePasswordAction.class 2KB
MyUpAction.class 2KB
AllPostAction.class 2KB
CopyOfStudent_97.class 2KB
Users.class 2KB
T73.class 2KB
Student.class 2KB
AddAdminAction.class 2KB
AdminLoginAction.class 2KB
Student.class 2KB
HibernateSessionFactory.class 2KB
DeleteMyPostAction.class 2KB
DeletePostAction.class 2KB
LoginAction.class 2KB
DatabaseDAO.class 2KB
AddPostAction.class 2KB
PersonalManageAction.class 2KB
DatabaseDAO.class 2KB
ManagerLoginAction.class 2KB
Post.class 2KB
EnrollAction.class 2KB
CopyOfAlbum_HashMap.class 2KB
CopyOfAlbum_hashset.class 2KB
CopyOfAlbum_TreeSet.class 2KB
CopyOfAlbum_TreeMap.class 2KB
CopyOfAlbum_list.class 2KB
LoginAction.class 2KB
Album.class 2KB
Album.class 2KB
Admin.class 2KB
SelectInfoAction.class 2KB
CopyOfScore_97.class 1KB
AuthorityInterceptor.class 1KB
Account.class 1KB
T4.class 1KB
Score.class 1KB
Accounts.class 1KB
MemberDAO.class 1KB
T1.class 1KB
Admin.class 1KB
LoginCheck.class 1KB
T10.class 1KB
News.class 1KB
UserInformationAction.class 1KB
DeleteAdminAction.class 1KB
ChooseAction.class 1KB
PostMatterAction.class 1KB
FindAllUsersAction.class 1KB
DeleteUsersAction.class 1KB
Manager.class 1KB
StudentScore.class 1KB
FindAdminAction.class 1KB
loginAction.class 1KB
Score.class 1KB
ExitAction.class 1KB
ManagerLoginCheck.class 1KB
ExceptionAction.class 1004B
ExitAction.class 963B
MyDownload.class 950B
FindNewUsersAction.class 879B
Member.class 869B
FindAllAdminAction.class 868B
T2.class 705B
ReverseAll.class 668B
ReverseAll.class 668B
T8.class 513B
BaseHibernateDAO.class 480B
BaseHibernateDAO.class 460B
共 559 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
- 纯净水_abc2014-04-02很好,很实用。。。
- soul_s2014-10-10第九章真是配置文件错的一塌糊涂哎。。。。必须重新按书上敲
- jieqixun2018-08-28谢谢分享,还可以
你就是猴子
- 粉丝: 3
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功