PhoneGap下Web SQL实践

HTML5里的Web SQL数据库，内置了SQLite数据库，

对数据库的操作使用executeSql执行增删改查

1. 创建数据库

1 2 3

function creatDatabase(){        db = openDatabase('Student', '1.0', 'StuManage', 2 * 1024 * 1024);   }

　

2. 创建表

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

function createTable(){        if (db) {          var strSQL = "create table if not exists StuInfo ";          strSQL += " (StuID unique,Name text,Sex text,Score int)";          db.transaction(function(tx) {              tx.executeSql(strSQL)          },          function() {              console.log("创建表错误");          },          function() {              console.log("创建表成功");          })      }

　　

3. 增加数据

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

function addData() {      if (db) {            var strSQL = "insert into StuInfo values";          strSQL += "(?,?,?,?)";          db.transaction(function(tx) {              tx.executeSql(strSQL,[                  $$("txtStuID").value,$$("txtName").value,                  $$("selSex").value,$$("txtScore").value              ],              function(){                  $$("txtName").value="";                  $$("txtScore").value="";                  alert("成功增加1条记录!");              },              function(tx,ex){                   console.log(ex.message)              })          })        }   }

　

4. 查询数据

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

function queryData(){      if(db){          var sql = "select * from StuInfo";           db.transaction(function(tx) {              tx.executeSql(sql,[],              function(tx, results){                  var len = results.rows.length,i;                  var htmlData = "";                  for(i = 0; i <  len ; i++){                      var item = results.rows.item(i);                      var htmlitem = item.StuID + " " + item.Name + " " + item.Sex + " " + item.Score;                      htmlData += htmlitem + "</br> ";                    }                  $$("info").innerHTML = htmlData;              },              function(tx,ex){                   console.log(ex.message)              })          })      } }

　　

5. 删除数据

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

function deleteData(){      if (db) {            var strSQL = "delete from StuInfo where StuID = ?";          db.transaction(function(tx) {              tx.executeSql(strSQL,[                  $$("txtStuID").value              ],              function(){                  alert("成功删除1条记录!");              },              function(tx,ex){                   console.log(ex.message)              })          })        }         queryData(); }

　　

 

完整的Code如下

+ View Code

　　

本文转自Work Hard Work Smart博客园博客，原文链接：http://www.cnblogs.com/linlf03/p/6657152.html，如需转载请自行联系原作者