samedi 28 février 2015

Data is not retrieving from android SQLite

I am trying to retrieve data from sq lite database in array list in toast message, but showing


[ util.AllProfileElement @4b0ae658,util.AllProfileElement @4b0a258c,...........]


like something my data is save in database which i confirm through toast message please help me get out of thisenter code here


Database Helper Class:



package database;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DatabaseHeleper extends SQLiteOpenHelper{

// Database Name
private static final String DATABASE_NAME = "profile.db";
// All Static variables
// Database Version
private static final int DATABASE_VERSION = 1;
//table name
public static final String PROFILE_TABLE_NAME = "profile_table";

// Table Columns names
public static final String COL_PROFILE_ID = "id";
public static final String COL_PROFILE_NAME = "name";
public static final String COL_PROFILEE_GENDER = "gender";
public static final String COL_PROFILE_BLOOD = "blood";
public static final String COL_PROFILE_AGE= "age";
public static final String COL_PROFILE_HEIGHT= "height";
public static final String COL_PROFILE_WEIGHT = "weight";

// table information
private static final String DATABASE_PROFILE_TABLE = "create table "+ PROFILE_TABLE_NAME +
"( " + COL_PROFILE_ID + " integer primary key autoincrement, " + " "
+ COL_PROFILE_NAME + " text not null," + " "
+ COL_PROFILEE_GENDER + " text not null," + " "
+ COL_PROFILE_BLOOD + " text not null," + " "
+ COL_PROFILE_AGE + " text not null," + " "
+ COL_PROFILE_HEIGHT + " text not null," + " "
+ COL_PROFILE_WEIGHT + " text not null);";



public DatabaseHeleper(Context thiscontext) {
// TODO Auto-generated constructor stub
super(thiscontext, DATABASE_NAME, null, DATABASE_VERSION);

}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(DATABASE_PROFILE_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.w(DatabaseHeleper.class.getName(), "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_PROFILE_TABLE);
onCreate(db);
}


}


and ******Database Source code is:******



enter code here



package database;

import java.util.ArrayList;

import util.AllNameList;
import util.AllProfileElement;


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;

public class DatabaseSource {

private SQLiteDatabase mDB;
private DatabaseHeleper mHelper;




public DatabaseSource(Context thiscontext) {
// TODO Auto-generated constructor stub
mHelper = new DatabaseHeleper(thiscontext);
}

public void open() throws SQLException {
mDB = mHelper.getWritableDatabase();
}

public void close() {
mHelper.close();
}


public long insertData(AllProfileElement object) {

try {
open();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


ContentValues values = new ContentValues();

values.put(DatabaseHeleper.COL_PROFILE_NAME, object.getName());
values.put( DatabaseHeleper.COL_PROFILE_AGE, object.getAge());
values.put( DatabaseHeleper .COL_PROFILEE_GENDER, object.getGender());
values.put( DatabaseHeleper .COL_PROFILE_BLOOD, object.getBlood());
values.put( DatabaseHeleper .COL_PROFILE_HEIGHT,object.getHeight());
values.put( DatabaseHeleper .COL_PROFILE_WEIGHT, object.getWeight());

long inserted = mDB.insert( DatabaseHeleper. PROFILE_TABLE_NAME, null, values);
close();

this.close();

return inserted;
}
//public ArrayList<AllProfileElement> getAllProfile() {
public ArrayList<AllProfileElement> getAllProfile()
{
//ArrayList<AllProfileElement> allprofile = new ArrayList<AllProfileElement>();
ArrayList<AllProfileElement> allprofile = new ArrayList<AllProfileElement>();
/* try {
open();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

Cursor mCursor = mDB.query(DatabaseHeleper.PROFILE_TABLE_NAME, null, null, null, null,
null, null);*/

try {
open();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

Cursor mCursor = mDB.query(DatabaseHeleper.PROFILE_TABLE_NAME, null, null, null, null,
null, null);



// looping through all rows and adding to list
if (mCursor != null && mCursor.getCount() > 0) {
mCursor.moveToFirst();

for (int i = 0; i < mCursor.getCount(); i++) {

int mID = mCursor.getInt(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILE_ID));
String name = mCursor.getString(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILE_NAME));
String age = mCursor.getString(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILE_AGE));
String gender = mCursor.getString(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILEE_GENDER));
String blood = mCursor.getString(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILE_BLOOD));
String height = mCursor.getString(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILE_HEIGHT));
String weight = mCursor.getString(mCursor.getColumnIndex(DatabaseHeleper.COL_PROFILE_WEIGHT));
AllProfileElement mProfile = new AllProfileElement(mID, name,age,gender,blood,height,weight);

allprofile.add(mProfile);
mCursor.moveToNext();
}
}
mCursor.close();
mDB.close();

// return place list
return allprofile;
}

}

Aucun commentaire:

Enregistrer un commentaire