封装数据库查询函数data.js
// 导入mysql模块,需要通过npm命令安装
//命令行运行 npm i mysql
const mysql = require('mysql')
//创建连接
const connection = mysql.createConnection({
host: 'localhost',
user: 'root' ,//数据库的用户名
password: 'root', //数据库的密码
database: 'mydatabase' //数据库名
})
//sql:sql语句 arr:数组,避免sql注入漏洞
//例: sql = `select * from user where usename = ? and password = ?`
// arr = [username,password] 数组中数据与sql语句中?一一对应
function Query(sql,arr) {
return new Promise((resolve,reject)=>{
connection.query(sql,arr,(err,result)=>{
if(err) {
return reject('出现了错误')
}
resolve(result)
})
})
}
module.exports = Query
//调用查询
async function login(username,password) {
let sql = `select * from user where usename = ? and password = ?`
let result =await Query(sql,[username,password])
return result
}