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+";");本文共 277 字，大约阅读时间需要 1 分钟。
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+";");转载于:https://www.cnblogs.com/webqiand/p/4315116.html