Save MySQL resultset as String/int/double etc...

[oldezwe]

once I have requested my result set from my server, how do i store it as the variable that I want it to be?

EX.

ResultSet rs2 = st.executeQuery("select userIDnum from userInfo where username = '"+username+"'");

how do i then save userIDnum as an integer to use in my program?

[anand01]

while(rs2.next()){	    			
String var1=rs2.getString("strFeildName");
int var2=rs2.getInt("intFeildName");
}