Yes, basically, when a user requests a page a database connection is made. Every query for the generated page is done using that connection, and when the page is served, the connection is closed.