1、Node.js安装sqlite3模块
- npm install sqlite3
2、新建db.js文件
用户名密码为空:
var sqlite3 = require('sqlite3');
var db = new sqlite3.Database('D:\\test.db',function() {
db.run("create table test(name varchar(15))",function(){
db.run("insert into test values('hello,world')",function(){
db.all("select * from test",function(err,res){
if(!err)
console.log(JSON.stringify(res));
else
console.log(err);
});
})
});
});
或:
var fs = require('fs');
var file = 'D:\\test.db';//这里写的就是数据库文件的路径
var exists = fs.existsSync(file);
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(file);
//增
var sql1 = db.prepare("insert into test(name) values ('lisi')");
sql1.run();
//删
var sql2 = db.prepare("delete from 表名 where id = 1");
//console.log(sql2);
sql2.run();
//改
var sql3 = db.prepare("update 表名 set name = winston where id = 1");
sql3.run();
//查表中所有数据
db.all("select * from test",function(err,row){
console.log(JSON.stringify(row));
})
//查一条数据
db.each("select * from test where name='zhangsan'",function(err,row){
console.log(row);
})
3、运行
- node db.js
- [{"name":"hello,world"},{"name":"lisi"}]