title: How to integrate dao in my Java Project
body: <p>I am working to complete an assignment to integrate dao Support in my website. I have completed most of the part of creating separate dao for each table an integrating create/update/inset/delete functionality in them. I have some additional questions. I will be extremely grateful if you can point me to some resources as I am confused after reading many tutorials:</p>
  
  <ol>
  <li><p>How to i create connection manager. So that I have single connections for each dbo and what is the best design to implement it. Should I put the Connection object in daoManager or create a separate singleton class for that and keep an object.</p></li>
  <li><p>Once I have the Dao ready, how do I manage complex operation like join from my controller as each dao fetched object/data from their corresponding table. Do I need to join the output in my controller.</p></li>
  </ol>
  
  <p>Please pardon me if this doesn't make sense. I can add additional information if required.</p>