TabLayout与频道拖拽联合+listview多条目+listview点击跳转

创建数据库

public class DBUtils {    private final SQLiteDatabase db;    public DBUtils(Context context) {        SQLite sqLite = new SQLite(context);        db = sqLite.getWritableDatabase();    }    //添加方法    public void add(List<ChannelBean> channelBeanList) {        if (channelBeanList == null || channelBeanList.size() < 0) {            return;        }        for (ChannelBean channelBean : channelBeanList) {            ContentValues values = new ContentValues();            values.put("name", channelBean.getName());            values.put("selected", channelBean.isSelect());            db.insert("channels", null, values);        }    }    //查询全部的方法    public List<ChannelBean> chaxun(){        Cursor cursor = db.query("channels", null, null, null, null, null, null);        List<ChannelBean> channelBeanList = new ArrayList<>();        ChannelBean channelBean;        while (cursor.moveToNext()) {            String name = cursor.getString(cursor.getColumnIndex("name"));            int selected = cursor.getInt(cursor.getColumnIndex("selected"));            channelBeanList.add(new ChannelBean(name, selected == 0 ? false : true));        }        cursor.close();        return channelBeanList;    } //条件查询 public List<ChannelBean> tiaojian(){        Cursor cursor = db.query("channels//表名", null, "selected=?", new String[]{"1"}, null, null, null);        List<ChannelBean> channelBeanList = new ArrayList<>();        ChannelBean channelBean;        while (cursor.moveToNext()) {            String name = cursor.getString(cursor.getColumnIndex("name"));            int selected = cursor.getInt(cursor.getColumnIndex("selected"));            channelBeanList.add(new ChannelBean(name, selected == 0 ? false : true));        }        cursor.close();        return channelBeanList;    }    //清除方法    public void clearChannels() {        db.delete("channels", null, null);    }}

MyAdapter类:

public class MyAdapter extends FragmentPagerAdapter {       List<ChannelBean> mChannelBeanList;    public MyAdapter(FragmentManager fm,List<ChannelBean> channelBeanList) {        super(fm);        mChannelBeanList = channelBeanList;    }    @Override    public Fragment getItem(int position) {        MyFragment myFragment = new MyFragment();        Bundle bundle = new Bundle();        bundle.putString("text", mChannelBeanList.get(position).getName());        myFragment.setArguments(bundle);        return myFragment;    }    @Override    public int getCount() {        return mChannelBeanList != null?mChannelBeanList.size():0;    }    @Override    public CharSequence getPageTitle(int position) {        return mChannelBeanList.get(position).getName();    }}

条目点击事件：

listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {    @Override    public void onItemClick(AdapterView<?> parent, View view, int position, long id) {        Intent intent = new Intent(getActivity(),Second.class);        intent.putExtra("label_text",list.get(position).getLabel_text());        startActivity(intent);    }});

主界面：

public class MainActivity extends AppCompatActivity {    private TabLayout tabLayout;    private ViewPager viewPager;    private TextView pindao;    private List<ChannelBean> qunabu;    private List<ChannelBean> tiaojian;    private DBUtils dbUtils;    private MyAdapter adapter;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);        tabLayout = (TabLayout) findViewById(R.id.tablayout);        viewPager = (ViewPager) findViewById(R.id.viewpager);        tabLayout.setupWithViewPager(viewPager);        viewPager.setOffscreenPageLimit(7);        pindao = (TextView) findViewById(R.id.pindao);        pindao.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                ChannelActivity.startChannelActivity(MainActivity.this, qunabu);            }        });        initData();    }    private void initData() {        qunabu = new ArrayList<>();        tiaojian = new ArrayList<>();        dbUtils = new DBUtils(this);        List<ChannelBean> chaxun = dbUtils.chaxun();        if(chaxun == null || chaxun.size() < 1){            ChannelBean channelBean1 = new ChannelBean("周一", true);            ChannelBean channelBean2 = new ChannelBean("周二", true);            ChannelBean channelBean3 = new ChannelBean("周三", true);            ChannelBean channelBean4 = new ChannelBean("周四", true);            ChannelBean channelBean5 = new ChannelBean("周五", true);            ChannelBean channelBean6 = new ChannelBean("今天", true);            ChannelBean channelBean7 = new ChannelBean("昨天", false);            tiaojian.add(channelBean1);            tiaojian.add(channelBean2);            tiaojian.add(channelBean3);            qunabu.add(channelBean1);            qunabu.add(channelBean2);            qunabu.add(channelBean3);            qunabu.add(channelBean4);            qunabu.add(channelBean5);            qunabu.add(channelBean6);            qunabu.add(channelBean7);            dbUtils.add(qunabu);        }else {            qunabu.addAll(chaxun);            List<ChannelBean> tj = dbUtils.tiaojian();            tiaojian.addAll(tj);        }        adapter = new MyAdapter(getSupportFragmentManager(),tiaojian);        viewPager.setAdapter(adapter);    }    @Override    protected void onActivityResult(int requestCode, int resultCode, Intent data) {        super.onActivityResult(requestCode, resultCode, data);        if(requestCode == ChannelActivity.REQUEST_CODE && resultCode == ChannelActivity.RESULT_CODE){            String stringExtra = data.getStringExtra(ChannelActivity.RESULT_JSON_KEY);            if (TextUtils.isEmpty(stringExtra)) {                return;            }            List<ChannelBean> list = new Gson().fromJson(stringExtra, new TypeToken<List<ChannelBean>>() {            }.getType());            if (list == null || list.size() < 1) {                return;            }            qunabu.clear();            tiaojian.clear();            qunabu.addAll(list);            for (ChannelBean channelBean : list) {                boolean select = channelBean.isSelect();                if (select) {                    tiaojian.add(channelBean);                }            }            adapter.notifyDataSetChanged();            dbUtils.clearChannels();            dbUtils.add(qunabu);        }    }}