queryprinttoexcel.jsp
来自「一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs」· JSP 代码 · 共 226 行
JSP
226 行
<%@ page contentType="application/vnd.ms-excel; charset=gb2312" %>
<%@ page import="java.util.*"%>
<%@page import="java.util.*,com.gs.util.*"%>
<%@ page import="com.gs.pageBuilder.model.*,com.gs.pageBuilder.util.*;"%>
<%
try{
String td="businessTd01Left";
ArrayList queryResultList= null;
queryResultList=(ArrayList)request.getAttribute("queryResultList");
QuerySuperResultModel querySuperResultModel= null;
int i=0;
Calendar calendar=Calendar.getInstance();
String querytoShowNowDate=PageBuildUtil.dataTypeConversion((String)PubFunc.getDateStr(calendar),"4","");
String titleStr1=(String)request.getAttribute("titleStr1");
String titleStr2=(String)request.getAttribute("titleStr2");
String titleStr3=(String)request.getAttribute("titleStr3");
String titleStr4=(String)request.getAttribute("titleStr4");
String titleStr5=(String)request.getAttribute("titleStr5");
String titleStr6=(String)request.getAttribute("titleStr6");
String titleStr7=(String)request.getAttribute("titleStr7");
String titleStr8=(String)request.getAttribute("titleStr8");
String titleStr9=(String)request.getAttribute("titleStr9");
String titleStr10=(String)request.getAttribute("titleStr10");
String titleStr11=(String)request.getAttribute("titleStr11");
String titleStr12=(String)request.getAttribute("titleStr12");
String titleStr13=(String)request.getAttribute("titleStr13");
String titleStr14=(String)request.getAttribute("titleStr14");
String titleStr15=(String)request.getAttribute("titleStr15");
String titleStr16=(String)request.getAttribute("titleStr16");
String titleStr17=(String)request.getAttribute("titleStr17");
String titleStr18=(String)request.getAttribute("titleStr18");
String titleStr19=(String)request.getAttribute("titleStr19");
String titleStr20=(String)request.getAttribute("titleStr20");
String titleStr21=(String)request.getAttribute("titleStr21");
String titleStr22=(String)request.getAttribute("titleStr22");
String titleStr23=(String)request.getAttribute("titleStr23");
String titleStr24=(String)request.getAttribute("titleStr24");
String titleStr25=(String)request.getAttribute("titleStr25");
String titleStr26=(String)request.getAttribute("titleStr26");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询结果</title>
</head>
<body>
<table border="1" class="businessTable01" id=stockmanID width="100%">
<tr>
<%if("ON".equals(titleStr1)){%>
<td width="100" class="businessTdTitle00" ><span>注册号</span></td>
<%}%>
<%if("ON".equals(titleStr2)){%>
<td width="200" class="businessTdTitle00" ><span>企业名称</span></td>
<%}%>
<%if("ON".equals(titleStr3)){%>
<td width="200" class="businessTdTitle00" ><span>注册资本(金)</span></td>
<%}%>
<%if("ON".equals(titleStr4)){%>
<td width="160" class="businessTdTitle00" ><span>住 所</span></td>
<%}%>
<%if("ON".equals(titleStr5)){%>
<td width="100" class="businessTdTitle00" ><span>负责人</span></td>
<%}%>
<%if("ON".equals(titleStr6)){%>
<td width="200" class="businessTdTitle00" ><span>联系电话</span></td>
<%}%>
<%if("ON".equals(titleStr7)){%>
<td width="80" class="businessTdTitle00" ><span>邮政编码</span></td>
<%}%>
<%if("ON".equals(titleStr8)){%>
<td width="80" class="businessTdTitle00" ><span>成立日期</span></td>
<%}%>
<%if("ON".equals(titleStr9)){%>
<td width="200" class="businessTdTitle00" ><span>核准日期</span></td>
<%}%>
<%if("ON".equals(titleStr10)){%>
<td width="80" class="businessTdTitle00" ><span>注销日期</span></td>
<%}%>
<%if("ON".equals(titleStr11)){%>
<td width="80" class="businessTdTitle00" ><span>吊销日期</span></td>
<%}%>
<%if("ON".equals(titleStr12)){%>
<td width="80" class="businessTdTitle00" ><span>营业期限自</span></td>
<%}%>
<%if("ON".equals(titleStr13)){%>
<td width="80" class="businessTdTitle00" ><span>营业期限至</span></td>
<%}%>
<%if("ON".equals(titleStr14)){%>
<td width="80" class="businessTdTitle00" ><span>经营范围</span></td>
<%}%>
<%if("ON".equals(titleStr15)){%>
<td width="80" class="businessTdTitle00" ><span>企业外文名</span></td>
<%}%>
<%if("ON".equals(titleStr16)){%>
<td width="80" class="businessTdTitle00" ><span>行业代码</span></td>
<%}%>
<%if("ON".equals(titleStr17)){%>
<td width="80" class="businessTdTitle00" ><span>企业类型</span></td>
<%}%>
<%if("ON".equals(titleStr18)){%>
<td width="80" class="businessTdTitle00" ><span>主管单位</span></td>
<%}%>
<%if("ON".equals(titleStr19)){%>
<td width="80" class="businessTdTitle00" ><span>国家</span></td>
<%}%>
<%if("ON".equals(titleStr20)){%>
<td width="80" class="businessTdTitle00" ><span>统一代码</span></td>
<%}%>
<%if("ON".equals(titleStr21)){%>
<td width="80" class="businessTdTitle00" ><span>字号</span></td>
<%}%>
<%if("ON".equals(titleStr22)){%>
<td width="80" class="businessTdTitle00" ><span>字号拼音</span></td>
<%}%>
<%if("ON".equals(titleStr23)){%>
<td width="80" class="businessTdTitle00" ><span>资金币种</span></td>
<%}%>
<%if("ON".equals(titleStr24)){%>
<td width="80" class="businessTdTitle00" ><span>业务状态</span></td>
<%}%>
<%if("ON".equals(titleStr25)){%>
<td width="80" class="businessTdTitle00" ><span>登记机关</span></td>
<%}%>
<%if("ON".equals(titleStr26)){%>
<td width="80" class="businessTdTitle00" ><span>管辖单位</span></td>
<%}%>
</tr>
<%
if(queryResultList!=null)
for(i=0;i<queryResultList.size();i++){
querySuperResultModel=(QuerySuperResultModel)queryResultList.get(i);
td=td=="businessTd01Left"?"businessTd00Left":"businessTd01Left";
%>
<tr>
<%if("ON".equals(titleStr1)){%>
<td width="100" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getRegID())%></span></td>
<%}%>
<%if("ON".equals(titleStr2)){%>
<td width="200" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getCorporationName())%></span></td>
<%}%>
<%if("ON".equals(titleStr3)){%>
<td width="200" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getRegistrationPrincipal())%></span></td>
<%}%>
<%if("ON".equals(titleStr4)){%>
<td width="160" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getAbode())%></span></td>
<%}%>
<%if("ON".equals(titleStr5)){%>
<td width="100" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getPrincipal())%></span></td>
<%}%>
<%if("ON".equals(titleStr6)){%>
<td width="200" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getPhonenumber())%></span></td>
<%}%>
<%if("ON".equals(titleStr7)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getPostalcode())%></span></td>
<%}%>
<%if("ON".equals(titleStr8)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getPracticeDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr9)){%>
<td width="200" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getApproveDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr10)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getLogoutDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr11)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getLogoutDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr12)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getBusinessTimelimitFrom())%></span></td>
<%}%>
<%if("ON".equals(titleStr13)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getBusinessTimelimitTo())%></span></td>
<%}%>
<%if("ON".equals(titleStr14)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getWorkArea())%></span></td>
<%}%>
<%if("ON".equals(titleStr15)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getCorporationEngName())%></span></td>
<%}%>
<%if("ON".equals(titleStr16)){%>
<td width="80" class="<%=td%>" ><span> <%=GetCodingTable.getCodingTrade(PubFunc.toShow(querySuperResultModel.getTradeCode()))%></span></td>
<%}%>
<%if("ON".equals(titleStr17)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getCorporationTypeName())%></span></td>
<%}%>
<%if("ON".equals(titleStr18)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getDirectorUnit())%></span></td>
<%}%>
<%if("ON".equals(titleStr19)){%>
<td width="80" class="<%=td%>" ><span> <%=GetCodingTable.getCodingGJ(PubFunc.toShow(querySuperResultModel.getCountry()))%></span></td>
<%}%>
<%if("ON".equals(titleStr20)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getUnificationCode())%></span></td>
<%}%>
<%if("ON".equals(titleStr21)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getWordName())%></span></td>
<%}%>
<%if("ON".equals(titleStr22)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getWordNameSpelling())%></span></td>
<%}%>
<%if("ON".equals(titleStr23)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getMoneyCategory())%></span></td>
<%}%>
<%if("ON".equals(titleStr24)){%>
<td width="80" class="<%=td%>" ><span> <%=PubFunc.toShow(querySuperResultModel.getCorporationState())%></span></td>
<%}%>
<%if("ON".equals(titleStr25)){%>
<td width="80" class="<%=td%>" ><span> <%=GetCodingTable.getAreaCode(PubFunc.toShow(querySuperResultModel.getDJJG()))%></span></td>
<%}%>
<%if("ON".equals(titleStr26)){%>
<td width="80" class="<%=td%>" ><span> <%=GetCodingTable.getAreaCode(PubFunc.toShow(querySuperResultModel.getGXDW()))%></span></td>
<%}%>
</tr>
<%}%>
</table>
<br>
<span>满足条件的企业共计： <%=i%>个. 打印日期:<%=querytoShowNowDate%></span>
<br>
</body>
</html>
<%}
catch(Exception ex){
Debug.println("querySuperPrintToExcel.jsp exception :"+ex.getMessage());
}
%>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?