本文介绍了利用Python编程实现基于RSA算法的数字签名系统，结合MySQL数据库进行数据存储，探讨了数字签名的原理和应用，包括登录模块、签名添加、验证及修改功能。同时，提到了Python语言的易用性和MySQL数据库的特性，强调了在信息安全中的重要性。
博主介绍：擅长Java、微信小程序、Python、Android等，专注于Java技术领域和毕业项目实战✌
🍅文末获取源码联系🍅
👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
目录
一、效果演示
二、前言介绍
此次就是利用RSA算法来进行信息数字签名的内容设计，通对于数字签名的内容讨论，来更好的掌握这项技术，通过对该技术的掌握来达到对密码学、安全知识的掌握能力，能够更好的实现对信息的保护和安全管理的内容学习，并且通过结合python技术来实现数字签名软件的设计，来提升整体对于系统搭建、数字签名的快速加密的内容研究，实现对国家信息安全推广的促进和帮助作用。
三、主要技术
3.1、Python语言
Python技术的发展历史相对比较短，是近代来出现的一种高级的编程语言，其最初的出现更多的是在数据的处理上进行运用的，但是后来在该技术不断地更新发展后，发现该技术对于系统的搭建也是非常适用的，并且基于该技术语言简单、可视化的操作，可以更好的适用于一些软件的开发、爬虫技术的运用等等。该语言技术又被称之为胶水语言，是因为该技术能够与C语言、C++语言等开发出的系统进行粘合使用，并且能够实现无缝对接，python的创始人在开发这款语言技术时，提倡将该语言作为一种类似于人类正常交流的语言去进行使用，而不是像C语言、java语言等这样过于专业化的计算机术语来进行编程开发，因此该技术的适用面很广，现在很多的大学都在利用python为底层基础进行课程教学，很多低龄儿童在接触编程时也都会选择python技术进行学习，这充分的证明了该语言的可用性强，容易理解。
3.2、MySQL数据库
MySQL数据库是一款可以面向对象的工具，能够实现面向对象的开发工作。该数据库有着免费的版本提供，并且安装体积轻便，但却蕴藏着丰富的使用功能。该数据库可以实现一对多、多对多的用户数据传输和存储的功能，并且可以实现多线程的数据处理，在数据的处理过程中可以通过多线程的传输设计提升整体的信息传输效果，该数据库还支持跨平台使用，具备了很好的可扩展性和兼容性。
3.3、RSA的数字签名算法
目前为止，科学家们通过科学研究已经将1024位的RSA算法进行了破解，选择RSA公钥密码算法进行数字签名的加密管理，则不得不采用更高位数的算法进行设计。而更高位数的算法则对素因子的需求比较大，现在的一般算法，都会选择在100位左右的素因子，而如此之大的模幂乘运算，会造成算法效率的下降，但是为了保证该算法的安全，却不得不采取这样的方式来对重要的信息内容进行数字签名的操作。
四、系统技术设计
4.1、公钥密码体制
五、功能截图
5.1、登录模块的实现
在登录模块的设计上，基于python的友好操作和开发，本次在登录的界面上设计了动态内容的显示，在蓝绿色的登录页面中背景选择了动态的雪花飘动，整体的背景显示流畅，通过色差的对比，提升了登录框的明亮度，可以在登录框中输入管理员的登录信息完成登录。具体的登录界面如下图所示：
图5.1用户登录界面
5.2、数字签名的实现
此次在数字签名的模块中设计了数字签名的添加功能，并且有已经生成数字签名的信息列表的内容显示。界面如下图所示
图5.2数字签名界面
当点击新增数字签名是会出现如下的显示内容：
图5.3数字签名添加界面
当输入完“我爱学习”的内容之后，点击确定就可以看到该信息添加完毕了，还需要一步的操作就是进行验证签名，通过对点击验证签名可以实现签名的验证工作，如下图所示：
图5.4数字签名验证界面
5.3、RSA数字签名的修改
上述已经完成签名验证的信息，点击修改，将原有“我爱学习”的内容修改为“我爱学习11”点击确认完成内容的修改，如下图所示：
图5.5信息修改界面
修改完毕后，再点击验证签名，可以得到系统反馈的信息为签名无效，如下图所示：
图5.6签名无效界面
这里功能太多，就不一一展示了
六、SQL参考
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 80023
Source Host : localhost:3306
Source Schema : shuziqianming
Target Server Type : MySQL
Target Server Version : 80023
File Encoding : 65001
Date: 17/09/2021 17:37:37
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`name` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`group_id` int(0) NOT NULL,
`permission_id` int(0) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_group_permissions_group_id_permission_id_0cd325b0_uniq`(`group_id`, `permission_id`) USING BTREE,
INDEX `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm`(`permission_id`) USING BTREE,
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`content_type_id` int(0) NOT NULL,
`codename` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_permission_content_type_id_codename_01ab375a_uniq`(`content_type_id`, `codename`) USING BTREE,
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of auth_permission
-- ----------------------------
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` VALUES (13, 'Can add user', 4, 'add_user');
INSERT INTO `auth_permission` VALUES (14, 'Can change user', 4, 'change_user');
INSERT INTO `auth_permission` VALUES (15, 'Can delete user', 4, 'delete_user');
INSERT INTO `auth_permission` VALUES (16, 'Can view user', 4, 'view_user');
INSERT INTO `auth_permission` VALUES (17, 'Can add content type', 5, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (18, 'Can change content type', 5, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (20, 'Can view content type', 5, 'view_contenttype');
INSERT INTO `auth_permission` VALUES (21, 'Can add session', 6, 'add_session');
INSERT INTO `auth_permission` VALUES (22, 'Can change session', 6, 'change_session');
INSERT INTO `auth_permission` VALUES (23, 'Can delete session', 6, 'delete_session');
INSERT INTO `auth_permission` VALUES (24, 'Can view session', 6, 'view_session');
INSERT INTO `auth_permission` VALUES (25, 'Can add user table', 7, 'add_usertable');
INSERT INTO `auth_permission` VALUES (26, 'Can change user table', 7, 'change_usertable');
INSERT INTO `auth_permission` VALUES (27, 'Can delete user table', 7, 'delete_usertable');
INSERT INTO `auth_permission` VALUES (28, 'Can view user table', 7, 'view_usertable');
INSERT INTO `auth_permission` VALUES (29, 'Can add message', 8, 'add_message');
INSERT INTO `auth_permission` VALUES (30, 'Can change message', 8, 'change_message');
INSERT INTO `auth_permission` VALUES (31, 'Can delete message', 8, 'delete_message');
INSERT INTO `auth_permission` VALUES (32, 'Can view message', 8, 'view_message');
-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`password` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`last_login` datetime(6) NULL DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`first_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`last_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`email` varchar(254) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`user_id` int(0) NOT NULL,
`group_id` int(0) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_user_groups_user_id_group_id_94350c0c_uniq`(`user_id`, `group_id`) USING BTREE,
INDEX `auth_user_groups_group_id_97559544_fk_auth_group_id`(`group_id`) USING BTREE,
CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`user_id` int(0) NOT NULL,
`permission_id` int(0) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq`(`user_id`, `permission_id`) USING BTREE,
INDEX `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm`(`permission_id`) USING BTREE,
CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`action_time` datetime(6) NULL,
`object_id` longtext CHARACTER SET utf8 COLLATE utf8_bin NULL,
`object_repr` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`action_flag` smallint unsigned NOT NULL,
`change_message` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`content_type_id` int(0) NULL DEFAULT NULL,
`user_id` int(0) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `django_admin_log_content_type_id_c4bce8eb_fk_django_co`(`content_type_id`) USING BTREE,
INDEX `django_admin_log_user_id_c564eba6_fk_auth_user_id`(`user_id`) USING BTREE,
CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`app_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`model` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `django_content_type_app_label_model_76bd3d3b_uniq`(`app_label`, `model`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of django_content_type
-- ----------------------------
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` VALUES (4, 'auth', 'user');
INSERT INTO `django_content_type` VALUES (8, 'common', 'message');
INSERT INTO `django_content_type` VALUES (5, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` VALUES (6, 'sessions', 'session');
INSERT INTO `django_content_type` VALUES (7, 'user', 'usertable');
-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`app` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`applied` datetime(6) NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of django_migrations
-- ----------------------------
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2021-09-16 03:43:38.565965');
INSERT INTO `django_migrations` VALUES (2, 'auth', '0001_initial', '2021-09-16 03:43:42.084982');
INSERT INTO `django_migrations` VALUES (3, 'admin', '0001_initial', '2021-09-16 03:43:52.337375');
INSERT INTO `django_migrations` VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2021-09-16 03:43:54.881915');
INSERT INTO `django_migrations` VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2021-09-16 03:43:54.939941');
INSERT INTO `django_migrations` VALUES (6, 'contenttypes', '0002_remove_content_type_name', '2021-09-16 03:43:57.161895');
INSERT INTO `django_migrations` VALUES (7, 'auth', '0002_alter_permission_name_max_length', '2021-09-16 03:43:58.171662');
INSERT INTO `django_migrations` VALUES (8, 'auth', '0003_alter_user_email_max_length', '2021-09-16 03:43:59.882041');
INSERT INTO `django_migrations` VALUES (9, 'auth', '0004_alter_user_username_opts', '2021-09-16 03:43:59.931876');
INSERT INTO `django_migrations` VALUES (10, 'auth', '0005_alter_user_last_login_null', '2021-09-16 03:44:01.628250');
INSERT INTO `django_migrations` VALUES (11, 'auth', '0006_require_contenttypes_0002', '2021-09-16 03:44:01.709042');
INSERT INTO `django_migrations` VALUES (12, 'auth', '0007_alter_validators_add_error_messages', '2021-09-16 03:44:01.787492');
INSERT INTO `django_migrations` VALUES (13, 'auth', '0008_alter_user_username_max_length', '2021-09-16 03:44:03.927155');
INSERT INTO `django_migrations` VALUES (14, 'auth', '0009_alter_user_last_name_max_length', '2021-09-16 03:44:05.895403');
INSERT INTO `django_migrations` VALUES (15, 'auth', '0010_alter_group_name_max_length', '2021-09-16 03:44:07.596250');
INSERT INTO `django_migrations` VALUES (16, 'auth', '0011_update_proxy_permissions', '2021-09-16 03:44:07.673267');
INSERT INTO `django_migrations` VALUES (17, 'sessions', '0001_initial', '2021-09-16 03:44:08.178698');
INSERT INTO `django_migrations` VALUES (18, 'user', '0001_initial', '2021-09-16 03:44:09.811784');
INSERT INTO `django_migrations` VALUES (19, 'common', '0001_initial', '2021-09-17 07:39:05.137477');
-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
`session_key` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`session_data` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`expire_date` datetime(6) NULL,
PRIMARY KEY (`session_key`) USING BTREE,
INDEX `django_session_expire_date_a5c62663`(`expire_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of django_session
-- ----------------------------
INSERT INTO `django_session` VALUES ('archkjs0kff1puv2q2yjjien90sertdq', 'OWUxNzU5ODhkNjU4NzdiMjU5OWU3N2UzOWEwN2EzNjQzMjRiNmQyOTp7InJvbGUiOjMsInVzZXJfaWQiOjF9', '2021-10-01 08:50:37.071785');
-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`text` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`zhaiyao` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`create_time` datetime(6) NULL,
`modify_time` datetime(6) NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (1, '20210917160247', '我要读研', 'b\'J\\xaa\\xbf\\xe06\\x8c\\x02~\\xbe\\xc81a \\xb7A\\x90\\xc9\\xa7\\xe8\\x8e\\x94\\x03\\x00F\\xf8\\x8e\\x08\\xf5\\xf3n`\\x8b:\\xb2\\xc3\\xa6\\xfa\\xa5\\x00qKA5\\xfd\\x04\\xa5\\xd0\\xe8\\xc08\\xf7D\\xdc\\x87\\x11Gl\\xbcum\\xa9\\xa59\\xef\\x9b\\xc2\\x11\\x80-T\\x82\\xaf\\x89$\\xc7\\xc1\\xc6\\xb2\\x16)\\xc4\\xb2;M\\xd3\\xd7\\x9c\\x8aRIy\\xa0\\r\\xec\\x84\\xe5\\xd0j\\xc2\\x96\\x8a\\t\\xa16\\x97\\xe9\\xe5H%.h\\xd5T\\xf9\\xd5\\x1c\\xdf\\x933Ap\\xc2\\x8a\\xa0r0\\xe3R\\x9b)\\x0b\\x01\\xf2OS3\\\'\\xfa1\\xc15\\x16E\\x87\\xcc~6\\xad(\\x029\\xb2\\xe7b2\\x89\\x94\\x1a\\x15\\x92%\\x90\\xf1\\xaa\\xaa\\\'\\xb2\\xb3B\\x85^m2\\xe9g\\xf9\\xe7\\\'\\x9e\\xb2\\n\\x98P\\xee\\xdf\\x7f\\x8c\\xc5Zid:\\xde\\xe31i\\xb9\\x1e7\\xf2\\xd2+\\xf0\\xd1\\xd7\\x99{\\xfdg\\x1ef\\xca\\xcd\\x8bc\\x87\\xeeq\\x96$\\xee4z\"\\xc5qT7$\\xab!k\\xd7\\xde\\xa5)e\\xde/\\x93\\xa7\\xbc\\xfai\\xae \\xef/b\\xad\\x8a\\x90\\x93\\xc4>o\'', '2021-09-17 08:02:47.886564', '2021-09-17 08:02:47.886564');
INSERT INTO `message` VALUES (2, '20210917163303', '我爱英语1', 'D:\\mycode\\django_platform\\shuziqianming\\static\\txt\\20210917163303.txt', '2021-09-17 08:33:03.409216', '2021-09-17 08:33:03.409216');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`create_time` datetime(6) NULL,
`modify_time` datetime(6) NULL,
`role` int(0) NOT NULL,
`description` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin', '12345', '12345679868', '2021-09-16 13:00:37.000000', '2021-09-16 13:00:40.000000', 3, '管理员');
INSERT INTO `user` VALUES (2, '张三', '1234', '12345678999', '2021-09-17 07:22:07.696214', '2021-09-17 07:22:07.696214', 2, '无');
SET FOREIGN_KEY_CHECKS = 1;
七、结论
此次设计的数字签名软件已经实现了具体的数字签名功能使用，这是一次对于密码学的尝试，通过此次的尝试，让我感受颇多。国家安全、信息安全、个人信息的安全等内容都是需要每一个人去进行保护的，只有人人做到信息安全的保密，才能提升网络的整体安全性。此次的设计也是一次尝试，对于密码学的知识内容掌握更加的全面，也希望此次的设计能够给数字签名带来一定的帮助作用，为信息安全作出贡献。
八、源码获取
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻
精彩专栏推荐订阅：在下方专栏👇🏻👇🏻👇🏻👇🏻
扫一扫
1409
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
