mysql使用

const mysql = require('mysql');

//配置连接
const connection = {
  host: 'localhost',
  post: '3306',
  user: 'root',
  password: 'root',
  database: 'timu'
};

//创建连接对象
//let con = mysql.createConnection(connection);

//连接
// con.connect(err => {
//   if (err) {
//     console.log('数据库连接失败');
//   } else {
//     console.log('数据库连接成功');
//   }
// });

//创建promise对象查询方法

function queryFn(sqlStr, arr) {
  //创建连接对象
  let con = mysql.createConnection(connection);
  return new Promise((resolve, reject) => {
    con.query(sqlStr, arr, (error, result) => {
      if (error) {
        reject(error);
      } else {
        resolve(result);
        con.end()
      }
    });
  });
}

module.exports = queryFn;

var express = require('express')
var app = express()
var sqlQuery = require('./sql')

app.get('/',(req,res)=>{
    res.send("这是答题API服务器")
})

app.get('/api/rtimu/',async (req,res)=>{
    //随机获取10个题目；
    //console.log(req.query)
    //跨域请求
    res.append("Access-Control-Allow-Origin","*")
    res.append("Access-Control-Allow-Content-Type","*")
    let page = req.query.page?req.query.page:2;
    let strSql = `select * from quizzes limit ${page*10},10`;
    let result = await sqlQuery(strSql)
    //console.log(result)

    res.json(Array.from(result));


})


app.listen(8080,()=>{
    console.log(
        "server Start",
        "http://localhost:8080/"
    )
})