📄 secondindexvehicle_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.text.*;
import com.huashi.util.jdbc.*;
public final class secondIndexVehicle_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("\r\n");
out.write(" <h1>\r\n");
out.write(" <form method=\"get\" action=\"secondIndexVehicle.jsp\" >\r\n");
out.write(" ");
Connection con = null;
try {
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u>车辆类型分布统计</u></font><br/>");
int sum = 0;
//Class.forName("oracle.jdbc.driver.OracleDriver");
//con=DriverManager.getConnection("jdbc:oracle:oci:@ASCRAC","ascdata2","asc12345");
con = ConnectionUtil.getConnectionByJndiName("oracle/ascdb");
Statement statement_VehicleType = con.createStatement();
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 start1 = request.getParameter("start1");
String end1 = request.getParameter("end1");
String p1,p2;
if (start1==null||end1==null){
p1 = startDateStr;
p2 = endDateStr;
out.println("<font face=仿宋_GB2312 size=4>起始时间："+
"</font><input name=start1 type=text value="+p1+" size=20/>"+
"<font face=仿宋_GB2312 size=4>(YYYY-MM-DD)</font></br>"+
"<font face=仿宋_GB2312 size=4>结束时间：</font><input name=end1 type=text value="+p1+" size=20/>"+
" <font face=仿宋_GB2312 size=4>(YYYY-MM-DD)</font></br> <input type=submit value=查询 /></br></br>");
}else{
p1 = start1;
p2 = end1;
out.println("<font face=仿宋_GB2312 size=4>起始时间："+
"</font><input name=start1 type=text value="+p1+" size=20/>"+
"<font face=仿宋_GB2312 size=4>(YYYY-MM-DD)</font></br>"+
"<font face=仿宋_GB2312 size=4>结束时间：</font><input name=end1 type=text value="+p2+" size=20/>"+
" <font face=仿宋_GB2312 size=4>(YYYY-MM-DD)</font></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>名称</font></th><th width=50% ><font face=仿宋_GB2312 size=4>数量</font></th></tr>");
String sql_VehicleType = "select trim(v_model),count(registration_no) "+
" from "+
" asc_vehicle_info_tbl a ,asc_tmnl_info_tbl b "+
" where "+
" a.tmnl_id=b.tmnl_id and b.test_stat=0 "+
" and a.inst_dt>=to_date('"+p1+
"','"+
"yyyy-mm-dd')"+
" and a.inst_dt<to_date('"+p2+
"','"+
"yyyy-mm-dd')+1 "+
" group by "+
" trim(v_model) " ;
ResultSet rs_VehicleType = statement_VehicleType.executeQuery(sql_VehicleType);
int total = 0;
sum = 0;
while(rs_VehicleType.next()){
String VehicleName = rs_VehicleType.getString(1);
if(VehicleName==null) {
VehicleName ="其他";
}
sum = rs_VehicleType.getInt(2);
total = total + sum;
out.println("<tr>");
out.println("<td width=50% height=17><font color=#000000 face=仿宋_GB2312 size=4><a href=vehicleTypeDetail.jsp?model="+VehicleName+"&d1="+p1+"&d2="+p2+">"+VehicleName+"</a></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("<tr>");
out.println("<th width=50% ><font face=仿宋_GB2312 size=4>合计</font></th>");
out.println("<td align=center width=50% height=17><font color=#000000 face=仿宋_GB2312 size=4>"+total+"</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=secondIndexAlarm.jsp>报警统计</a></u></font></br>");
out.println("<font color=#008080 face=仿宋_GB2312 size=5><u><a href=alarmcount.jsp>车机报警统计</a></u></font></br>");
statement_VehicleType.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 + -