jsp互联网应用开发：小型贴吧

/* SQLyog 企业版 - MySQL GUI v8.14 MySQL - 5.7.37 : Database - 数据库1 ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`数据库1` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `数据库1`; /*Table structure for table `follow` */ DROP TABLE IF EXISTS `follow`; CREATE TABLE `follow` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `用户` varchar(255) DEFAULT NULL, `关注` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4; /*Data for the table `follow` */ insert into `follow`(`Id`,`用户`,`关注`) values (2,'630','630'),(3,'630','111'),(4,'630','中文'),(5,'中文测试','709'),(7,'中文测试1','709'); /*Table structure for table `likes` */ DROP TABLE IF EXISTS `likes`; CREATE TABLE `likes` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `topicId` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; /*Data for the table `likes` */ insert into `likes`(`Id`,`username`,`topicId`) values (2,'中文测试1',18),(3,'中文测试1',16); /*Table structure for table `reply` */ DROP TABLE IF EXISTS `reply`; CREATE TABLE `reply` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `主贴Id` int(11) NOT NULL DEFAULT '0', `回帖人` varchar(255) NOT NULL DEFAULT '', `内容` varchar(2550) NOT NULL DEFAULT '', `日期` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8; /*Data for the table `reply` */ insert into `reply`(`Id`,`主贴Id`,`回帖人`,`内容`,`日期`) values (107,16,'709','是否库哈斯更好的精神得灰色空间的供货商卡话可给话就看撒很快就哈萨克赶紧发噶发货的','2022-06-08 10:40:40'),(108,16,'111','大数据国家的是个的尽快哈数控加工和健康和看见撒谎空间','2022-06-08 10:41:26'),(109,18,'111','的说法合法的JDF HAJS JGHJSGAKKask感觉肯定是个就开始健身卡 ','2022-06-08 10:41:51'),(110,17,'111','给安徽的数据库搞活动开始计划空间规划口感较好卡号','2022-06-08 10:42:04'),(111,19,'630','的客观环境宽松的环境是否很快就大概和快捷方式的很快就大概好卡啊','2022-06-08 10:42:34'),(112,16,'630','上的回家干啥空间和大家啥很感慨结婚打算空间很快就　','2022-06-08 10:42:44'),(113,20,'630','十分谨慎的开工建设的口感较好尽快就','2022-06-08 10:43:30'),(114,20,'中文','沙克哈岁的矿工很少看见航空高技术考试机会就卡上尽快哈看见哈萨克很快就','2022-06-08 10:43:47'),(115,19,'中文','考多少分HSKJGH反抗精神的很快就很快旮角很快就很快就发给和快捷方式','2022-06-08 10:44:01'),(116,18,'中文','更何况是肌肉瘫痪既然他就会日哦计划深刻即可s','2022-06-08 10:44:12'),(117,23,'630','1','2022-06-09 17:28:09'),(118,21,'中文测试','111111','2022-06-09 17:50:06'),(119,24,'中文测试','10010','2022-06-09 17:50:21'),(120,22,'中文测试','666','2022-06-09 17:53:56'),(121,25,'中文测试1','666','2022-06-10 10:51:51'),(122,26,'中文测试1','1','2022-06-10 10:52:03'); /*Table structure for table `topic` */ DROP TABLE IF EXISTS `topic`; CREATE TABLE `topic` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `用户名` varchar(255) NOT NULL DEFAULT '', `标题` varchar(255) NOT NULL DEFAULT '', `内容` varchar(2550) NOT NULL DEFAULT '', `发帖日期` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `回复数` int(11) DEFAULT '0', `点赞数` int(11) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; /*Data for the table `topic` */ insert into `topic`(`Id`,`用户名`,`标题`,`内容`,`发帖日期`,`回复数`,`点赞数`) values (16,'709','123','萨非交付撒酒疯按规范咖啡嘎嘎课件撒飞机嘎斯看过卡','2022-06-08 10:40:27',3,1),(17,'709','456','师弟刚是个十分腌三个897 9安社 多杀个啊','2022-06-08 10:40:55',1,0),(18,'709',' 过热哥',' 二GDSGSA G FA FAF A阿桑的歌是的爱国更改','2022-06-08 10:41:09',2,1),(19,'111','的风格s',' 反倒是发巅峰赛发的和发粉红色是和啊','2022-06-08 10:41:38',2,0),(20,'630','S发D','的撒给啊广泛的和发的就和计划开工','2022-06-08 10:42:20',2,0),(21,'中文','很久很久','就很久很久以前　是的开发建设的开国将军速度过快就阿里嘎多就立刻积分管理会计管理卡价格','2022-06-08 10:44:24',1,0),(22,'111','测试1','333','2022-06-09 16:57:03',1,0),(23,'630','测试2','6666','2022-06-09 16:57:28',1,0),(24,'630','6300000','4564654561324897789','2022-06-09 17:27:04',1,0),(25,'中文测试','sfsa','安抚让然而 阿尔','2022-06-09 17:49:56',1,0),(26,'中文测试1','安社','123456789','2022-06-10 10:51:38',1,0),(27,'中文测试1','和任何谈话任何','今天就一天','2022-06-10 10:54:12',0,0); /*Table structure for table `user` */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `sex` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, UNIQUE KEY `username` (`username`), UNIQUE KEY `username_2` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*Data for the table `user` */ insert into `user`(`username`,`password`,`sex`,`email`) values ('1','111111','男','1@.1'),('111','1','男','1@.1'),('11111','1','男','11@qq.com'),('123','1','男','11@qq.com'),('630','1','男','1@.1'),('709','1','男','709@qq.com'),('中文','121212','男','1213213@qq.com'),('中文1','11','女','1@.1'),('中文测试','1','男','chin@qq.com'),('中文测试1','1','男','1@.1'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;