react-ative-sqlite是ReactNative上的一个 sqlite3绑定,它可以打开数据库并让SQL查询运行其中。目前还只是早期版本,API还有可能会改变。
示例代码:
var sqlite = require('./react-ative-sqlite');sqlite.ope("fileame.sqlite", fuctio (error, database) { if (error) { cosole.log("Failed to ope database:", error); retur; } var sql = "SELECT a, b FROM table WHERE field=? AND otherfield=?"; var params = ["somestrig", 99]; database.executeSQL(sql, params, rowCallback, completeCallback); fuctio rowCallback(rowData) { cosole.log("Got row data:", rowData); } fuctio completeCallback(error) { if (error) { cosole.log("Failed to execute query:", error); retur } cosole.log("Query complete!"); database.close(fuctio (error) { if (error) { cosole.log("Failed to close database:", error); retur } }); }});
评论