Skip to main content

Get all records from SQLite in ANDROID

For COMPLETE TUTORIALS see here :
in DABASEHELPER CLASS :
  String[] coloumns = new String[] { KEY_ROWID, KEY_NAME,KEY_NICKNAME }; // calling  all  elements in an array
  Cursor c = db.query(DATABASE_TABLE, coloumns, null, null, null, null,null);// basically reading a database need cursor
  String result = " ";// since string is to be returned
  System.out.println("count of cursor=====>>" + c.getCount());

  int iRowid = c.getColumnIndex(KEY_ROWID);
                // calling each row values
  int iRowName = c.getColumnIndex(KEY_NAME);
  int iRowNickName = c.getColumnIndex(KEY_NICKNAME);
  
     if (c.moveToFirst()) {
         c.moveToFirst();
          for (int i = 0; i < c.getCount(); i++) {result
                      = result + c.getString(iRowid) + " "
                      + c.getString(iRowName) + " "
                      + c.getString(iRowNickName) + "\n";
     System.out.println(result + " <> " + iRowid + " <> "+ iRowName);
         c.moveToNext();
            }
        }
        c.close();
        db.close();
        return result;
in sqlite.java :
       TextView infotext=(TextView) findViewById(R.id.tvsqlinfo);
       DBAdapter info = new DBAdapter(this);
       info.open();
       String data =info.getdata();
       System.out.println("result is ==========>>" + data);
       info.close();
       infotext.setText(data);
       infotext.setTextColor(Color.RED);

Comments

Popular posts from this blog

Spannable String in Android - URL Span ,Clickable Span, Rich-Style Formatting of Textview .....

See more Android Tutorials here....... Faster Loading images in GridViews or ListViews Spannable brings lots of possibility to TextView, includes displaying various appearance of a Text and onClick callbak. The SpannableString class allows you to easily format certain pieces which are called spans of a string, by applying CharacterStyle ie,color, font, ormake it a link . Here is an example where, explained how to use spannable string to give font size, color, linking a text via clickable span and through URL Span and to strike through the text. Lets go through the example : import android.os.Bundle; import android.text.SpannableString; import android.text.method.LinkMovementMethod; import android.text.style.ClickableSpan; import android.text.style.ForegroundColorSpan; import android.text.style.RelativeSizeSpan; import android.text.style.StrikethroughSpan; import android.text.style.URLSpan; import android.view.View; import android.widget.TextView; import android.widget.Toast;

Passing Images between Activities in Android

in First Activity: Intent intent=new Intent(FirstClass.this, SecondClass.class); Bundle bundle=new Bundle(); bundle.putInt("image",R.drawable.ic_launcher); intent.putExtras(bundle); startActivity(intent); in Second Acticity: Bundle bundle=this.getIntent().getExtras(); int pic=bundle.getInt("image"); v.setImageResource(pic); another method: in First Activity: Drawable drawable=imgv.getDrawable(); Bitmap bitmap= ((BitmapDrawable)drawable).getBitmap(); ByteArrayOutputStream baos = new ByteArrayOutputStream(); bitmap.compress(Bitmap.CompressFormat.PNG, 100, baos); byte[] b = baos.toByteArray(); Intent intent=new Intent(Passimage.this,myclass.class); intent.putExtra("picture", b); startActivity(intent); in Second Acticity: Bundle extras = getIntent().getExtras(); byte[] b = extras.getByteArray("picture"); Bitmap bmp = BitmapFactory.decodeByteArray(b, 0, b.lengt

Show and Resume Android Soft-Keyboard

Code to show keyboard: InputMethodManager imm = (InputMethodManager)getSystemService(Context.INPUT_METHOD_SERVICE); imm.showSoftInput(yourEditText,InputMethodManager.SHOW_IMPLICIT); Code resume keyboard : InputMethodManager imm = (InputMethodManager)gettSystemService(Context.INPUT_METHOD_SERVICE); imm.hideSoftInputFromWindow(yourEditText.getWindowToken(), 0);