using spinner on ListView with Sql lite in android

问题:

My android app contains a list view that shows the data base context. This is what I want:

1-When the list view row gets clicked (itemClickListener),the custom spinner shows.

2-When a spinner item is selected, the title of it is shown in the list view fields.

3-At last: The color of the rows change, when an item is selected.

I've found a solution for no.1 in this link but I don't know about the other two. Would you please help me to solve these problems ?