String sql2="select count(*) from t_testuser where substr(INSETTIME,1,10)=to_char(sysdate,‘yyyy-MM-dd‘) ";
ResultSet rs2=stmt.executeQuery(sql2);
while(rs2.next()){
int count2=rs2.getInt(1); //本日新增体检用户数
out.print(count2+";");
原文：http://www.cnblogs.com/webqiand/p/4315116.html