<script src="../js/mui.min.js"></script>
<script type="text/javascript">
mui.init();
//plusReady,用来定义加载dom后的操作
//读取数据
mui.plusReady(function() {
var options = {
name:'db_note',
path: '_doc/db_note.db',
success: function(e){
console.log('openDatabase success!');
},
fail: function(e){
console.log('openDatabase failed: '+JSON.stringify(e));
}
};
//打开数据库
var dbOpen = plus.sqlite.isOpenDatabase(options);
if (dbOpen == false){
plus.sqlite.openDatabase(options);
}
var mui_content = document.querySelector(".mui-content");
plus.sqlite.selectSql({
name: 'db_note',
sql: 'select * from category', //此处报错
success: function (res) {
console.log('selectSql success: ');
var html = '<ul class="items">';
mui.each(res,function(index,item){
html += '<li><a data-id="'+index+'">' +item+ '</a></li>';
});
html += '</ul>';
mui_content.innerHTML = html;
},
fail: function (e) {
console.log('selectSql failed: '+JSON.stringify(e));
}
})
});
// 获取目标子页的id
mui('li').on('tap','a',function () {
var targetTab = this.getAttribute('data-id');
mui.openWindow({
url:'content.html',
extras:{
cid:targetTab //扩展参数
}
});
});
</script>
10:33:04.529 正在同步手机端程序文件...
10:33:05.075 同步手机端程序文件完成
10:33:05.277 正在启动HBuilder调试基座...
10:33:09.310 如手机上HBuilder调试基座未启动,请手动启动...
10:33:09.818 openDatabase success! at html/sign.html:37
10:33:09.838 selectSql failed: {"code":-1404,"message":"android.database.sqlite.SQLiteException: no such table: category (Sqlite code 1 SQLITE_ERROR): , while compiling: select * from category, (OS error - 2:No such file or directory),http://ask.dcloud.net.cn/article/282"} at html/sign.html:65
请教各位大牛指点:
数据库和数据表都是存在的,而且看提示,数据库已连接成功了
0 个回复