How to fetch an arralist element (i need the code)

[raj reddy]

WE HAVE TO CALL THE "SEL1" element IN THE PUBLI STATIC VOID MAIN METHOD.


[ "SEL1" element is located in an array in the public List fetchTicketkey1() method ie

al.add(rs.getInt("sel1")]










public class Keno {


public List fetchTicketkey1() {

List al = new ArrayList();

try {


pstmt=con.prepareStatement("select * from draw );

rs=pstmt.executeQuery();

while(rs.next()) {

al.add(rs.getInt("sel1"));
al.add(rs.getInt("sel2"));


}


} catch(Exception e) {

} return al;
}


public static void main(String[] args) {


Keno ken = new Keno();


List al = (List) ken.fetchTicketkey1();





}}(i need the code)

[Eranga]

What you are looking here?

[raj reddy]

hi Eranga

Thks for u r reply

how can we call the sel1 variable

/* ie located in al.add(rs.getInt("sel1"))*/

in the public static void main method

system.out.println( " the value of sel1 is " + al.sel1) //this is showing error


i need the correct code

[Eranga]

You want to get the element name sel1 which is in the al List, right?

[raj reddy]

yes, i need that element in the


public static void main method



for example like this ::: system.out.println( " the value of sel1 is " + al.sel1) //this is showing error

[raj reddy]

Hi Eranga


Did u got the code


if any queries reply me

[Eranga]

Quote:

Originally Posted by raj reddy

yes, i need that element in the


public static void main method



for example like this ::: system.out.println( " the value of sel1 is " + al.sel1) //this is showing error

Yes, it's wrong. Get the element of the al list, you have to refer the index of that. Say sel1 is in the 0[sup]th[/sup] place in the list. To get the value,

Code:

system.out.println( " the value of sel1 is " + al.get(0));

[Eranga]

Quote:

Originally Posted by raj reddy

Hi Eranga


Did u got the code


if any queries reply me

Did you read any document relating to this. And also are you working on a Java IDE? If so, you comes with compile errors. Did you read them carefully?