Node.js+mysql

mysql2使用

简单使用

const mysql = require("mysql2");

const connection = mysql.createConnection({
  host: "localhost",
  port: 3306,
  database: "test",
  user: "root",
  password: "****",
});

const statement = `select * from products;`;

//query执行mysql语句
connection.query(statement, (err, results, fields) => {
  console.log(results);
  connection.end();//connection.destroy();
});

sql语句使用预编译方法

const statement = `select * from products
                  where name=? and password=?`;
connection.execute(statement, ["n", "111"], (err, results, fields) => {
  console.log(results);
});

连接池

const connection = mysql.createPool({
  host: "localhost",
  port: 3306,
  database: "codehub",
  user: "root",
  password: "***",
  connectionLimit: 10,
});
//使用execute执行sql语句
connection.execute()
//异步执行方法
connection
  .promise()
  .execute(statement, ["n", "11"])
  .then(([results, fields]) => {
    console.log(results);
  })
  .catch((err) => {
    console.log(err);
  });

ORM方式--Sequelize

在java中经常使用的ORM包括了Hibernate和MyBatis Node.js中下面使用Sequelize

//基础使用
const { Sequelize } = require("sequelize");
//数据库名，username，password
const sequelize = new Sequelize("test", "root", "123456", {
  host: "localhost",
  //数据库类型
  dialect: "mysql",
});

sequelize
  .authenticate()
  .then(() => {
    console.log("success");
  })
  .catch((err) => {
    console.log(err);
  });