Javafx模拟微博.zip

/* Navicat Premium Data Transfer Source Server : conn-localhost Source Server Type : MySQL Source Server Version : 80017 Source Host : localhost:3306 Source Schema : simulated_microblog Target Server Type : MySQL Target Server Version : 80017 File Encoding : 65001 Date: 26/06/2022 15:12:28 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for fans -- ---------------------------- DROP TABLE IF EXISTS `fans`; CREATE TABLE `fans` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `follow_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `username`(`username`) USING BTREE, CONSTRAINT `fans_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`user_name`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fans_ibfk_2` FOREIGN KEY (`username`) REFERENCES `users` (`user_name`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of fans -- ---------------------------- INSERT INTO `fans` VALUES (30, '毛毛', 4); INSERT INTO `fans` VALUES (31, '毛毛', 5); INSERT INTO `fans` VALUES (34, '李四', 4); INSERT INTO `fans` VALUES (35, '李四', 2); INSERT INTO `fans` VALUES (36, '李四', 9); INSERT INTO `fans` VALUES (37, '某涛', 3); INSERT INTO `fans` VALUES (39, '光头强', 3); INSERT INTO `fans` VALUES (40, '光头强', 2); INSERT INTO `fans` VALUES (41, '光头强', 1); INSERT INTO `fans` VALUES (42, '光头强', 4); INSERT INTO `fans` VALUES (43, '熊大', 7); INSERT INTO `fans` VALUES (44, '熊大', 9); INSERT INTO `fans` VALUES (45, '熊大', 6); INSERT INTO `fans` VALUES (46, '熊大', 1); INSERT INTO `fans` VALUES (47, '熊大', 5); INSERT INTO `fans` VALUES (50, '某聚', 14); INSERT INTO `fans` VALUES (51, '某帆', 14); INSERT INTO `fans` VALUES (54, '毛毛', 15); INSERT INTO `fans` VALUES (57, '某帆', 16); -- ---------------------------- -- Table structure for folws -- ---------------------------- DROP TABLE IF EXISTS `folws`; CREATE TABLE `folws` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `fans_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of folws -- ---------------------------- INSERT INTO `folws` VALUES (12, '毛毛', 4); INSERT INTO `folws` VALUES (13, '毛毛', 5); INSERT INTO `folws` VALUES (16, '李四', 4); INSERT INTO `folws` VALUES (17, '李四', 2); INSERT INTO `folws` VALUES (18, '李四', 9); INSERT INTO `folws` VALUES (19, '某涛', 3); INSERT INTO `folws` VALUES (21, '光头强', 3); INSERT INTO `folws` VALUES (22, '光头强', 2); INSERT INTO `folws` VALUES (23, '光头强', 1); INSERT INTO `folws` VALUES (24, '光头强', 4); INSERT INTO `folws` VALUES (25, '熊大', 7); INSERT INTO `folws` VALUES (26, '熊大', 9); INSERT INTO `folws` VALUES (27, '熊大', 6); INSERT INTO `folws` VALUES (28, '熊大', 1); INSERT INTO `folws` VALUES (29, '熊大', 5); INSERT INTO `folws` VALUES (32, '某聚', 14); INSERT INTO `folws` VALUES (33, '某帆', 14); INSERT INTO `folws` VALUES (36, '毛毛', 15); INSERT INTO `folws` VALUES (39, '某帆', 16); -- ---------------------------- -- Table structure for information -- ---------------------------- DROP TABLE IF EXISTS `information`; CREATE TABLE `information` ( `id` int(11) NOT NULL AUTO_INCREMENT, `age` int(11) NULL DEFAULT NULL, `address` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of information -- ---------------------------- INSERT INTO `information` VALUES (1, 18, '贵州贵阳'); INSERT INTO `information` VALUES (2, 12, '贵州毕节'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `user_pwd` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `user_tel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `information_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_name`(`user_name`) USING BTREE, UNIQUE INDEX `user_tel`(`user_tel`) USING BTREE, UNIQUE INDEX `user_name_2`(`user_name`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, '李四', '111666', '15121626159', 1); INSERT INTO `users` VALUES (2, '熊二', '222222', '525252', 2); INSERT INTO `users` VALUES (3, '熊大', '666666', '10086', NULL); INSERT INTO `users` VALUES (4, '王五', '222222', '18934468976', NULL); INSERT INTO `users` VALUES (6, '赵六', '123456', '11122223333', NULL); INSERT INTO `users` VALUES (7, '毛毛', '999999', '10000', NULL); INSERT INTO `users` VALUES (9, '吉吉', 'jjjjjj', '123123123', NULL); INSERT INTO `users` VALUES (10, '团子', '000000', '000000', NULL); INSERT INTO `users` VALUES (11, '光头强', '111111', '808080', NULL); INSERT INTO `users` VALUES (12, '某涛', '123456', '090909', NULL); INSERT INTO `users` VALUES (13, '某聚', '111', '111', NULL); INSERT INTO `users` VALUES (15, '某帆', '111', '333', NULL); -- ---------------------------- -- Table structure for webs -- ---------------------------- DROP TABLE IF EXISTS `webs`; CREATE TABLE `webs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `webtx` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `date_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `username`(`username`) USING BTREE, CONSTRAINT `webs_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`user_name`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of webs -- ---------------------------- INSERT INTO `webs` VALUES (1, '熊大', '网上熊大', '2022-06-26 12:56:03'); INSERT INTO `webs` VALUES (3, '某聚', '我是某聚，这是测试', '2022-06-26 13:39:46'); INSERT INTO `webs` VALUES (4, '毛毛', '这是毛毛的第二条动态', '2022-06-26 13:46:41'); INSERT INTO `webs` VALUES (5, '某帆', 'cout<<\"某帆大佬第一次发微博\";', '2022-06-26 13:51:02'); INSERT INTO `webs` VALUES (6, '王五', '王五的第一次', '2022-06-26 13:59:06'); SET FOREIGN_KEY_CHECKS = 1;