AsyncTask上面写

//判断网络 if (!NetWorkutils.getWork(getActivity())) { Toast.makeText(getActivity(), "没网you", Toast.LENGTH_SHORT).show(); new Thread(new Runnable() { @Override public void run() { //查询数据 List<News.DataBean> list = dao.query(); guanAdapter.setData(list); } }).start(); return; }

在 AsyncTask,if判断最外层

//将数据添加到数据库 for (int i = 0; i < data.size(); i++) { String uniquekey = data.get(i).getUniquekey(); String title = data.get(i).getTitle(); String date = data.get(i).getDate(); String category = data.get(i).getCategory(); String author_name = data.get(i).getAuthor_name(); String url = data.get(i).getUrl(); String thumbnail_pic_s = data.get(i).getThumbnail_pic_s(); String thumbnail_pic_s02 = data.get(i).getThumbnail_pic_s02(); String thumbnail_pic_s03 = data.get(i).getThumbnail_pic_s03(); dao.insert(uniquekey, title, date, category, author_name, url, thumbnail_pic_s, thumbnail_pic_s02, thumbnail_pic_s03); }

判断网络工具类

package wanghuiqi.bawie.com.whq_yuekao;

import android.content.Context; import android.net.ConnectivityManager; import android.net.NetworkInfo;

public class NetWorkutils { public static boolean getWork(Context context){ ConnectivityManager conn = (ConnectivityManager) context.getApplicationContext() .getSystemService(Context.CONNECTIVITY_SERVICE); NetworkInfo info=conn.getActiveNetworkInfo(); return info != null && info.isAvailable(); } }

DBHelper

package wanghuiqi.bawie.com.whq_yuekao;

import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper { public DBHelper(Context context) { super(context, "News.db", null, 1); } @Override public void onCreate(SQLiteDatabase db) { //sql语句 String sql="create table news (id Integer primary key autoincrement,uniquekey text," + "title text,date text,category text,author_name text,url text,thumbnail_pic_s text," + "thumbnail_pic_s02 text,thumbnail_pic_s03 text)"; db.execSQL(sql); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } }

NewsDao

package wanghuiqi.bawie.com.whq_yuekao;

import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.text.TextUtils;

import java.util.ArrayList; import java.util.List;

public class NewsDao { private final SQLiteDatabase db; private final DBHelper helper; public NewsDao(Context context) { helper = new DBHelper(context); db = helper.getReadableDatabase(); } public void insert(String uniquekey, String title, String date, String category, String author_name, String url, String thumbnail_pic_s, String thumbnail_pic_s02, String thumbnail_pic_s03) { db.execSQL("insert into news(uniquekey,title,date,category,author_name,url,thumbnail_pic_s" + ",thumbnail_pic_s02,thumbnail_pic_s03)values(?,?,?,?,?,?,?,?,?)",new Object[]{uniquekey,title, date,category, author_name,url,thumbnail_pic_s,thumbnail_pic_s02,thumbnail_pic_s03}); } //查询所有 public List<News.DataBean> query() { Cursor cursor = db.rawQuery("select * from news ", null); ArrayList<News.DataBean> dataBeans = new ArrayList<>(); while (cursor.moveToNext()){ String uniquekey = cursor.getString(cursor.getColumnIndex("uniquekey")); String title = cursor.getString(cursor.getColumnIndex("title")); String date = cursor.getString(cursor.getColumnIndex("date")); String category = cursor.getString(cursor.getColumnIndex("category")); String author_name = cursor.getString(cursor.getColumnIndex("author_name")); String url = cursor.getString(cursor.getColumnIndex("url")); String thumbnail_pic_s = cursor.getString(cursor.getColumnIndex("thumbnail_pic_s")); String thumbnail_pic_s02 = cursor.getString(cursor.getColumnIndex("thumbnail_pic_s02")); String thumbnail_pic_s03 = cursor.getString(cursor.getColumnIndex("thumbnail_pic_s03")); News.DataBean dataBean = new News.DataBean(uniquekey, title, date, category, author_name, url, thumbnail_pic_s, thumbnail_pic_s02, thumbnail_pic_s03); dataBeans.add(dataBean); } return dataBeans; } }