js 本地存储:本地数据库存储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] + "' ,"; 本文链接http://www.cxybl.com/html/wyzz/JavaScript_Ajax/20130716/39101.html