java ArrayList & JDBC

Question

public class UserBean<br>
{ 
 public String name; 
 public String role; 
} 

class Dao{ 
 ArrayList<UserBean> a = new ArrayList<UserBean>();
 String sql = "Select * from user";
 ResultSet rs = pStmt.executeQuery(sql);
 while(rs.next()){
 //----------Problem------------
 // i want to do something like<br>
  a.add[0].name = rs.getString("name");
  a.add[0].role = rs.getString("role");
 // Get column from resultset and set the value of userbean column
 }
}

sorry line no 9 is ArrayList<UserBean> a= new ArrayList<UserBean>(); — Zubair Idrees
– Zubair Idrees, Commented Oct 17, 2011 at 4:09

KV Prajapati · Accepted Answer · 2011-10-17 04:14:37Z

4

Create an instance of UserBean and add it to the List.

 while(rs.next()){
  UserBean bean=new UserBean();
  bean.name = rs.getString("name");
  bean.role = rs.getString("role");
  a.add(bean);
 // Get column from resultset and set the value of userbean column
 }

answered Oct 17, 2011 at 4:14

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

Comments

Ernesto Campohermoso · Accepted Answer · 2011-10-17 04:14:01Z

1

You can try:

public class UserBean {
    public String name;
    public String role;
}

class Dao{
    ArrayList<UserBean> a= new ArrayList<UserBean>();
    String sql = "Select * from user";
    ResultSet rs = pStmt.executeQuery(sql);
    while(rs.next()){
        UserBean ub = new UserBean();
        ub.name=rs.getString("name");
        ub.role=rs.getString("role");
        a.add(ub);

    }
}

answered Oct 17, 2011 at 4:14

Ernesto Campohermoso

7,4411 gold badge42 silver badges51 bronze badges

Collectives™ on Stack Overflow

java ArrayList & JDBC

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related