- 浏览: 127003 次
- 性别:
- 来自: 北京
最新评论
-
MIMIko:
怎么显示少了一个文件呢?跑步起来
Sencha Touch 2 Menu -
daydayupx:
有完整的代码吗?1240500584@qq.com
Sencha Touch Carousel -
JAVA一小菜:
您好,我想问下,为什么我从官网下载下来的sencha touc ...
Sencha Tuch Spket1.6.23 IDE 配置 -
zengdingshan:
请回复zdsxsc@163.com
Sencha Touch 2 Menu -
zengdingshan:
你好,这个demo运行不起来,请问有什么特殊配置吗
Sencha Touch 2 Menu
插件下载地址: https://github.com/ApplicationCraft/PGSQLitePlugin
在 plugins.xml 加上
Sencha Touch 调用
忘了说了 我用的是phonegap 1.9
package com.sai.plugin; import org.json.JSONArray; import org.json.JSONObject; import android.content.Context; import org.apache.cordova.api.Plugin; import org.apache.cordova.api.PluginResult; import android.os.Environment; import android.os.StatFs; import android.util.Log; import android.content.ContentValues; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import java.io.OutputStream; import java.util.Hashtable; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; public class PGSQLitePlugin extends Plugin { /** List Action */ private static final String ACTION_EXECUTE="backgroundExecuteSql"; private static final String ACTION_OPEN="open"; private static final String ACTION_CLOSE="close"; private static final String ACTION_INSERT="insert"; private static final String ACTION_DELETE="delete"; private static final String ACTION_UPDATE="update"; private static final String ACTION_QUERY="query"; private static final String ACTION_REMOVE="remove"; private static final String ACTION_BATCHEXECUTE="backgroundExecuteSqlBatch"; private static final String ACTION_TRANSACTION="transactionExecuteSqlBatch"; private static final String USE_INTERNAL="internal"; private static final String USE_EXTERNAL="external"; private Hashtable<String,SQLiteDatabase> openDbs = new Hashtable<String,SQLiteDatabase>(); @Override public PluginResult execute(String action, JSONArray data, String callbackId) { Log.e("PGSQLitePlugin", "Plugin Called"); PluginResult result = null; if (action.equals(PGSQLitePlugin.ACTION_EXECUTE)) { result = rawQuery(data); } else if (action.equals(PGSQLitePlugin.ACTION_TRANSACTION)) { result = batchRawQuery(data, true); } else if (action.equals(PGSQLitePlugin.ACTION_INSERT)) { result = insertQuery(data); } else if (action.equals(PGSQLitePlugin.ACTION_DELETE)) { result = deleteQuery(data); } else if (action.equals(PGSQLitePlugin.ACTION_UPDATE)) { result = updateQuery(data); } else if (action.equals(PGSQLitePlugin.ACTION_QUERY)) { result = query(data); } else if (action.equals(PGSQLitePlugin.ACTION_OPEN)) { result = openDatabese(data); } else if (action.equals(PGSQLitePlugin.ACTION_CLOSE)) { result = closeDatabese(data); } else if (action.equals(PGSQLitePlugin.ACTION_REMOVE)) { result = remove(data); } else if (action.equals(PGSQLitePlugin.ACTION_BATCHEXECUTE)) { result = batchRawQuery(data); } else { result = new PluginResult(PluginResult.Status.NO_RESULT); Log.e("PGSQLitePlugin", "Invalid action : "+action+" passed"); } return result; } private SQLiteDatabase getDb(String path){ SQLiteDatabase db = (SQLiteDatabase)openDbs.get(path); return db; } private String getStringAt(JSONArray data, int position, String dret){ String ret = getStringAt(data, position); return (ret == null) ? dret : ret; } private String getStringAt(JSONArray data, int position){ String ret = null; try{ ret = data.getString(position); //JSONArray convert JavaScript undefined|null to string "null", fix it ret = ( ret.equals("null") ) ? null : ret; } catch(Exception er){}; return ret; } private JSONArray getJSONArrayAt(JSONArray data, int position){ JSONArray ret = null; try{ ret = (JSONArray)data.get(position); } catch(Exception er){}; return ret; } private JSONObject getJSONObjectAt(JSONArray data, int position){ JSONObject ret = null; try{ ret = (JSONObject)data.get(position); } catch(Exception er){}; return ret; } private PluginResult query(JSONArray data){ PluginResult result = null; try { Log.e("PGSQLitePlugin", "query"); String dbName = data.getString(0); String tableName = data.getString(1); JSONArray columns = getJSONArrayAt(data, 2); String where = getStringAt(data, 3); JSONArray whereArgs = getJSONArrayAt(data, 4); String groupBy = getStringAt(data, 5); String having = getStringAt(data, 6); String orderBy = getStringAt(data, 7); String limit = getStringAt(data, 8); String[] _whereArgs = null; if (whereArgs != null){ int vLen = whereArgs.length(); _whereArgs = new String[vLen]; for (int i = 0; i < vLen; i++){ _whereArgs[i] = whereArgs.getString(i); } } String[] _columns = null; if (columns != null){ int vLen = columns.length(); _columns = new String[vLen]; for (int i = 0; i < vLen; i++){ _columns[i] = columns.getString(i); } } SQLiteDatabase db = getDb(dbName); // if (db == null){ // db=getDb("www/db/" + dbName); // } Cursor cs = db.query(tableName, _columns, where, _whereArgs, groupBy, having, orderBy, limit); if (cs != null){ JSONObject res = new JSONObject(); JSONArray rows = new JSONArray(); if (cs.moveToFirst()) { String[] names = cs.getColumnNames(); int namesCoint = names.length; do { JSONObject row = new JSONObject(); for (int i = 0; i < namesCoint; i++){ String name = names[i]; row.put(name, cs.getString(cs.getColumnIndex( name ))); } rows.put( row ); } while (cs.moveToNext()); } res.put("rows", rows); cs.close(); Log.e("PGSQLitePlugin", "query::count="+rows.length()); result = new PluginResult(PluginResult.Status.OK, res); } else { result = new PluginResult(PluginResult.Status.ERROR, "Error execute query"); } } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult updateQuery(JSONArray data){ PluginResult result = null; try { Log.e("PGSQLitePlugin", "updateQuery"); String dbName = data.getString(0); String tableName = data.getString(1); JSONObject values = (JSONObject)data.get(2); String where = getStringAt(data, 3, "1"); JSONArray whereArgs = getJSONArrayAt(data, 4); String[] _whereArgs = null; if (whereArgs != null){ int vLen = whereArgs.length(); _whereArgs = new String[vLen]; for (int i = 0; i < vLen; i++){ _whereArgs[i] = whereArgs.getString(i); } } JSONArray names = values.names(); int vLenVal = names.length(); ContentValues _values = new ContentValues(); for (int i = 0; i < vLenVal; i++){ String name = names.getString(i); _values.put( name, values.getString( name ) ); } SQLiteDatabase db = getDb(dbName); long count = db.update(tableName, _values, where, _whereArgs); result = new PluginResult(PluginResult.Status.OK, count); Log.e("PGSQLitePlugin", "updateQuery::count=" + count); } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult deleteQuery(JSONArray data){ PluginResult result = null; try { Log.e("PGSQLitePlugin", "deleteQuery"); String dbName = data.getString(0); String tableName = data.getString(1); String where = getStringAt(data, 2); JSONArray whereArgs = getJSONArrayAt(data, 3); String[] _whereArgs = null; if (whereArgs != null){ int vLen = whereArgs.length(); _whereArgs = new String[vLen]; for (int i = 0; i < vLen; i++){ _whereArgs[i] = whereArgs.getString(i); } } SQLiteDatabase db = getDb(dbName); long count = db.delete(tableName, where, _whereArgs); result = new PluginResult(PluginResult.Status.OK, count); Log.e("PGSQLitePlugin", "deleteQuery::count=" + count); } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult insertQuery(JSONArray data){ PluginResult result = null; try { Log.e("PGSQLitePlugin", "insertQuery"); String dbName = data.getString(0); String tableName = data.getString(1); JSONObject values = (JSONObject)data.get(2); JSONArray names = values.names(); int vLen = names.length(); SQLiteDatabase db = getDb(dbName); ContentValues _values = new ContentValues(); for (int i = 0; i < vLen; i++){ String name = names.getString(i); _values.put( name, values.getString( name ) ); } long id = db.insert(tableName, null, _values); if (id == -1){ result = new PluginResult(PluginResult.Status.ERROR, "Insert error"); } else { result = new PluginResult(PluginResult.Status.OK, id); } Log.e("PGSQLitePlugin", "insertQuery::id=" + id); } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult batchRawQuery(JSONArray data){ return batchRawQuery(data, false); } private PluginResult batchRawQuery(JSONArray data, boolean transaction){ PluginResult result = null; SQLiteDatabase db = null; try { Log.e("PGSQLitePlugin", "batchRawQuery"); String dbName = data.getString(0); db = getDb(dbName); JSONArray batch = (JSONArray)data.get(1); int len = batch.length(); if (transaction){ db.beginTransaction(); } for (int i = 0; i < len; i++){ JSONObject el = (JSONObject)batch.get(i); String type = el.getString("type"); JSONArray args = (JSONArray)el.get("opts"); int len1 = args.length(); JSONArray rData = new JSONArray(); rData.put(dbName); for (int j = 0; j < len1; j++){ rData.put(args.get(j) ); } Log.e("PGSQLitePlugin", "batchRawQuery::type="+type); if (type.equals("raw")){ result = rawQuery(rData); } else if (type.equals("insert") ){ result = insertQuery(rData); } else if (type.equals("del") ){ result = deleteQuery(rData); } else if (type.equals("query") ){ result = query(rData); } else if (type.equals("update" ) ){ result = updateQuery(rData); } if (result == null ){ result = new PluginResult(PluginResult.Status.ERROR, "Unknow action"); if (transaction){ db.endTransaction(); } break; } else if (result.getStatus() != 1){ if (transaction){ db.endTransaction(); } result = new PluginResult(PluginResult.Status.ERROR, result.getMessage()); break; } } if (transaction){ db.setTransactionSuccessful(); db.endTransaction(); } } catch (Exception e) { if (db != null && db.inTransaction()){ db.endTransaction(); } Log.e("PGSQLitePlugin", "error batch" + e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult rawQuery(JSONArray data){ PluginResult result = null; try { String dbName = data.getString(0); String sql = data.getString(1); SQLiteDatabase db = getDb(dbName); Log.e("PGSQLitePlugin", "rawQuery action::sql="+sql); Cursor cs = db.rawQuery(sql, new String [] {}); JSONObject res = new JSONObject(); JSONArray rows = new JSONArray(); if (cs != null && cs.moveToFirst()) { String[] names = cs.getColumnNames(); int namesCoint = names.length; do { JSONObject row = new JSONObject(); for (int i = 0; i < namesCoint; i++){ String name = names[i]; row.put(name, cs.getString(cs.getColumnIndex( name ))); } rows.put( row ); } while (cs.moveToNext()); cs.close(); } res.put("rows", rows); Log.e("PGSQLitePlugin", "rawQuery action::count="+rows.length()); result = new PluginResult(PluginResult.Status.OK, res); } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult remove(JSONArray data){ PluginResult result = null; JSONObject ret = new JSONObject(); try { Log.i("PGSQLitePlugin", "remove action"); ret.put("status", 1); String dbName = data.getString(0); File dbFile=null; SQLiteDatabase db = getDb(dbName); if (db != null){ db.close(); openDbs.remove(dbName); } dbFile = new File( ((Context)this.ctx).getExternalFilesDir(null), dbName); if (!dbFile.exists()){ dbFile = ((Context)this.ctx).getDatabasePath(dbName); if (!dbFile.exists()){ ret.put("message", "Database not exist"); ret.put("status", 0); result = new PluginResult(PluginResult.Status.ERROR, ret); } else { if (dbFile.delete()){ Log.i("PGSQLitePlugin", "remove action::remove from internal"); result = new PluginResult(PluginResult.Status.OK); } else { ret.put("message", "Can't remove db"); ret.put("status", 2); result = new PluginResult(PluginResult.Status.ERROR, ret); } } } else { if (dbFile.delete()){ result = new PluginResult(PluginResult.Status.OK); Log.i("PGSQLitePlugin", "remove action::remove from sdcard"); } else { ret.put("message", "Can't remove db"); ret.put("status", 2); result = new PluginResult(PluginResult.Status.ERROR, ret); } } } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, ret); } return result; } private PluginResult openDatabese(JSONArray data){ PluginResult result = null; try { String storage = PGSQLitePlugin.USE_INTERNAL; String dbName = data.getString(0); JSONObject options = getJSONObjectAt(data, 1); if (options != null){ storage = options.getString("storage"); } if (storage.equals(PGSQLitePlugin.USE_EXTERNAL) && !Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED)){ return new PluginResult(PluginResult.Status.ERROR, "SDCard not mounted"); } Log.i("PGSQLitePlugin", "open action::storage"+storage); String _dbName = null; SQLiteDatabase db = getDb(dbName); File dbFile=null; if (Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED) && !storage.equals(PGSQLitePlugin.USE_INTERNAL) ) { if (storage.equals(PGSQLitePlugin.USE_EXTERNAL)){ dbFile = new File(((Context)this.ctx).getExternalFilesDir(null), dbName); } else { dbFile = ((Context)this.ctx).getDatabasePath(dbName); if (!dbFile.exists()){ dbFile = new File(((Context)this.ctx).getExternalFilesDir(null), dbName); if (!dbFile.exists()){ StatFs stat = new StatFs("/data/"); long blockSize = stat.getBlockSize(); long availableBlocks = stat.getBlockCount(); long size = blockSize * availableBlocks; if (size >= 1024*1024*1024){ //more then 1 Gb dbFile = ((Context)this.ctx).getDatabasePath(dbName); } else { dbFile = new File(((Context)this.ctx).getExternalFilesDir(null), dbName); } Log.i("blockSize * availableBlocks", Long.toString(size) ); } } } } else{ dbFile = ((Context)this.ctx).getDatabasePath(dbName); } _dbName = dbFile.getPath(); Log.i("PGSQLitePlugin", "open action::"+dbName); int status = 0; if (db == null){ if (!dbFile.exists()){ status = 1; try{ InputStream assetsDB = this.ctx.getActivity().getAssets().open( "www/db/" + dbName ); OutputStream dbOut = new FileOutputStream( _dbName ); byte[] buffer = new byte[1024]; int length; while ((length = assetsDB.read(buffer))>0){ dbOut.write(buffer, 0, length); } dbOut.flush(); dbOut.close(); assetsDB.close(); status = 2; } catch(Exception e){ Log.e("PGSQLitePlugin", "error get db from assets=" + e.getMessage()); } } db = SQLiteDatabase.openDatabase(_dbName, null, SQLiteDatabase.CREATE_IF_NECESSARY ); openDbs.put(dbName, db); } JSONObject ret = new JSONObject(); ret.put( "status", status ); ret.put( "version", db.getVersion() ); ret.put( "systemPath", _dbName ); result = new PluginResult(PluginResult.Status.OK, ret); } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } private PluginResult closeDatabese(JSONArray data){ PluginResult result = null; try { Log.e("PGSQLitePlugin", "close action"); String dbName = data.getString(0); SQLiteDatabase db = getDb(dbName); if (db != null){ db.close(); openDbs.remove(dbName); } result = new PluginResult(PluginResult.Status.OK); } catch (Exception e) { Log.e("PGSQLitePlugin", e.getMessage()); result = new PluginResult(PluginResult.Status.ERROR, e.getMessage()); } return result; } }
在 plugins.xml 加上
<plugin name="PGSQLitePlugin" value="com.sai.plugin.PGSQLitePlugin"/>
(function(gap) { var isAndroid = (/android/gi).test(navigator.appVersion); if (!isAndroid){ return; } var root = this; root.PGSQLitePlugin = (function() { PGSQLitePlugin.prototype.openDBs = {}; function PGSQLitePlugin(dbPath, success, error, options) { this.dbPath = dbPath; if (!dbPath) { throw new Error("Cannot create a PGSQLitePlugin instance without a dbPath"); } this.open(success, error, options); } PGSQLitePlugin.prototype.open = function(success, error, options) { var self = this; if (!(this.dbPath in this.openDBs)) { gap.exec(function(result){ self.openDBs[self.dbPath] = { self : self, result : result}; if (typeof success == "function"){ success(result, self); } }, error, 'PGSQLitePlugin', 'open', [this.dbPath, options]) } else { if (typeof success == "function"){ success(self.openDBs[self.dbPath].result, self.openDBs[self.dbPath].self); } } }; PGSQLitePlugin.prototype.close = function(success, error) { if (this.dbPath in this.openDBs) { delete this.openDBs[this.dbPath]; return gap.exec(success, error, 'PGSQLitePlugin', 'close', [this.dbPath]); } }; PGSQLitePlugin.prototype.remove = function(dbName, success, error) { PGSQLitePlugin.remove(dbName, success, error); }; PGSQLitePlugin.prototype.executeSql = function(sql, success, error) { return gap.exec(success, error, 'PGSQLitePlugin', 'backgroundExecuteSql', [this.dbPath, sql]); }; PGSQLitePlugin.prototype.insert = function(table, values, success, error) { return gap.exec(success, error, 'PGSQLitePlugin', 'insert', [this.dbPath, table, values]); }; PGSQLitePlugin.prototype.del = function(table, where, whereArgs, success, error) { return gap.exec(success, error, 'PGSQLitePlugin', 'delete', [this.dbPath, table, where, whereArgs]); }; PGSQLitePlugin.prototype.update = function(table, values, where, whereArgs, success, error) { return gap.exec(success, error, 'PGSQLitePlugin', 'update', [this.dbPath, table, values, where, whereArgs]); }; PGSQLitePlugin.prototype.query = function(table, columns, where, whereArgs, groupBy, having, orderBy, limit, success, error) { return gap.exec(success, error, 'PGSQLitePlugin', 'query', [this.dbPath, table, columns, where, whereArgs, groupBy, having, orderBy, limit]); }; PGSQLitePlugin.prototype.transaction = function(fn, success, error) { var t = new root.PGSQLitePluginTransaction(this.dbPath, this); try{ fn(t); return t.complete(success, error); } catch(er){ if (error) error(er); } }; PGSQLitePlugin.remove = function(dbName, success, error) { delete PGSQLitePlugin.prototype.openDBs[dbName]; return gap.exec(success, error, 'PGSQLitePlugin', 'remove', [dbName]); }; return PGSQLitePlugin; })(); root.PGSQLitePluginTransaction = (function() { function PGSQLitePluginTransaction(dbPath, db) { this.dbPath = dbPath; this.executes = []; this.db = db; } PGSQLitePluginTransaction.prototype.executeSql = function(sql) { this.executes.push( { opts : [sql], type : "raw" } ); }; PGSQLitePluginTransaction.prototype.insert = function(table, values) { this.executes.push({opts : [table, values] , type : "insert"}); }; PGSQLitePluginTransaction.prototype.del = function(table, where, whereArgs) { this.executes.push({opts : [table, where, whereArgs], type : "del"}); }; PGSQLitePluginTransaction.prototype.query = function(table, columns, where, whereArgs, groupBy, having, orderBy, limit) { this.executes.push({opts : [table, columns, where, whereArgs, groupBy, having, orderBy, limit], type : "query"}); }; PGSQLitePluginTransaction.prototype.update = function(table, values, where, whereArgs) { this.executes.push({opts : [table, values, where, whereArgs], type : "update"}); }; PGSQLitePluginTransaction.prototype.complete = function(success, error) { gap.exec(success, error, 'PGSQLitePlugin', 'transactionExecuteSqlBatch', [this.dbPath, this.executes]); }; return PGSQLitePluginTransaction; })(); }).call(this, window.Cordova || window.PhoneGap || window.cordova); function PGSQLiteHelper(){ this.DATABASE_NAME = "addressBook.db"; this.DATABASE_VERSION = 1; this.DATABASE_STORAGE = "auto"; this.db = null; this.CREATE_BATCH = []; this.UPDATE_BATCH = []; this.openDatabase = function(success, error, options){ var __self = this; options = (typeof options == "object") ? options : {}; options.storage = __self.DATABASE_STORAGE; __self.db = new PGSQLitePlugin(__self.DATABASE_NAME, function(result){ var _version = __self.DATABASE_VERSION + ""; if (result.status == 1){ __self.onCreate(function(){ __self.db.executeSql("PRAGMA user_version='"+_version + "'", function(res){ if (typeof success == "function"){ success( __self.db, _version, result.systemPath); } }, error); }, error); } else { if (result.version != _version){ __self.onUpdate(result.version, function(){ __self.db.executeSql("PRAGMA user_version='"+_version + "'" , function(res){ if (typeof success == "function"){ success( __self.db, _version, result.systemPath); } }, error); }, error); } else { if (typeof success == "function"){ success( __self.db, _version, result.systemPath); } } } }, function(err){ if (typeof error == "function"){ error(err); } }, options ); return this.db; } this.onCreate = function(success, error) { var ___self = this; ___self.db.transaction(function(tr){ for (var i in ___self.CREATE_BATCH){ tr.executeSql(___self.CREATE_BATCH[i]); } }, success, error); } this.onUpdate = function(version, success, error) { var ___self = this; version = parseInt(version, 10) - 1; var currVersion = parseInt(this.DATABASE_VERSION, 10) - 1; if (version < 1){ ___self.onCreate(function(){ ___self.db.executeSql("PRAGMA user_version='"+ (currVersion + 1 ) + "'", function(res){ if (typeof success == "function"){ success( ___self.db, (currVersion + 1 ) + ""); } }, error); }, error); return; } ___self.db.transaction(function(tr){ for (var j = version; j < currVersion; j++){ for (var i in ___self.UPDATE_BATCH[j]){ tr.executeSql(___self.UPDATE_BATCH[j][i]); } } }, success, error); } this.getDB = function(){ return this.db; } }
Sencha Touch 调用
var list= Ext.create('Ext.List', { fullscreen: true, itemTpl: '{USER_NAME}{MOBILE}', indexBar :true }); var db = new PGSQLitePlugin("addressBook.db", function(dbResult, dbObject){ db = dbObject; db.executeSql("select * from KM_USER where USER_NAME like '%张%'", function(data){ // alert(data.rows[0].MOBILE); list.setData(data.rows); }, function(err){ console.log( err); }); }, function(err){ console.log( err); });
忘了说了 我用的是phonegap 1.9
发表评论
-
Sencha Touch chart 时间轴
2013-06-28 17:33 1894JSon 时间数据格式 {"data" ... -
Sencha Touch 复杂 store
2013-06-25 11:26 2766Ext.define('Contact.model.Titl ... -
gird 翻页
2013-05-15 14:57 1594//<debug> Ext.Loader ... -
Sencha Touch TextArea 支持滑动
2013-04-12 16:41 3533TextArea ios 支持滑动 Ext.def ... -
Sencha Touch history 理解
2013-02-20 14:20 1254/** * @author Ed Spencer ... -
Sencha Touch history
2013-02-20 14:19 1735/** * @author Ed Spencer ... -
Sencha Touch Carousel 自动切换
2013-01-25 11:20 1671setInterval(function () { ... -
Sencha Touch userAgent 判断
2013-01-25 11:05 1254[{ name: 'en ... -
Sencha Touch 2 Menu
2013-01-23 17:01 5025主页面 /** * @Author sai */ ... -
Sencha Touch Ajax CORS 跨域
2013-01-21 11:28 4723CORS 全称:Cross-Origin Resource ... -
Sencha Touch Carousel
2012-12-26 14:37 1370var el = carousel.element; ... -
Sencha Touch 判断横竖屏
2012-12-26 14:27 1454Ext.Viewport.on('orientat ... -
Sencha Touch 2 第二讲
2012-11-13 09:25 1256第二讲(Sencha Touch 应用组成部分及简单介绍) h ... -
Sencha Touch 2 第一讲
2012-11-06 11:51 2106教学视频 下载地址 http://www.kuaipan.cn ... -
Sencha Touch 2 Jsonp原理
2012-10-27 22:51 4335JSONP是一个非官方的协议,它允许在服务器端集成Script ... -
ST谷歌语音搜索
2012-09-05 09:57 1064var dom= me.element.down(' ... -
picker 加title
2012-08-21 16:06 1098var picker = Ext.create('Ex ... -
Sencha Touch 自定义图标
2012-08-13 17:37 5774首先把你 图标图片放入 E:\space\Theming\sd ... -
Sencha Touch 2 Slidenavigation
2012-08-07 14:57 1639launch: function() { var ... -
XTemplate 使用
2012-07-23 18:05 0itemTpl: new Ext.XTemplate( ...
相关推荐
9. **兼容性和限制**:虽然PhoneGap的SQLite插件在大多数Android设备上工作良好,但需要注意不同Android版本间的差异,以及与iOS或其他平台的兼容性问题。 总之,PhoneGap SQLite(Android)结合了Web开发的便利性...
4. 数据存储插件:SQLite Plugin,提供本地数据库存储;File System Plugin,用于读写文件系统。 5. 服务集成插件:例如推送通知服务,如Firebase Cloud Messaging (FCM) 或者OneSignal插件;支付接口,如Alipay或...
3. **插件系统**:PhoneGap的插件机制使得开发者可以通过JavaScript调用设备的原生API,比如访问硬件特性、存储数据、推送通知等。 4. **打包与发布**:PhoneGap提供命令行工具,允许开发者将Web项目打包成对应平台...
PhoneGap支持使用SQLite数据库进行本地数据存储,以及使用Ajax进行HTTP请求与服务器通信。开发者需要理解如何操作这些功能,以便实现应用的数据管理和网络交互。 用户界面的构建和响应式设计是另一个关键环节。使用...
此外,还可以使用PhoneGap的插件功能来增强应用的功能,比如使用Local Storage或SQLite存储用户信息,或者通过Notification插件显示登录结果。 标签中的“plugins”指的是PhoneGap插件,它们是PhoneGap应用程序与...
1. 创建SQLite数据库插件 PhoneGap提供了访问设备本地存储的API,其中包括SQLite数据库。通过调用这些API,我们可以创建数据库,定义表结构,并执行SQL语句来保存服务器获取的数据。 2. 保存数据至数据库 当应用...
适用于Cordova / PhoneGap的跨平台SQLite存储插件-cordova-sqlite-storage插件版本 具有基于HTML5 / 的本机SQLite组件,适用于以下平台: 浏览器 安卓 的iOS macOS(“ osx”平台) Windows 10(UWP)桌面和移动...
在 PhoneGap 应用中,SQLite 通常作为本地数据存储的解决方案,特别是在需要离线数据存储或大量数据处理时。 "sqlitetest" 项目是为了测试 PhoneGap 应用中 SQLite 的功能和性能。这个测试可能包括创建数据库、插入...
具有额外功能的Cordova / PhoneGap sqlite存储适配器 具有基于HTML5 / 的本机SQLite组件,适用于以下平台: 安卓 的iOS macOS(“ osx”平台) Windows 10(UWP)桌面和手机(有关主要限制,请参见下文) 许可:...
4. **本地资源访问**:PhoneGap允许开发者访问设备的文件系统,存储和读取数据,同时也能调用设备的数据库功能,如SQLite,用于本地数据存储。 5. **事件处理**:PhoneGap 2.9.1支持设备生命周期事件,例如设备就绪...
6. **插件**:PhoneGap允许通过插件来访问设备的特定功能,例如,如果此应用能够存储和读取本地数据,可能包含了SQLite数据库插件;如果能获取当前日期,可能使用了Device API。 要运行这个小程序,你需要先安装...
1. **调用 PhoneGap API 制作数据库插件**:PhoneGap 提供了 SQLite API,可以创建、读取、更新和删除数据库中的记录。通过 JavaScript 调用这些 API,可以实现数据的离线存储。 2. **保存数据至数据库**:将从...
3. **本地存储**:在 PhoneGap 1.3 中,开发者可以利用 SQLite 数据库进行本地数据存储,使得应用可以离线工作并保存用户数据。 4. **事件处理**:PhoneGap 提供了与设备事件交互的能力,如页面加载、设备方向变化...
7. **添加PhoneGap插件**:根据应用需求,可能需要添加额外的PhoneGap插件,如推送通知、分享功能等。使用`phonegap plugin add <plugin_name>`命令安装。 8. **测试和调试**:在Eclipse或Android Studio中,通过...
4. **本地存储**:PhoneGap支持Web Storage(localStorage和sessionStorage)以及SQLite数据库,为应用提供离线数据存储能力。 5. **JavaScript API**:PhoneGap提供了一系列JavaScript接口,使得Web应用可以调用...
在PhoneGap应用中,开发者可能使用了PhoneGap的插件机制,创建了一个自定义插件来调用Android的Contacts Provider API,从而获取和更新联系人信息。 用户可以通过关键词搜索联系人,这通常涉及到在前端使用...
- **编写自定义插件**:对于PhoneGap不支持的功能,开发者可以编写自己的插件,实现JavaScript和原生代码之间的通信。 **6. PhoneGap调试与部署** - **使用浏览器模拟器**:如Chrome的Device Mode或Firefox的...
通过阅读《Fanfq.iteye.com/blog/1684626》这篇博文,你可以获取更多关于PhoneGap Storage的实践经验和技巧,包括如何安装和配置SQLite插件,以及如何编写JavaScript代码来操作数据库。 总之,PhoneGap Storage为...
6. **plugins**目录:包含了安装的PhoneGap插件,这些插件扩展了PhoneGap的基本功能,例如访问硬件特性。 7. **platforms**目录:可能包含了针对不同移动操作系统的特定实现,如iOS、Android等。 通过这些示例,...
9. **插件扩展**:PhoneGap允许开发自定义插件,以访问未内置的设备功能。DEMO可能有如何创建和使用插件的例子。 10. **应用生命周期管理**:DEMO会展示如何处理应用的启动、暂停、恢复和关闭等生命周期事件。 ...