![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIwkjNmE2NtllaXl3dkhzN5pXNiBXa6ZDMw8CXwkjN312Lc52YucWbpFmbpNnLxEzcvw1LcpDc0RHaiojIsJye.jpg)
執行個體一(AES_ENCRYPT/AES_DECRYPT)
MariaDB [study_db]> INSERT INTO book_classify
-> (classify_id, classify_name, description)
-> VALUES
-> (100, 'AES', AES_ENCRYPT(123, 'KEY'));
Query OK, 1 row affected (0.01 sec)
MariaDB [study_db]> SELECT classify_id, classify_name, description,
-> AES_DECRYPT(description, 'KEY')
-> FROM book_classify
-> WHERE classify_id = 100;
+-------------+---------------+------------------+---------------------------------+
| classify_id | classify_name | description | AES_DECRYPT(description, 'KEY') |
+-------------+---------------+------------------+---------------------------------+
| 100 | AES | ?^ڻIi?6wvn??a | 123 |
+-------------+---------------+------------------+---------------------------------+
1 row in set (0.00 sec)
*執行個體二(ENCODE/DECODE)
MariaDB [study_db]> INSERT INTO book_classify
-> (classify_id, classify_name, description)
-> VALUES
-> (111, 'AES', ENCODE(123, 'KEY'));
Query OK, 1 row affected (0.00 sec)
MariaDB [study_db]> SELECT classify_id, classify_name, description,
-> DECODE(description, 'KEY')
-> FROM book_classify
-> WHERE classify_id = 111;
+-------------+---------------+-------------+----------------------------+
| classify_id | classify_name | description | DECODE(description, 'KEY') |
+-------------+---------------+-------------+----------------------------+
| 111 | AES | W? | 123 |
+-------------+---------------+-------------+----------------------------+
1 row in set (0.00 sec)
三, MD5加密
MD5主要用途:
1、對一段資訊生成資訊摘要,該摘要對該資訊具有唯一性,可以作為數字簽名。
2、用于驗證檔案的有效性(是否有丢失或損壞的資料),
3、對使用者密碼的加密,
4、在哈希函數中計算散列值
MD5是沒有解密算法的,經常用來作為對賬号密碼的驗證。驗證的一般流程為:
1. 新增賬號密碼時對密碼進行MD5加密,賬号明文存入資料庫,密碼存入的是經過MD5加密的密文。
2. 登入時先根據賬号,在資料庫進行檢測。
3. 檢測到賬号後對本次登入輸入的密碼進行MD5加密,拿本次密文與資料庫裡的密文進行驗證。通過後即可成功登陸。
版權聲明:本文為CSDN部落客「weixin_33939843」的原創文章,遵循CC 4.0 BY-SA版權協定,轉載請附上原文出處連結及本聲明。
原文連結:https://blog.csdn.net/weixin_33939843/article/details/92356258