helper class.java
 
public class DBAdapter {
 
    private static final String DATABASE_NAME="satya_db";
    private static final int DATABASE_VERSION=1;
    private static Context context;
    private SQLiteDatabase db=null;
 
    private static String CREATE_TABLE="create table states(_id integer primary key autoincrement,sna varchar(13) not null)";
    private static String CREATE_TABLE_P="create table places(_id integer primary key autoincrement,pna varchar(13) not null)";    
    public DBAdapter(Context ctx)
    {
        context=ctx;
 
    }
 
    private static class DatabaseHelper extends SQLiteOpenHelper {
 
        DatabaseHelper(Context ctx) {
        super(ctx, DATABASE_NAME, null, DATABASE_VERSION);
 
        }
 
        @Override
        public void onCreate(SQLiteDatabase db) {
         db.execSQL(CREATE_TABLE );
        db.execSQL(CREATE_TABLE_P);
        }
 
        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            // TODO Auto-generated method stub
 
        }
    }
 
 
        public DBAdapter open()
        {
            DatabaseHelper dbhelper=new DatabaseHelper(context);
            db=dbhelper.getWritableDatabase();
            return this;
        }
 
        public void close()
        {
            db.close();
        }
 
        public long insertRow(String sna)
        {
            ContentValues cv=new ContentValues();
            cv.put("sna", sna);
 
            return db.insert("states",null,cv);
        }
        public long insertRowP(String pna)
        {
            ContentValues cv=new ContentValues();
            cv.put("pna", pna);
 
            return db.insert("places",null,cv);
        }
        public int updateRow(ContentValues cvs,String p[])
        {
            return db.update("states", cvs,"_id=?",p);
        }
 
        public Cursor equery()
        {
            return db.rawQuery("select * from states where _id<200",null);
        }
}

package touchmeme.Datalist;
 
import android.app.Activity;
import android.os.Bundle;
 
public class Datalist extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        @SuppressWarnings("unused")
		DBAdapter db= new DBAdapter();
 
 
    }
}