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] + "' ,";
本文链接：http://www.cxybl.com/html/wyzz/JavaScript_Ajax/20130716/39101.html
