:p
Hi
I think you just want to convert the varchar columns data to int data.
For this first retrieve the data as varchar and then convert to int as
String varchar=rs.getString("abcd");
int aa=Integer.parseInt(varchar);
this will throw the parse exception if the varchar contains any characters.
Otherway around , friend change the database column to int as actually you want int value . Why you r using varchar.