自制二维码数据库

// 使用qrcode.js生成二维码
const qrcode = require('qrcode');

qrcode.toDataURL('Hello World', (err, url) => {
  if (err) throw err;
  console.log(url);
});

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'user',
  password: 'password',
  database: 'database_name'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database!');
});

connection.query('SELECT * FROM qrcodes', (err, results) => {
  if (err) throw err;
  console.log(results);
});

connection.end();

const crypto = require('crypto');

const algorithm = 'aes-256-cbc';
const key = crypto.randomBytes(32);
const iv = crypto.randomBytes(16);

function encrypt(text) {
  let cipher = crypto.createCipheriv(algorithm, Buffer.from(key), iv);
  let encrypted = cipher.update(text);
  encrypted = Buffer.concat([encrypted, cipher.final()]);
  return { iv: iv.toString('hex'), encryptedData: encrypted.toString('hex') };
}

function decrypt(text) {
  let iv = Buffer.from(text.iv, 'hex');
  let encryptedText = Buffer.from(text.encryptedData, 'hex');
  let decipher = crypto.createDecipheriv(algorithm, Buffer.from(key), iv);
  let decrypted = decipher.update(encryptedText);
  decrypted = Buffer.concat([decrypted, decipher.final()]);
  return decrypted.toString();
}

const encryptedData = encrypt('Sensitive QR Code Data');
console.log(encryptedData);

const decryptedData = decrypt(encryptedData);
console.log(decryptedData);