nodejs

安装node-sqlite3

这里用到的模块就是这个了[node-sqlite3][0]

npm install sqlite3

node-sqlite3 api

1.  - new sqlite3.Database(filename, [mode], [callback])
2.  - Database#run(sql, [param, ...], [callback])
3.  - Database#get(sql, [param, ...], [callback])
4.  - Database#all(sql, [param, ...], [callback])
5.  - Database#each(sql, [param, ...], [callback], [complete])
6.  - Database#exec(sql, [callback])
7.  - Database#prepare(sql, [param, ...], [callback])
8.  - ...

db = new sqlite3.Database(‘chain.sqlite3‘, createTable);
db.run("CREATE TABLE IF NOT EXISTS lorem (info TEXT)", insertRows);
var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
db.all("SELECT rowid AS id, info FROM lorem", function(err, rows) {});
db.close();

sqlite3.db

SELECT id,content,title,description FROM blog_blogpost

"use strict";


var sqlite3 = require(‘sqlite3‘).verbose();
var db = new sqlite3.Database(‘sqlite3.db‘);


function readAllRows() {
    console.log("readAllRows lorem");
    db.all("SELECT id,content,title,description FROM blog_blogpost", function(err, rows) {
        rows.forEach(function (row) {
            console.log(row.id + ": " + row.title);
        });
        closeDb();
    });
}


function closeDb() {
    console.log("closeDb");
    db.close();
}


readAllRows();

node sqlite3.js

readAllRows lorem
1: ...
215: rhino javascript,用rhino搭建本地的javascript环境
216: be a geek 8:无处不在的三剑客
217: dip 依赖倒置原则小试
218: OO notes 面向对象编程笔记
closeDb

最后效果可见:Phodal‘s New Homepage

网站重构——轻量化的网站架构设计一,使用nodejs sqlite3查询数据,布布扣,bubuko.com

网站重构——轻量化的网站架构设计一,使用nodejs sqlite3查询数据

原文：http://blog.csdn.net/phodal/article/details/21325365