使用python书写一个新闻管理系统

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50744 (5.7.44-log) Source Host : 43.139.61.142:3306 Source Schema : mydemo Target Server Type : MySQL Target Server Version : 50744 (5.7.44-log) File Encoding : 65001 Date: 20/08/2024 14:54:11 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_news -- ---------------------------- DROP TABLE IF EXISTS `t_news`; CREATE TABLE `t_news` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `editor_id` int(10) UNSIGNED NOT NULL, `type_id` int(10) UNSIGNED NOT NULL, `content_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `is_top` tinyint(3) UNSIGNED NOT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `statu` enum('草稿','待审批','已审批','隐藏') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `editor_id`(`editor_id`) USING BTREE, INDEX `type_id`(`type_id`) USING BTREE, INDEX `is_top`(`is_top`) USING BTREE, INDEX `create_time`(`create_time`) USING BTREE, INDEX `statu`(`statu`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_news -- ---------------------------- INSERT INTO `t_news` VALUES (2, 'Miss.', 2, 1, 'LYL3qUbdHy', 106, '2005-08-04 20:30:56', '2021-07-17 00:59:25', '待审批'); INSERT INTO `t_news` VALUES (3, 'Mr.', 2, 1, 'VSCgbmstew', 176, '2022-09-13 04:16:03', '2014-04-29 21:33:01', '已审批'); INSERT INTO `t_news` VALUES (4, 'Mrs.', 2, 1, '6wCNWQbZbT', 80, '2000-01-19 03:40:27', '2006-04-04 19:41:35', '待审批'); INSERT INTO `t_news` VALUES (5, 'Ms.', 2, 1, '20vqcH194h', 148, '2007-11-05 01:07:37', '2018-05-26 19:23:08', '待审批'); INSERT INTO `t_news` VALUES (6, 'Mrs.', 2, 1, 'jw6Fwq1ZvH', 173, '2010-11-20 03:08:22', '2002-11-23 09:12:15', '待审批'); INSERT INTO `t_news` VALUES (7, 'Mr.', 2, 1, 'ocEkTN2JcU', 97, '2001-11-30 01:19:05', '2013-08-24 23:25:29', '已审批'); INSERT INTO `t_news` VALUES (8, 'Ms.', 2, 1, 'LdV4Kh33Oq', 94, '2010-10-05 22:57:09', '2002-01-23 19:09:39', '待审批'); INSERT INTO `t_news` VALUES (9, 'Prof.', 2, 1, 'm61JI8Jgaz', 108, '2010-05-18 01:40:04', '2014-05-16 23:33:47', '待审批'); INSERT INTO `t_news` VALUES (11, 'Mr.', 2, 2, 'NmWSc73cIB', 52, '2007-02-20 02:48:00', '2009-07-17 03:28:03', '已审批'); INSERT INTO `t_news` VALUES (12, 'Mr.', 2, 2, 'CWpYWTMy1O', 64, '2010-11-07 16:57:41', '2016-05-28 06:48:55', '已审批'); INSERT INTO `t_news` VALUES (13, 'Prof.', 2, 2, 'C8ofmEC6xk', 211, '2001-10-09 02:31:08', '2017-07-31 05:01:49', '待审批'); INSERT INTO `t_news` VALUES (14, 'Miss.', 2, 2, 'QEfYxL42X9', 142, '2019-09-18 18:49:31', '2008-10-19 07:16:22', '已审批'); INSERT INTO `t_news` VALUES (15, 'Mr.', 2, 2, 'Suz0IBBHPi', 222, '2019-12-26 04:43:16', '2022-11-30 20:20:29', '待审批'); INSERT INTO `t_news` VALUES (16, 'Mrs.', 2, 2, 'vLf6OpMh6G', 1, '2006-01-31 00:56:48', '2022-04-24 07:34:54', '已审批'); INSERT INTO `t_news` VALUES (17, 'Mr.', 2, 2, 'TvA4O1Lz8z', 234, '2011-09-01 22:45:00', '2006-01-28 12:44:09', '待审批'); INSERT INTO `t_news` VALUES (18, 'Mrs.', 2, 2, 'UbsRFojiCa', 198, '2002-07-21 16:00:29', '2023-08-20 17:48:32', '待审批'); INSERT INTO `t_news` VALUES (19, 'Ms.', 2, 2, 'GJmYxyZVkW', 24, '2006-04-20 11:27:04', '2007-08-08 03:36:10', '待审批'); INSERT INTO `t_news` VALUES (20, 'Prof.', 2, 3, 'WPP3jldoQY', 102, '2007-03-19 13:02:18', '2011-04-09 05:14:25', '已审批'); INSERT INTO `t_news` VALUES (21, 'Ms.', 2, 3, 'OXXjweNK37', 137, '2014-07-03 13:39:15', '2024-06-29 16:11:04', '待审批'); INSERT INTO `t_news` VALUES (22, 'Mr.', 2, 3, 'yLJmWCiNCg', 97, '2005-05-20 18:41:19', '2006-04-30 01:27:44', '待审批'); INSERT INTO `t_news` VALUES (23, 'Prof.', 2, 3, 'z3sDO9GOkN', 21, '2012-12-03 01:07:38', '2017-02-04 18:04:05', '已审批'); INSERT INTO `t_news` VALUES (24, 'Mr.', 2, 3, 'ZXQC3fPWMz', 94, '2016-08-23 17:38:37', '2019-12-29 03:27:46', '待审批'); INSERT INTO `t_news` VALUES (25, 'Mr.', 4, 3, '5N8SISm40r', 177, '2022-09-29 06:27:00', '2002-08-10 20:36:27', '待审批'); INSERT INTO `t_news` VALUES (26, 'Prof.', 4, 3, 'WxJ44jcej7', 35, '2021-12-02 07:06:21', '2006-04-26 18:57:28', '待审批'); INSERT INTO `t_news` VALUES (27, 'Mrs.', 4, 3, 'nuiGmsGvyv', 188, '2009-08-26 06:09:47', '2006-03-14 16:10:33', '待审批'); INSERT INTO `t_news` VALUES (28, 'Ms.', 4, 3, 'IAxrM3yMMr', 55, '2012-03-26 03:10:42', '2020-08-28 03:06:56', '待审批'); INSERT INTO `t_news` VALUES (29, 'Prof.', 4, 3, '3TYt9keEQF', 19, '2002-12-14 09:40:07', '2005-06-14 05:38:05', '待审批'); INSERT INTO `t_news` VALUES (30, 'Ms.', 4, 4, '4CjTrMHWkd', 116, '2008-11-14 22:47:36', '2020-11-15 07:16:04', '已审批'); INSERT INTO `t_news` VALUES (31, 'Mrs.', 4, 4, 'qx5RfhgDgX', 58, '2009-02-24 18:49:38', '2013-06-29 23:29:02', '待审批'); INSERT INTO `t_news` VALUES (32, 'Mrs.', 4, 4, '8YHUGxIXM0', 126, '2001-02-19 00:28:52', '2013-11-01 01:58:18', '待审批'); INSERT INTO `t_news` VALUES (33, 'Ms.', 4, 4, 'EqWuMLotgV', 128, '2003-11-22 14:59:37', '2000-03-29 00:09:34', '待审批'); INSERT INTO `t_news` VALUES (34, 'Miss.', 4, 4, 'F8whXUTZ1L', 245, '2004-03-27 12:59:32', '2013-10-11 06:15:55', '已审批'); INSERT INTO `t_news` VALUES (35, 'Mr.', 4, 4, '1VFMA8m4s8', 223, '2015-04-19 16:19:24', '2002-02-12 21:46:40', '待审批'); INSERT INTO `t_news` VALUES (36, 'Prof.', 4, 4, '4d2c07pjk2', 103, '2018-04-05 08:18:06', '2007-06-25 10:15:43', '已审批'); INSERT INTO `t_news` VALUES (37, 'Mr.', 4, 4, 'Bnt1z1eCXg', 165, '2005-04-28 01:43:19', '2018-04-25 03:29:16', '待审批'); INSERT INTO `t_news` VALUES (38, 'Mr.', 4, 4, 'z1rAIeFSoQ', 226, '2001-07-23 09:44:13', '2019-03-05 12:30:05', '已审批'); INSERT INTO `t_news` VALUES (39, 'Mrs.', 4, 4, 'uhlM5HQvtB', 204, '2023-11-05 19:44:12', '2021-08-31 01:30:47', '待审批'); INSERT INTO `t_news` VALUES (40, 'Ms.', 4, 5, 'n8Ju15aaIp', 17, '2003-02-03 22:51:08', '2019-09-19 15:44:46', '已审批'); INSERT INTO `t_news` VALUES (41, 'Mr.', 4, 5, 'X8UxuTaYem', 70, '2022-01-23 18:02:59', '2003-10-26 10:44:57', '已审批'); INSERT INTO `t_news` VALUES (42, 'Mr.', 4, 5, 'LuRuSDjyZN', 198, '2014-05-15 01:03:16', '2007-09-25 16:31:38', '待审批'); INSERT INTO `t_news` VALUES (43, 'Ms.', 4, 5, 'WAyutocidb', 187, '2004-08-01 12:52:22', '2015-03-13 22:43:01', '待审批'); INSERT INTO `t_news` VALUES (44, 'Prof.', 4, 5, 'Dwjw6ilBbD', 167, '2012-05-04 19:19:04', '2016-07-25 00:08:10', '已审批'); INSERT INTO `t_news` VALUES (45, 'Miss.', 4, 5, 'xigKHOqefs', 163, '2011-12-25 09:31:45', '2005-09-13 03:15:33', '待审批'); INSERT INTO `t_news` VALUES (46, 'Prof.', 4, 5, 'SXCmZGRggj', 139, '2018-10-01 07:11:07', '2017-11-07 14:31:04', '待审批'); INSERT INTO `t_news` VALUES (47, 'Miss.', 4, 5, '8vqdSriXBQ', 204, '2006-07-15 03:21:21', '2020-07-15 21:44:27', '待审批'); INSERT INTO `t_news` VALUES (48, 'Ms.', 4, 5, 'ekGvqtBfCw', 66, '2001-09-04 06:48:50', '2007-08-22 07:51:52', '待审批'); INSERT INTO `t_news` VALUES (49, 'Miss.', 4, 5, 'VkdaYL1wyo', 224, '2010-09-01 02:02:18', '2011-03-03 04:01:16', '已审批'); INSERT INTO `t_news` VALUES (50, 'Mrs.', 4, 5, 'FbT72oV9YF', 96, '2016-12-14 00:36:15', '2003-05-13 15:43:17', '待审批'); SET FOREIGN_KEY_CHECKS = 1;