如何阅读和放大器;在内部数据库与PhoneGap的写？ [英] How to Read & Write in Internal DataBase with PhoneGap?

问题描述

我在资产一个内部SQLite数据库文件夹在我所存储的100用户名和放大器;相应的密码，我该如何通过PhoneGap的访问它？
我读

• 的http://docs.phonegap.com/en/1.6.1/cordova_storage_storage.md.html#Storage

• <一个href="http://stackoverflow.com/questions/9171662/connecting-to-sqlite-database-from-phonegap-html-file-for-android">connecting从PhoneGap的html文件，对于Android

SQLite数据库

• 的http://wiki.phonegap.com/w/page/16494756/Adding-SQL-Database-support-to-your-iPhone-App

  我还是没能弄清楚如何连接到我的内部数据库是已经创建，
  数据库名= USERAUTH
  表名=章
  参数= usrnm，PSW < BR> 任何答案是非常鼓励
  
  的我使用该此处
  
  

解决方案

  / **
 *创建/打开到数据库的连接
 * /
DB.openDB =功能（）{
    尝试 {
        如果（！window.openDatabase）{
            //警报（无法打开数据库！'）;
        } 其他 {
            VAR短名称='DB_NAME';
            变种版本='1.0';
            VAR显示名='DBNAME';
            VAR MAXSIZE =（DEVICE_TYPE == DEVICE_ANDROID || DEVICE_TYPE == DEVICE_ANDROID_TAB）？ 5242880：1000000; //// 819200; // 65536; //以字节为单位//增加支持Android // 163840; //
            this.vocabDB = window.openDatabase（短名称，版本，显示名，MAXSIZE，this.DBCreated）;
            this.DBSupported = TRUE;
        }
    }赶上（五）{
        //console.log("DB错误处理code到这里）。
        //console.log(e）;
        返回;
    }
}
 

I have an internal SQLite DB under "Assets" Folder in which i have stored 100 usernames & corresponding Passwords, How do i access it via phoneGap.?
I have read

• http://docs.phonegap.com/en/1.6.1/cordova_storage_storage.md.html#Storage

• connecting to sqlite database from phonegap html file for android

• http://wiki.phonegap.com/w/page/16494756/Adding-SQL-Database-support-to-your-iPhone-App

  Am still not able to figure out How to connect to my internal DB which is already Created,
  dbname = userauth
  Tablename = reg
  parameters = usrnm , psw
  Any Answer is Highly Encouraged
  
  Am using this here.
  
  

解决方案

/**
 * Creates / Opens a connection to DB
 */
DB.openDB = function() {
    try {
        if (!window.openDatabase) {
            //alert('Cannot open database!');
        } else {
            var shortName = 'db_name';
            var version = '1.0';
            var displayName = 'DBNAME';
            var maxSize = (DEVICE_TYPE == DEVICE_ANDROID || DEVICE_TYPE == DEVICE_ANDROID_TAB) ? 5242880 : 1000000; ////819200; //65536; // in bytes // increased to support Android//163840; // 
            this.vocabDB = window.openDatabase(shortName, version, displayName, maxSize, this.DBCreated);
            this.DBSupported = true;
        }
    } catch(e) {
        //console.log("DB Error handling code goes here.");
        //console.log(e);
        return;
    }
}

这篇关于如何阅读和放大器;在内部数据库与PhoneGap的写？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！