Android ContentProvider（内容提供器运用一）-优快云博客

-----Manifest设置
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="gongzibai.co.cc"
android:versionCode="1"
android:versionName="1.0" >

<uses-sdk android:minSdkVersion="8" />

<application
android:icon="@drawable/ic_launcher"
android:label="@string/app_name" >
//加入provider
<provider
android:authorities="testprovider"
android:name="TextProvider" >
</provider>

<category

android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
</application>

</manifest>

-----------------DtaabaseHelper.java
package gongzibai.co.cc;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.BaseColumns;

public class DtaabaseHelper extends
SQLiteOpenHelper {

//建立数据库
public DtaabaseHelper(
Context context) {
super(context, "test.db", null,
1);
// TODO Auto-generated constructor stub
}

//创建表test 列表数字、名字、描述
@Override
public void onCreate(
SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("CREATE TABLE test("
+ BaseColumns._ID
+ "INTEGER PRIMARY KEY,"
+ "name TEXT,"
+ "description TEXT"
+ ");");

}

@Override
public void onUpgrade(
SQLiteDatabase db,
int oldVersion,
int newVersion) {
// TODO Auto-generated method stub
db.execSQL("DROP TABLE IF EXISTS test");
onCreate(db);

}

------------TextProvider.java
package gongzibai.co.cc;

import android.content.ContentProvider;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;
import android.net.Uri;

public class TextProvider extends
ContentProvider {
//定义类
DtaabaseHelper dtaabaseHelper;

@Override
public int delete(Uri arg0,
String arg1, String[] arg2) {
// TODO Auto-generated method stub
return 0;
}

@Override
public String getType(Uri uri) {
// TODO Auto-generated method stub
return null;
}

//插数据可以写入，插入表test
@Override
public Uri insert(Uri uri,
ContentValues values) {
// TODO Auto-generated method stub
SQLiteDatabase db = dtaabaseHelper
.getWritableDatabase();
db.insert("test", null, values);
return null;
}

//实例化类

@Override
public boolean onCreate() {
// TODO Auto-generated method stub
dtaabaseHelper = new DtaabaseHelper(
getContext());
return true;
}

//检索数据可以读取，数据检索简历设置表test
@Override
public Cursor query(Uri uri,
String[] projection,
String selection,
String[] selectionArgs,
String sortOrder) {
// TODO Auto-generated method stub
SQLiteDatabase db = dtaabaseHelper
.getReadableDatabase();
SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
qb.setTables("test");
Cursor cursor = qb.query(db,
projection, selection,
selectionArgs, null,
null, null);

return cursor;
}

@Override
public int update(Uri uri,
ContentValues values,
String selection,
String[] selectionArgs) {
// TODO Auto-generated method stub
return 0;
}

}

---------------P1Activity.java
package gongzibai.co.cc;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.widget.ListView;
import android.widget.SimpleAdapter;

public class P1Activity extends
Activity {
// ProvideTest主程序
/** Called when the activity is first created. */
@Override
public void onCreate(
Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
// 取得Content Provider的Uri
getIntent()
.setData(
Uri.parse

("content://gongzibai.co.cc.testprovider"));
Uri uri_test = getIntent()
.getData();
// 建立二行测试用的数据
ContentValues values = new ContentValues();
values.put("name", "Macoto");
values.put("description",
"0932-158983");
getContentResolver().insert(
uri_test, values);
values.put("name", "Ming");
values.put("description",
"0932-123456");
getContentResolver().insert(
uri_test, values);
// 经Content Provider来检索
Cursor cur = managedQuery(
uri_test, null, null,
null, null);
cur.moveToFirst();
// 设定ArrayList显示下拉列表
ArrayList<Map<String, Object>> data = new

ArrayList<Map<String, Object>>();
Map<String, Object> item;
// 將自数据库读出的数据整理到ArrayList data容器內
for (int i = 0; i < cur
.getCount(); i++) {
item = new HashMap<String, Object>();
item.put("column00",
cur.getString(0));
item.put("column01",
cur.getString(1));
item.put("column02",
cur.getString(2));
data.add(item);
cur.moveToNext();
}
cur.close();
// ArrayList data容器內的数据放到mListView01
ListView mListView01 = new ListView(
this);
SimpleAdapter adapter = new SimpleAdapter(
this,
data,
R.layout.main,
new String[] {
"column00",
"column01",
"column02" },
new int[] {
R.id.TextView01,
R.id.TextView02,
R.id.TextView03 });
mListView01.setAdapter(adapter);
setContentView(mListView01);
}
}