later to have the "Amount"
field be a number rather than text?
On Dec 22, 11:21 pm, niva k <elakkiya...@gmail.com> 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 android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
No comments:
Post a Comment