0

this is helper class .
i m unable create a second table in my sqlite
please observe the following code

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);
        }
}

main class java

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();
 
        
    }
}

please help me
thanks

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by peter_budo
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.