For the most part, Oliver is a little sad. But he always remains hopeful. He is hopeful that he will find someone who loves him, which he never had. This is portrayed in the song "Where Is Love".
The main flim of Oliver! (there has been many others) Mark Lester played Oliver the street child.
There have been a number of film and TV versions of Oliver Twist, and there are more closely related...