Java File
Application -> ADD -> Provider
main.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="DB정보가 셋팅되었습니다." />
</LinearLayout>
main activity
package dr.android.contents;
import android.app.Activity;
import android.os.Bundle;
public class ConstantsOne extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
}
}
Provider
package dr.android.contents;
import java.util.HashMap;
import android.content.ContentProvider;
import android.content.ContentUris;
import android.content.ContentValues;
import android.content.Context;
import android.content.UriMatcher;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteQueryBuilder;
import android.hardware.SensorManager;
import android.net.Uri;
import android.provider.BaseColumns;
import android.text.TextUtils;
import android.util.Log;
public class Provider extends ContentProvider{
//DB명
private static final String DATABASE_NAME ="constants.db";
//테이블 명
private static final String TABLE_NAME = "constants";
//URI중 고유이름 지정
private static final String AUTHORITY = "dr.android.contents.Provider";
//집합데이터와 개별 데이터 구별을 위한 상수 지정
private static final int CONSTANTS =1;
private static final int CONSTANT_ID=2;
//URI 정보를 갖는 객체 선언
private static final UriMatcher MATCHER;
//마임타입 지정 (집합데이터/개별데이터)
private static final String COLLECTION_TYPE =
"vnd.android.cursor.dir/vnd.commonsware.constant";
private static final String SINGLE_TYPE =
"vnd.android.cursor.item/vnd.commonsware.constant";
//컬럼 명세 갖는 객체 선언
private static HashMap<string,string> CONSTANTS_LIST_PROJECTION;
//SQLite 연동을 위한 db선언
private SQLiteDatabase db;
public static final class Constants implements BaseColumns{
public static final Uri CONTENT_URI =Uri.parse("content://"+AUTHORITY+"/constants");
public static final String TITLE="title";
public static final String VALUE="value";
}
static {
//UriMatcher 객체 생성
//전달되는 Uri가 집합데이터를 의미하는지 개별데이터를 의미하는지 여부 판결
MATCHER = new UriMatcher(UriMatcher.NO_MATCH);
MATCHER.addURI(AUTHORITY, "constants", CONSTANTS);
MATCHER.addURI(AUTHORITY, "constants/#", CONSTANT_ID);
//컬럼 명세를 보관하는 객체
CONSTANTS_LIST_PROJECTION = new HashMap<string,string>();
CONSTANTS_LIST_PROJECTION.put(Provider.Constants._ID, Provider.Constants._ID);
CONSTANTS_LIST_PROJECTION.put(Provider.Constants.TITLE, Provider.Constants.TITLE);
CONSTANTS_LIST_PROJECTION.put(Provider.Constants.VALUE, Provider.Constants.VALUE);
}
@Override
public boolean onCreate(){
db=(new DatabaseHelper (getContext())).getWritableDatabase();
return (db ==null)?false:true;
}
//전달된 URI를 통해서
//집합데이터 / 개별데이터 요청 요부를 확인
private boolean isCollectionUri(Uri url) {
return(MATCHER.match(url)==CONSTANTS);
}
//기본 컬럼 명세를 갖고있는 객체 반환
private HashMap<string, string=""> getDefaultProjection() {
return(CONSTANTS_LIST_PROJECTION);
}
@Override
public Cursor query(Uri url, String[] projection, String selection,
String[] selectionArgs, String sort) {
SQLiteQueryBuilder qb=new SQLiteQueryBuilder();
qb.setTables(TABLE_NAME);
if (isCollectionUri(url)) {
//집합 데이터
qb.setProjectionMap(getDefaultProjection());
}
else {
//개별 데이터
qb.appendWhere(Provider.Constants._ID+"="+url.getPathSegments().get(1));
}
String orderBy;
if (TextUtils.isEmpty(sort)) {
//전달되는 정렬 정보가 없을 경우
orderBy=Provider.Constants.TITLE;
} else {
//전달되는 정렬 정보가 있을 경우
orderBy=sort;
}
Cursor c=qb.query(db, projection, selection, selectionArgs,
null, null, orderBy);
//URI 원본자료가 변하면 그 사실을 Cursor 객체에 통보하는 역할
//예)update후 query될 때 update시 변경된 자료 반영
c.setNotificationUri(getContext().getContentResolver(), url);
return c;
}
@Override
public String getType(Uri url) {
if (isCollectionUri(url)) {
return(COLLECTION_TYPE);
}
return(SINGLE_TYPE);
}
@Override
public Uri insert(Uri url, ContentValues initialValues) {
long rowID;
ContentValues values;
if (initialValues!=null) {
values=new ContentValues(initialValues);
} else {
values=new ContentValues();
}
if (!isCollectionUri(url)) {
throw new IllegalArgumentException("Unknown URL " + url);
}
rowID=db.insert(TABLE_NAME, Provider.Constants.TITLE, values);
if (rowID > 0) {
Uri uri=ContentUris.withAppendedId(Provider.Constants.CONTENT_URI, rowID);
getContext().getContentResolver().notifyChange(uri, null);
return uri;
}
throw new SQLException("Failed to insert row into " + url);
}
@Override
public int delete(Uri url, String where, String[] whereArgs) {
int count;
long rowId=0;
if (isCollectionUri(url)) {
count=db.delete(TABLE_NAME, where, whereArgs);
}
else {
String segment=url.getPathSegments().get(1);
rowId=Long.parseLong(segment);
count=db
.delete(TABLE_NAME, Provider.Constants._ID+"="
+ segment
+ (!TextUtils.isEmpty(where) ? " AND (" + where
+ ')' : ""), whereArgs);
}
getContext().getContentResolver().notifyChange(url, null);
return count;
}
@Override
public int update(Uri url, ContentValues values, String where, String[] whereArgs) {
int count;
if (isCollectionUri(url)) {
count=db.update(TABLE_NAME, values, where, whereArgs);
}
else {
String segment=url.getPathSegments().get(1);
count=db
.update(TABLE_NAME, values, Provider.Constants._ID+"="
+ segment
+ (!TextUtils.isEmpty(where) ? " AND (" + where
+ ')' : ""), whereArgs);
}
getContext().getContentResolver().notifyChange(url, null);
return count;
}
private class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
try {
db.execSQL(
"CREATE TABLE constants (_id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, value REAL);");
ContentValues cv=new ContentValues();
cv.put(Constants.TITLE, "Gravity, Death Star I");
cv.put(Constants.VALUE, SensorManager.GRAVITY_DEATH_STAR_I);
db.insert("constants", Provider.Constants.TITLE, cv);
cv.put(Constants.TITLE, "Gravity, Earth");
cv.put(Constants.VALUE, SensorManager.GRAVITY_EARTH);
db.insert("constants", Provider.Constants.TITLE, cv);
cv.put(Constants.TITLE, "Gravity, Jupiter");
cv.put(Constants.VALUE, SensorManager.GRAVITY_JUPITER);
db.insert("constants", Provider.Constants.TITLE, cv);
cv.put(Constants.TITLE, "Gravity, Mars");
cv.put(Constants.VALUE, SensorManager.GRAVITY_MARS);
db.insert("constants", Provider.Constants.TITLE, cv);
}catch(SQLException e){
Log.e("Provider",e.toString());
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.w("Constants", "Upgrading database, which will destroy all old data");
db.execSQL("DROP TABLE IF EXISTS constants");
onCreate(db);
}
}
}
res/ layout/ add_edit.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="vertical" >
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:text="이름:" />
<EditText
android:id="@+id/title"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:layout_alignParentRight="true" />
</LinearLayout>
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:text="값:" />
<EditText
android:id="@+id/value"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:layout_alignParentRight="true" />
</LinearLayout>
</LinearLayout>
res/ layout/ main.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="Hello World, ConstantsBrowser" />
</LinearLayout>
res/ layout/ row.xml
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="horizontal" >
<TextView
android:id="@+id/title"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true" />
<TextView
android:id="@+id/value"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentRight="true" />
</RelativeLayout>
res/ values/ strings.xml
<?xml version="1.0" encoding="utf-8"?>
<resources>
<string name="app_name">77ConstantsTwo</string>
<string name="ok">확인</string>
<string name="cancel">취소</string>
<string name="add_title">상수 추가</string>
<string name="delete_title">상수 데이터를 제거하시겠습니까?</string>
</resources>
src/ dr.android.contents2/ ConstantsTwo
package dr.android.contents2;
import android.app.AlertDialog;
import android.app.ListActivity;
import android.content.ContentUris;
import android.content.ContentValues;
import android.content.DialogInterface;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.provider.BaseColumns;
import android.view.ContextMenu;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.AdapterView;
import android.widget.EditText;
import android.widget.ListAdapter;
import android.widget.SimpleCursorAdapter;
public class ConstantsTwo extends ListActivity {
private static final String TITLE="title";
private static final String VALUE="value";
private static final String CONTENT_URI =
"content://dr.android.contents.Provider/constants";
private static final String[] PROJECTION = new String[] {
BaseColumns._ID, TITLE, VALUE};
private Cursor constantsCursor;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
//manageQuery()와 getContentResolver().query() 둘다 사용가능
constantsCursor=managedQuery(
Uri.parse(CONTENT_URI),PROJECTION, null, null, null);
ListAdapter adapter=new SimpleCursorAdapter(this,
R.layout.row, constantsCursor,
new String[] {TITLE,VALUE},
new int[] {R.id.title, R.id.value});
setListAdapter(adapter);
registerForContextMenu(getListView());
}
@Override
public void onDestroy() {
super.onDestroy();
constantsCursor.close();
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
menu.add(Menu.NONE, 1, Menu.NONE, "추가")
.setIcon(R.drawable.add)
.setAlphabeticShortcut('a');
menu.add(Menu.NONE, 2, Menu.NONE, "종료")
.setIcon(R.drawable.eject)
.setAlphabeticShortcut('c');
return(super.onCreateOptionsMenu(menu));
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) {
case 1:
add();
return(true);
case 3:
finish();
return(true);
}
return(super.onOptionsItemSelected(item));
}
@Override
public void onCreateContextMenu(ContextMenu menu, View v,
ContextMenu.ContextMenuInfo menuInfo) {
menu.add(Menu.NONE, 2, Menu.NONE, "삭제")
.setIcon(R.drawable.delete)
.setAlphabeticShortcut('d');
}
@Override
public boolean onContextItemSelected(MenuItem item) {
switch (item.getItemId()) {
case 2:
AdapterView.AdapterContextMenuInfo info=
(AdapterView.AdapterContextMenuInfo)item.getMenuInfo();
delete(info.id);
return(true);
}
return(super.onOptionsItemSelected(item));
}
private void add() {
LayoutInflater inflater=LayoutInflater.from(this);
View addView=inflater.inflate(R.layout.add_edit, null);
final DialogWrapper wrapper=new DialogWrapper(addView);
new AlertDialog.Builder(this)
.setTitle(R.string.add_title)
.setView(addView)
.setPositiveButton(R.string.ok,
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog,
int whichButton) {
processAdd(wrapper);
}
})
.setNegativeButton(R.string.cancel,
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog,
int whichButton) {
// ignore, just dismiss
}
})
.show();
}
private void delete(final long rowId) {
if (rowId>0) {
new AlertDialog.Builder(this)
.setTitle(R.string.delete_title)
.setPositiveButton(R.string.ok,
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog,
int whichButton) {
processDelete(rowId);
}
})
.setNegativeButton(R.string.cancel,
new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog,
int whichButton) {
// ignore, just dismiss
}
})
.show();
}
}
private void processAdd(DialogWrapper wrapper) {
ContentValues values=new ContentValues(2);
values.put(TITLE, wrapper.getTitle());
values.put(VALUE, wrapper.getValue());
getContentResolver().insert(Uri.parse(CONTENT_URI),values);
constantsCursor.requery();
}
private void processDelete(long rowId) {
Uri uri=ContentUris.withAppendedId(Uri.parse(CONTENT_URI),rowId);
getContentResolver().delete(uri, null, null);
constantsCursor.requery();
}
class DialogWrapper {
EditText titleField=null;
EditText valueField=null;
View base=null;
DialogWrapper(View base) {
this.base=base;
valueField=(EditText)base.findViewById(R.id.value);
}
String getTitle() {
return(getTitleField().getText().toString());
}
float getValue() {
return(new Float(getValueField().getText().toString()).floatValue());
}
private EditText getTitleField() {
if (titleField==null) {
titleField=(EditText)base.findViewById(R.id.title);
}
return(titleField);
}
private EditText getValueField() {
if (valueField==null) {
valueField=(EditText)base.findViewById(R.id.value);
}
return(valueField);
}
}
}
swing-worker-1.1.jar
