html数据库sql数据库,html5 当地数据库的sql操作

//********************************

//****Html5 管理本地数据库脚本****

//********************************

var LOCAL = window.LOCAL || {}, win = window;

LOCAL.LocalDB = function(options){

this.opts = $.extend({}, LOCAL.defaults, options);

console.log(this.opts);

}

LOCAL.LocalDB.prototype = {

//打开数据库

openDB: function() {

var self = this, options = self.opts;

try{

if(!options.dbObj) {

options.dbObj = win.openDatabase(options.dbName, options.dbVersion,

options.dbDescription, options.dbMaxSize);

console.log(options.dbName + '数据库创建成功...');

}

}catch(e){

console.log("打开数据库出现未知错误： " + e);

options.dbObj = null;

};

},

//连接数据库

getDBConn: function() {

this.openDB();

},

//默认执行sql方式

executeSqlDefault: function(sqlStr, params, successHandler, errorHandler) {

var self = this, options = self.opts;

this.getDBConn();

options.dbObj.transaction(function(tx){

tx.executeSql(sqlStr, params, successHandler, errorHandler);

}, null, null);

},

//自定义sql函数执行

executeSqlTrans: function(fun, successHandler, errorHandler) {

var self = this, options = self.opts;

this.getDBConn();

options.dbObj.transaction(fun, successHandler, errorHandler);

},

//修改数据库版本信息

changeDBVersion: function(newVersion) {

var self = this, options = self.opts;

this.getDBConn();

options.dbObj.changeVersion(options.dbVersion, newVersion, null, errorFun, null);

},

//判断某表是否存在：表名、存在回调函数、不存在回调函数

isExitTable: function(tableName, exitFun, notExitFun) {

var self = this, options = self.opts,

sql = "select * from sqlite_master where type='table' and name = ?";

this.getDBConn();

options.dbObj.transaction(function(tx) {

tx.executeSql(sql, [tableName], function(transaction, result) {

if (result.rows.length > 0 && exitFun) {

exitFun.call();

} else if (result.rows.length <= 0 && notExitFun) {

notExitFun.call();

}

}, null);

});

},

//删除表数据：表名，删除成功回调函数

delTableData: function(tableName, callBackFun) {

var self = this, options = self.opts,

sql = 'delete form ?'

this.getDBConn();

options.dbObj.transaction(function(tx) {

tx.executeSql(sql, [tableName], callBackFun, null);

});

},

//删除表，删除成功回调函数

dropTable: function(tableName, callBackFun) {

var self = this, options = self.opts,

sql = 'drop table ?'

this.getDBConn();

options.dbObj.transaction(function(tx) {

tx.executeSql(sql, [tableName], callBackFun, null);

});

}

};

LOCAL.defaults = {

dbName: 'book',//数据库名

dbVersion: '1.0',//版本信息

dbDescription: 'just test',//描述

dbMaxSize: 1024*1024*1024,//最大值

dbObj: null

}

基于jquery