var DB = (function() {
var database = openDatabase('JackDms','1.0','bendi',20971520);
var tables = {
barcode:'create table if not exists barcode(vbeln text,salesOrderItemId text,matnr text,barcode text)',
purchaseBarcode:'create table if not exists purchaseBarcode(vbeln text,matnr text,barcode text)',
client:'create table if not exists client(barcode text)',
salesReturn:'create table if not exists salesReturn(barcode text)'
};
return {
executeQuery: function(tablename,sql,success){
database.transaction(function(tx){
//如果数据表不存在,则创建数据表
tx.executeSql(tables[tablename],[]);
//执行sql
tx.executeSql(sql,[],function(tx,resultSet){
var rows = resultSet.rows;
//console.log('查询sql:' + sql);
//alert('获取数据条数:' + JSON.stringify(rows.length));
success(rows);
},function(tx,error){
console.log(JSON.stringify(error));
});
});
},
updateQuery: function(tablename,sql,array,onSuccess){
database.transaction(function(tx){
tx.executeSql(tables[tablename],[]);
tx.executeSql(sql,array,function(tx,resultSet){
var rows = resultSet.rows;
onSuccess(rows);
},function(tx,error){
console.log(JSON.stringify(error));
});
});
},
delectQuery: function(tablename,sql,array,noSuccess){
database.transaction(function(tx){
tx.executeSql(tables[tablename],[]);
tx.executeSql(sql,array,function(tx,resultSet){
var rows = resultSet.rows;
noSuccess(rows);
},function(tx,error){
console.log(JSON.stringify(error));
});
});
}
}
}());
ChineGuo (作者)
同一套代码,HB打包出来可以使用,HBX打包出来不能使用。没办法
2020-08-24 13:04
ChineGuo (作者)
详情可以看代码示例,附件代码上传不上去
2020-08-24 13:11