SQlite on list view... PLS HELP

  • Replies:0
Cosmic AD
  • Forum posts: 1

Dec 14, 2016, 2:41:32 PM via Website

Pls check the code ...the code run well but the list view shows

com.example.cosmic.myapplication.DB.Registration@cc4922c
com.example.cosmic.myapplication.DB.Registration@e43d4f5
com.example.cosmic.myapplication.DB.Registration@42828c

instead of Data from database

Registration.java

package com.example.cosmic.myapplication.DB;

/**
 * Created by cosmic on 12/12/16.
 */

public class Registration {

    private long reg;
    private String email;

    public long getReg() {
        return reg;
    }

    public void setReg(long reg) {
        this.reg = reg;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    private String password;
    private String mobile;
}

mainActivity.java

package com.example.cosmic.myapplication;

import android.content.Context;


import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import java.lang.String;
import android.widget.ArrayAdapter;
import java.util.*;
import android.widget.ListView;
import android.widget.TextView;

import com.example.cosmic.myapplication.DB.LoginDatasource;


public class Main5Activity extends AppCompatActivity {

    LoginDatasource dataSource;

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


        dataSource = new LoginDatasource(this);
        dataSource.open();


        ArrayAdapter adpt = new ArrayAdapter(this, R.layout.listview_item, dataSource.getAllContacts());

        ListView lv = (ListView) findViewById(R.id.lists);

        lv.setAdapter(adpt);


    }



}

getallcontacts()

public List<Registration> getAllContacts() {

            List<Registration> contactList = new ArrayList<Registration>();

            // Select All Query
            String selectQuery = "SELECT  email,password,mobile FROM " + loginOpenhelper.TABLE_REGISTRATION;

            //SQLiteDatabase db = this.getWritableDatabase();
            Cursor cursor = database.rawQuery(selectQuery, null);

            // Registration contact = new Registration();

            // looping through all rows and adding to list
            if (cursor.moveToFirst()) {
                do {
                    Registration contact = new Registration();

                    //contact.setEmail(Integer.parseInt(cursor.getString(0)));
                    contact.setEmail(cursor.getString(0));
                    contact.setMobile(cursor.getString(2));
                    // Adding contact to list
                    contactList.add(contact);
                } while (cursor.moveToNext());
            }

            // return contact list

            return contactList;
        }

Pls Help ...

Reply