5924

custom list view with images and database connectivity

Question:

I am trying to create an application regarding the custom view which is connected with sqllite database.I consists of images also.

<strong>The Problem is:When I am trying to execute the program in the emulator it is show the icons(images) are occurring repeatedly every time when I am executing the program .For example my program consists of facebook.png. First time when I am executing only one image is being displayed.Again when trying to execute Two Facebook icons are coming. How to remove solve this issue</strong>

The code is as follows:

MainActivity.java

package com.example.sqlliteimagedemo; import java.io.ByteArrayOutputStream; import java.util.ArrayList; import java.util.List; import android.graphics.Bitmap; import android.graphics.BitmapFactory; import android.os.Bundle; import android.support.v7.app.ActionBarActivity; import android.util.Log; import android.widget.ListView; public class MainActivity extends ActionBarActivity { ArrayList<Contact> imageArry = new ArrayList<Contact>(); ContactImageAdapter adapter; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); DataBaseHandler db = new DataBaseHandler(this); // get image from drawable Bitmap image = BitmapFactory.decodeResource(getResources(),R.drawable.facebook); // convert bitmap to byte ByteArrayOutputStream stream = new ByteArrayOutputStream(); image.compress(Bitmap.CompressFormat.JPEG, 50, stream); byte imageInByte[] = stream.toByteArray(); /** * CRUD Operations * */ // Inserting Contacts Log.d("Insert: ", "Inserting .."); db.addContact(new Contact("FaceBook", imageInByte)); // display main List view bcard and contact name // Reading all contacts from database List<Contact> contacts = db.getAllContacts(); for (Contact cn : contacts) { String log = "ID:" + cn.getID() + " Name: " + cn.getName() + " ,Image: " + cn.getImage(); // Writing Contacts to log Log.d("Result: ", log); //add contacts data in arrayList imageArry.add(cn); } adapter = new ContactImageAdapter(this, R.layout.screen_list, imageArry); ListView dataList = (ListView) findViewById(R.id.list); dataList.setAdapter(adapter); } }

ContactImageAdapter.java

