const { json } = require('express/lib/response');
const mysql=require ('mysql');
const express=require('express');
var app=express();
const bodyparser=require('body-parser');
app.use(bodyparser.json());
var mysqlConnection=mysql.createConnection({
host:'localhost',
user: 'root',
password:'',
database: 'employee_db'
});
mysqlConnection.connect((err)=>{
if(!err)
{
console.log("DB connection is successfull");
}
else{
console.log("DB connection failed " JSON.stringify(err,undefined,2));
}
});
app.listen(8000,()=>console.log('Express server is running on port number: 8000'));
app.get('/employess',(res,req)=>{
mysqlConnection.query('SELECT * FROM EMPLOYEE',(err,rows,fields)=>{
if(!err)
{
console.log(rows);
}
else{
console.log(err);
}
})
});
Windows PowerShell 著作權所有 (C) Microsoft Corporation。著作權所有。
嘗試新的跨平臺 PowerShell https://aka.ms/pscore6
PS E:\Development\crud-node> node index.js Express server is running on port number: 8000 資料庫連接成功
uj5u.com熱心網友回復：
終點似乎有拼寫錯誤。您在錯誤詳細資訊中指定的與代碼中定義的不同
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/480429.html
標籤：javascript mysql 节点.js 表示 phpmyadmin
下一篇：異步等待后獲取一組Promise