nodejsmysql查询结果在pug页面中以chart.js标签呈现

1. 在Node.js中使用mysql模块连接到MySQL数据库并查询结果。 例如：

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});
connection.connect();
connection.query('SELECT * FROM table_name', function (error, results, fields) {
  if (error) throw error;
  console.log(results);
});
connection.end();

2. 将查询结果转换为chart.js的标签格式，例如：

labels: ["Red", "Blue", "Yellow", "Green", "Purple", "Orange"],
datasets: [{
  label: '# of Votes',
  data: [12, 19, 3, 5, 2, 3],
  backgroundColor: [
    'rgba(255, 99, 132, 0.2)',
    'rgba(54, 162, 235, 0.2)',
    'rgba(255, 206, 86, 0.2)',
    'rgba(75, 192, 192, 0.2)',
    'rgba(153, 102, 255, 0.2)',
    'rgba(255, 159, 64, 0.2)'
  ],
  borderColor: [
    'rgba(255, 99, 132, 1)',
    'rgba(54, 162, 235, 1)',
    'rgba(255, 206, 86, 1)',
    'rgba(75, 192, 192, 1)',
    'rgba(153, 102, 255, 1)',
    'rgba(255, 159, 64, 1)'
  ],
  borderWidth: 1
}]

3. 将转换后的标签插入到pug模板中，例如：

canvas#myChart(width="400", height="400")
script.
  var ctx = document.getElementById('myChart').getContext('2d');
  var myChart = new Chart(ctx, {
      type: 'bar',
      data: {
          labels: ["Red", "Blue", "Yellow