如何将数据库内容显示到EJS Web页面？
如何将数据库内容显示到EJS Web页面？
提问于 2018-08-01 05:51:31
所以我有一个包含以下代码的JavaScript页面：Story.js:
var express = require('express');
var dbcon = require('./app/db/databaseconnection');
var app = express();
var router = express.Router();
dbcon.createTable();
var filepath = __dirname + '/views/';
app.set('view engine', 'ejs');
app.use(express.static(__dirname + '/public'));
app.use('/', router);
var results = dbcon.getProducts().then(results => {
return results;
}).catch(err => { console.log(err) })
router.get('/', (request, response) => response.render(filepath + 'index', { page_name: 'home' }));
router.get('/store', (request, response) => response.render(filepath + 'store', { page_name: 'store', products: results }));
router.get('/about', (request, response) => response.render(filepath + 'about', { page_name: 'about' }));
router.get('/contact', (request, response) => response.render(filepath + 'contact', { page_name: 'contact' }));
router.get('/build', (request, response) => response.render(filepath + 'build/build'));
router.get('/learn', (request, response) => response.render(filepath + 'learn/learn'));
app.use('*', (request, response) => response.render(filepath + '404', { page_name: '404' }));
app.listen(3000, () => console.log("Server running at Port 3000"));我还有一个包含数据库内容的JavaScript页面：Databaseconnection.js:
const mysql = require("mysql");
const pool = mysql.createPool({
connectionLimit: 10,
host: "localhost",
user: "root",
password: "LOTOS123l",
database: "dbComputerStore"
});
module.exports = {
getProducts: () => new Promise((resolve, reject) => {
pool.query("SELECT * FROM products", (error, results, fields) => {
if (error) {
reject(error);
} else {
resolve(results);
}
});
}),
createTable: () => new Promise((resolve, reject) => {
PRIMARY KEY NOT NULL, image LONGBLOB NOT NULL)", (error, results, fields) => {
pool.query("SELECT * FROM pimages", (error, results, fields) => {
if (error) {
reject(error);
} else {
resolve(results);
console.log(results);
}
});
}),
populatetable: () => new Promise((resolve, reject) => {
pool.query();
})
};然后我有了我想要显示的ejs页面：store.ejs
<!DOCTYPE html>
<html>
<head>
<title>PC Store | Store</title>
<% include partials/header %>
</head>
<body>
<header>
<% include partials/navbar %>
</header>
<main>
<div class="container">
<% console.log(products); %>
</div>
</main>
<footer>
<% include partials/footer %>
</footer>
</body>
</html> 目前，我将其设置为console.log，因为我正在尝试查看信息是否正在传递。然而，它不是，它说承诺解决了。那么我该如何向ejs页面显示我的db内容呢？我正在试着做一个网上商店，我想知道我会怎么做。如有任何帮助，我们不胜感激！
在一些帮助下，我能够将数据库内容获取到store.js，但仍然无法将内容从store.js获取到store.ejs页面。
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-08-01 06:01:24
当你向EJS传递一个用于渲染的promise时，你需要传递这个值。修改你的render函数来解析产品promise并将结果转发给EJS。例如：
router.get('/store', (request, response) => {
return productPromise.then(results => {
return response.render(filepath + 'store', { page_name: 'store', products: results });
});
});或者，根据每个请求从数据库获取产品：
router.get('/store', (request, response) => {
return dbcon.getProducts().then(results => {
return response.render(filepath + 'store', { page_name: 'store', products: results });
});
});页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51622615
复制相关文章
相似问题