HTML5 web SQL動態建立資料庫表，html5sql

HTML5 web SQL動態建立資料庫表，html5sql

smcsServices.service( 'VisitInstitutionCacheService', [ '$rootScope','$http', 'BaseURL','DataSourceService', function( $rootScope,$http,BaseURL,DataSourceService ) {var service = {synVisit: function (synvtdatetime) {$http({method: 'post',cache: false,url: BaseURL + 'SysCommonCodeTransform/findVisitInstitution.do',params: {datetime: synvtdatetime}}).success(function(response, status, headers, config) {try{var obj=response.VisitInstitution;var synobj=response.synvisitlist;//測試開發 以後最佳化為動態建立表var objstr=JSON.stringify(obj[0]);console.log("obj[0]===="+objstr);var objjson=JSON.parse(objstr);for(var key in objjson){console.log("objjson的key為===="+key);}//測試開發 以後最佳化為動態建立表var db = DataSourceService.getConnection();//console.log("synvisitlist synobj[0].syndatetime==="+synobj[0].syndatetime);//var db = openDatabase('mydb14', '1.0', 'Test DB', 6 * 1024 * 1024);db.transaction(function (tx) {tx.executeSql('CREATE Table If Not Exists VisitInstitution (id,AKB020, AKB021,AKA020,AKA101)');  tx.executeSql('DELETE FROM syncachecode WHERE syntablename="VisitInstitution"');tx.executeSql('INSERT INTO syncachecode (syntablename, syndatetime) VALUES ("VisitInstitution","'+synobj[0].syndatetime+'")');for(var i=0;i<obj.length;i++){var objAKB020=obj[i].AKB020+"";var objAKB021=obj[i].AKB021+"";var objAKA020=obj[i].AKA020+"";var objAKA101=obj[i].AKA101+"";if(synvtdatetime!="1970-01-01 00:00:00"){//初始化時刪除語句不執行。//同步資料時先刪除後插入。tx.executeSql('DELETE FROM VisitInstitution WHERE ID=?', [obj[i].ID]);}tx.executeSql('INSERT INTO VisitInstitution (id,AKB020, AKB021,AKA020,AKA101) VALUES ("'+obj[i].ID+'","'+objAKB020+'","'+objAKB021+'","'+objAKA020+'","'+objAKA101+'")');}});}catch(e){console.log(e.name  +   " :  "   +  e.message);}});},initSysCode: function () {var syndatetime="";//var db = openDatabase('mydb14', '1.0', 'Test DB', 6 * 1024 * 1024);var db = DataSourceService.getConnection();db.transaction(function (tx) {tx.executeSql('select * from syncachecode where syntablename="VisitInstitution" ', [], function (tx, results) {var len = results.rows.length; syndatetime=results.rows.item(0)['syndatetime'];console.log("前台資料庫CenterReimburs的同步時間為"+results.rows.item(0)['syndatetime']);service.synVisit(syndatetime);}, null);});}}return service;}]);

控制台：

obj[0]===={"AKA101":"11","AKB020":"02162001","AKB021":"西城區西長安街街道靈境社區衛生服務站","ID":"11010602162001","AKA020":"xcqxcajjdljsqwsfwz"}
objjson的key為====AKA101
objjson的key為====AKB020
objjson的key為====AKB021
objjson的key為====ID
objjson的key為====AKA020

web db 動態建立表

web SQL動態建立資料庫表，和後台資料庫同步。

第一次建表時mydatetime=“1970”年，以後的時後台返回的日期時間作為同步時間。

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。