h5+中如何操作sqlite，求解，谢谢

分类：HTML5+

HTML5+

var db = openDatabase('_www/js/db.db', '', 'website DB', 5 1000 1000);

function queryMydb() {
alert(111);
alert(db.name);

db.transaction(function(tx) {  
    //tx.executeSql('create table if not exists course(id INTEGER,name text)', []);  
    //tx.executeSql('insert into course values(?,?)',[1,"数学1"],onSuccess,onError);   
    //tx.executeSql('insert into course values(?,?)',[2,"数学2"],onSuccess,onError);   
    //执行访问数据库的语句  
    tx.executeSql('select * from course', [], onSuccess, onError);   
});

}

//sql语句执行成功后执行的回调函数
function onSuccess(tx, rs) {
alert(rs.rows.length);
if (rs.rows.length > 0) {
for (var i = 0; i < rs.rows.length; i++) {
var row = rs.rows.item(i);
alert(row.name);
}
}
alert("操作成功");
}
//sql语句执行失败后执行的回调函数

function onError(tx, error) {
alert("操作失败，失败信息：" + error.message);
}

mui.plusReady(queryMydb);

2015-02-05 15:38 负责人:无分享