PullToRefreshListView上下拉加载刷新+数据库

布局页面

<?xml version="1.0" encoding="utf-8"?>

轮播图的布局
<com.youth.banner.Banner
android:id="@+id/banner"
android:layout_width=“match_parent”
android:layout_height=“300dp”>

</com.youth.banner.Banner>

<com.handmark.pulltorefresh.library.PullToRefreshListView
    android:id="@+id/plv"
    android:layout_width="match_parent"
    android:layout_height="match_parent">

</com.handmark.pulltorefresh.library.PullToRefreshListView>

代码页面
public class Frag_a extends Fragment {
String urlbitmap=“https://api.dujin.org/pic/”;
ArrayList<User.DataBean> list = new ArrayList<User.DataBean>();
int page;
String urlString = “http://api.expoon.com/AppNews/getNewsList/type/1/p/”;
private PullToRefreshListView plv;

@Nullable
@Override
public View onCreateView(@NonNull LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {
    View view = inflater.inflate(R.layout.frag_a,container,false);

    //轮播图
    Banner banner = view.findViewById(R.id.banner);
    banner.setImageLoader(new ImageLoader() {
        @Override
        public void displayImage(Context context, Object path, ImageView imageView) {
            com.nostra13.universalimageloader.core.ImageLoader instance = com.nostra13.universalimageloader.core.ImageLoader.getInstance();
            instance.displayImage((String)path,imageView);
        }
    });

    //创建集合
    ArrayList<String> bitmapList = new ArrayList<>();
    //循环5个图片
    for (int i=0;i<5;i++){
        bitmapList.add(urlbitmap);
    }
    banner.setImages(bitmapList);
    banner.start();

    //写listView
    plv = view.findViewById(R.id.plv);
    plv.setMode(PullToRefreshListView.Mode.BOTH);
    init(page);
    //适配器
    MyAdapter adapter = new MyAdapter(getActivity(),list);
    plv.setAdapter(adapter);
    //设置监听事件
    plv.setOnRefreshListener(new PullToRefreshBase.OnRefreshListener2<ListView>() {

        //上拉加载
        @Override
        public void onPullDownToRefresh(PullToRefreshBase<ListView> pullToRefreshBase) {
            list.clear();
            init(0);
        }
        //下拉刷新
        @Override
        public void onPullUpToRefresh(PullToRefreshBase<ListView> pullToRefreshBase) {
            page++;
            init(page);
        }
    });
    //刷新一下适配器
    adapter.notifyDataSetChanged();

    return view;
}

//判断网络
private void init(int page) {
    String string = urlString+page;
    //有网就加载异步
    if (NetStateUtil.isConn(getActivity())){
        new MyAsyncTask().execute(string);
    //没网就去设置网络
    }else{
        NetStateUtil.showNoNetWorkDlg(getActivity());
        Toast.makeText(getActivity(),"没网",Toast.LENGTH_SHORT).show();
        Dao dao = new Dao(getActivity());
        Cursor cursor = dao.query("person",null,null,null,null,null,null);
        ArrayList<User.DataBean> lista = new ArrayList<>();
        if (cursor.moveToFirst()){
            do {
                String news_title = cursor.getString(cursor.getColumnIndex("news_title"));
                User.DataBean bean = new User.DataBean(news_title);
                lista.add(bean);
            }while (cursor.moveToNext());
        }
        list.addAll(lista);
    }
}

private class MyAsyncTask extends AsyncTask<String,Void,String> {

    private Long insert;

    @Override
    protected String doInBackground(String... strings) {
        String string = Net.getJson(strings[0]);
        return string;
    }

    @Override
    protected void onPostExecute(String s) {
        super.onPostExecute(s);
        //解析json
        Gson gson = new Gson();
        User bean = gson.fromJson(s,User.class);
        List<User.DataBean> data = bean.getData();

        list.addAll(data);
        //取消刷新头和加载头
        plv.onRefreshComplete();

        Dao dao = new Dao(getActivity());
        for (int i=0;i<list.size();i++){
            User.DataBean bean1 = list.get(i);
            ContentValues values = new ContentValues();
            values.put("news_id",bean1.getNews_id());
            values.put("news_summary",bean1.getNews_summary());
            values.put("news_title",bean1.getNews_title());
            values.put("pic_url",bean1.getPic_url());

            insert = dao.insert("person",null,values);
        }
        Toast.makeText(getActivity(),"添加到数据库的条目为:"+insert,Toast.LENGTH_SHORT).show();
    }
}

}