频道管理

//创建2张表 @Override public void onCreate(SQLiteDatabase db) { db.execSQL("create table wode(_id Integer primary key autoincrement,title varchar(20))"); db.execSQL("create table qita(_id Integer primary key autoincrement,title varchar(20))"); } public class Frag_my extends Fragment { private SQLiteDatabase db; private GridView gridView_my; private GridView gridView_qita; String[]str = new String[]{"热点","八卦","娱乐","时尚","野史"}; String[]str1 = new String[]{"豪车","美女","大咖","明细","我的"}; List<String>list_wo = new ArrayList<>(); List<String>list_qita = new ArrayList<>(); private int id; private int ids; @Nullable @Override public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) { View view = inflater.inflate(R.layout.frag_my, null); gridView_my = (GridView) view.findViewById(R.id.my); gridView_qita = (GridView) view.findViewById(R.id.qita); Sqlite sqlite = new Sqlite(getActivity()); db = sqlite.getWritableDatabase(); return view; } @Override public void onActivityCreated(@Nullable Bundle savedInstanceState) { super.onActivityCreated(savedInstanceState); //添加数据 /* for (int i = 0; i < str.length; i++) { ContentValues values = new ContentValues(); values.put("title",str[i]); db.insert("wode",null,values); } for (int i = 0; i < str1.length; i++) { ContentValues values1 = new ContentValues(); values1.put("title",str1[i]); db.insert("qita",null,values1); }*/ //查询表1 Cursor cursor = db.query("wode", null, null, null, null, null, null); while (cursor.moveToNext()){ id = cursor.getInt(0); String title = cursor.getString(1); list_wo.add(title); Log.i("xx",title); } //查询表2 Cursor cursor1 = db.query("qita", null, null, null, null, null, null); while (cursor1.moveToNext()){ ids = cursor1.getInt(0); String title = cursor1.getString(1); list_qita.add(title); Log.i("xx",title); } //适配第一个GridView final ArrayAdapter<String> adapter = new ArrayAdapter<>(getActivity(), android.R.layout.simple_list_item_1, list_wo); gridView_my.setAdapter(adapter ); //适配第二个GridView final ArrayAdapter<String> adapter1 = new ArrayAdapter<>(getActivity(), android.R.layout.simple_list_item_1, list_qita); gridView_qita.setAdapter(adapter1); //第一个GridView点击事件 gridView_my.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() { @Override public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) { //获取点击时的值 String name = list_wo.get(position); //添加到集合2 list_qita.add(name); //添加到表2 ContentValues values1 = new ContentValues(); values1.put("title",name); db.insert("qita",null,values1); //删除表1的值 String[] g1 = new String[]{name}; db.delete("wode","title = ?",g1); //移除点击的条目 list_wo.remove(name); //刷新2个适配器 adapter.notifyDataSetChanged(); adapter1.notifyDataSetChanged(); Toast.makeText(getActivity(), ""+name, Toast.LENGTH_SHORT).show(); return false; } }); //变色 gridView_my.setOnTouchListener(new View.OnTouchListener() { @Override public boolean onTouch(View v, MotionEvent event) { switch (event.getAction()){ case MotionEvent.ACTION_DOWN: gridView_my.setSelected(true); break; case MotionEvent.ACTION_UP: gridView_my.setSelected(false); break; } return false; } }); //第二个GridView点击事件 gridView_qita.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() { @Override public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) { String name = list_qita.get(position); list_wo.add(name); ContentValues values = new ContentValues(); values.put("title",name); db.insert("wode",null,values); String[] g2 = new String[]{name}; db.delete("qita","title = ?",g2); list_qita.remove(name); adapter.notifyDataSetChanged(); adapter1.notifyDataSetChanged(); return false; } }); } }