nodejs获取mysql数据
- 创建一个connection
- 连接connection
- 执行SQL语句,获取数据
- 关闭connection
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '123456'
});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function(err, data) {
if(err){throw err;}
return JSON.parse(JSON.stringify(data));
});
connection.end();
将mysql数据渲染到页面
findData(sql, callback) {
createConnect((collection) => {
collection.query(sql, (err, data) => {
if (err) {
throw err;
}
callback(JSON.parse(JSON.stringify(data)));
collection.end();
});
});
}
let moduleData = (sql) => {
return new Promise((resolve, reject) => {
try {
findData(sql, (data) => {
resolve(data);
});
}
catch (e) {reject(e);}
});
}
findTitle(){
let sql="select * from navTitle";
return moduleData(sql);
}
let Router = express.Router();
Router.all("*", (req, res, next) => {
let fun = async () => {
let navTitle = await findTitle();
return {navTitle}
}
fun().then((result) => {
res.locals.navTitle = result.navTitle;
next();
}).catch((error) => {
next(error);
});
}
Router.get("/", (req, res) => {
res.render("index", {
topNav: res.locals.navTitle
}, (err, html) => {
res.send(html);
});
});