come creare una listview con immagine e due dati da db

[Chry1911]

Salve amici

allora sono quasi al termine della mia app....ora mi serve solo un aiuto su come popolare la mia listview che ho creato con i dati dal mio db...
io faccio questo metodo nel db:

public ArrayList<Note> GetNotes(String mail){
        SQLiteDatabase db = this.getReadableDatabase();
        ArrayList<Note> notes = new ArrayList<Note>();
        notes.clear();
        String sql = "SELECT titolo, colore, data_scadenza FROM ToDoNotes_Notes WHERE email_user = '" + mail + "'";
        Cursor cursor = db.rawQuery(sql, null);
        if(cursor != null || cursor.getCount() != 0){
            if(cursor.moveToFirst()){
                do{

                    String titolo = (cursor.getString(cursor.getColumnIndex("titolo")));
                    String colore =(cursor.getString(cursor.getColumnIndex("colore")));
                    String data_sca =(cursor.getString(cursor.getColumnIndex("data_scadenza")));
                    Note n = new Note(titolo,"","",colore,data_sca);
                    notes.add(n);
                    Log.d("tutte le note", n.toString());

                } while (cursor.moveToNext());
            }
        }
        cursor.close();
        return notes;


    }

poi ho creato questo layout xml
<?xml version="1.0" encoding="utf-8"?><br /> <RelativeLayout xmlns:android ="http://schemas.android.com/<span class="forTooltip">apk</span>/res/android"<br /> android:layout_width="match_parent"<br /> android:layout_height="match_parent"<br /> android:orientation="horizontal"<br /> android:padding ="10dp"><br /> <br /> <TextView<br /> android:id="@+id/colorenota"<br /> android:layout_width="wrap_content"<br /> android:layout_height="wrap_content"<br /> android:layout_alignParentLeft="true"<br /> android:layout_centerVertical="true"/><br /> <br /> <br /> <TextView<br /> android:id="@+id/titolo"<br /> android:layout_width="150dp"<br /> android:layout_height="wrap_content"<br /> android:layout_toRightOf="@id/colorenota"<br /> android:layout_centerVertical="true"/><br /> <br /> <TextView<br /> android:id="@+id/scadenza"<br /> android:layout_width="wrap_content"<br /> android:layout_height="wrap_content"<br /> android:layout_toRightOf="@id/titolo"<br /> android:layout_centerVertical="true"/><br /> </RelativeLayout><br />

 

1

<?xml version="1.0" encoding="utf-8"?>

2

<RelativeLayout xmlns:android ="http://schemas.android.com/apk/res/android"

3

    android:layout_width="match_parent"

4

    android:layout_height="match_parent"

5

    android:orientation="horizontal"

6

    android:padding ="10dp">

7

​

8

    <TextView

9

        android:id="@+id/colorenota"

10

        android:layout_width="wrap_content"

11

        android:layout_height="wrap_content"

12

        android:layout_alignParentLeft="true"

13

        android:layout_centerVertical="true"/>

14

​

15

​

16

    <TextView

17

        android:id="@+id/titolo"

18

        android:layout_width="150dp"

19

        android:layout_height="wrap_content"

20

        android:layout_toRightOf="@id/colorenota"

21

        android:layout_centerVertical="true"/>

22

​

23

    <TextView

24

        android:id="@+id/scadenza"

25

        android:layout_width="wrap_content"

26

        android:layout_height="wrap_content"

27

        android:layout_toRightOf="@id/titolo"

28

        android:layout_centerVertical="true"/>

29

</RelativeLayout>

30

​

e la mia main activity cosi:
?xml version="1.0" encoding="utf-8"?><br /> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"<br /> xmlns:tools="http://schemas.android.com/tools"<br /> android:layout_width="match_parent"<br /> android:layout_height="match_parent"<br /> tools:context=".MainActivity"<br /> android:background="#D6D6D6"><br /> <br /> <br /> <LinearLayout<br /> android:layout_width="fill_parent"<br /> android:layout_height="wrap_content"<br /> android:layout_alignParentT<span class="forTooltip">op</span>="true"<br /> android:orientation="vertical"><br /> <br /> <br /> <include<br /> android:id="@+id/toolbar"<br /> layout="@layout/toolbar"/><br /> <br /> <br /> <ListView<br /> xmlns:android ="http://schemas.android.com/apk/res/android"<br /> xmlns:tools="http://schemas.android.com/tools"<br /> android:layout_width="match_parent"<br /> android:layout_height="match_parent"<br /> android:id="@+id/listview"<br /> tools:context=".MainActivity"><br /> <br /> </ListView><br /> <br /> <br /> </LinearLayout><br /> <br /> <br /> </RelativeLayout>

36

 

1

?xml version="1.0" encoding="utf-8"?>

2

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

3

    xmlns:tools="http://schemas.android.com/tools"

4

    android:layout_width="match_parent"

5

    android:layout_height="match_parent"

6

    tools:context=".MainActivity"

7

    android:background="#D6D6D6">

8

​

9

​

10

    <LinearLayout

11

    android:layout_width="fill_parent"

12

    android:layout_height="wrap_content"

13

    android:layout_alignParentTop="true"

14

    android:orientation="vertical">

15

​

16

​

17

    <include

18

    android:id="@+id/toolbar"

19

    layout="@layout/toolbar"/>

20

​

21

​

22

    <ListView

23

        xmlns:android ="http://schemas.android.com/apk/res/android"

24

        xmlns:tools="http://schemas.android.com/tools"

25

        android:layout_width="match_parent"

26

        android:layout_height="match_parent"

27

        android:id="@+id/listview"

28

        tools:context=".MainActivity">

29

​

30

    </ListView>

31

​

32

​

33

    </LinearLayout>

34

​

35

​

36

</RelativeLayout>

cosa devo fare nella main activity per avere le 3 info che voglio??