[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_11":-5,"_56":57,"_58":59,"_60":61},"routes/user.$name.collections",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":16},"topics",[35],"user",{"_20":21,"_13":14,"_22":23,"_24":25,"_26":27,"_28":29,"_30":31,"_32":16,"_33":34},"loginname","keeliang","page",1,"limit",20,"total","id","2628","avatar_url","http://www.gravatar.com/avatar/13e623321f54fe3e803aebdf4ba1dccc?size=48","githubUsername","","create_at","2012-02-17T17:03:40.136Z","score",5,"topic_count",0,"reply_count","is_star",false,{"_20":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":34,"_47":34,"_32":48,"_49":50,"_26":51,"_52":53},"95","author_id","15","tab","content","

起因

\r\n
看到simple todo的各种python版本实现, 我也来凑凑热闹...\r\n
既然已经有这么多python版本了, 我就对比实现了一个Simple-TODO的nodejs版本: Node TODO, 模版和樣式全部copy自web.py版本.\r\n

Source Code && Demo

\r\n

源代码: https://github.com/fengmk2/todo

在线demo: http://api.yongwo.de:3888

\r\n
$\"http://ww3.sinaimg.cn/large/6cfc7910jw1diwdadumcwj.jpg\"$ \r\n

代码目录

\r\n
目录还是很清晰的, public存放静态文件, views存放模版, controllers处理业务逻辑,\r\n
还有配置config.js, web主入口server.js\r\n
\r\n
$\"代码目录\"$ \r\n

使用到的第三方nodejs模块

\r\n

express: Web框架, 目前nodejs使用最广泛的web框架

ejs: 模版渲染引擎, 用于生成动态内容

node-mysql: 纯javascript实现的mysql驱动, 无法安装任何mysql包依赖.

\r\n
这3个模块都可以直接通过npm安装获得:\r\n

$ npm install express ejs mysql\r\n

\r\n

开发过程记录

\r\n

config.js

\r\n
可配置的信息:\r\n
* 网站名称\r\n
* 监听端口号, 默认8080\r\n
* 数据库配置信息\r\n

如何访问数据库

\r\n
在config.js文件里面, 会使用一下方式保持着数据库的链接对象\r\n

var db = exports.db = new require('mysql').Client(db_options);\r\n
db.connect(function(err) {\r\n
    if(err) {\r\n
        console.error('connect db ' + db.host + ' error: ' + err);\r\n
        process.exit();\r\n
    }\r\n
});\r\n

\r\n
这样我们就可以在别的地方直接使用db对象了\r\n

server.js

\r\n
express可以帮我们默认实现了静态文件处理, cookie处理, 请求参数处理等事情, 只需要配置一下, 就可以使用上这些功能了.\r\n

var app = express.createServer();\r\n
app.use(express.static(__dirname + '/public', {maxAge: 3600000 * 24 * 30}));\r\n
app.use(express.cookieParser());\r\n
app.use(express.bodyParser());\r\n

\r\n
同样, 需要配置模版渲染引擎为ejs\r\n

app.set(\"view engine\", \"html\");\r\n
app.set(\"views\", __dirname + '/views');\r\n
app.register(\"html\", ejs);\r\n

\r\n
看看views/index.html里面的一个最复杂的模版例子,\r\n
ejs最让我喜欢的是不用再学一套语法, 直接是内嵌js, 还是很容易读懂的\r\n
\r\n
$\"http://ww1.sinaimg.cn/large/6cfc7910jw1dix6f9kailj.jpg\"$ \r\n

URL Routing与Controllers

\r\n
一个http请求过来, 由那个controller处理, express提供了简便的routing方式\r\n

app.get('/', todo.index);\r\n
app.post('/todo/new', todo.new);\r\n
app.get('/todo/:id', todo.view);\r\n
app.get('/todo/:id/edit', todo.edit);\r\n
app.post('/todo/:id/edit', todo.save);\r\n
app.get('/todo/:id/delete', todo.delete);\r\n
app.get('/todo/:id/finish', todo.finish);\r\n

\r\n
如添加一条todo记录: HTTP GET /new, 将由todo.new方法处理,\r\n
代码逻辑包括了title参数有效性验证, 数据保存到数据库, http redirect:\r\n

exports.new = function(req, res, next) {\r\n
    var title = req.body.title || '';\r\n
    title = title.trim();\r\n
    if(!title) {\r\n
        return res.render('error', {message: '标题是必须的'});\r\n
    }\r\n
    db.query('insert into todo set title=?, post_date=now()', [title], function(err, result) {\r\n
        if(err) return next(err);\r\n
        res.redirect('/');\r\n
    });\r\n
};\r\n

\r\n
更多的controller处理逻辑请查看/controllers/todo.js.\r\n

数据库初始化及启动Web进程

\r\n

$ mysql xxx\r\n
$ source ~/todo/todo.sql\r\n
$ node server.js\r\n

\r\n

有爱

\r\n
可以看到, 无论是python的web开发, 还是nodejs, 我们以前对web的概念还是无需改变的.\r\n
都是我们熟悉的一些关键词:\r\n
http, request, response, html, template engine, url routing, MVC, GET, POST, MYSQL, Database...\r\n
\r\n
不同的是, 这里只使用javascript就可以驱动着以上的一切.\r\n
\r\n
希望本文对你有用 ^_^","title","nodejs web开发入门: Simple-TODO Nodejs 实现版","last_reply_at","2016-03-11T11:06:29.877Z","good","top",22,"visit_count",41705,"2011-07-07T07:32:39.000Z","author",{"_13":54,"_22":55},"fengmk2","https://avatars.githubusercontent.com/u/156269?v=4","zones",[107],"tabs",[75,76,77,78,79,80],"publicConfig",{"_62":63,"_64":25,"_65":66},"apiBaseUrl","https://api.cnodejs.org","turnstileSiteKey","build",{"_67":68,"_69":70,"_71":72,"_73":74},"service","cnode-web","version","0.1.0","commit","9ab83f39eed6b4a14eedbb8fbadfefe40dba3d45","buildTime","2026-07-30T19:01:36Z",{"_20":16,"_82":105,"_84":106,"_86":97,"_87":16,"_89":98},{"_20":102,"_82":103,"_84":104,"_86":97,"_87":102,"_89":98},{"_20":99,"_82":100,"_84":101,"_86":97,"_87":99,"_89":98},{"_20":95,"_82":46,"_84":96,"_86":97,"_87":95,"_89":98},{"_20":91,"_82":92,"_84":93,"_86":34,"_87":94,"_89":90},{"_20":81,"_82":83,"_84":85,"_86":34,"_87":88,"_89":90},10,"key","test","label","测试","visible","sort_order",91,"scope","admin",9,"dev","开发",90,4,"精华",true,"public",3,"job","招聘",2,"ask","问答","share","分享",{"_20":16,"_108":109,"_110":101,"_111":112,"_113":114,"_86":97,"_87":16},"slug","jobs","name","description","Node.js 招聘信息专区","icon","briefcase"]