package com.example.sqlliteimagedemo; import java.io.ByteArrayInputStream; import java.util.ArrayList; import android.app.Activity; import android.content.Context; import android.graphics.Bitmap; import android.graphics.BitmapFactory; import android.view.LayoutInflater; import android.view.View; import android.view.ViewGroup; import android.widget.ArrayAdapter; import android.widget.ImageView; import android.widget.TextView; public class ContactImageAdapter extends ArrayAdapter<Contact> { Context context; int layoutResourceId; // BcardImage data[] = null; ArrayList<Contact> data=new ArrayList<Contact>(); public ContactImageAdapter(Context context,int layoutResourceId, ArrayList<Contact> data) { super(context, layoutResourceId, data); this.layoutResourceId = layoutResourceId; this.context = context; this.data = data; } @Override public View getView(int position, View convertView, ViewGroup parent) { View row = convertView; ImageHolder holder = null; if(row == null) { LayoutInflater inflater = ((Activity) context).getLayoutInflater(); row = inflater.inflate(layoutResourceId, parent, false); holder = new ImageHolder(); holder.txtTitle = (TextView)row.findViewById(R.id.txtTitle); holder.imgIcon = (ImageView)row.findViewById(R.id.imgIcon); row.setTag(holder); } else { holder = (ImageHolder)row.getTag(); } Contact picture = data.get(position); holder.txtTitle.setText(picture._name); //convert byte to bitmap take from contact class byte[] outImage=picture._image; ByteArrayInputStream imageStream = new ByteArrayInputStream(outImage); Bitmap theImage = BitmapFactory.decodeStream(imageStream); holder.imgIcon.setImageBitmap(theImage); return row; } static class ImageHolder { ImageView imgIcon; TextView txtTitle; } }

DataBaseHandler.java

package com.example.sqlliteimagedemo; import java.util.ArrayList; import java.util.List; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class DataBaseHandler extends SQLiteOpenHelper { // All Static variables // Database Version private static final int DATABASE_VERSION = 1; // Database Name private static final String DATABASE_NAME = "imagedb"; // Contacts table name private static final String TABLE_CONTACTS = "contacts"; // Contacts Table Columns names private static final String KEY_ID = "id"; private static final String KEY_NAME = "name"; private static final String KEY_IMAGE = "image"; public DataBaseHandler(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } //creating tables @Override public void onCreate(SQLiteDatabase db) { String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "(" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT," + KEY_IMAGE + " BLOB" + ")"; db.execSQL(CREATE_CONTACTS_TABLE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { //Drop older table if existed db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS); // Create tables again onCreate(db); } /** * All CRUD(Create, Read, Update, Delete) Operations */ public// Adding new contact void addContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(KEY_NAME, contact._name); // Contact Name values.put(KEY_IMAGE, contact._image); // Contact Phone // Inserting Row db.insert(TABLE_CONTACTS, null, values); db.close(); // Closing database connection } // Getting single contact Contact getContact(int id) { SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.query(TABLE_CONTACTS, new String[] { KEY_ID, KEY_NAME, KEY_IMAGE }, KEY_ID + "=?", new String[] { String.valueOf(id) }, null, null, null, null); if (cursor != null) cursor.moveToFirst(); Contact contact = new Contact(Integer.parseInt(cursor.getString(0)), cursor.getString(1), cursor.getBlob(1)); // return contact return contact; } // Getting All Contacts public List<Contact> getAllContacts() { List<Contact> contactList = new ArrayList<Contact>(); // Select All Query String selectQuery = "SELECT * FROM contacts ORDER BY name"; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { Contact contact = new Contact(); contact.setID(Integer.parseInt(cursor.getString(0))); contact.setName(cursor.getString(1)); contact.setImage(cursor.getBlob(2)); // Adding contact to list contactList.add(contact); } while (cursor.moveToNext()); } // close inserting data from database db.close(); // return contact list return contactList; } // Updating single contact public int updateContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(KEY_NAME, contact.getName()); values.put(KEY_IMAGE, contact.getImage()); // updating row return db.update(TABLE_CONTACTS, values, KEY_ID + " = ?", new String[] { String.valueOf(contact.getID()) }); } // Deleting single contact public void deleteContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); db.delete(TABLE_CONTACTS, KEY_ID + " = ?", new String[] { String.valueOf(contact.getID()) }); db.close(); } // Getting contacts Count public int getContactsCount() { String countQuery = "SELECT * FROM " + TABLE_CONTACTS; SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.rawQuery(countQuery, null); cursor.close(); // return count return cursor.getCount(); } }

activity_main.xml

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent" android:orientation="vertical" > <ListView android:id="@+id/list" android:layout_width="fill_parent" android:layout_height="0dp" android:layout_weight="0.55" > </ListView> </LinearLayout>

screen_list.xml

<?xml version="1.0" encoding="UTF-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent" android:orientation="horizontal" android:padding="10dp" > <ImageView android:id="@+id/imgIcon" android:layout_width="0dp" android:layout_height="100dp" android:layout_weight="0.71" android:gravity="center_vertical" /> <TextView android:id="@+id/txtTitle" android:layout_width="80dp" android:layout_height="fill_parent" android:gravity="center_vertical" android:textSize="14dp" android:layout_marginLeft="7dp" /> </LinearLayout>

Please Help..

Answer1:

Your adding facebook contact Log.d("Insert: ", "Inserting .."); db.addContact(new Contact("FaceBook", imageInByte)); before showing the list.

You Code Running like this:- refer below points

<ul><li>When first time you execute, one facebook added.</li> <li>Again when you execute the program, New facebook contact added. So it shows two contacts.</li> <li>Like wise it gets added and printed, whenever you execute the program</li> </ul>

Updated Code:- `

@Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); DataBaseHandler db = new DataBaseHandler(this); // get image from drawable Bitmap image = BitmapFactory.decodeResource(getResources(),R.drawable.facebook); // convert bitmap to byte ByteArrayOutputStream stream = new ByteArrayOutputStream(); image.compress(Bitmap.CompressFormat.JPEG, 50, stream); byte imageInByte[] = stream.toByteArray(); /** * CRUD Operations * */ // Inserting Contacts Log.d("Insert: ", "Inserting .."); //Added Code below SharedPreferences preferences = getSharedPreferences("SETTINGS_PREF", Context.MODE_PRIVATE); if(preferences.getBoolean("isFirstLaunch", true)){ db.addContact(new Contact("FaceBook", imageInByte)); SharedPreferences.Editor editor = preferences.edit(); editor.putBoolean("isFirstLaunch", false); editor.commit(); } // display main List view bcard and contact name // Reading all contacts from database List<Contact> contacts = db.getAllContacts(); for (Contact cn : contacts) { String log = "ID:" + cn.getID() + " Name: " + cn.getName() + " ,Image: " + cn.getImage(); // Writing Contacts to log Log.d("Result: ", log); //add contacts data in arrayList imageArry.add(cn); } adapter = new ContactImageAdapter(this, R.layout.screen_list, imageArry); ListView dataList = (ListView) findViewById(R.id.list); dataList.setAdapter(adapter); }

Answer2:

try to use this

// Inserting Contacts Log.d("Insert: ", "Inserting .."); db.addContact(new Contact("FaceBook", imageInByte)); // display main List view bcard and contact name // ArrayList clear() operation removes all elements imageArry.clear(); // Reading all contacts from database List<Contact> contacts = db.getAllContacts();

Recommend

  • ImageJ jar file plugin shortcut creation - More help needed
  • java resize image dynamically to fit grids in gridlayout
  • How to change JLabel when JButton is clicked? [duplicate]
  • Write ObjectOutputStream append file, keep getting StreamCorruptedException error [duplicate]
  • MVC Url.Content with javascript local variable
  • RecyclerView on Click Listener Not working
  • Magento Product Images Full URL Path Instead of Cached
  • How to interchange between 2 timers? in Java GUI
  • How to get/read picture from Excel file (xlsx) using EPPlus
  • Using “await” in a converter (IValueConverter) not working?
  • Pending Intent triggered by Alarm Manager seems to fire right away
  • add an element to a node, if it doesnot exist
  • Display blob image in html with angularjs
  • How to parse nested JSON with GSON
  • Problem serializing DecimalFormatSymbols in 2.3.4
  • Issue with static code in Android
  • What should be the grok pattern for thoses logs ? (ingest pipeline for filebeat)
  • Displaying image retrieved from database to image control
  • How to Set wallpaper of image with its actual size?
  • Mapping ManyToMany with composite Primary key and Annotation:
  • What is the equivalent of Android permissions in iOS development? [duplicate]
  • Problem with rejecting incoming call
  • Why does it draw lines in the wrong place?
  • How can I enlarge video fullscreen without the affected interface project in as3?
  • MailKit: The IMAP server replied to the 'EXAMINE' command with a 'BAD' response
  • Python urlparse: small issue
  • Exception “firebase.functions() takes … no argument …” when specifying a region for a Cloud Function
  • FileReader+canvas image loading problem
  • Can a Chrome extension content script make an jQuery AJAX request for an html file that is itself a
  • Upload files with Ajax and Jquery
  • How to get icons for entities from eclipse?
  • How to delete a row from a dynamic generate table using jquery?
  • json Serialization in asp
  • AngularJs get employee from factory
  • Rails 2: use form_for to build a form covering multiple objects of the same class
  • Proper way to use connect-multiparty with express.js?
  • How to stop GridView from loading again when I press back button?
  • apache spark aggregate function using min value
  • python draw pie shapes with colour filled
  • Sorting a 2D array using the second column C++