package com.ddd;
import java.util.ArrayList;
import android.app.ActivityGroup;
import android.content.ContentResolver;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.provider.MediaStore;
import android.util.Log;
import android.view.View;
import android.widget.ListView;
import android.widget.TabHost;
import android.widget.TextView;
import android.widget.Toast;
public class ExampleActivity extends ActivityGroup {
/** Called when the activity is first created. */
private TabHost tabHost;
private SQLiteDatabase db;
private final static String DB_NAME = "test.db"; // DB name setting
private final static int DB_MODE = Context.MODE_PRIVATE;
private final static String T_NAME = "musicDB";
private ArrayList<Music> songs = new ArrayList<Music>();
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
openDB();
createTable();
insertIntoDB();
tabHost = (TabHost) findViewById(R.id.tabhost);
// TabHost 를 findViewById 로 생성한 후 Tab 추가 전에 꼭 실행
tabHost.setup(getLocalActivityManager());
tabHost.addTab(tabHost.newTabSpec("first_tab")
.setIndicator("노래")
.setContent(new Intent(this, SongList.class)));
tabHost.addTab(tabHost.newTabSpec("Tab_ROTATE")
.setIndicator("가수")
.setContent(new Intent(this, SongByArtist.class)));
tabHost.addTab(tabHost.newTabSpec("Tab_WATERMARK")
.setIndicator("앨범")
.setContent(new Intent(this, SongByAlbum.class)));
tabHost.addTab(tabHost.newTabSpec("Tab_WATERMARK")
.setIndicator("상황")
.setContent(new Intent(this, SongByMood.class)));
tabHost.setCurrentTab(0);
}
private void openDB() {
// TODO Auto-generated method stub
db = openOrCreateDatabase(DB_NAME, DB_MODE, null);
showToast("DB(" + DB_NAME + ")생성 or 열림");
Log.e("openDB()","openDB");
}
private void createTable() {
// TODO Auto-generated method stub
String sql=
"CREATE TABLE IF NOT EXISTS " + T_NAME+
"(" +
" id integer primary key " +
" , artist TEXT "+
" , title TEXT " +
" , album TEXT " +
" , displayName TEXT " +
" , albumId INTEGER " +
" , composer TEXT"+
" , data TEXT"+
" , mood TEXT"+
");";
try {
db.execSQL(sql);
showToast("Table(" + T_NAME + ")생성 완료!");
} catch (SQLException se) {
// TODO: handle exception
Log.e("createTable()시오류 : ",se.toString());
}
Log.e("createTable()","createtable");
}
private void insertIntoDB()
{
// People.NAME + "ASC")
Cursor mCursor;
Cursor maxIdInDB;
ContentResolver mContentResolver;
String[] mCursorCols = new String[]{
MediaStore.Audio.Media._ID,
MediaStore.Audio.Media.ARTIST,
MediaStore.Audio.Media.TITLE,
MediaStore.Audio.Media.ALBUM,
MediaStore.Audio.Media.DISPLAY_NAME,
MediaStore.Audio.Media.ALBUM_ID,
MediaStore.Audio.Media.COMPOSER,
MediaStore.Audio.Media.DATA
};
mContentResolver = getContentResolver();
mCursor = mContentResolver.query(MediaStore.Audio.Media.EXTERNAL_CONTENT_URI, mCursorCols, null, null,"_ID"+" DESC");
maxIdInDB = db.query(T_NAME, new String[]{"max(id)"},null,null, null, null, null);
maxIdInDB.moveToFirst();
// valid column을 추가해서 지금 쓸수있는 거만 추가?
// select *from a where
// TextView tt = (TextView)findViewById(R.id.URI1);
// tt.setText(maxIdInDB.getString(0));
if( mCursor.moveToFirst() ){
int id;
String artist,title,album,displayName,composer,data,mood;
long albumId;
int IDColumn = mCursor.getColumnIndex(MediaStore.Audio.Media._ID);
int artistColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.ARTIST);
int titleColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.TITLE);
int albumColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.ALBUM);
int displayNameColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.DISPLAY_NAME);
int albumIDColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.ALBUM_ID);
int composerColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.COMPOSER);
int dataColumn = mCursor.getColumnIndex(MediaStore.Audio.Media.DATA);
do{
id = mCursor.getInt(IDColumn);
artist = mCursor.getString(artistColumn);
title = mCursor.getString(titleColumn);
album = mCursor.getString(albumColumn);
displayName = mCursor.getString(displayNameColumn);
albumId = mCursor.getLong(albumIDColumn);
composer = mCursor.getString(composerColumn);
data = mCursor.getString(dataColumn);
mood="null"
임폴트 후에 빌드하려니 에러2개가 뜨고 안되네요
자바는 초보라 도움 부탁드립니다~
