nodejs---banner
模板文件放在./templete文件夹下,其他的前台文件都在./www
const express = require('express');
const expressStatic = require('express-static');
const consolidate = require('consolidate');
const mysql = require('mysql');
//连接池
const db = mysql.createConnection({host:'localhost',database:'blog',user:'root',password:'root'});
var server = express();
//配置模板引擎
//输出什么东西
server.set('view engine','html');
//模板文件放在哪
server.set('views','./templete');
//哪种模板引擎
server.engine('html',consolidate.ejs);
//接收用户请求
server.get('/',function(req,res){
//查询banner的东西
db.query('SELECT * FROM `banner_table`;',(err,data)=>{
if(err){
//console.log(err)
res.status(500).send('database error').end();
}else{
//console.log(data)
res.render('fenmian.ejs',{banners:data})
}
})
});
//读取静态文件
server.use(expressStatic('./www'))
server.listen(8090);
前台页面
<div class="swiper-container">
<div class="swiper-wrapper">
<%for(var i=0;i<banners.length;i++){%>
<div class="swiper-slide">
<div class="content-slide">
<div class="txt">
<h3><%=banners[i].title%></h3>
<p><%=banners[i].sub_title%></p>
</div>
<img src="<%=banners[i].src%>" alt="">
</div>
</div>
<%}%>
</div>
</div>