本文整理汇总了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);
}
)
}