1.安装
npm install mysql
2.导入
const mysql = require('mysql')
3.书写数据库的匹配项
const options = {
host: 'localhost',
user: 'root',
password: '123456',
port: 3306,
database: 'student'
}
详细参数配置见
4.实例链接数据库对象
const objCon = mysql.createConnection(options)
5.连接数据库
objCon.connect(() => {
console.log('连接成功')
})
6.查询
const selectSql = 'select * from student';
objCon.query(selectSql,function (err, result) {
if(err){
console.log(err.message);
return;
}
console.log(result);
});
7.删除表格
const dropSql = 'drop table student'
objCon.query(dropSql, (err, result) => {
if(err) {
console.log(err)
}else {
console.log(result)
}
})
8.删除数据库
const dropDataSql = 'drop database zh'
objCon.query(dropDataSql, (err, result) => {
if(err) {
console.log(err)
}else {
console.log(result)
}
})
9.添加数据库
const createDataSql = 'create database zh'
objCon.query(createDataSql, (err, result) => {
if(err) {
console.log(err)
}else {
console.log(result)
}
})
10.添加表
const createSql = "CREATE TABLE user(id int AUTO_INCREMENT,username VARCHAR(255),password VARCHAR(255),PRIMARY KEY(id))"
objCon.query(createSql, (err, result) => {
if (err) {
console.log(err)
} else {
console.log(result)
}
})
objCon.query(createSql, (err, result) => {
if(err) {
console.log(err)
}else {
console.log(result)
}
})
11.增加
const insertSql = 'insert into students(id, name, gender) values(3, "zheng", "男")'
objCon.query(insertSql, (err, result) => {
if(err) {
console.log(err)
}else {
console.log(result)
}
})
const insertSql = 'insert into students(id, name, gender) values(?, ?, ?)'
objCon.query(insertSql, [4, 'jcl', '男'], (err, result) => {
if(err) {
console.log(err)
}else {
console.log(result)
}
})