David lived a real life in a real world.  He experienced ups and downs like the rest of us.  The Book of Psalms is filled with many of these experiences.  David experienced the power of how to overcome problems by prayer and praise.  When David got real with God, God got real with him.