nodejs ejs模板数据库操作

1. 建立数据连接setting.js

var settings = {};

settings.db = {

host: 'localhost',

user: 'root',

password: '1234',

port: '3306',

database: 'testnode'

}

module. exports = settings;

 2. mysqlconn.js

var mysql = require( 'mysql');

var settings = require( './setting')

var conn = mysql. createConnection(settings.db);

conn. connect();

module. exports = conn;

3. app.js

app. set( 'views', path. join(__dirname, 'views'));

//设置模板的后缀是html

app. engine( 'html', require( 'ejs').renderFile);

//指定总模板

app. set( 'view engine', 'html');

 4.建立路由idnex.js