4***@qq.com
4***@qq.com
  • 发布:2020-04-16 10:36
  • 更新:2020-04-16 10:36
  • 阅读:1000

html5+ SQLite提示数据表不存在

分类:HTML5+

<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

请教各位大牛指点:
数据库和数据表都是存在的,而且看提示,数据库已连接成功了

2020-04-16 10:36 负责人:无 分享
已邀请:

该问题目前已经被锁定, 无法添加新回复