数据库studio

数据库
package com.example.zkmoni;

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

public class Sqlter extends SQLiteOpenHelper {
public Sqlter(Context context) {
super(context, “Usera”, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table usera(id integer primary key autoincrement," +
            "news_title text," +
            "news_summary text)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

布局
<android.support.v4.view.ViewPager
android:id="@+id/pager"
android:layout_width=“0dp”
android:layout_height=“0dp”
app:layout_constraintTop_toTopOf=“parent”
app:layout_constraintLeft_toLeftOf=“parent”
app:layout_constraintRight_toRightOf=“parent”
app:layout_constraintBottom_toTopOf="@id/navigation"
/>
主页面
package com.example.zkmoni;

import android.os.Bundle;
import android.support.annotation.NonNull;
import android.support.design.widget.BottomNavigationView;
import android.support.v4.app.Fragment;
import android.support.v4.app.FragmentPagerAdapter;
import android.support.v4.view.ViewPager;
import android.support.v7.app.AppCompatActivity;
import android.view.MenuItem;
import android.widget.TextView;

public class Main2Activity extends AppCompatActivity {

private TextView mTextMessage;

private BottomNavigationView.OnNavigationItemSelectedListener mOnNavigationItemSelectedListener
        = new BottomNavigationView.OnNavigationItemSelectedListener() {

    @Override
    public boolean onNavigationItemSelected(@NonNull MenuItem item) {
        switch (item.getItemId()) {
            case R.id.navigation_home:
                pager.setCurrentItem(0);
                return true;
            case R.id.navigation_dashboard:
                pager.setCurrentItem(1);
                return true;
            case R.id.navigation_notifications:
                pager.setCurrentItem(2);
                return true;
        }
        return false;
    }
};
private ViewPager pager;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main2);
    initView();
    pager.setAdapter(new FragmentPagerAdapter(getSupportFragmentManager()) {
        @Override
        public Fragment getItem(int i) {
            switch (i){
                case 0:
                    return new FragmentOne();
                case 1:
                    return new FragmentTwo();
                case 2:
                    return new FragmentTwo();
            }
            return null;
        }

        @Override
        public int getCount() {
            return 3;
        }
    });

    mTextMessage = (TextView) findViewById(R.id.message);
    final BottomNavigationView navigation = (BottomNavigationView) findViewById(R.id.navigation);
    navigation.setOnNavigationItemSelectedListener(mOnNavigationItemSelectedListener);
    pager.addOnPageChangeListener(new ViewPager.OnPageChangeListener() {
        @Override
        public void onPageScrolled(int i, float v, int i1) {

        }

        @Override
        public void onPageSelected(int i) {
        switch (i){
            case 0:
                navigation.setSelectedItemId(R.id.navigation_home);
                break;
            case 1:
                navigation.setSelectedItemId(R.id.navigation_dashboard);
                break;
            case 2:
                navigation.setSelectedItemId(R.id.navigation_notifications);
                break;
        }
        }

        @Override
        public void onPageScrollStateChanged(int i) {

        }
    });
}

private void initView() {
    pager = (ViewPager) findViewById(R.id.pager);
}

}

fragmentone页面
package com.example.zkmoni2;
import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.net.ConnectivityManager;
import android.net.NetworkInfo;
import android.os.AsyncTask;
import android.os.Bundle;
import android.support.annotation.NonNull;
import android.support.annotation.Nullable;
import android.support.v4.app.Fragment;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.ListView;
import android.widget.Toast;

import com.google.gson.Gson;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.ArrayList;
import java.util.List;

public class FragmentOne extends Fragment {

private ListView lv;
private List<Myuser> list=new ArrayList<>();
String auiUrl="https://api.expoon.com/AppNews/getNewsList/type/1/p/1";
private MyAdapter myAdapter;
private UserDao userDao;
private int ling=0;

@Nullable
@Override
public View onCreateView(@NonNull LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {
    View view=inflater.inflate(R.layout.fragmentone,container,false);
    lv = view.findViewById(R.id.lv);
    myAdapter = new MyAdapter(getActivity(), list);
    lv.setAdapter(myAdapter);
    userDao = new UserDao(getActivity());
    list=userDao.selete();
    if (!wl()){
        Toast.makeText(getActivity(),"无网络",ling).show();
    }else {
        new zkmn().execute(auiUrl);
    }
    lv.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {
        @Override
        public boolean onItemLongClick(AdapterView<?> parent, View view, final int position, long id) {
            AlertDialog dialog=new AlertDialog.Builder(getActivity())
                    .setTitle("删除")
                    .setIcon(R.drawable.ic_launcher_background)
                    .setMessage("确定要删除吗")
                    .setPositiveButton("确定", new DialogInterface.OnClickListener() {
                        @Override
                        public void onClick(DialogInterface dialog, int which) {
                            Toast.makeText(getActivity(),"删除成功",ling).show();
                            userDao.delete(list.get(position).getNews_title());
                            list.remove(position);
                            myAdapter.notifyDataSetChanged();
                        }
                    })
                    .setNegativeButton("取消", new DialogInterface.OnClickListener() {
                        @Override
                        public void onClick(DialogInterface dialog, int which) {
                            Toast.makeText(getActivity(),"取消删除",ling).show();
                        }
                    })
                    .create();
            dialog.show();
            return true;
        }
    });
    return view;
}
class zkmn extends AsyncTask<String,Void,ArrayList<Myuser>>{

    @Override
    protected ArrayList<Myuser> doInBackground(String... strings) {
        try {
            URL url=new URL(strings[0]);
            HttpURLConnection urlConnection= (HttpURLConnection) url.openConnection();
            if (urlConnection.getResponseCode()==200){
                InputStream inputStream = urlConnection.getInputStream();
                Gson gson = new Gson();
                User user = gson.fromJson(new BufferedReader(new InputStreamReader(inputStream)), User.class);
                List<User.DataBean> data = user.getData();
                if (list.size()==0){
                    for (int i=0;i<data.size();i++){
                        userDao.add(data.get(i).getNews_title(),data.get(i).getNews_summary());
                    }
                }
                list=userDao.selete();
                return (ArrayList<Myuser>) list;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    @Override
    protected void onPostExecute(ArrayList<Myuser> myusers) {
        super.onPostExecute(myusers);
        myAdapter.setList(myusers);
    }
}
public boolean wl(){
    ConnectivityManager cm= (ConnectivityManager) getActivity().getSystemService(Context.CONNECTIVITY_SERVICE);
    NetworkInfo activeNetworkInfo = cm.getActiveNetworkInfo();
    return activeNetworkInfo!=null &&activeNetworkInfo.isAvailable();
}

}