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