dimanche 26 juillet 2015

Passing data from database to intent

I am getting a random value from the database in my getnum function whenever i enter a 10 digit number but when i enter a number less than 10 digits,eveything works fine.
Please tell how to pass a 10 digit number in the getnum function.

  public void callme(View v)
{
    Intent i= new Intent();
    i.setData(Uri.parse("tel:" + mydb.getnum(id_To_Update)));
    i.setAction(Intent.ACTION_CALL);
    startActivity(i);
}

and this is my getnum function in MyDBHandler

 public Integer getnum(int id){
   int dat =0;
    SQLiteDatabase db = getReadableDatabase();
    Cursor cursor = db.rawQuery(
            "SELECT number FROM userdata1 where id="+id+"", null);
    if(cursor.moveToFirst()) {
        dat = cursor.getInt(0);
    }

    return dat;
}

And this is how i created MyDBHandler

public class MyDBHandler extends SQLiteOpenHelper {

public static final int DATABASE_VERSION=1;
public static final String DATABASE_NAME = "ome1.db";
public static final String TABLE_NAME = "userdata1";

public static final String COLUMN_ID = "id";
public static final String COLUMN_NAME = "name";
public static final String COLUMN_EMAIL = "email";
public static final String COLUMN_AMOUNT = "amount";
public static final String COLUMN_NUMBER = "number";

public MyDBHandler(Context context)

{
    super(context, DATABASE_NAME , null, 1);

}

@Override
public void onCreate(SQLiteDatabase db) {

        db.execSQL(
                "create table userdata1 " +
                        "(id integer primary key, name text,email text,amount integer,number integer)"
        );


}

Aucun commentaire:

Enregistrer un commentaire