Langsung ke konten utama

SQLiteDatabase Part3: Retrieve data from Database Example

Part 3: view all details which are available in database


ScreenShos:






Step 1: Add the following method in DBAdapter

DBAdapter.java

       public Cursor getAllValues(){
              return database.rawQuery("select * from sample_table", null);
       }

Step 2: Create custom xml to inflate to ListView

custom_listview_item.xml

<?xml version="1.0"encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <TextView
        android:id="@+id/custom_textView_name"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:text="Name :"
        android:textAppearance="?android:attr/textAppearanceLarge"/>

    <TextView
        android:id="@+id/custom_textView_contact"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/custom_textView_name"
        android:layout_marginTop="20dp"
        android:text="Contact :"
        android:textAppearance="?android:attr/textAppearanceMedium"/>

    <TextView
        android:id="@+id/custom_textView_id"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentRight="true"
        android:layout_alignParentTop="true"
        android:text="id :" />

</RelativeLayout>

Step 3: create ViewAllActivity and its respective layout file

activity_view_all.xml

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".ViewAllActivity" >

    <ListView
        android:id="@+id/viewall_listView"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true">
    </ListView>

</RelativeLayout>

ViewAllActivity.java

packagecom.swamys.databaseexample;

importandroid.app.Activity;
importandroid.database.Cursor;
import android.os.Bundle;
import android.view.View;
importandroid.view.ViewGroup;
importandroid.widget.BaseAdapter;
importandroid.widget.ListView;
importandroid.widget.TextView;

importcom.swamys.database.dbadapter.DBAdapter;

public class ViewAllActivity extends Activity {

       DBAdapter dbAdapter;
       ListView listView;
       Cursor cursor;

       @Override
       protected void onCreate(Bundle savedInstanceState) {
              super.onCreate(savedInstanceState);
              setContentView(R.layout.activity_view_all);

              listView = (ListView) findViewById(R.id.viewall_listView);
              dbAdapter = newDBAdapter(getApplicationContext());
              cursor = dbAdapter.getAllValues();
              cursor.moveToFirst();
              MyAdapter adapter = new MyAdapter();
              listView.setAdapter(adapter);
       }

       private class MyAdapter extends BaseAdapter {

              @Override
              public int getCount() {
                     return cursor.getCount();
              }

              @Override
              public Object getItem(int position) {
                     return null;
              }

              @Override
              public long getItemId(int position) {
                     return 0;
              }

              @Override
              public View getView(int position, View convertView, ViewGroup parent) {

                     cursor.moveToPosition(position);
                     View view = getLayoutInflater().inflate(
                                  R.layout.custom_listview_item, null);
                     TextView textView_name = (TextView) view
                                  .findViewById(R.id.custom_textView_name);
                     TextView textView_contact = (TextView) view
                                  .findViewById(R.id.custom_textView_contact);
                     TextView textView_id = (TextView) view
                                  .findViewById(R.id.custom_textView_id);
                     textView_id.setText("" + cursor.getInt(0));
                     textView_name.setText(cursor.getString(1));
                     textView_contact.setText(cursor.getString(2));

                     return view;
              }
       }

       @Override
       protected void onDestroy() {
              super.onDestroy();
              dbAdapter.closeConnection();
       }

}

Step 4: create a button in main Layout add the following code

activity_main.xml

    <Button
        android:id="@+id/main_button_view"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/main_button_insert"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="30dp"
        android:text="View All"
        android:onClick="viewAll" />

Step 5: add the view button Click method in MainActivity

MainActivity.java

public void viewAll(View view){
              Intent intent = new Intent(getApplicationContext(),ViewAllActivity.class);
              startActivity(intent);
             
       }

Step 6: Register ViewAllActivity in manifest

Manifest.xml

<?xml version="1.0"encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.swamys.databaseexample"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk
        android:minSdkVersion="9"
        android:targetSdkVersion="17" />

    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name="com.swamys.databaseexample.MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN"/>

                <category android:name="android.intent.category.LAUNCHER"/>
            </intent-filter>
        </activity>
        <activity
            android:name="com.swamys.databaseexample.InsertActivity"
            android:label="@string/title_activity_insert" >
        </activity>
        <activity
            android:name="com.swamys.databaseexample.ViewAllActivity"
            android:label="@string/title_activity_view_all">
        </activity>
    </application>

</manifest>






Komentar

Postingan populer dari blog ini

Android Tutorial: Use LeakCanary to detect memory leaks

Overview The memory leak can be a headache to detect and to resolve, small memory leaks can be hidden and may be seen after a long usage of the application and hunting memory leaks is not a simple task. In this tutorial we will create a leaked application and we will use the LeakCanary library to detect the memory leak. Step 1: add the LeakCanary dependency to the application Modify the app/build.gradle to add the LeakCanary dependency as follows: Step 2: Extend and configure the Application class We need to call LeakCanary.install in onCreate method: Step 3: Create a leaked activity For this we will create a singleton class that saves the context: Then, the main activity (leaked one), will use the singleton and then we'll go to a new activity: Then, in the new activity we'll call System.gc to force the garbage collector in order to accelerate the analysis. Step 4: Retrieve the analysis result A nice notification can be shown: The result can be retrieved from logcat: Source c...

FlatBuffers Android Tutorial

FlatBuffers is an efficient cross platform serialization library for C++, Java, C#, Go, Python and JavaScript. It was originally created at Google for game development and other performance-critical applications. FlatBuffers is Open Source (Apache license V2) and available on GitHub . It's currently used by:   Cocos2d-x , the open source mobile game engine and used to serialize the game data. Facebook uses it for client-server communication in the Android app (see the article) . Fun Propulsion Labs at Google in most of libraries and games. Solution overview  The schema will be defind in JSON format, then it will be converted to FlatBuffer format outside the application The Java classes of the Data model will be generated manually using flatc (FlatBuffer compiler) Step 1: Build FlatBuffers Download the source code in Google’s flatbuffers repository .  The build process is described on Google's documentation FlatBuffers Building .  On MacOS for example: Open the ...

QR-Code Generator - Library

In this Post, I introduce my new Gradle Library. This Library is used to Generate QR Code Automatically for our specified input. How to Import the Library: Gradle: compile 'androidmads.library.qrgenearator:QRGenearator:1.0.0' Permission: <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/> How to use this Library: After importing this library, use the following lines to use this library. The following lines are used to generated the QR Code // Initializing the QR Encoder with your value to be encoded, type you required and Dimension QRGEncoder qrgEncoder = new QRGEncoder(inputValue, null, QRGContents.Type.TEXT, smallerDimension); try { // Getting QR-Code as Bitmap bitmap = qrgEncoder.encodeAsBitmap(); // Setting Bitmap to ImageView qrImage.setImageBitmap(bitmap); } catch (WriterException e) { Log.v(TAG, e.toString()); } Save QR Code as Image // Save with location, value, bitmap returned and type of Image(JPG/PNG). QRGSaver.save(s...