using spinner on ListView qith Sql lite in android

my android app contains a list view that shows data base 's context. this is my want:

1-as list view's row clicks (itemClickListener), custom spinner shows.

2-by selecting spinner's item, the title of it shows in list view's fields.

3-and at last, the row's color changes, as each item select.

I find a solution for no 1 in this link.but I don't know about others. would you please help me to complete this question.