insert database elements in an array.

Question

I want to add database elements into array. how do I do that.

the table row has elements a to d.

i want to do this because. I have created a quiz and each time the user answers a question the answer in stored in a database. the questions are multiple choice. so a, b, c or d. (there are 5 questions) i am creating a servlet score page. so once they are in an array the i can check each element.

here is my code

private String ans[];
...  
int i = 0;

while (rs.next()) {
ans[i] = {rs.getString(1)};
i++;
}

GavinCattell · Accepted Answer · 2012-03-30 17:48:18Z

3

Consider using an ArrayList<String> instead.

private ArrayList<String> ans = new ArrayList<String>();
...

while (rs.next()) {
    ans.add(rs.getString(1));
}

answered Mar 30, 2012 at 17:48

GavinCattell

4,00323 silver badges22 bronze badges

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

1 Comment

user1181445 Over a year ago

beat me by like 5 seconds, but depending on the size a LinkedList will be more effecient.

Yogesh Prajapati · Accepted Answer · 2012-03-30 17:49:56Z

1

this will help you

private String ans[];
...  
int i = 0;

while (rs.next()) {
ans[i] = rs.getString(1);
i++;
}

answered Mar 30, 2012 at 17:49

Yogesh Prajapati

4,8682 gold badges40 silver badges77 bronze badges

Comments

user1181445 · Accepted Answer · 2012-03-30 17:49:38Z

0

private LinkedList<String> ans = new LinkedList<String>();
//...  

while (rs.next()) {
ans.add(rs.getString(1));
}

This would work better as you can have multiple elements.

answered Mar 30, 2012 at 17:49

user1181445

Collectives™ on Stack Overflow

insert database elements in an array.

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related