81,092
社区成员
发帖
与我相关
我的任务
分享
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String zdid=request.getParameter("zdid");
String sql_shuiwen="select commsta,to_char(rq,'yyyy-mm-dd hh24:mi:ss'),to_char(round(shuiwen,1),'fm99990.0'),to_char(round(yandu,1),'fm99990.0'),to_char(round(chaowei,1),'fm9999999.0'),dianya from shuiwenrealtimedata where zdid='"+zdid+"'";
String sql_qixiang="select commsta,to_char(rq,'yyyy-mm-dd hh24:mi:ss'),to_char(round(qiya,1),'fm99999.0'),to_char(round(qiwen,1),'fm99990.0'),to_char(round(shidu,1),'fm99990.0'),to_char(round(jiangshui,1),'fm99990.0'),to_char(round(jiangshui2008,1),'fm99990.0'),to_char(round(jiangshui0820,1),'fm99990.0'),to_char(round(fengsuextr,1),'fm99990.0'),fengxiangextr,to_char(round(fengsuavg,1),'fm99990.0'),fengxiangavg,to_char(round(dayfengsuextr,1),'fm99990.0'),dayfengxiangextr,to_char(dayextrtime,'yyyy-mm-dd hh24:mi:ss'),to_char(round(dayfengsumax,1),'fm99990.0'),dayfengxiangmax,to_char(dayextrtime,'yyyy-mm-dd hh24:mi:ss'),dianya from qixiangrealtimedata where zdid='"+zdid+"'";
//设置输出信息的格式及字符集
response.setContentType("text/xml;charset=utf-8");
response.setHeader("Cache-Control","no-cache");
//response.setHeader("refresh","2");
//创建输出流对象
PrintWriter out = response.getWriter();
//依据验证结果输出不同的数据信息
out.print("<response>");
try{
rs_shuiwen=st.executeQuery(sql_shuiwen);
while(rs_shuiwen.next())
{
if(rs_shuiwen.getString(1).equals("0"))
{
out.print("<telestatus1>"+"<font color=#ff0000>通讯故障</font>"+"</telestatus1>");
}
else
{
out.print("<telestatus1>"+"<font color=#008000>通讯正常</font>"+"</telestatus1>");
}
out.print("<rq1>"+rs_shuiwen.getString(3)+"</rq1>");
out.print("<shuiwen>"+rs_shuiwen.getString(4)+"</shuiwen>");
out.print("<yandu>"+rs_shuiwen.getString(7)+"</yandu>");
out.print("<chaowei>"+rs_shuiwen.getString(10)+"</chaowei>");
out.print("<shuiwendianya>"+rs_shuiwen.getString(23)+"</shuiwendianya>");
}
}
catch(Exception e)
{
out.print(e.toString());
}
try
{
rs_qixiang=st.executeQuery(sql_qixiang);
while(rs_qixiang.next())
{
if(rs_qixiang.getString(1).equals("0"))
{
out.print("<telestatus2>"+"<font color=#ff0000>通讯故障</font>"+"</telestatus2>");
}
else
{
out.print("<telestatus2>"+"<font color=#008000>通讯正常</font>"+"</telestatus2>");
}
out.print("<rq2>"+rs_qixiang.getString(3)+"</rq2>");
out.print("<qiya>"+rs_qixiang.getString(4)+"</qiya>");
out.print("<qiwen>"+rs_qixiang.getString(7)+"</qiwen>");
out.print("<shidu>"+rs_qixiang.getString(10)+"</shidu>");
out.print("<jiangshui>"+rs_qixiang.getString(12)+"</jiangshui>");
out.print("<jiangshui2008>"+rs_qixiang.getString(13)+"</jiangshui2008>");
out.print("<jiangshui0820>"+rs_qixiang.getString(14)+"</jiangshui0820>");
out.print("<fengsuextr>"+rs_qixiang.getString(15)+"</fengsuextr>");
out.print("<fengxiangextr>"+rs_qixiang.getString(16)+"</fengxiangextr>");
out.print("<10minfengsuavg>"+rs_qixiang.getString(17)+"</10minfengsuavg>");
out.print("<10minfengxiangavg>"+rs_qixiang.getString(18)+"</10minfengxiangavg>");
out.print("<dayfengsuextr>"+rs_qixiang.getString(19)+"</dayfengsuextr>");
out.print("<dayfengxiangextr>"+rs_qixiang.getString(20)+"</dayfengxiangextr>");
out.print("<dayextrtime>"+rs_qixiang.getString(21)+"</dayextrtime>");
out.print("<dayfengsumax>"+rs_qixiang.getString(22)+"</dayfengsumax>");
out.print("<dayfengxiangmax>"+rs_qixiang.getString(23)+"</dayfengxiangmax>");
out.print("<daymaxtime>"+rs_qixiang.getString(24)+"</daymaxtime>");
out.print("<qixiangdianya>"+rs_qixiang.getString(25)+"</qixiangdianya>");
}
}
catch(Exception e)
{
out.print(e.toString());
}
out.print("</response>");
out.close();
}