使用node.js和ejs从mysql下载PDF

const mysql = require('mysql');

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

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

connection.query('SELECT * FROM table_name', (err, results) => {
  if (err) throw err;
  // 处理查询结果
});

const ejs = require('ejs');
const fs = require('fs');

const template = fs.readFileSync('template.ejs', 'utf8');
const html = ejs.render(template, { data: results });

const pdf = require('html-pdf');

pdf.create(html).toFile('output.pdf', (err, res) => {
  if (err) throw err;
  console.log('PDF downloaded successfully');
});