Retrieve mysql data base value into array

Question

How to retrieve the mysql database value into array using java.If I retrieve Student Name from mysql Database means How can I get The all Student name in a mysql table to array using java?give me some examples.

thanks in advance

Since you'd retrieve DB results into an array the exact same way in the command line or a servlet as in Swing, we can conclude this problem has nothing to do with Swing. — Andrew Thompson
– Andrew Thompson, Commented Jan 5, 2012 at 6:13

KV Prajapati · Accepted Answer · 2012-01-05 06:06:05Z

4

Use ArrayList<T> to store name from database and later you may convert it to String[] using List.toArray() method.

ArrayList<String> list= new ArrayList<String>();
while (rs.next()) {
    list.add(rs.getString(1));
}

answered Jan 5, 2012 at 6:06

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

Comments

COD3BOY · Accepted Answer · 2012-01-05 05:57:13Z

0

I'm not sure if this is right question on SO, it seems you've not tried anything :(

Btw, have a look at this first : JDBC Basics

First query all the student names from DB, then

 while(resultset.next(){
            //add each of them to array
       }

answered Jan 5, 2012 at 5:57

COD3BOY

12.1k2 gold badges41 silver badges56 bronze badges

Collectives™ on Stack Overflow

Retrieve mysql data base value into array

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