本文介绍了将结果集转换为字符串数组的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要将我的结果集转换为字符串数组.我正在从数据库中读取电子邮件地址,我需要能够像这样发送它们:
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:
message.addRecipient(Message.RecipientType.CC, "abc@abc.com,abc@def.com,ghi@abc.com");
这是我读取电子邮件地址的代码:
Here is My code for reading the Email addresses:
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("
");
for (int i =0; i < arr.length; i++){
System.out.println(arr[i]);
}
}
} catch (Exception asd) {
System.out.println(asd);
}
}
}
我的输出是:
myemailaddress@abc.com
myotheremail@abc.com
我需要这样:
myemailaddress@abc.com,myotheremail@abc.com
我使用的是 Oracle 11g.
I am using Oracle 11g.
推荐答案
获得想要的输出:
替换这些行
String[] arr = null;
while (rs.next()) {
String em = rs.getString("EM_ID");
arr = em.split("
");
for (int i =0; i < arr.length; i++){
System.out.println(arr[i]);
}
}
由
String arr = null;
while (rs.next()) {
String em = rs.getString("EM_ID");
arr = em.replace("
", ",");
System.out.println(arr);
}
这篇关于将结果集转换为字符串数组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!