วิธีการตั้งค่า
ทุกครั้งที่มี activity ใหม่ต้องตั้งค่า Android Manifest
StudentProvider.java
package com.example.mydb2;
import android.content.ContentProvider;
import android.content.ContentUris;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.net.Uri;
public class StudentProvider extends ContentProvider {
@Override
public int delete(Uri uri, String selection, String[] selectionArgs) {
// TODO Auto-generated method stub
return 0;
}
@Override
public String getType(Uri uri) {
// TODO Auto-generated method stub
return null;
}
@Override
public Uri insert(Uri uri, ContentValues values) {
SQLiteDatabase db=MyStudentDB.getWritableDatabase();
Uri u=null;
long rowid=0;
rowid=db.insert(”Students”, null, values);
u=ContentUris.withAppendedId(uri, rowid);
return u;
}
//Create Help
private static class MyHelper extends SQLiteOpenHelper
{
public MyHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(”Create Table Students (”+
“_id integer primary key autoincrement,”+
“studentid Text,”+
“firstname Text,”+
“lastname Text,” +
“level integer);”);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL(”Drop table if Exists Students;”);
onCreate(db);
}
}
MyHelper MyStudentDB;
@Override
public boolean onCreate() {
MyStudentDB=new MyHelper(getContext(),
“Student.db”,
null,
3);
return true;
}
@Override
public Cursor query(Uri uri, String[] projection, String selection,
String[] selectionArgs, String sortOrder) {
SQLiteDatabase db=MyStudentDB.getReadableDatabase();
Cursor c=db.query(”Students”, projection, selection, selectionArgs,
null, null, sortOrder);
return c;
}
@Override
public int update(Uri uri, ContentValues values, String selection,
String[] selectionArgs) {
// TODO Auto-generated method stub
return 0;
}
}