📄 __resultsum.java
字号:
strDisp=request.getParameter("Disp"); //[ /Resultsum.jsp; Line: 31] if (BeginDate.equals("")) BeginDate="10000000"; //[ /Resultsum.jsp; Line: 32] if (EndDate.equals("")) EndDate="99999999"; //[ /Resultsum.jsp; Line: 33] if ("1".equals(strDisp)){ //[ /Resultsum.jsp; Line: 34] sql="select * from UserFile where (Nsrid like '"+Userid+"%') and (datetime between '"+BeginDate+"' and '"+EndDate+"') and (filetype='0') order by Nsrid"; //[ /Resultsum.jsp; Line: 35] sql2="select count( distinct NsrId) as iCount from UserFile where (Nsrid like '"+Userid+"%') and (datetime between '"+BeginDate+"' and '"+EndDate+"') and (filetype='0') "; //[ /Resultsum.jsp; Line: 36] }else if("2".equals(strDisp)){ //[ /Resultsum.jsp; Line: 37] sql="select * from UserFile where (Nsrid like '"+Userid+"%') and (datetime between '"+BeginDate+"' and '"+EndDate+"') and (filetype='1') order by Nsrid"; //[ /Resultsum.jsp; Line: 38] sql2="select count(distinct NsrId) as icount from UserFile where (Nsrid like '"+Userid+"%') and (datetime between '"+BeginDate+"' and '"+EndDate+"') and (filetype='1') "; //[ /Resultsum.jsp; Line: 39] }else{ //[ /Resultsum.jsp; Line: 40] sql="select * from UserFile where (Nsrid like '"+Userid+"%') and (datetime between '"+BeginDate+"' and '"+EndDate+"') order by Nsrid"; //[ /Resultsum.jsp; Line: 41] sql2="select count(distinct Nsrid) as icount from UserFile where (Nsrid like '"+Userid+"%') and (datetime between '"+BeginDate+"' and '"+EndDate+"') "; //[ /Resultsum.jsp; Line: 42] }; //[ /Resultsum.jsp; Line: 43] ResultSet rs=LoginBean.executeQuery2(sql) ; //[ /Resultsum.jsp; Line: 44] ResultSet rs2=LoginBean.executeQuery(sql2); //[ /Resultsum.jsp; Line: 45] rs2.next(); //[ /Resultsum.jsp; Line: 46] rs.last(); //[ /Resultsum.jsp; Line: 47] intRowCount=rs.getRow(); //[ /Resultsum.jsp; Line: 48] //计算总页数 //[ /Resultsum.jsp; Line: 49] intPageCount=(intRowCount+intPageSize-1)/intPageSize; //[ /Resultsum.jsp; Line: 50] //调整待显示页 //[ /Resultsum.jsp; Line: 51] if(intPage>intPageCount) intPage=intPageCount; //[ /Resultsum.jsp; Line: 52] String downloadURL=LoginBean.strPath+"\\filedat\\"; //[ /Resultsum.jsp; Line: 53] //[ /Resultsum.jsp; Line: 54] String tempURL=""; //[ /Resultsum.jsp; Line: 55] out.print("\r\n<HTML>\r\n<HEAD >\r\n<link href=\"Admin_STYLE.CSS\" rel=\"stylesheet\" type=\"text/css\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><title>结果页</title>\r\n</HEAD>\r\n<BODY bgcolor=\"#E1F4EE\" font color=\"#000000\">\r\n<font color=\"#000000\" size=\"+1\"></font>\r\n<table width=\"100%\" border=\"0\">\r\n <tr>\r\n <td><div align=\"center\" class=\"topbg\"><font color=\"#000000\" ><strong><font color=\"#FFFFFF\">查询结果：</font></strong></font></div></td>\r\n </tr>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" class=\"border\">\r\n <tr class=\"title\">\r\n <td width=\"25%\"><div align=\"center\"><font color=\"#000000\">企业纳税人识别号</font></div></td>\r\n <td width=\"36%\" class=\"title\"><div align=\"center\"><font color=\"#000000\">文件名</font></div></td>\r\n <td width=\"13%\"><div align=\"center\"><font color=\"#000000\">文件大小(KB)</font></div></td>\r\n <td width=\"15%\"><div align=\"center\"><font color=\"#000000\">日 期</font></div></td>\r\n <td width=\"11%\"><div align=\"center\"><font color=\"#000000\">类 别</font></div></td>\r\n </tr>\r\n\r\n"); //[ /Resultsum.jsp; Line: 78] if (intPageCount>0){ //[ /Resultsum.jsp; Line: 79] //将指针定位到待显示页的第一条记录上 //[ /Resultsum.jsp; Line: 80] rs.absolute((intPage-1)*intPageSize+1); //[ /Resultsum.jsp; Line: 81] //显示数据 //[ /Resultsum.jsp; Line: 82] i=0; //[ /Resultsum.jsp; Line: 83] while (i<intPageSize && !rs.isAfterLast() ){ //[ /Resultsum.jsp; Line: 84] //[ /Resultsum.jsp; Line: 84] out.print("\r\n <tr class=\"tdbg\">\r\n <td><div align=\"left\"><font color=\"#000000\">"); out.print(rs.getString("NsrId")); //[ /Resultsum.jsp; Line: 86] //[ /Resultsum.jsp; Line: 86] out.print("</font></div></td>\r\n "); tempURL=downloadURL+rs.getString("FileName").substring(22,30)+"\\"+rs.getString("FileName"); //[ /Resultsum.jsp; Line: 87] //[ /Resultsum.jsp; Line: 87] out.print("\r\n <td onMouseOver=\"window.status=\'点击在新窗口中下载文件\';return true\" onMouseOut=\"window.status=\'\';return true\">\r\n <a href=\"/downservlet?downLoadUrl="); out.print(String.valueOf(tempURL)); //[ /Resultsum.jsp; Line: 89] out.print("\" target=\"_self\" >\r\n "); out.print(rs.getString("FileName")); //[ /Resultsum.jsp; Line: 90] //[ /Resultsum.jsp; Line: 90] out.print("</a>\r\n </td>\r\n "); tempURL=""; //[ /Resultsum.jsp; Line: 92] //[ /Resultsum.jsp; Line: 92] out.print("\r\n <td><div align=\"left\"><font color=\"#000000\">"); out.print(rs.getString("FileSize")); //[ /Resultsum.jsp; Line: 93] //[ /Resultsum.jsp; Line: 93] out.print("</font></div></td>\r\n <td><div align=\"left\"><font color=\"#000000\">"); out.print(rs.getString("DateTime")); //[ /Resultsum.jsp; Line: 94] //[ /Resultsum.jsp; Line: 94] out.print("</font></div></td>\r\n"); String disptype; //[ /Resultsum.jsp; Line: 95] if ("0".equals(rs.getString("Filetype"))) disptype="上报文件"; //[ /Resultsum.jsp; Line: 96] else disptype="回执文件"; //[ /Resultsum.jsp; Line: 97] out.print("\r\n<td><div align=\"left\"><font color=\"#000000\">"); out.print(disptype); //[ /Resultsum.jsp; Line: 99] //[ /Resultsum.jsp; Line: 99] out.print("</font></div></td>\r\n </tr>\r\n"); //[ /Resultsum.jsp; Line: 101] rs.next(); //[ /Resultsum.jsp; Line: 102] i++; //[ /Resultsum.jsp; Line: 103] } //[ /Resultsum.jsp; Line: 104] } //[ /Resultsum.jsp; Line: 105] out.print("\r\n</table>\r\n"); //[ /Resultsum.jsp; Line: 108] //rs2.next(); //[ /Resultsum.jsp; Line: 109] //[ /Resultsum.jsp; Line: 110] //[ /Resultsum.jsp; Line: 110] out.print("\r\n<font color=\"#000000\">共有"); out.print(String.valueOf(intRowCount)); //[ /Resultsum.jsp; Line: 111] out.print("条记录,每页"); out.print(String.valueOf(i)); //[ /Resultsum.jsp; Line: 111] out.print("条记录!共有"); out.print(rs2.getString("iCount")); //[ /Resultsum.jsp; Line: 111] //[ /Resultsum.jsp; Line: 111] out.print("个企业纳税人</font>\r\n第"); out.print(String.valueOf(intPage)); //[ /Resultsum.jsp; Line: 112] out.print("页共"); out.print(String.valueOf(intPageCount)); //[ /Resultsum.jsp; Line: 112] out.print("页"); if(intPage<intPageCount){ //[ /Resultsum.jsp; Line: 112] //[ /Resultsum.jsp; Line: 112] out.print("<a href=\"Resultsum.jsp?page="); out.print(String.valueOf(intPage+1)); //[ /Resultsum.jsp; Line: 112] out.print("&UserID="); out.print(String.valueOf(Userid)); //[ /Resultsum.jsp; Line: 112] out.print("&BeginDate="); out.print(String.valueOf(BeginDate)); //[ /Resultsum.jsp; Line: 112] out.print("&EndDate="); out.print(String.valueOf(EndDate)); //[ /Resultsum.jsp; Line: 112] out.print("&Disp="); out.print(String.valueOf(strDisp)); //[ /Resultsum.jsp; Line: 112] out.print("\">\r\n下一页</a>"); } //[ /Resultsum.jsp; Line: 113] //[ /Resultsum.jsp; Line: 113] out.print(" "); if(intPage>1){ //[ /Resultsum.jsp; Line: 113] //[ /Resultsum.jsp; Line: 113] out.print("<a href=\"Resultsum.jsp?page="); out.print(String.valueOf(intPage-1)); //[ /Resultsum.jsp; Line: 113] out.print("&UserID="); out.print(String.valueOf(Userid)); //[ /Resultsum.jsp; Line: 113] out.print("&BeginDate="); out.print(String.valueOf(BeginDate)); //[ /Resultsum.jsp; Line: 113] out.print("&EndDate="); out.print(String.valueOf(EndDate)); //[ /Resultsum.jsp; Line: 113] out.print("&Disp="); out.print(String.valueOf(strDisp)); //[ /Resultsum.jsp; Line: 113] out.print("\">上一页</a>"); } //[ /Resultsum.jsp; Line: 113] //[ /Resultsum.jsp; Line: 113] out.print("\r\n<P> </P>\r\n\r\n</BODY>\r\n</HTML>\r\n"); //[ /Resultsum.jsp; Line: 118] rs.close(); //[ /Resultsum.jsp; Line: 119] rs2.close(); //[ /Resultsum.jsp; Line: 120] } catch (Throwable __ee) { while (out != null && out != _originalOut) out = pageContext.popBody(); ((weblogic.servlet.jsp.PageContextImpl)pageContext).handlePageException((Throwable)__ee); }
//before final close brace...
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -