<%
getserviceins g2=new getserviceins();
Collection col2 = g2.getserviceins(service, btime, etime, provinceid);
Iterator it2 = col2.iterator();
while(it2.hasNext())
{
getserviceins gc2=(getserviceins)it2.next();
%>
<tr bgcolor="#9FCAAC" class="style8">
<td><%=gc2.sActdate%> </td>//查询时间
<td><%=gc2.sCount_in%> </td>//上行流量
<td><%=gc2.sCount_out%> </td>//下行流量
<td><%out.println(Integer.parseInt(gc2.sCount_in) - Integer.parseInt(gc2.sCount_out));%> </td>//流量差
-----------------------↑jsp段 ↓java段 ----------------------
conn = connPool.getConnection();
stmt = conn.createStatement(); //rs返回所有上下行的日期
if(servicecode.equals("0"))
strSQL = "select to_char(RECVDATE, 'yyyy-mm-dd') from mms_recv where provinceid = '"+provinceid+"' and RECVDATE > to_date('"+timeb+"', 'yyyy-mm-dd hh24:mi:ss') and RECVDATE < to_date('"+timee+"', 'yyyy-mm-dd hh24:mi:ss') group by to_char(RECVDATE, 'yyyy-mm-dd') union select to_char(SENDDATE, 'yyyy-mm-dd') from mms_send where provinceid = '"+provinceid+"' and SENDDATE > to_date('"+timeb+"', 'yyyy-mm-dd hh24:mi:ss') and SENDDATE < to_date('"+timee+"', 'yyyy-mm-dd hh24:mi:ss') group by to_char(SENDDATE, 'yyyy-mm-dd')";
else
strSQL = "select to_char(RECVDATE, 'yyyy-mm-dd') from mms_recv where provinceid = '"+provinceid+"' and servicecode = '"+servicecode+"' and RECVDATE > to_date('"+timeb+"', 'yyyy-mm-dd hh24:mi:ss') and RECVDATE < to_date('"+timee+"', 'yyyy-mm-dd hh24:mi:ss') group by to_char(RECVDATE, 'yyyy-mm-dd') union select to_char(SENDDATE, 'yyyy-mm-dd') from mms_send where provinceid = '"+provinceid+"' and servicecode = '"+servicecode+"' and SENDDATE > to_date('"+timeb+"', 'yyyy-mm-dd hh24:mi:ss') and SENDDATE < to_date('"+timee+"', 'yyyy-mm-dd hh24:mi:ss') group by to_char(SENDDATE, 'yyyy-mm-dd')";
rs = stmt.executeQuery(strSQL);
while(rs.next())
{
stmtsend = conn.createStatement();
stmtrecv = conn.createStatement();
sActdate = rs.getString(1);
//rsrecv每天上行统计
if(servicecode.equals("0"))
strSQLrecv = "select count(*) from mms_recv where provinceid = '"+provinceid+"' and to_char(RECVDATE, 'yyyy-mm-dd') = '"+sActdate+"'";
else
strSQLrecv = "select count(*) from mms_recv where provinceid = '"+provinceid+"' and servicecode = '"+servicecode+"' and to_char(RECVDATE, 'yyyy-mm-dd') = '"+sActdate+"'"; rsrecv = stmtrecv.executeQuery(strSQLsend);
if(rsrecv.next())
{
sCount_in = rsrecv.getString(1);
}
//rssend每天下行统计
if(servicecode.equals("0"))
strSQLsend = "select count(*) from mms_send where provinceid = '"+provinceid+"' and to_char(SENDDATE, 'yyyy-mm-dd') = '"+sActdate+"' and status = '1000'";
else
strSQLsend = "select count(*) from mms_send where provinceid = '"+provinceid+"' and servicecode = '"+servicecode+"' and to_char(SENDDATE, 'yyyy-mm-dd') = '"+sActdate+"' and status = '1000'"; rssend = stmtsend.executeQuery(strSQLsend);
if(rssend.next())
{
sCount_out = rssend.getString(1);
}
//付值给返回参数
getserviceins gc = new getserviceins();
gc.sCount_in=sCount_in;
gc.sCount_out=sCount_out;
gc.sActdate=sActdate;
ret.add(gc);
------------------------------------------
哎 看得头都痛了 sql语句都已经检查过了 没有错误的 现在显示页面的没有输出结果.......
头都大了 有没有可能是 sql数据量太大 或者响应时间过长 jsp页面收不到值...?
解决方案 »
- struts2 ,web.xml中配置为/*.action,运行报错Invalid <url-pattern> /*.action in filter mapp
- struts2 中 ServletActionContext.getPageContext()为什么总是获取为null值
- 大家帮我实现一个jquery+ajax的功能。
- Hibernate<set>问题
- 一个JSP得问题
- include -- just for myself
- 急用:如何根据JSP写出这个JAVABEAN
- Lucene关于几种中文分词的总结
- 在JB7中,做一JSP,当服务器选为Tomcat时,可以正常运行,但当服务器为Weblogic 6.1出错.为什么?
- Class.forName("org.gjt.mm.mysql.Driver")的问题!
- 在jsp和htm之间相互传递参数的问题
- 刚装然后配置了WEBLOGIC,结果我要管理它,却密码不对了,怎么办?
可读性太差了