81,094
社区成员
发帖
与我相关
我的任务
分享
在鸿蒙OS中,我想基于Stage模型,利用关系型数据库的基础代码 与本地的SQLite数据库相连,但是数据库连接没有问题 查询时结果集没有值,球球各位大佬解惑,可能问题很简单 ,我会女里成长的!!
query(device_id: string, callback: Function, isAll: boolean = true) {
let predicates = new data_rdb.RdbPredicates(CommonConstants.TH_STATE_TABLE.tableName);
if (!isAll) {
predicates.equalTo('device_id', device_id);
}
this.th_state.query(predicates, function (resultSet) {
let count = resultSet.rowCount;
if (count === 0 || typeof count === 'string') {
console.log(`${CommonConstants.TABLE_TAG}` + 'Query no results!');
callback([]);
} else {
resultSet.goToFirstRow();
const result = [];
for (let i = 0; i < count; i++) {
let tmp: th_state = { _id: 0, device_id: '', SW: '', state: '', time: '' };
tmp._id = resultSet.getDouble(resultSet.getColumnIndex('_id'));
tmp.device_id = resultSet.getString(resultSet.getColumnIndex('device_id'));
tmp.SW = resultSet.getString(resultSet.getColumnIndex('SW'));
tmp.state = resultSet.getString(resultSet.getColumnIndex('state'));
tmp.time = resultSet.getString(resultSet.getColumnIndex('time'));
result[i] = tmp;
resultSet.goToNextRow();
}
console.log("111111f");
callback(result);
}
});
}
报错结果是这样: