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