不就是一个SQL语句吗?
String SQL_STATISTIC=
"SELECT TM.M_DEPT,COUNT(*) AS NUM " +
"FROM T_MONITOR TM,T_USER TU " +
"WHERE TM.M_SYS_USER_ID=TU.US_LOGID " +
"AND TU.ORG_ID=" + String.valueOf(userBean.getUdptid()) +
" AND TM.M_KIND=2 " +
(fmForm.getM_senddate().equals("")?"":(" AND TM.M_CREATED >= TO_DATE('"+fmForm.getM_senddate()+" 01:00:00','yyyy-mm-dd HH24:MI:SS') ")) +
(fmForm.getM_sysdate().equals("")?"":(" AND TM.M_CREATED <= TO_DATE('"+fmForm.getM_sysdate() +" 23:59:59','yyyy-mm-dd HH24:MI:SS') " ))+
" GROUP BY TM.M_DEPT";
String SQL_STATISTIC=
"SELECT TM.M_DEPT,COUNT(*) AS NUM " +
"FROM T_MONITOR TM,T_USER TU " +
"WHERE TM.M_SYS_USER_ID=TU.US_LOGID " +
"AND TU.ORG_ID=" + String.valueOf(userBean.getUdptid()) +
" AND TM.M_KIND=2 " +
(fmForm.getM_senddate().equals("")?"":(" AND TM.M_CREATED >= TO_DATE('"+fmForm.getM_senddate()+" 01:00:00','yyyy-mm-dd HH24:MI:SS') ")) +
(fmForm.getM_sysdate().equals("")?"":(" AND TM.M_CREATED <= TO_DATE('"+fmForm.getM_sysdate() +" 23:59:59','yyyy-mm-dd HH24:MI:SS') " ))+
" GROUP BY TM.M_DEPT";
请大家帮帮忙.