you should post what errors you are getting. And wouldn't it be easier later to have the "Amount" field be a number rather than text?
On Dec 22, 11:21 pm, niva k <[email protected]> wrote: > i have Created a database in Sqllite Android Application.and i try to > add two tables in my Database But i have problem to create that > Database.First Table only Created.AnyBody Help me Thanks in Advance! > > package com.android.cdtech; > > import java.sql.SQLException; > > import android.content.ContentValues; > import android.content.Context; > import android.database.Cursor; > import android.database.sqlite.SQLiteDatabase; > import android.database.sqlite.SQLiteOpenHelper; > import android.util.Log; > > public class saveData { > public static final String KEY_ROWID = "rowid"; public static final > String KEY_DATE = "Date";public static final String KEY_NAME = > "CustomerName";public static final String KEY_AMOUNT = "Amount";public > static final String KEY_BANK = "Banks"; > private static final String TAG = "DBAdapter"; > public static final String KEY_BUSNAME="BusinessName";public static > final String KEY_ADD="Address";public static final String > KEY_CPERSON="ContactPerson";public static final String > KEY_PNUM="PhoneNumber";public static final String KEY_MAIL="EmailID"; > public static final String KEY_TINUMBER="TINNumber";public static > final String KEY_CREDITLIMIT="CreditLimit";public static final String > KEY_CREDITDAYS="CreditDays"; > private static final String DATABASE_NAME = "EXPORTDETAILS"; > private static final String DATABASE_TABLE = "Payment"; > private static final String DATABASE_TABLE2 = "Customer"; > private static final int DATABASE_VERSION = 1; > // private static final String DATABASE_CREATE = ; > > // private static final String DATABASE_CREATECUS = > // ; > private final Context context; > private DatabaseHelper DBHelper; > private SQLiteDatabase db; > > public saveData(Context ctx) > { > this.context = ctx; > DBHelper = new DatabaseHelper(context); > } > private static class DatabaseHelper extends SQLiteOpenHelper > { > DatabaseHelper(Context context) > { > super(context, DATABASE_NAME, null, DATABASE_VERSION); > } > > @Override > public void onCreate(SQLiteDatabase db) > { > db.execSQL( "create table Customer (_id1 integer > primary > key autoincrement, " > + "BusinessName text not > null,"+"Address text not > null,"+"ContactPerson text not null,"+"PhoneNumber text not > null,"+"EmailID text not null,"+"TINNumbertext not null,"+"CreditLimit > text not null,"+"CreditDays text not null);"); > > db.execSQL("create table Payment (_id integer primary key > autoincrement, " > + "Date text not null,"+"CustomerName text not > null,"+"Amount text not null,"+"Banks text not null);"); > } > > @Override > public void onUpgrade(SQLiteDatabase db, int oldVersion, > int newVersion) > { > Log.w(TAG, "Upgrading database from version " + > oldVersion > + " to " > + newVersion + ", which will destroy all old > data"); > db.execSQL("DROP TABLE IF EXISTS titles"); > onCreate(db); > } > } > public saveData open()throws SQLException > { > db=DBHelper.getWritableDatabase(); > return this; > } > public void close() > { > DBHelper.close(); > } > > public long insert(String Date,String CustomerName,String > Amount,String Banks) { > // TODO Auto-generated method stub > ContentValues cv=new ContentValues(); > cv.put(KEY_DATE,Date); > cv.put(KEY_NAME,CustomerName); > cv.put(KEY_AMOUNT,Amount); > cv.put(KEY_BANK,Banks); > return db.insert(DATABASE_TABLE, null,cv); > } > public long insertForm(String BusinessName ,String Address > ,String > ContactPerson,String PhoneNumber,String EmailID,String > TINNumber,String CreditLimit,String CreditDays) { > // TODO Auto-generated method stub > ContentValues cv=new ContentValues(); > cv.put(KEY_BUSNAME,BusinessName); > cv.put(KEY_ADD,Address); > cv.put(KEY_CPERSON,ContactPerson); > cv.put(KEY_PNUM,PhoneNumber); > cv.put(KEY_MAIL,EmailID); > cv.put(KEY_TINUMBER,TINNumber); > cv.put(KEY_CREDITLIMIT,CreditLimit); > cv.put(KEY_CREDITDAYS,CreditDays); > return db.insert(DATABASE_TABLE2, null,cv); > } > public Cursor getlatlng() > { > Cursor latlngCursor = db.rawQuery("select * from " + > DATABASE_TABLE,null); > if (latlngCursor != null) > { > latlngCursor.moveToFirst(); > } > db.close(); > return latlngCursor; > } > public Cursor order() > { > Cursor latlngCursor1 = db.rawQuery("select * from " + > DATABASE_TABLE2,null); > if (latlngCursor1 != null) > { > latlngCursor1.moveToFirst(); > } > db.close(); > return latlngCursor1; > } > > > > > > > > } -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
