本次文章主要讲解nodejs整合mysql
下载mysql2模块
npm install mysql2
环境初始化
创建数据库nodejsproject
create database nodejsproject;
创建数据表并插入数据
use nodejsproject;
create table user(id int auto_increment primary key,username varchar(10),password varchar(20));
select * from user;
具体增删改查操作
const mysql = require("mysql2")
const connection = {
host: "127.0.0.1",
port: 3306,
user: "root",
password: "123456",
database: "nodejsproject",
connectionLimit: 1//创建一个连接池
};
//创建一个连接池,返回的是promise对象
const pool = mysql.createPool(connection).promise();
//查找数据
async function select(name) {
//query() 第一个参数是sql语句,第二个参数是sql语句中对应?的数据,?相当于挖了一个空,在后面通过数组来进行赋值
//数组参数会按顺序与?对应
const users = await pool.query("select * from user where username=?", [name]);
console.log(users[0])//他会返回一个数组,数组第一位是数据
}
//插入数据
async function insert(name, password) {
const user = await pool.query("insert into user(username,password) values(?,?)", [name, password]);
console.log(user)
}
//修改数据
async function update(password, name) {
const user = await pool.query("update user set password=? where username=?", [password, name]);
console.log(user)
}
//删除数据
async function deleteUser(username) {
const userDelete = await pool.query("delete from user where username=?", [username]);
console.log(userDelete)
}
deleteUser("zs")
以上就是nodejs整合mysql相关的内容,欢迎各位评论教导,如果觉得文章还不错或者有什么地方不懂的,欢迎留言提问点赞🧡🤞🤞🤞🧡