服务器端实现数据库增删改查

const mysql = require('mysql');

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

connection.connect();

const sql = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')";

connection.query(sql, function (error, results, fields) {
  if (error) throw error;
  console.log('Data inserted successfully');
});

connection.end();

const mysql = require('mysql');

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

connection.connect();

const sql = "DELETE FROM table_name WHERE condition";

connection.query(sql, function (error, results, fields) {
  if (error) throw error;
  console.log('Data deleted successfully');
});

connection.end();

const mysql = require('mysql');

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

connection.connect();

const sql = "UPDATE table_name SET column1 = 'new_value' WHERE condition";

connection.query(sql, function (error, results, fields) {
  if (error) throw error;
  console.log('Data updated successfully');
});

connection.end();

const mysql = require('mysql');

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

connection.connect();

const sql = "SELECT * FROM table_name WHERE condition";

connection.query(sql, function (error, results, fields) {
  if (error) throw error;
  console.log(results);
});

connection.end();