Android数据库缓存

1. [代码][Java]代码 跳至 [1] [全屏预览]?123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.os.Handler;import android.os.Message; /** * 缓存数据库 * @author lu * */public class CacheHelper extends SQLiteOpenHelper { private static final String tableName = "JSONCACHE"; private static final String URL = "URL"; private static final String JSON = "JSON"; private static final String DATE = "DATE"; public CacheHelper(Context context) { super(context, "cache.db", null, 1); } @Override public void onCreate(SQLiteDatabase db) { //建表jsoncache，字段：请求地址url、缓存数据json、时间date db.execSQL("CREATE TABLE "+tableName+" (ID INTEGER PRIMARY KEY AUTOINCREMENT, "+URL+" TEXT NOT NULL, "+JSON+" TEXT NOT NULL, "+DATE+" INTEGER NOT NULL )"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } private static CacheHelper helper = null; public static CacheHelper init(Context context){ if (helper==null) { helper = new CacheHelper(context); } return helper; } /**储存缓存json*/ public void setJson(final String url0,final String json){ new Thread(){ public void run() { String url = urlEncode(url0); ContentValues cv = new ContentValues(); cv.put(URL, url); cv.put(JSON, json); cv.put(DATE, System.currentTimeMillis()); helper.getReadableDatabase().delete(tableName, URL+"=?", new String[]{url}); helper.getReadableDatabase().insert(tableName, null, cv); } }.start(); } /**获取缓存json，以handler的obj返回（懒得写监听器了）*/ public void getJson(final String url0,final Handler handler){ new Thread(){ public void run() { String url = urlEncode(url0); String result = null; Cursor c = helper.getReadableDatabase().query(tableName, null, URL+"=?", new String[]{url}, null, null, null); if (c.moveToNext()) { result = c.getString(c.getColumnIndex(JSON)); } Message msg = Message.obtain(); msg.obj = result; handler.sendMessage(msg); } }.start(); } /**缓存需要定时清空*/ public void clear(){ new Thread(){ public void run() { helper.getReadableDatabase().delete(tableName, "ID>?", new String[]{"0"}); } }.start(); } /**url需要去掉token*/ private String urlEncode(String url){ String result = url.replaceAll("accessToken.*?\\&", ""); if (result.contains("accessToken")) {//如果还没去掉，说明是在尾部 result = result.replaceAll("\\&accessToken.*?$", ""); } return result; } }http://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307090.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307091.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307092.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307093.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307094.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307095.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307096.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307097.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307098.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307099.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307100.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307101.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307102.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307103.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307104.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307105.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307106.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307107.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307108.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307109.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307110.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307111.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307112.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307113.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307114.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307115.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307116.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307117.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307118.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307119.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307120.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307121.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307122.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307123.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307124.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307125.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307126.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307127.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307128.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307129.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307130.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307131.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307132.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307133.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307134.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307135.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307136.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307137.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307138.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307139.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307140.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307141.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307142.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307143.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307144.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307145.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307146.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307147.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307148.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307149.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307150.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307151.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307152.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307153.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307154.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307155.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307156.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307157.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307158.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307159.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307160.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307161.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307162.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307163.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307164.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307165.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307166.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307167.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307168.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307169.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307170.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307171.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307172.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307173.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307174.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307175.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307176.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307177.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307178.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307179.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307180.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307181.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307182.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307183.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307184.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307185.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307186.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307187.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307188.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307189.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307190.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307191.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307192.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307193.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307194.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307195.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307196.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307197.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307198.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307199.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307200.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307201.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307202.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307203.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307204.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307205.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307206.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307207.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307208.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307209.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307210.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307211.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307212.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307213.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307214.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307215.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307216.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307217.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307218.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307219.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307220.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307221.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307222.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307223.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307224.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307225.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307226.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307227.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307228.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307229.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307230.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307231.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307232.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307233.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307234.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307235.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307236.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307237.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307238.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307239.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307240.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307241.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307242.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307243.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307244.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307245.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307246.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307247.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307248.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307249.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307250.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307251.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307252.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307253.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307254.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307255.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307256.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307257.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307258.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307259.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307260.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307261.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307262.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307263.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307264.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307265.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307266.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307267.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307268.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307269.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307270.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307271.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307272.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307273.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307274.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307275.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307276.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307277.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307278.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307279.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307280.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307281.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307282.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307283.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307284.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307285.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307286.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307287.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307288.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307289.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307290.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307291.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307292.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307293.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307294.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307295.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307296.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307297.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307298.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307299.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307300.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307301.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307302.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307303.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307304.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307305.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307306.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307307.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307308.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307309.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307310.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307311.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307312.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307313.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307314.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307315.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307316.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307317.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307318.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307319.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307320.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307321.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307322.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307323.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307324.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307325.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307326.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307327.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307328.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307329.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307330.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307331.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307332.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307333.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307334.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307335.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307336.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307337.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307338.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307339.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307340.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307341.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307342.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307343.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307344.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307345.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307346.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307347.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307348.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307349.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307350.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307351.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307352.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307353.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307354.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307355.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307356.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307357.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307358.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307359.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307360.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307361.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307362.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307363.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307364.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307365.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307366.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307367.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307368.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307369.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307370.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307371.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307372.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307373.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307374.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307375.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307376.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307377.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307378.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307379.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307380.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307381.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307382.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307383.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307384.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307385.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307386.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307387.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307388.htmlhttp://www.hynews.net/jiankang/yc/xinwen/gzcshyxw/5307389.html1. [代码][Java]代码 跳至 [1] [全屏预览]?123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.os.Handler;import android.os.Message; /** * 缓存数据库 * @author lu * */public class CacheHelper extends SQLiteOpenHelper { private static final String tableName = "JSONCACHE"; private static final String URL = "URL"; private static final String JSON = "JSON"; private static final String DATE = "DATE"; public CacheHelper(Context context) { super(context, "cache.db", null, 1); } @Override public void onCreate(SQLiteDatabase db) { //建表jsoncache，字段：请求地址url、缓存数据json、时间date db.execSQL("CREATE TABLE "+tableName+" (ID INTEGER PRIMARY KEY AUTOINCREMENT, "+URL+" TEXT NOT NULL, "+JSON+" TEXT NOT NULL, "+DATE+" INTEGER NOT NULL )"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } private static CacheHelper helper = null; public static CacheHelper init(Context context){ if (helper==null) { helper = new CacheHelper(context); } return helper; } /**储存缓存json*/ public void setJson(final String url0,final String json){ new Thread(){ public void run() { String url = urlEncode(url0); ContentValues cv = new ContentValues(); cv.put(URL, url); cv.put(JSON, json); cv.put(DATE, System.currentTimeMillis()); helper.getReadableDatabase().delete(tableName, URL+"=?", new String[]{url}); helper.getReadableDatabase().insert(tableName, null, cv); } }.start(); } /**获取缓存json，以handler的obj返回（懒得写监听器了）*/ public void getJson(final String url0,final Handler handler){ new Thread(){ public void run() { String url = urlEncode(url0); String result = null; Cursor c = helper.getReadableDatabase().query(tableName, null, URL+"=?", new String[]{url}, null, null, null); if (c.moveToNext()) { result = c.getString(c.getColumnIndex(JSON)); } Message msg = Message.obtain(); msg.obj = result; handler.sendMessage(msg); } }.start(); } /**缓存需要定时清空*/ public void clear(){ new Thread(){ public void run() { helper.getReadableDatabase().delete(tableName, "ID>?", new String[]{"0"}); } }.start(); } /**url需要去掉token*/ private String urlEncode(String url){ String result = url.replaceAll("accessToken.*?\\&", ""); if (result.contains("accessToken")) {//如果还没去掉，说明是在尾部 result = result.replaceAll("\\&accessToken.*?$", ""); } return result; } }