It's not a secret anymore!*
The moose likes JDBC and the fly likes get multiple value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "get multiple value " Watch "get multiple value " New topic
Author

get multiple value

raya jaya
Greenhorn

Joined: Apr 18, 2012
Posts: 2
hello,
when i execute this code, it just give me one studentID number


how cn i get more than one number of studentID

[Added code tags - see UseCodeTags for details]
William P O'Sullivan
Ranch Hand

Joined: Mar 28, 2012
Posts: 859

Welcome raya,

Sorry to be honest, It seems you need to do some more basic Java programming.

Your if statement is working fine. The result set has a "next" (or first) record,
you add it to the collection, then leave the if. There could be 10000 more results.

Try reading about loops and in particular the "while" statement.

WP
raya jaya
Greenhorn

Joined: Apr 18, 2012
Posts: 2
thank you
 
GeeCON Prague 2014
 
subject: get multiple value