我需要将我的结果集转换为字符串数组.我正在从数据库中读取电子邮件地址,我需要能够发送它们,如：
@H_404_2@message.addRecipient(Message.RecipientType.CC,"abc@abc.com,abc@def.com,ghi@abc.com");
@H_404_2@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 < arr.length; i++){
System.out.println(arr[i]);
}
}
} catch (Exception asd) {
System.out.println(asd);
}
}
}
我的输出是：
@H_404_2@myemailaddress@abc.com myotheremail@abc.com我需要这样：
@H_404_2@myemailaddress@abc.com,myotheremail@abc.com我正在使用Oracle 11g.
解决方法
获得所需的输出：
替换这些线
@H_404_2@String[] arr = null; while (rs.next()) { String em = rs.getString("EM_ID"); arr = em.split("\n"); for (int i =0; i < arr.length; i++){ System.out.println(arr[i]); } }通过
@H_404_2@String arr = null; while (rs.next()) { String em = rs.getString("EM_ID"); arr = em.replace("\n",","); System.out.println(arr); }