[android-developers] Error while Creating the Two tables in Single DataBAse Android Application?
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()
[android-developers] In Android How to Save the images in OnDraw While Adding Many pictures?
Hai i used onDraw() in My Application,i can view the images ins
working fine.My problem is to save the images.
here my code to draw the images,My problem is Mentioned below.
protected void onDraw(Canvas canvas)
{
// TODO Auto-generated method stub
Paint paint = new Paint();
Bitmap myBitmap =
BitmapFactory.decodeResource(getResources(),R.drawable.ban_background);
Bitmap
resizeImage1=Bitmap.createScaledBitmap(myBitmap,590,350,false);
canvas.drawColor(Color.BLACK);
canvas.drawBitmap(resizeImage1,10,5, null);
Bitmap icon;
try { // Get reference to AssetManager
AssetManager mngr = getAssets();
// Create an input stream to read from
the asset folder
InputStream ins = mngr.open(imageName
+".png");
icon = BitmapFactory.decodeStream(ins);
Bitmap
icon9=Bitmap.createScaledBitmap(icon,590,250,false);
canvas.drawBitmap(icon9,1,60, null);
}
catch (IOException e) {
e.printStackTrace();
}
if(isCamera)
{
icon1 = BitmapFactory.decodeByteArray(pictureByte,
0,pictureByte.length);
Bitmap
resizeImage=Bitmap.createScaledBitmap(icon1,150,170,false);
canvas.drawBitmap(resizeImage,400,100, null);
}
Bitmap toDisk = Bitmap.createBitmap(resizeImage1);
canvas.setBitmap(toDisk);
try {
toDisk.compress(Bitmap.CompressFormat.JPEG, 100, new
FileOutputStream(new File("/mnt/sdcard/arun.jpg")));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch
block
e.printStackTrace();
}
}
}
Bitmap toDisk = Bitmap.createBitmap(resizeImage1);
Here i can Save the image (resizeImage1),i can passed the Single value
only.i cannot access all pictures.i add many pictures in onDraw();how
can i access all pictures in Canvas?
--
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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
[android-developers] Error message while running SQLite Database
Hello Sir i created a Android Application by using SQLiteDatabase, my project is launch Succesfully.But i got runtime Exception. va/lang/String;)V (CallStaticVoidMethodV) W/dalvikvm( 170): Pending exception is: I/dalvikvm( 170): java.lang.RuntimeException: android.os.RemoteException I/dalvikvm( 170): at android.os.Parcel.writeException(Parcel.java:1222) I/dalvikvm( 170): at android.os.Binder.execTransact(Binder.java: 341) I/dalvikvm( 170): at com.android.server.SystemServer.init1(Native Method) I/dalvikvm( 170): at com.android.server.SystemServer.main(SystemServer.jav a:643) I/dalvikvm( 170): at java.lang.reflect.Method.invokeNative(Native Method) I/dalvikvm( 170): at java.lang.reflect.Method.invoke(Method.java: 491) I/dalvikvm( 170): at com.android.internal.os.ZygoteInit $MethodAndArgsCalle r.run(ZygoteInit.java:841) I/dalvikvm( 170): at com.android.internal.os.ZygoteInit.main(ZygoteInit.ja va:599) I/dalvikvm( 170): at dalvik.system.NativeStart.main(Native Method) I/dalvikvm( 170): Caused by: I/dalvikvm( 170): android.os.RemoteException: I/dalvikvm( 170): at com.android.server.CountryDetectorService.detectCount ry(CountryDetectorService.java:96) I/dalvikvm( 170): at android.location.ICountryDetector $Stub.onTransact(ICo untryDetector.java:53) I/dalvikvm( 170): at android.os.Binder.execTransact(Binder.java: 339) I/dalvikvm( 170): at com.android.server.SystemServer.init1(Native Method) I/dalvikvm( 170): at com.android.server.SystemServer.main(SystemServer.jav a:643) I/dalvikvm( 170): at java.lang.reflect.Method.invokeNative(Native Method) I/dalvikvm( 170): at java.lang.reflect.Method.invoke(Method.java: 491) I/dalvikvm( 170): at com.android.internal.os.ZygoteInit $MethodAndArgsCalle r.run(ZygoteInit.java:841) I/dalvikvm( 170): at com.android.internal.os.ZygoteInit.main(ZygoteInit.ja va:599) I/dalvikvm( 170): at dalvik.system.NativeStart.main(Native Method) I/dalvikvm( 170): "main" prio=5 tid=1 NATIVE I/dalvikvm( 170): | group="main" sCount=0 dsCount=0 obj=0x4001b5c8 self=0x125 d8 I/dalvikvm( 170): | sysTid=170 nice=0 sched=0/0 cgrp=default handle=-13429134 32 I/dalvikvm( 170): | schedstat=( 913830670 679912199 101 ) utm=55 stm=36 core= 0 I/dalvikvm( 170): at com.android.server.SystemServer.init1(Native Method) I/dalvikvm( 170): at com.android.server.SystemServer.main(SystemServer.java:6 43) I/dalvikvm( 170): at java.lang.reflect.Method.invokeNative(Native Method) I/dalvikvm( 170): at java.lang.reflect.Method.invoke(Method.java: 491) I/dalvikvm( 170): at com.android.internal.os.ZygoteInit $MethodAndArgsCaller.r un(ZygoteInit.java:841) I/dalvikvm( 170): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java: 599) I/dalvikvm( 170): at dalvik.system.NativeStart.main(Native Method) I/dalvikvm( 170): E/dalvikvm( 170): VM aborting I/DEBUG ( 31): *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** * ** -- 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
