Save Values with comma separated.

Absolutely! In the provided code snippet, the SQL query retrieves email addresses from a specific database based on certain conditions. If multiple records are retrieved, and you want to store those email addresses in a variable with comma separation, you can adjust your code to concatenate the email addresses accordingly.

Here's how you can modify your code to achieve this:

String _StrSQL = "SELECT T0.\"Email\" , T0.\"T0.CntctPrsn\" " +
                "FROM \"ATULAYA_NEW_LIVE\".OCPR T0 " +
                "INNER JOIN OVPM T1 ON T0.\"CardCode\" = T1.\"CardCode\"  " +
                "where T1.\"DocEntry\" = 62960";

ResultSet rs = stmt.executeQuery(_StrSQL); // Assuming you have a statement object for execution

String addresses = ""; // Initialize the variable to store email addresses

while (rs.next()) {
    String email = rs.getString("Email");
    addresses += email + ","; // Concatenate the email with a comma separator
}

// Remove the trailing comma, if any
if (addresses.endsWith(",")) {
    addresses = addresses.substring(0, addresses.length() - 1);
}

System.out.println("Email Addresses: " + addresses); // Print or use the comma-separated email addresses as needed

This modified code snippet will fetch email addresses from the database and store them in the `addresses` variable with comma separation. Additionally, it ensures that there is no trailing comma at the end of the `addresses` string.

Feel free to incorporate this logic into your existing codebase. If you have any more questions or need further clarification, please let me know!