java-mysql-reccount

java-mysql-reccount

sqlString="select count(*) from payroll where employeeNumber='1' and year=2013 and mth=' 7'";
rs = stmt.executeQuery(sqlString);
rs.next();  // java-skip
int k=rs.getInt(1);  //first Column
System.out.println("check had or not");
System.out.println(k);