title: How to append the multiple values from resultset?
body: <p>I have resultset with below data for one product code same like more productcodes. Now i want to get only itemcode and desc in single row as string in java. How to get these values ? I knew if going to get through SQL , its very simple.but i don't want to hit database again.I would like to use same resultset. Please advise.</p>
  
  <pre><code>product   itemcode  Desc
  6799        8205        OR
  6799        8206        OR
  6799        8208        OR
  6799        8422        OR
  6799        8424        OR
  6799        1381        OR
  6799        1485        OR
  6799        1563        OR
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code> column1  column2  column3  
  6799      item1   8205 OR 8206 OR 8208 OR8422 
  6799      item2   8205 OR 8206 OR 8208 OR8422 
  6799      item3   8205 OR 8206 OR 8208 OR8422 
  6799      item4   8205 OR 8206 OR 8208 OR8422 
  6799      item5   8205 OR 8206 OR 8208 OR8422 
  </code></pre>