nodejs express mongodb
nodejs做后台 可以连接sql 但是没有很好的例子
so nodejs+express+mongodb(从安装到一个简单的数据提交、显示的网站)
原文:http://cwbuecheler.com/web/tutorials/2013/node-express-mongo/#
1(1)打开cmd
在你想的目录下建立一个文件夹 如e:\0922
(2)安装 express-generator
e:\0922>npm install -g express-generator
(3)使用express 新建一个应用 ,如0922,express -e 表示采用ejs
e:>express -e 0922
(4)打开 0922\package_json 如图:
{ "name": "nodetest1", "version": "0.0.0", "private": true, "scripts": { "start": "node ./bin/www" }, "dependencies": { "body-parser": "~1.12.4", "cookie-parser": "~1.3.5", "debug": "~2.2.0", "express": "~4.12.4", "jade": "~1.9.2", "morgan": "~1.5.3", "serve-favicon": "~2.2.1" } }
在denpendencies添加 mongodb,monk,如图:
"dependencies": { "body-parser": "~1.12.4", "cookie-parser": "~1.3.5", "debug": "~2.2.0", "express": "~4.12.4", "jade": "~1.9.2", "morgan": "~1.5.3", "serve-favicon": "~2.2.1", "mongodb": "^1.4.4", "monk": "^1.0.1" }
(5) npm安装mpngodb依赖包,根据我们刚刚修改的 denpendencies
e:\0922>npm install
(6) 0922文件夹 下 新建data文件夹 来保存数据(数据库放的地方 )
e:\0922>mkdir data
(7)终于可以开启nodejs 服务器啦 ,使用npm start
e:\0922>npm start
结果:
> application-name@0.0.1 start e:\0922 > node ./bin/www
在浏览器 地址栏打开 http://localhost:3000
2. 做一个 HEELO WORLD的网站
(1)0922\routes\index.js 在module.exports= router;这一句前面加上 代码
var express = require('express'); var router = express.Router(); /* GET home page. */ router.get('/', function(req, res) { res.render('index', { title: 'Express' }); }); //注意 下面代码 手动添加 /* GET Hello World page. */ router.get('/helloworld', function(req, res) { res.render('helloworld', { title: 'Hello, World!' }); }); module.exports = router;
(2)0922\views\helloworld.ejs 新建一个helloworld.ejs,如下:
<html> <head> <title></title> </head> <body> <p> <%= title %> </p> </body> </html>
(3)0922>npm start
(4)打开 http://localhost:3000/helloworld
3.建立数据库啦
(1)安装 mongodb ,从 http://mongodb.org/
(2)例如mongodb安装在e盘下面,e:\mongo\bin
e:\mongod\bin>mongod --dbpath e:\0922\data
Once it says "[initandlisten] waiting for connections on port 27017", you're good.
(3)再重新打开一个cmd命令端 (这里 记住不是在上面一个cmd里面 ,是重新打开一个)
e:\mongo\bin>mongo
会看到如下,就证明ok了
e:\mongo\bin>mongo MongoDB shell version: 2.4.5 connecting to: test
(4)在上一个cmd里面 ,建立一个数据库叫做news
>use news
show dbs 可以查看当前有哪些数据库,目前 就有local,news
(5)往news里面加入一下数据
newstuff = [{ "username" : "testuser2", "email" : "testuser2@testdomain.com" }, { "username" : "testuser3", "email" : "testuser3@testdomain.com" }] db.usercollection.insert(newstuff);
查看数据:
db.usercollection.find().pretty()
会显示:
{ "_id" : ObjectId("5202b49ad2184d390cbf6ecb"), "username" : "testuser2", "email" : "testuser2@testdomain.com" } { "_id" : ObjectId("5202b49ad2184d390cbf6ecc"), "username" : "testuser3", "email" : "testuser3@testdomain.com" }
(6)在0922\app.js 添加如下三行代码:
var express = require('express'); var path = require('path'); var favicon = require('serve-favicon'); var logger = require('morgan'); var cookieParser = require('cookie-parser'); var bodyParser = require('body-parser'); // 注意 下面是添加的代码 var mongo = require('mongodb'); var monk = require('monk'); var db = monk('localhost:27017/nodetest1');
在0922\app.js 继续添加 代码
// 添加的代码 要放在 app.use前面 app.use(function(req,res,next){ req.db = db; next(); }); app.use('/', routes); app.use('/users', users);
完整的 app.js如下:
var express = require('express'); var path = require('path'); var favicon = require('serve-favicon'); var logger = require('morgan'); var cookieParser = require('cookie-parser'); var bodyParser = require('body-parser'); // New Code var mongo = require('mongodb'); var monk = require('monk'); var db = monk('localhost:27017/nodetest1'); var routes = require('./routes/index'); var users = require('./routes/users'); var app = express(); // view engine setup app.set('views', path.join(__dirname, 'views')); app.set('view engine', 'jade'); // uncomment after placing your favicon in /public //app.use(favicon(__dirname + '/public/favicon.ico')); app.use(logger('dev')); app.use(bodyParser.json()); app.use(bodyParser.urlencoded({ extended: false })); app.use(cookieParser()); app.use(express.static(path.join(__dirname, 'public'))); // Make our db accessible to our router app.use(function(req,res,next){ req.db = db; next(); }); app.use('/', routes); app.use('/users', users); /// catch 404 and forwarding to error handler app.use(function(req, res, next) { var err = new Error('Not Found'); err.status = 404; next(err); }); /// error handlers // development error handler // will print stacktrace if (app.get('env') === 'development') { app.use(function(err, req, res, next) { res.status(err.status || 500); res.render('error', { message: err.message, error: err }); }); } // production error handler // no stacktraces leaked to user app.use(function(err, req, res, next) { res.status(err.status || 500); res.render('error', { message: err.message, error: {} }); }); module.exports = app;
(7)把数据通过mongo推送并且显示
0922\routes\index.js
/* GET Userlist page. 添加 如下*/ router.get('/userlist', function(req, res) { var db = req.db; var collection = db.get('usercollection'); collection.find({},{},function(e,docs){ res.render('userlist', { "userlist" : docs }); }); });
明天接着 更新