js与数据库连接步骤
安装mysql模块
//使用命令安装mysql模块
npm i mysql
配置mysql模块
const mysql = require ( 'mysql' )
const db = mysql. createPool ( {
host: '127.0.0.1' ,
user: 'root' ,
password: '123456' ,
database: 'user'
} )
module. exports = db
使用占位符的写法
const db = require ( './04db' )
const sql = 'insert into users(username,age) values(?,?)'
const userInfo = { username: 'xiaohai' , age: '21' }
db. query ( sql, [ userInfo. username, userInfo. age] , ( err, results) => {
if ( err) {
return console. log ( '失败了' , err. message)
}
console. log ( '成功了' , results)
} )
使用便携写法写sql执行语句
const db = require ( './04db' )
const userInfo = { username: 'xiaoxiao' , age: '11' }
const sql = 'insert into users set ?'
db. query ( sql, [ userInfo] , ( err, results) => {
if ( err) {
return console. log ( '失败了' , err. message)
}
if ( results. affectedRows === 1 ) {
console. log ( '成功了' , results)
}
} )
使用命令运行js
创建数据库中的数据