mysql - Access count returned by a query -

connection con = connectionprovider.getcon(); statement s_sickleave = con.createstatement("select count(leavetypeid) leave leavetypeid=2"); resultset rs_sickleave = s_sickleave.executequery(); integer sick_leave_count = rs_sickleave.getint(1);//line 4 

i'm getting exception @ line 4. how access count value returned query?

you have iterate through result set read each of row.

change:

resultset rs_sickleave = s_sickleave.executequery(); integer sick_leave_count = rs_sickleave.getint(1);//line 4 

to:

resultset rs_sickleave = s_sickleave.executequery(); if ( rs_sickleave.next() ) {     integer sick_leave_count = rs_sickleave.getint(1);//line 4 } 

as count(x) returns single row, can iterate single row. otherwise use while(rs.next()) looping syntax.

refer to:

resultset.next()
moves cursor froward 1 row current position. resultset cursor positioned before first row; first call method next makes first row current row; second call makes second row current row, , on.