判断网络、数据库、putorefresh

判断网络 ：：：：：：

public class NetUtils {

    public static boolean isNetAvailable(Context context) {
        ConnectivityManager manager = (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE);
        NetworkInfo info = manager.getActiveNetworkInfo();
        if (info == null) {
            return false;
        }
        return info.isAvailable();
    }
}

if(NetUtils.isNetAvailable(getActivity())){
    getData();
} else {
    getDataFromDB();
}

 

数据库：：：：：：

public static final String DB_NAME = "news.db";
public static final int DB_VERSION = 1;

public DBHelper(Context context) {
    super(context, DB_NAME, null, DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
    String sql = "create table " + NewsDao.TABLE_NAME + "(" + NewsDao.COLUMN_ID
            + " text primary key," +
            NewsDao.COLUMN_TITLE + " text," +
            NewsDao.COLUMN_DATE + " text," +
            NewsDao.COLUMN_CATEGORY + " text," +
            NewsDao.COLUMN_AUTHOR_NAME + " text," +
            NewsDao.COLUMN_URL + " text," +
            NewsDao.COLUMN_THUMBNAIL_01 + " text," +
            NewsDao.COLUMN_THUMBNAIL_02 + " text," +
            NewsDao.COLUMN_THUMBNAIL_03 + " text)";
    db.execSQL(sql);

____------------

public NewsDao(Context context) {
    DBHelper helper = new DBHelper(context);
    db = helper.getWritableDatabase();
}

public int insert(List<News.DataBean> list) {
    int count = 0;
    ContentValues values = new ContentValues();
    for (News.DataBean bean : list) {

        if (!hasId(bean.getUniquekey())) {
            values.put(COLUMN_ID, bean.getUniquekey());
            values.put(COLUMN_TITLE, bean.getTitle());
            values.put(COLUMN_DATE, bean.getDate());
            values.put(COLUMN_CATEGORY, bean.getCategory());
            values.put(COLUMN_AUTHOR_NAME, bean.getAuthorName());
            values.put(COLUMN_URL, bean.getUrl());
            values.put(COLUMN_THUMBNAIL_01, TextUtils.isEmpty(bean.getThumbnail01()) ? "" : bean.getThumbnail01());
            values.put(COLUMN_THUMBNAIL_02, TextUtils.isEmpty(bean.getThumbnail02()) ? "" : bean.getThumbnail02());
            values.put(COLUMN_THUMBNAIL_03, TextUtils.isEmpty(bean.getThumbnail03()) ? "" : bean.getThumbnail03());
            long l = db.insert(TABLE_NAME, null, values);
            if (l > 0) {
                count++;
            }
        }
    }
    return count;
}

public boolean hasId(String id) {
    Cursor cursor = db.query(TABLE_NAME, null, COLUMN_ID + "=?", new String[]{id}, null, null, null);
    if (cursor.moveToNext()) {
        return true;
    }
    return false;
}

public List<News.DataBean> queryAll() {
    List<News.DataBean> list = new ArrayList<>();
    Cursor cursor = db.query(TABLE_NAME, null, null, null, null, null, null);
    while (cursor.moveToNext()) {
        News.DataBean bean = new News.DataBean();
        bean.setUniquekey(cursor.getString(cursor.getColumnIndex(COLUMN_ID)));
        bean.setTitle(cursor.getString(cursor.getColumnIndex(COLUMN_TITLE)));
        bean.setDate(cursor.getString(cursor.getColumnIndex(COLUMN_DATE)));
        bean.setAuthorName(cursor.getString(cursor.getColumnIndex(COLUMN_AUTHOR_NAME)));
        bean.setCategory(cursor.getString(cursor.getColumnIndex(COLUMN_CATEGORY)));
        bean.setUrl(cursor.getString(cursor.getColumnIndex(COLUMN_URL)));
        bean.setThumbnail01(cursor.getString(cursor.getColumnIndex(COLUMN_THUMBNAIL_01)));
        bean.setThumbnail02(cursor.getString(cursor.getColumnIndex(COLUMN_THUMBNAIL_02)));
        bean.setThumbnail03(cursor.getString(cursor.getColumnIndex(COLUMN_THUMBNAIL_03)));
        list.add(bean);
    }
    return list;
}

 

pullToRefreash：：：：

<com.handmark.pulltorefresh.library.PullToRefreshListView

pList.setMode(PullToRefreshBase.Mode.BOTH);

pList.onRefreshComplete();