<%@ page language="java" import="java.util.*" pageEncoding="GBK"%> <%@ page import="com.lightway.db.DBUtil" %> <%@ page import="com.lightway.db.DBResultSet" %> <%@ page import="com.lightway.resource.ResourceTypeManager" %> <%@ page import="com.lightway.resource.ResourceType" %> <%@ page import="com.lightway.resource.ResourceField" %> <%@ page import="com.lightway.system.Enumeration" %> 联系我们 最大的住人集装箱供应商 得劳斯集装箱联盟
<% ResourceType resourceType = ResourceTypeManager.getResourceType("dls_jmgc"); ResourceField resourceField1 = resourceType.getResourceField("area"); ArrayList enumList1 = resourceField1.getEnumerations(); StringBuffer buf = new StringBuffer(); for(int j=0; j\n\n\n") .append("\n") .append("\n") .append("\n\n"); }else{ DBResultSet arealinkman = DBUtil.executeQuery("select linkname,telephone from dls_jmgc where area = '00' and isused = '0' and province = '"+enumName1+"'"); buf.append("\n\n"); DBResultSet provincesum = DBUtil.executeQuery("select province,proseq from dls_jmgc where area = '"+enumID1+"' and isused = '1' group by province,proseq order by proseq"); if(provincesum.size()>0){ for(int k=1; k<=provincesum.size(); k++){ String province=provincesum.getValue(k,"province"); DBResultSet provincelinkman = DBUtil.executeQuery("select linkname,telephone,url from dls_jmgc where area = '00' and isused = '0' and province = '"+province+"'"); buf.append("\n\n"); DBResultSet resultSet = DBUtil.executeQuery("select ctiy,name,url,address,telephone from dls_jmgc where area = '"+enumID1+"' and province = '"+province+"' order by seqNo,joindate"); for(int i=1; i<=resultSet.size(); i++){ if(i==1){ buf.append("\n\n\n") .append("\n") .append("\n") .append("\n\n"); }else{ buf.append("\n\n") .append("\n") .append("\n") .append("\n\n"); } } } } } } out.print(buf.toString()); buf.setLength(0); %>
得劳斯联盟工厂名称 地址 电话 各工厂网站入口
总部").append(resultSet2.getValue(1,"ctiy")).append("  ").append(resultSet2.getValue(1,"name")).append("").append(resultSet2.getValue(1,"address")).append("").append(resultSet2.getValue(1,"telephone")).append("\"").append(resultSet2.getValue(1,"ctiy")).append(resultSet2.getValue(1,"name")).append("\"/
").append(enumName1).append("地区分公司加盟洽谈及集装箱材料"); if(arealinkman.size()>0){ buf.append("(").append(arealinkman.getValue(1,"linkname")).append(":").append(arealinkman.getValue(1,"telephone")).append(")"); } buf.append("
"); if(provincelinkman.size()>0){ buf.append(""); } buf.append(province).append("分部集装箱材料"); if(provincelinkman.size()>0){ buf.append("(").append(provincelinkman.getValue(1,"linkname")).append(":").append(provincelinkman.getValue(1,"telephone")).append(")"); } buf.append("
").append(enumName1).append("").append(resultSet.getValue(i,"ctiy")).append("  ").append(resultSet.getValue(i,"name")).append("").append(resultSet.getValue(i,"address")).append("").append(resultSet.getValue(i,"telephone")).append("\"").append(resultSet.getValue(i,"ctiy")).append(resultSet.getValue(i,"name")).append("\"/
").append(resultSet.getValue(i,"ctiy")).append("  ").append(resultSet.getValue(i,"name")).append("").append(resultSet.getValue(i,"address")).append("").append(resultSet.getValue(i,"telephone")).append("\"").append(resultSet.getValue(i,"ctiy")).append(resultSet.getValue(i,"name")).append("\"/