本地数据库存储JS类
//js调用本地数据库主JS文件var HD = {is_db : null,uid : null,ukey : null,shortName : 'hd',version : '1.0',displayName : 'hd_2345',maxSize : 100000,data : null,other : null,login : null,index : null,// 创建数据库initDatabase : function() {try {if (!window.openDatabase) {alert('Databases are not supported in this browser.');} else {DEMODB = openDatabase(this.shortName, this.version,this.displayName, this.maxSize);this.createUserTable();this.createMyWebSite();this.createMyApp();this.createCitySite();this.createMyFenlei();}} catch (e) {if (e == 2) {// Version number mismatch.} else {}return;}},createUserTable : function() {DEMODB.transaction(function(transaction) {var sql = "CREATE TABLE IF NOT EXISTS hd_users("+ "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"+ "uid INTEGER NOT NULL,passid INTEGER NOT NULL,uname TEXT NOT NULL,ukey TEXT NOT NULL,"+ "uemail TEXT NULL,city TEXT NULL)";transaction.executeSql(sql, [], HD.nullDataHandler,HD.errorHandler);});},createMyWebSite : function() {DEMODB.transaction(function(transaction) {var sql = "CREATE TABLE IF NOT EXISTS hd_users_website("+ "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"+ "uid INTEGER NOT NULL,content TEXT NULL)";transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},createMyApp : function() {DEMODB.transaction(function(transaction) {var sql = "CREATE TABLE IF NOT EXISTS hd_users_app("+ "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"+ "uid INTEGER NOT NULL,content TEXT NULL)";transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},createMyFenlei:function(){DEMODB.transaction(function(transaction) {var sql = "CREATE TABLE IF NOT EXISTS hd_users_fenlei("+ "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"+ "uid INTEGER NOT NULL,content TEXT NULL)";transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},createCitySite : function() {DEMODB.transaction(function(transaction) {var sql = "CREATE TABLE IF NOT EXISTS hd_city_site("+ "id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"+ "uid INTEGER NULL,content TEXT NULL)";transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},errorHandler : function(transaction, error) {// Error is a human-readable string.return false;},nullDataHandler : function() {},insert : function(data, table_name) {DEMODB.transaction(function(transaction) {var sql_addsub_name = '';var sql_add_var_name = "";for ( var k in data) {sql_addsub_name += " `" + k + "` ,";sql_add_var_name += " '" + data[k] + "' ,";}sql_addsub_name = sql_addsub_name.substr(0,(sql_addsub_name.length - 1));sql_add_var_name = sql_add_var_name.substr(0,(sql_add_var_name.length - 1));var sqlAdd = "INSERT INTO " + table_name + " ( " + sql_addsub_name+ ") VALUES (" + sql_add_var_name + ")";// 输出sql语句transaction.executeSql(sqlAdd, [], HD.nullDataHandler,HD.errorHandler);});},update : function(where, data, table_name) {DEMODB.transaction(function(transaction) {var sql = "";var edit_sql = "";for ( var k in data) {edit_sql += "`" + k + "` = " + "'" + data[k] + "' ,";}edit_sql = edit_sql.substr(0, (edit_sql.length - 1));sql = "UPDATE `" + table_name + "` SET " + edit_sql + " WHERE "+ where;transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},deletedata : function(table_name, where) {DEMODB.transaction(function(transaction) {var sqlDel = "DELETE FROM " + table_name + " WHERE " + where;transaction.executeSql(sqlDel, [], HD.nullDataHandler,HD.errorHandler);});},deleteall : function(table_name) {DEMODB.transaction(function(transaction) {var sql = 'DELETE FROM ' + table_name;transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},query : function(sql) {DEMODB.transaction(function(transaction) {transaction.executeSql(sql, [], HD.dataSelectHandler,HD.errorHandler);});},dropTable : function(table_name) {DEMODB.transaction(function(transaction) {var sql = "DROP TABLE " + table_name;transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});},dropDatabase : function(database) {DEMODB.transaction(function(transaction) {var sql = "DROP DATABSE " + database;transaction.executeSql(sql, [], HD.nullDataHandler, HD.errorHandler);});}};HD.initDatabase();?