【代码段建立表】
var fs = require("fs");
var file = "test.db";var exists = fs.existsSync(file);
if(!exists) {
console.log("Creating DB file.");
fs.openSync(file, "w");
}
var sqlite3 = require("sqlite3").verbose();
var db = new sqlite3.Database(file);
db.each("SELECT rowid AS id, thing FROM Stuff where thing = '" + "Thing #1995800" + "'", function(err, row) {
console.log(row.id + ": " + row.thing);
});
return;
db.serialize(function() {
if(!exists) {
db.run("CREATE TABLE Stuff (thing TEXT)");
}
var stmt = db.prepare("INSERT INTO Stuff VALUES (?)");
//I