npm install mysql
const express = require('express')
const cors = require('cors')
const app = express()
const mysql = require('mysql')
const db = mysql.createPool({
host:'127.0.0.1',
user:'root',
password:'123456',
database:'leon'
})
app.use(cors())
app.get('/',(res,req)=>{
db.query('select * from student',(err,result)=>{
if(err){
console.log(err)
}else{
console.log(result)
req.send(result)
}
})
})
app.listen(3000,()=>{
console.log("start 127.0.0.1:3000")
})
【Node.js】--MySql连接教程
最新推荐文章于 2024-06-14 10:36:59 发布