如何使用javascript在数据库中添加带有检索到的引用计数的文本框？

SELECT COUNT(*) AS referenceCount FROM yourTable WHERE condition;

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'yourHost',
  user: 'yourUser',
  password: 'yourPassword',
  database: 'yourDatabase'
});

connection.connect();

connection.query('SELECT COUNT(*) AS referenceCount FROM yourTable WHERE condition', function (error, results, fields) {
  if (error) throw error;
  
  const referenceCount = results[0].referenceCount;
  
  // 在这里处理引用计数
});

connection.end();

const textBox = document.createElement('input');
textBox.type = 'text';
textBox.value = referenceCount;

const container = document.getElementById('container');
container.appendChild(textBox);