在Phonegap中访问预填充SQL Lite DB [英] Access pre-populate SQL Lite DB in Phonegap

问题描述

我创建了一个预先填充的SQL Lite数据库，并将其添加到我的应用中，如我的其他问题中所述。

现在，我如何使用这个DB？

我想我需要使用 openDatabase 但是如何让它打开我的数据库在/assets/data.db？

  var shortName ='data'; 
 var version ='1.0'; 
 var displayName ='data'; 
 var maxSize = 65535; 
 
 var db = openDatabase（shortName，version，displayName，maxSize）; 
 
 function errorHandler（transaction，error）
 {
 // error.message是一个人类可读的字符串。 
 // error.code是一个数字错误代码
 alert（'DB Error：'+ error.message +'（Code'+ error.code +'）'）; 
} 
 
 db.transaction（
 function（tx）{
 tx.executeSql（'SELECT street，numbers FROM streets'，[]，function（tx，结果）{
 //做一些更多的东西
 alert（我的第一个数据库查询完成执行！）; 
}，errorHandler）; 
} 
）; 
  

但是get sqlite返回：错误代码= 1，msg = ：streets 。

我使用 SQLite数据库浏览器，以确保表存在。您是否从 http://gauravstomar.blogspot.com/2011/08/prepopulate-sqlite-in-phonegap.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+GauravSTomarBootstrappingIntelligence+%28Gaurav+S+Tomar+%3A+Bootstrapping+智力％29rel =nofollow> http://gauravstomar.blogspot.com/2011/08/prepopulate-sqlite-in-phonegap.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+GauravSTomarBootstrappingIntelligence+% 28 Gaurav + S + Tomar +％3A + Bootstrapping + Intelligence％29 将您的数据库从资产文件夹复制到设备上的正确文件夹中？

I created a pre-populate SQL Lite DB an added it to my app as described in my other question.

Now, how can I use this DB?

I guess I need to use openDatabase but how do i make it open my DB in /assets/data.db?

I tried this:

        var shortName = 'data'; 
        var version = '1.0'; 
        var displayName = 'data'; 
        var maxSize = 65535;

        var db = openDatabase(shortName, version, displayName, maxSize); 

        function errorHandler(transaction, error)
        {
            // error.message is a human-readable string.
            // error.code is a numeric error code
            alert('DB Error: '+error.message+' (Code '+error.code+')');
        }

        db.transaction(
            function(tx) {
                tx.executeSql('SELECT street, numbers FROM streets', [], function(tx, results) {
                    // do some more stuff
                    alert("My first database query finished executing!");
                }, errorHandler);
            }
        );

But get sqlite returned: error code = 1, msg = no such table: streets.

I used the SQLite Database Browser to make sure the table exists. BTW: I don't have a 0000000000000001.db file.

解决方案

Did you add the Java code from http://gauravstomar.blogspot.com/2011/08/prepopulate-sqlite-in-phonegap.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+GauravSTomarBootstrappingIntelligence+%28Gaurav+S+Tomar+%3A+Bootstrapping+Intelligence%29 to copy your DB from the assets folder to the correct folder on your device?

这篇关于在Phonegap中访问预填充SQL Lite DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！