AndroidStudio如何獲取SQLite數(shù)據(jù)并顯示到ListView上

AndroidStudio如何獲取SQLite數(shù)據(jù)并顯?到ListView上ListViewSQLiteListView當(dāng)中SQLite數(shù)據(jù)（SQLite數(shù)據(jù)庫(kù)并填寫了?些數(shù)據(jù)），然后引?ListViewListView綁定就好了。?獲取SQLite數(shù)據(jù)庫(kù)中的數(shù)據(jù)SQLite是?個(gè)輕量級(jí)的數(shù)據(jù)庫(kù)，它能將數(shù)據(jù)保存到你的?機(jī)，但缺點(diǎn)是?旦軟件卸載所有數(shù)據(jù)將?同被銷毀。所以要根據(jù)??的項(xiàng)?需要選擇性的使?。下?要演?將SQLite中的數(shù)據(jù)提取出來(lái)。?先定義?個(gè)類?來(lái)實(shí)例化數(shù)據(jù)庫(kù)publicclassinitdate{publicBitmapbitmap;publicStringcontent;publicStringdata;publicinitdate(Bitmapbitmap,Stringcontext,Stringtime){this.bitmap=bitmap;this.content=context;this.data=time;}}創(chuàng)建?個(gè)List對(duì)象?來(lái)存儲(chǔ)數(shù)據(jù)List<initdate>list=newArrayList<>();獲取SQLite中對(duì)應(yīng)表的數(shù)據(jù)DBOpenHelperhelper=newDBOpenHelper(getActivity(),"數(shù)據(jù)庫(kù)的名稱",null,1);//創(chuàng)建對(duì)象SQLiteDatabasedb=helper.getWritableDatabase();Cursorc=db.query("表名",null,null,null,null,null,null);if(c!=null&&c.getCount()>=1){while(c.moveToNext()){list.add(newinitdate(base64ToBitmap(c.getString(c.getColumnIndex("字段名1"))),c.getString(c.getColumnIndex("字段名2")),c.getString(c.getColumnIndex("字段名3"))));}c.close();db.close();//關(guān)閉數(shù)據(jù)庫(kù)}base64ToBitmap?法?于將String類型轉(zhuǎn)換成BitmappublicstaticBitmapbase64ToBitmap(Stringbase64info){byte[]bytes=Base64.decode(base64info,Base64.DEFAULT);returnBitmapFactory.decodeByteArray(bytes,0,bytes.length);}ListView控件ListViewListViewxml?件中即可。這?不過(guò)多介紹<ListViewandroid:id="@+id/lv_expense"style="@style/Animation.AppCompat.DropDownUp"android:layout_width="match_parent"android:layout_height="wrap_content"/>ListView綁定?先將獲取到的數(shù)據(jù)通過(guò)?個(gè)循環(huán)存放到map對(duì)象中for(inti=0;i<list.size();i++){Map<String,Object>map=newHashMap<String,Object>();map.put("image",list.get(i).bitmap);map.put("category",list.get(i).content);map.put("money",list.get(i).data);listitem.add(map);}SimpleAdapteradapter=newSimpleAdapter(getActivity(),listitem,R.layout.fragment_one_item,newString[]{"category","money","image"},newint[]{R.id.tv_expense_category,R.id.tv_expense_money,R.id.image_expense});ListViewlistView=(ListView)v.findViewById(R.id.lv_expense);listView.setAdapter(adapter);listView.setOnItemClickListener(newAdapterView.OnItemClickListener(){//設(shè)置監(jiān)聽(tīng)器@OverridepublicvoidonItemClick(AdapterView<?>parent,Viewview,intposition,longid){Map<String,Object>map=(Map<String,Object>)parent.getItemAtPosition(position);Toast.makeText(getActivity(),map.get("category").toString(),Toast.LENGTH_LONG).show();}});fragment_one_item.xml<?xmlversion="1.0"encoding="utf-8"?><LinearLayoutxmlns:android="/apk/res/android"android:layout_width="match_parent"android:layout_height="match_parent"><ImageViewandroid:id="@+id/image_expense"android:layout_width="wrap_content"android:layout_height="wrap_content"android:paddingTop="10dp"android:paddingRight="10dp"android:paddingBottom="10dp"android:adjustViewBounds="true"android:maxWidth="72dp"android:maxHeight="72dp"/><TextViewandroid:layout_width="wrap_content"android:layout_height="wrap_content"android:layout_weight="1"android:padding="10dp"/><TextViewandroid:layout_width="wrap_content"android:layout_height="40dp"android:text="100yuan"/></LinearLayout>ftListView進(jìn)?了綁定，我們可以直接運(yùn)?，發(fā)現(xiàn)除了?照?不能顯?外其他的信息都正常顯SimpleAdapter得到的，如果我們想BitmapListView這個(gè)接?，在??定義數(shù)據(jù)和視圖的匹配for(inti=0;i<list.size();i++){Map<String,Object>map=newHashMap<String,Object>();map.put("image_expense",list.get(i).bitmap);map.put("expense_category",list.get(i).content);map.put("expense_money",list.get(i).data);listitem.add(map);}SimpleAdapteradapter=newSimpleAdapter(getActivity(),listitem,R.layout.fragment_one_item,newString[]{"expense_category","expense_money","image_expense"},newint[]{R.id.tv_expense_category,R.id.tv_expense_money,R.id.image_expense});adapter.setViewBinder(newSimpleAdapter.ViewBinder(){@OverridepublicbooleansetViewValue(Viewview,Objectdata,StringtextRepresentation){if((viewinstanceofImageView)&(datainstanceofBitmap)){ImageViewiv=(ImageView)view;Bitmapbm=(Bitmap)data;iv.setImageBitmap(bm);returntrue;}returnfalse;}});ListViewlistView=(ListView)v.findViewById(R.id.lv_expense);listView.setAdapter(adapter);listView.setOnItemClickListener(newAdapterView.OnItemClickListener(){//設(shè)置監(jiān)聽(tīng)器@OverridepublicvoidonItemClick(AdapterView<?>parent,Viewview,intposition,longid){Map<String,Object>map=(Map<String,Object>)parent