You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
52 lines
1.2 KiB
52 lines
1.2 KiB
const dbName = 'test'
|
|
const dbPath = '_doc/test.db'
|
|
|
|
export default {
|
|
createDatabase(){
|
|
let isOpen = plus.sqlite.isOpenDatabase({
|
|
name: dbName,
|
|
path: dbPath
|
|
});
|
|
if(isOpen){
|
|
return Promise.resolve();
|
|
}
|
|
return new Promise((resolve,reject)=>{
|
|
plus.sqlite.openDatabase({
|
|
name: dbName,
|
|
path: dbPath,
|
|
success: resolve,
|
|
fail: reject
|
|
});
|
|
});
|
|
},
|
|
selectSql(sql){
|
|
console.log('查询',sql);
|
|
return new Promise((resolve, reject)=>{
|
|
plus.sqlite.selectSql({
|
|
name: dbName,
|
|
sql,
|
|
success: resolve,
|
|
fail: reject
|
|
});
|
|
})
|
|
},
|
|
|
|
executeSql(sql){
|
|
// console.log('执行',sql);
|
|
return new Promise((resolve, reject)=>{
|
|
plus.sqlite.executeSql({
|
|
name: dbName,
|
|
sql,
|
|
success: resolve,
|
|
fail: reject
|
|
});
|
|
})
|
|
}
|
|
}
|
|
// adb -s emulator-5554 shell
|
|
// cd /storage/emulated/0/Android/data/io.dcloud.HBuilder/apps/HBuilder/doc
|
|
// sqlite3 test.db
|
|
|
|
// DROP TABLE IF EXISTS chat_groups;删除表chat_groups代表你的表名
|
|
// DROP TABLE IF EXISTS getSystemInfo;
|
|
// adb pull /storage/emulated/0/Android/data/io.dcloud.HBuilder/apps/HBuilder/doc/<数据库文件名> . 从雷电模拟器中里拉取你的数据库到本地运行
|