title: Convert Resultset to String array
body: <p>I need to Convert My result set to an array of Strings. I am reading Email addresses from the database and I need to be able to send them like:</p>
  
  <pre><code>message.addRecipient(Message.RecipientType.CC, "abc@abc.com,abc@def.com,ghi@abc.com");
  </code></pre>
  
  <p>Here is My code for reading the Email addresses:</p>
  
  <pre><code>import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.ResultSet;
  import java.sql.Statement;
  
  public class Test {
  
      public static void main(String[] args) {
          Connection conn = null;
          String iphost = "localhost";
          String dbsid = "ASKDB";
          String username = "ASKUL";
          String password = "askul";
  
          try {
              Class.forName("oracle.jdbc.driver.OracleDriver");
              String sql = "SELECT * FROM EMAIL";
              conn = DriverManager.getConnection("jdbc:oracle:thin:@" + iphost + ":1521:" + dbsid, username, password);
              Statement st = conn.createStatement();
              ResultSet rs = st.executeQuery(sql);
              String[] arr = null;
              while (rs.next()) {
                  String em = rs.getString("EM_ID");
                 arr = em.split("\n");
                 for (int i =0; i &lt; arr.length; i++){
                     System.out.println(arr[i]);
                 }
              }
          } catch (Exception asd) {
              System.out.println(asd);
          }
      }
  }
  </code></pre>
  
  <p>MyOutput is:</p>
  
  <pre><code>myemailaddress@abc.com
  myotheremail@abc.com
  </code></pre>
  
  <p>I need it like this:</p>
  
  <pre><code>myemailaddress@abc.com,myotheremail@abc.com
  </code></pre>
  
  <p>I am using Oracle 11g.</p>