title: Map Resultset value to another value while traverse
body: <p>Map list:</p>
  
  <p>RBS(Table Value)- RoyalBankofScotland(to be mapped to result set output)</p>
  
  <p>VT(Table Value)- VaccumTube(to be mapped to result set output)</p>
  
  <p>We can list the value through below code in Java. How could we map the value from result set to another value which has the mapping already done below.</p>
  
  <pre><code>while(rs.next())
  
             {               
                 System.out.println("INSERT INTO table_name VALUES('"+rs.getString(2)+"',"+ MT+",NULL,"+rs.getString(4)+")");
                 ;
             }
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>INSERT INTO table_name VALUES('RBS',61501000,NULL,1000) 
  
  INSERT INTO table_name VALUES('VT',61501000,NULL,1000) 
  </code></pre>
  
  <p>and so on.....</p>
  
  <p>Instead of getting above usual output how can i get the below through result set </p>
  
  <p>Result:</p>
  
  <pre><code>INSERT INTO table_name VALUES('RoyalBankOfScotland',61501000,NULL,1000) 
  
  INSERT INTO table_name VALUES('VaccumTube',61501000,NULL,1000) 
  </code></pre>