📄 alarmcount_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import com.huashi.util.jdbc.*;
public final class alarmcount_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
"index1_error.jsp", true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write(" <head>\r\n");
out.write(" <title>\r\n");
out.write(" 统计查询\r\n");
out.write(" </title>\r\n");
out.write(" </head>\r\n");
out.write(" <body bgcolor=\"#C0C0C0\">\r\n");
out.write(" <h1>\r\n");
out.write("\r\n");
out.write(" <form method=\"get\" action=\"alarmcount.jsp\" >\r\n");
out.write(" ");
Connection con = null;
try {
int sum = 0;
//String count1=0;
String start1 = request.getParameter("start1");
String end1 = request.getParameter("end1");
String count1 =request.getParameter("count");
String eort = request.getParameter("r1");
String startDateStr = new SimpleDateFormat("yyyy-MM-dd").format(new java.util.Date());
String endDateStr = startDateStr.substring(0,8)+ (new Integer(startDateStr.substring(8)).intValue()+1);
String p1,p2;
//int p3;
if (start1==null||end1==null){
p1 = startDateStr;
p2 = endDateStr;
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u>车机报警统计</u></font></br>");
out.println("<font face=仿宋_GB2312 size=4>起始时间：</font><input name=start1 type=text value="+p1+" size=15/>"+
"<font face=仿宋_GB2312 size=4>结束时间：</font><input name=end1 type=text value="+p1+" size=15/><font face=仿宋_GB2312 size=4>(YYYY-MM-DD)</font></br>"+
"<font face=仿宋_GB2312 size=4>报警数量：</font><input name=count type=text value=3 size=15/>"+
"<font face=仿宋_GB2312 size=4>事件：</font><input name=r1 type=radio checked value=e size=15/>"+
"<font face=仿宋_GB2312 size=4>车机：</font><input name=r1 type=radio value=t size=15/></br>"+
"<input type=submit value=查询 /></br></br>");
}else{
p1 = start1;
p2 = end1;
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u>车机报警统计</u></font></br>");
out.println("<font face=仿宋_GB2312 size=4>起始时间：</font><input name=start1 type=text value="+p1+" size=15/>"+
"<font face=仿宋_GB2312 size=4>结束时间：</font><input name=end1 type=text value="+p1+" size=15/><font face=仿宋_GB2312 size=4>(YYYY-MM-DD)</font></br>"+
"<font face=仿宋_GB2312 size=4>报警数量：</font><input name=count type=text value=3 size=15/>"+
"<font face=仿宋_GB2312 size=4>事件：</font><input name=r1 type=radio checked value=e size=15/>"+
"<font face=仿宋_GB2312 size=4>车机：</font><input name=r1 type=radio value=t size=15/></br>"+
"<input type=submit value=查询 /></br></br>");
}
out.println("<table border=1 cellspacing=0 cellpadding=5 width=100% height=45>");
out.println("<tr><th width=50% ><font face=仿宋_GB2312 size=4>车机ID</font></th><th width=50% ><font face=仿宋_GB2312 size=4>报警数量</font></th></tr>");
// Class.forName("oracle.jdbc.driver.OracleDriver");
// con=DriverManager.getConnection("jdbc:oracle:oci:@ASCRAC","ascdata2","asc12345");
con = ConnectionUtil.getConnectionByJndiName("oracle/ascdb");
Statement statement_alarm = con.createStatement();
String sql;
if(eort.equals("e")){
sql="SELECT tmnl_id,"+
" COUNT(event_id) "+
" FROM asc_tmnl_event_tbl t "+
" WHERE t.event_date BETWEEN to_date('"+p1+
"','"+
"yyyy-mm-dd')"+
" and to_date('"+p2+
"','"+
"yyyy-mm-dd')+1 "+
" GROUP BY tmnl_id "+
" HAVING COUNT(event_id) >"+count1;
}else{
sql="SELECT tmnl_id,"+
" COUNT(msg_id)"+
" FROM asc_tmnl_message_vw t"+
" WHERE t.msg_date BETWEEN to_date('"+p1+
"','"+
"yyyy-mm-dd')"+
" and to_date('"+p2+
"','"+
"yyyy-mm-dd')+1 "+
" AND t.alm_level > 0"+
" AND t.testing = 0 "+
" AND t.cmd_nbr IN (162, 165, 169, 172, 184, 215, 218, 221)"+
" AND t.msg_from = 7434"+
" GROUP BY tmnl_id"+
" HAVING COUNT(msg_id) >"+count1;
}
ResultSet rs_alarm = statement_alarm.executeQuery(sql);
sum = 0;
while(rs_alarm.next()){
String alarmName = rs_alarm.getString(1);
sum = rs_alarm.getInt(2);
out.println("<tr>");
out.println("<td width=50% height=17><font color=#000000 face=仿宋_GB2312 size=4>"+alarmName+"</font></td>");
out.println("<td align=center width=50% height=17><font color=#000000 face=仿宋_GB2312 size=4>"+sum+"</font></td>");
out.println("</tr>");
}
out.println("</table></br>");
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u><a href=secondIndexType.jsp>设备类型统计</a></u></font></br>");
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u><a href=secondIndexCenter.jsp>分局安装统计</a></u></font></br>");
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u><a href=secondIndexVehicle.jsp>车辆类型分布统计</a></u></font></br>");
statement_alarm.close();
con.close();
} catch (Exception e) {
//out.println(e.getMessage());
try{con.close();}catch(Exception ex){}
}
out.write("\r\n");
out.write(" </form>\r\n");
out.write(" </h1>\r\n");
out.write(" </body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -