如何在MediaStore中获得艺术家的跟踪 [英] How to get the No of track from an Artist in mediastore
问题描述
我正在尝试使用Mediastore在Artist表中获取跟踪号.我可以获取所有艺术家的姓名,但是当我尝试获取NUMBER_OF_TRACKS
时遇到错误.我搜索并发现
I am trying to get the no of track in Artist table using mediastore. I am able to get all the artist name but when I try to get the NUMBER_OF_TRACKS
I am getting error .I searched and found this But this is not the problem in my case .Here is my code
try {
String[] proj = {MediaStore.Audio.Artists._ID,
MediaStore.Audio.Artists.ARTIST,
MediaStore.Audio.ArtistsColumns.NUMBER_OF_TRACKS,
MediaStore.Audio.Artists.ARTIST_KEY
,MediaStore.Audio.Artists.NUMBER_OF_ALBUMS
};// Can include more data for more details and check it.
String selection = null;
String[] selectionArgs = null;
String sortOrder = MediaStore.Audio.Artists.ARTIST + " ASC";
Cursor audioCursor = getContentResolver().query(MediaStore.Audio.Artists.EXTERNAL_CONTENT_URI, proj, selection, selectionArgs, sortOrder);
if (audioCursor != null) {
if (audioCursor.moveToFirst()) {
do {
int artistname = audioCursor.getColumnIndexOrThrow(MediaStore.Audio.Artists.ARTIST);
int artist_id = audioCursor.getColumnIndexOrThrow(MediaStore.Audio.Artists._ID);
int artist_track = audioCursor.getColumnIndexOrThrow(MediaStore.Audio.Artists.NUMBER_OF_TRACKS);
int artist_key = audioCursor.getColumnIndexOrThrow(MediaStore.Audio.Artists.ARTIST_KEY);
Mediafileinfo info = new Mediafileinfo();
info.setArtistname(audioCursor.getString(artistname));
info.setArtistkey(audioCursor.getString(artist_key));
info.setArtist_track(audioCursor.getInt(artist_track));
info.setArtist_id(audioCursor.getString(artist_id));
audioList.add(info);
} while (audioCursor.moveToNext());
并且适配器代码为
Mediafileinfo item = (Mediafileinfo) getItem(position);
TextView artist = (TextView) view.findViewById(R.id.textView);
TextView count = (TextView) view.findViewById(R.id.textView2);
artist.setText(item.artistname);
count.setText(item.artist_track);
我做错了什么?以及如何在Mediastore中使用No of Track的任何示例 当我尝试时遇到这样的错误
What I am doing wrong? And how to use No of Track in mediastore any example when I try I am getting error like this
FATAL EXCEPTION: main
android.content.res.Resources$NotFoundException: String resource ID #0x1
at android.content.res.Resources.getText(Resources.java:233)
at android.support.v7.widget.ResourcesWrapper.getText(ResourcesWrapper.java:52)
at android.widget.TextView.setText(TextView.java:3657)
at com.example.neelay.level10.CustomAdapter.getView(CustomAdapter.java:35)
at android.widget.AbsListView.obtainView(AbsListView.java:2267)
at android.widget.ListView.makeAndAddView(ListView.java:1769)
at android.widget.ListView.fillDown(ListView.java:672)
at android.widget.ListView.fillFromTop(ListView.java:733)
at android.widget.ListView.layoutChildren(ListView.java:1622)
at android.widget.AbsListView.onLayout(AbsListView.java:2102)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.widget.RelativeLayout.onLayout(RelativeLayout.java:953)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.support.design.widget.CoordinatorLayout.layoutChild(CoordinatorLayout.java:1139)
at android.support.design.widget.CoordinatorLayout.onLayoutChild(CoordinatorLayout.java:833)
at android.support.design.widget.ViewOffsetBehavior.layoutChild(ViewOffsetBehavior.java:63)
at android.support.design.widget.HeaderScrollingViewBehavior.layoutChild(HeaderScrollingViewBehavior.java:135)
at android.support.design.widget.ViewOffsetBehavior.onLayoutChild(ViewOffsetBehavior.java:42)
at android.support.design.widget.AppBarLayout$ScrollingViewBehavior.onLayoutChild(AppBarLayout.java:1364)
at android.support.design.widget.CoordinatorLayout.onLayout(CoordinatorLayout.java:846)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.widget.FrameLayout.onLayout(FrameLayout.java:463)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1730)
at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1588)
at android.widget.LinearLayout.onLayout(LinearLayout.java:1487)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.widget.FrameLayout.onLayout(FrameLayout.java:463)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1730)
at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1588)
at android.widget.LinearLayout.onLayout(LinearLayout.java:1487)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.widget.FrameLayout.onLayout(FrameLayout.java:463)
at android.view.View.layout(View.java:13902)
at android.view.ViewGroup.layout(ViewGroup.java:4476)
at android.view.ViewRootImpl.performLayout(ViewRootImpl.java:1876)
at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1697)
at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1008)
at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:4222)
at android.view.Choreographer$CallbackRecord.run(Choreographer.java:725)
at android.view.Choreographer.doCallbacks(Choreographer.java:555)
at android.view.Choreographer.doFrame(Choreographer.java:525)
at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:711)
at android.os.Handler.handleCallback(Handler.java:615)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:4793)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:808)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:575)
at dalvik.system.NativeStart.main(Native Method)
推荐答案
我在PC上使用Razorsql查看了数据库本身.数据保存在名为artist_info的视图中.所需的详细信息在那里. 代替
I had a look at the database itself using Razorsql on a pc. The data is held in a view called artist_info. The required detail is there. Instead of
MediaStore.Audio.Artists.NUMBER_OF_TRACKS);
尝试
MediaStore.Audio.ArtistColumns.NUMBER_OF_TRACKS;
找到了这个例子:
MediaStore.Audio.Artists.EXTERNAL_CONTENT_URI, new String[] {
BaseColumns._ID,
ArtistColumns.ARTIST,
ArtistColumns.NUMBER_OF_ALBUMS,
ArtistColumns.NUMBER_OF_TRACKS }, null, null,null);
这篇关于如何在MediaStore中获得艺术家的跟踪的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!