本文整理匯總了TypeScript中@ionic-native/sqlite.SQLiteObject.executeSql方法的典型用法代碼示例。如果您正苦於以下問題：TypeScript SQLiteObject.executeSql方法的具體用法？TypeScript SQLiteObject.executeSql怎麽用？TypeScript SQLiteObject.executeSql使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類@ionic-native/sqlite.SQLiteObject的用法示例。
在下文中一共展示了SQLiteObject.executeSql方法的9個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的TypeScript代碼示例。
示例1: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== Select tb_stepsumassure success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let objMs: Array<StepSumAssureM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let objM: StepSumAssureM = result.rows.item(index);
objMs.push(objM);
}
responseM.data = objMs;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_stepsumassure error " + error.message);
reject(error);
}
)
}示例2: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== Select tb_packagedetail success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let objMs: Array<PackageDetailM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let objM: PackageDetailM = result.rows.item(index);
// console.log("CCCCCCCCC " + JSON.stringify(objM));
objMs.push(objM);
}
responseM.data = objMs;
responseM.size = objMs.length;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_packagedetail error " + error.message);
reject(error);
}
)
}示例3: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== Select tb_pmrate success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let pmrateMs: Array<PmrateM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let pmrateM: PmrateM = result.rows.item(index);
pmrateMs.push(pmrateM);
}
responseM.data = pmrateMs;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_pmrate error " + JSON.stringify(error));
reject(error);
}
)
}示例4: resolve
this.openDatabase().then((db: SQLiteObject) => {
db.executeSql(query, values).then(() => {
resolve();
}).catch((err) => {
reject("Error while updating record!");
});
}).catch((err) => {示例5: function
this.openDatabase().then((db: SQLiteObject) => {
db.executeSql(query, []).then((result) => {
for(let i = 0; i < result.rows.length; i++)
tables.push(result.rows.item(i).tbl_name);
db.transaction(function(tx){
for(let tblName of tables){
if(tblName.toLowerCase() === "MergeIdentity".toLowerCase()){
tx.executeSql("UPDATE MergeIdentity SET MergeUpdate=0 WHERE MergeUpdate > 0;", [], null, null);
}
if(tblName.toLowerCase() !== "MergeDelete".toLowerCase() && tblName.toLowerCase() !== "MergeIdentity".toLowerCase()){
query = "SELECT sql FROM sqlite_master WHERE type='trigger' AND name LIKE 'trMergeUpdate_" + tblName + "'";
let updTriggerSQL = null;
tx.executeSql(query, [],
function(transaction, result) {
updTriggerSQL = result.rows.item(0)[0];
if (updTriggerSQL != null){
tx.executeSql("DROP trigger trMergeUpdate_" + tblName, [], null, null);
tx.executeSql("UPDATE " + tblName + " SET MergeUpdate=0 WHERE MergeUpdate > 0;", [], null, null);
tx.executeSql(updTriggerSQL, [], null, null);
}
}, function(transaction, error){
});
}
}
tx.executeSql("DELETE FROM MergeDelete;",[],null,null);
}).then(() => {
resolve();
}).catch((err) => {
reject("Error while clearing local markers");
});
}).catch((err) => {
reject("Error while getting tables from local database!");
});
}).catch((err) => {示例6: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== SELECT Agent SUCCESS size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
//console.log("BBBB = " + JSON.stringify(result.rows.item()));
if (result.rows.length > 0) {
let agents: Array<AgentModel> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
agents.push(result.rows.item(index));
}
responseM.data = agents;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("===== SELECT Agent ERROR " + error.message);
reject(error);
}
)
}示例7: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
responseM.size = result.rows.length;
responseM.status = 0;
let objMs: Array<ExtendedM> = [];
if (result.rows.length > 0) {
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let objM: ExtendedM = result.rows.item(index);
objMs.push(objM);
}
//console.log("----------- ExtendedService : search objMs = " + JSON.stringify(objMs));
//console.log("----------- ExtendedService : search objMs length = " + objMs.length);
responseM.data = objMs;
resolve(responseM);
}
else {
responseM.data = objMs;
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_extended error " + JSON.stringify(error));
reject(error);
}
)
}示例8: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let subDistrictMs: Array<ProvinceModel> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
subDistrictMs.push(result.rows.item(index));
}
responseM.data = subDistrictMs;
resolve(responseM);
}
else {
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("===== Select tb_province error " + error.message);
reject(error);
}
)
}示例9: resolve
(connection: SQLiteObject) => {
connection.executeSql(sql, paramSQL).then(
(result) => {
//console.log("===== Select tb_coupon success size " + result.rows.length);
responseM.size = result.rows.length;
responseM.status = 0;
if (result.rows.length > 0) {
let objMs: Array<CouponM> = [];
var len = result.rows.length;
for (var index = 0; index < len; index++) {
let objM: CouponM = result.rows.item(index);
objMs.push(objM);
}
//console.log("===== Select tb_coupon success objMs " + JSON.stringify(objMs));
responseM.size = objMs.length;
responseM.data = objMs;
resolve(responseM);
}
else {
let objMs: Array<CouponM> = [];
responseM.data = objMs;
responseM.size = 0;
responseM.status = 0;
resolve(responseM);
}
}
, (error) => {
console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_coupon error " + JSON.stringify(error));
reject(error);
}
)
}