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
