安装express，创建项目，添加sqlite3模块
express --sessions --css stylus --ejs myhotel
npm install sqlite3
node app #运行方式
源代码如下：
网站入口app.js
var express = require('express');
var routes = require('./routes');
var photo = require('./routes/photo');
var http = require('http');
var path = require('path');
var app = express();
// all environments
app.set('port', process.env.PORT || 80);
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');
app.use(express.favicon());
app.use(express.logger('dev'));
app.use(express.json());
app.use(express.urlencoded());
app.use(express.bodyParser({ keepExtensions: true, uploadDir: __dirname + '/uploads' } ));
app.use(express.methodOverride());
app.use(express.cookieParser('your secret here'));
app.use(express.session());
app.use(app.router);
app.use(require('stylus').middleware(path.join(__dirname, 'public')));
app.use(express.static(path.join(__dirname, 'public')));
// development only
if ('development' == app.get('env')) {
app.use(express.errorHandler());
}
app.get('/', routes.index);
app.post('/upload', photo.upload);
app.get('/list', photo.list);
http.createServer(app).listen(app.get('port'), function(){
console.log('Express server listening on port ' + app.get('port'));
});
connect.bodyParser()会有报错，替换如下
var multipart = require('connect-multiparty');
app.use(express.urlencoded()); // Replace for depricated connect.bodyParser()
app.use(express.json()); // Replace for depricated connect.bodyParser()
app.use(multipart({ uploadDir: __dirname + '/uploads' })) // Replace for depricated connect.bodyParser()
控制与路由
routes/index.js
exports.index = function(req, res){
res.render('index', { title: 'Express' });
};
routes/photo.js
var sqlite3 = require("sqlite3"),
fs = require("fs");
var db = new sqlite3.Database("photos.db");
/*
* GET users listing.
*/
exports.list = function(req, res){
var photos = [];
db.serialize(function() {
db.each("SELECT name, path FROM photos", function(err, row) {
photos.push({name: row.name, path:row.path})
}, function(){
res.render("photos",{photos:photos})
});
});
};
exports.upload = function(req, res){
var name = req.param('name', null);
fs.readFile(req.files.image.path, function (err, data) {
// ...
if(err) {throw err;}
var hash = require('crypto').createHash('md5');
var target_path = 'images/uploads/' + hash.update(data+"").digest('hex') + "." + req.files.image.name.split(".")[1];
fs.writeFile("./public/"+ target_path, data, function (err) {
if(err) {throw err;}
db.serialize(function() {
var stmt = db.prepare("INSERT INTO photos VALUES (?,?)");
stmt.run(name,target_path);
stmt.finalize();
res.redirect("/list");
});
// db.close();
});
});
};
视图代码
view/index.ejs
<!DOCTYPE html>
<html>
<head></head> <body>
<form enctype="multipart/form-data" action="/upload" method="POST">
<input type="text" id="name" name="name"></input>
Send this file: <input name="image" id="image" type="file" />
<input name="tt" type="submit" value="Send File" />
</form> </body>
</html>
view/photos.ejs
<!DOCTYPE html>
<html>
<head>
<title>AB</title>
<link rel='stylesheet' href='/stylesheets/style.css' />
</head>
<body>
<ul class="nostyle">
<% photos.forEach(function(photo){ %>
<li><%= photo.name %> <img src="<%= photo.path %>" /></li>
<% }) %>
</ul>
</body>
</html>
样式控制public/stylesheets/style.styl
body
padding: 50px
font: 14px "Lucida Grande", Helvetica, Arial, sans-serif
a
color: #00B7FF
.nostyle
list-style-type: circle