java while (resultset.next()) does not return all data in the same column

Question

i need your help. i want the resultset to fetch all data in member_code column, but it's only fetch 1 data. how to fetch all data in member_code using looping? here's my 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;
}

you reassigne the value of res.getString("member_code") in loop. so member variable take the last value. try use List<String> instead — Hiep Le
– Hiep Le, Commented Jul 23, 2020 at 15:34

The Impaler · Accepted Answer · 2020-07-23 15:28:21Z

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;
}

answered Jul 23, 2020 at 15:28

The Impaler

49.3k10 gold badges50 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java while (resultset.next()) does not return all data in the same column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related