Java--- Result Set Help..

[MysorePak]

Hi all

i am facing a problem how to put result set in array

 

okka method lo query run chesthuna then adhi oka column with data vasthundhi so adhi nenu array list lo ela pettali and display that list in JSP

 

here is the method where i am running query

 public String getabc value(){

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

String xyz= null;  

String sql =  "SELECT ID from EMPLOYEE";

   

try{

con = getConnection();

ps = con.prepareStatement(sql);

 

rs = ps.executeQuery();

while(rs.next()){

ekkada ela run cheyali aa list value and how to capture and return array

}

 

 

[bisketraja]

List<String> idList = new ArrayList<String>(); declare chesi while loop lo idList.add(rs.getString(1)) ani pettukoni idList return cheyochemo...

 

 

Calling experts.....

[alpachinao]

try{

con = getConnection();

ps = con.prepareStatement(sql);

List<?> l = new ArrayList<?>()

rs = ps.executeQuery();

while(rs.next()){

l.add(rs.getString("ColumnName");

}

 

[joblessjack]

 

try{

con = getConnection();

ps = con.prepareStatement(sql);

List<?> l = new ArrayList<?>()

rs = ps.executeQuery();

while(rs.next()){

l.add(rs.getString("ColumnName");

}

 

corestt 

[cherlapalli_jailer]

hope u got it 

[MysorePak]

Yeah i will try now 

[MysorePak]

Thanks Bhayya

 

try{

con = getConnection();

ps = con.prepareStatement(sql);

List<?> l = new ArrayList<?>()

rs = ps.executeQuery();

while(rs.next()){

l.add(rs.getString("ColumnName");

}

 

 

[MysorePak]

Syntax error on token(s), misplaced construct(s)  vasthundhi at

 

l.add(rs.getString("ColumnName"); deggara

[MysorePak]

no errors just nenu braces thappu petta.. epudu test chesthanu