phonegap操作数据库详解
这次给大家带来phonegap操作数据库详解,phonegap操作数据库的注意事项有哪些,下面就是实战案例,一起来看一下。
实例如下:
<!DOCTYPE html> <html> <head> <meta charset=UTF-8> <title>Database Example</title> <script type=text/javascript charset=UTF-8 src=cordova.js></script> <script type=text/javascript charset=UTF-8> document.addEventListener("deviceready", onDeviceReady, false); function onDeviceReady() { var db=window.openDatabase("Test","1.0","Test",200000); db.transaction(populateDB,errorDB,successDB); } //初始化数据库数据 function populateDB(tx){ tx.executeSql('DROP TABLE IF EXISTS test1'); tx.executeSql('CREATE TABLE IF NOT EXISTS test1 (id unique,name)'); tx.executeSql('INSERT INTO test1(id,name) VALUES(1,"Tony")'); tx.executeSql('INSERT INTO test1(id,name) VALUES(2,"Bill")'); tx.executeSql('INSERT INTO test1(id,name) VALUES(3,"Tony")'); } //查询方法 function queryDB(tx){ tx.executeSql('SELECT * FROM test1',[],querySuccess,errorDB); } //查询成功回调 function querySuccess(tx,results){ var len=results.rows.length; var status=document.getElementById("status"); var string ="Rows:"+len+"<br />"; for(var i=0;i相信看了本文案例你已经掌握了方法,更多精彩请关注双恒网络其它相关文章!
推荐阅读:
phonegap创建联系人详解
不刷新的前提下怎样改变当前url的代码
以上就是phonegap操作数据库详解的详细内容,更多请关注双恒网络其它相关文章!