UZZWtAhd

1public void Enter(View V){
2    mhelper=new AppDBHelper(this);
3 db=mhelper.getWritableDatabase();
4 ContentValues val=new ContentValues();
5 val.put(AppContract.TaskEntry.CONTENT,"thatsall");
6 val.put(AppContract.TaskEntry.ID,"4");
7 val.put(AppContract.TaskEntry.STATE,"notStarted");
8long err= this.db.insert(AppContract.TaskEntry.TABLE,null,val);
9Toast.makeText(getApplicationContext(),"db ="+ err,Toast.LENGTH_SHORT).show();
10db.close();
11}
12	
13public class AppContract {          
14public static. final String  DB_NAME = "storage.db"; 
15public static final int DB_VERSION = 1;
16
17public class TaskEntry implements BaseColumns {
18public static final String TABLE = "tasks";
19public static final String CONTENT ="content";
20public static final String ID ="Id";
21
22public static final String STATE = "state";
23  }
24	
25public class AppDBHelper extends SQLiteOpenHelper 
26{
27public AppDBHelper(Context context) {
28    super(context, AppContract.DB_NAME, null, AppContract.DB_VERSION);
29}
30
31@Override
32public void onCreate(SQLiteDatabase db) {
33    String createTable = "CREATE TABLE " + AppContract.TaskEntry.TABLE + " ( t_id INTEGER PRIMARY KEY AUTOINCREMENT , " +
34        AppContract.TaskEntry.ID + " TEXT , " +
35        AppContract.TaskEntry.STATE + " TEXT NOT NULL," +
36        AppContract.TaskEntry.CONTENT+ "  TEXT )";
37
38    db.execSQL(createTable);
39}
40
41@Override
42public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
43    db.execSQL("DROP TABLE IF EXISTS " + AppContract.TaskEntry.TABLE);
44    onCreate(db);
45}
46 }
47	
48public class DataProvider extends ContentProvider
49 {
50    private AppDBHelper adbhelper;
51
52@Override
53public boolean onCreate() {
54    adbhelper= new AppDBHelper(getContext());
55    return true;
56}
57
58
59@Override
60public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs,
61                    String sortOrder) {
62    return null;
63}
64
65
66@Override
67public Uri insert(Uri uri, ContentValues contentValues) {
68    return null;
69}
70
71
72@Override
73public int update(Uri uri, ContentValues contentValues, String selection, String[] selectionArgs) {
74    return 0;
75}
76
77@Override
78public int delete(Uri uri, String selection, String[] selectionArgs) {
79    return 0;
80}
81
82
83@Override
84public String getType(Uri uri) {
85    return null;
86}
87
88 }