sqlite selectSql

娃娃们,通过then的状态传递可以实现回调函数,结合上面老伙计给个方案:
function executeSelect (tableName, offset) {
var promise = new Promise((resolve, reject) => {
plus.sqlite.selectSql({
name: DB_NAME,
sql: select * from ${tableName} limit 10 offset ${offset},
success: function (res) {
resolve(res)
},
fail: function (e) {
console.log('selectSql failed: ' + JSON.stringify(e))
reject(e)
}
})
});
return promise;
}
调用方式:
executeSelect(tableName, offset).then(res => {
for(var i in res){
//这里是循环体,下面靠你们自己搞搞了
}
});

查询是异步请求：可以用Promise封装，类似下面：

export function executeSelect (tableName, offset) {  
  return new Promise((resolve, reject) => {  
    plus.sqlite.selectSql({  
      name: DB_NAME,  
      sql: `select * from ${tableName}  limit 10 offset ${offset}`,  
      success: function (res) {  
        resolve(res)  
      },  
      fail: function (e) {  
        console.log('selectSql failed: ' + JSON.stringify(e))  
        reject(e)  
      }  
    })  
  })  
}

我也想知道