Skip to main content

Posts

Showing posts from January, 2015

Database create, read, update, delete in android

To create a db , first create a schema create a class that extends SQLiteOpenHelper create an object of SQLdatabse and initialise using getwritabledatabase create sepatrate methods for CRUD operation Schema class package com.example.avinash.sql2; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import java.sql.SQLException; /** * Created by Avinash on 01-01-2015. */ public class DBAdapter {     DBHelper helper;     public DBAdapter(Context c) {         helper = new DBHelper(c);     }     public long insertdata(String u,String p)     {   SQLiteDatabase sqldb=helper.getWritableDatabase();         ContentValues cv=new ContentValues();         c...