問題描述
java while (resultset.next()) 不返回同一列中的所有數據 (java while (resultset.next()) does not return all data in the same column)
我需要你的幫助。我希望結果集獲取 member_code 列中的所有數據，但它只獲取 1 個數據。如何使用循環獲取 member_code 中的所有數據？這是我的代碼：
public String membercode() throws SQLException{
String member="";
String sql = "SELECT member_code FROM member";
java.sql.Connection conn = (Connection) koneksi.config();
java.sql.Statement stm = conn.createStatement();
java.sql.ResultSet res = stm.executeQuery(sql);
while(res.next()) {
member = res.getString("member_code");
}
return member;
}
</code></pre>
參考解法
方法 1:
You need to assemble and return a "list". For example:
public List<String> membercode() throws SQLException{
List<String> members = new ArrayList<String>();
String sql = "SELECT member_code FROM member";
java.sql.Connection conn = (Connection) koneksi.config();
java.sql.Statement stm = conn.createStatement();
java.sql.ResultSet res = stm.executeQuery(sql);
while(res.next()) {
member = res.getString("member_code");
members.add(member);
}
return members;
}
(by Ryan Chandra、The Impaler)
參考文件