区域业绩
- 国家
- 地区
- 名称
想更便捷地了解产品?联系我们时遇到问题?请提交在线产品订购,相关人员将在半小时内为您服务。
%@page contentType="text/html;charset=utf-8" import="java.sql.*,java.util.*,jerehnet.jsp.database.*,jerehnet.jsp.util.*,java.text.SimpleDateFormat,java.util.regex.Matcher,java.util.regex.Pattern"%> <% PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } DataManager db = new DataManager(); String maptypeSelect = Common.getFormatPara(request.getParameter("maptype")); String productCataSelect = Common.getFormatPara(request.getParameter("pro")); String provinceSelect = Common.getFormatPara(request.getParameter("province")); String searchContent = Common.getFormatPara(request.getParameter("keywords")); Connection conn = null; ResultSet maptype = null; ResultSet proCata = null; ResultSet provinces = null; ResultSet areaNation = null; ResultSet network = null; try { conn = pool.getConnection(); //调取网点类别信息 maptype = db.executeQuery(conn,"select keyv,name from jrcms_param where no = '101015' and is_show = '1' order by orderno,id"); //调取产品类别信息 proCata = db.executeQuery(conn," select * from jrcms_website_channel where website_no='20150623163145344' and parent_no='20150623172454151' and is_show=1 order by orderno"); //调取省份信息 provinces = db.executeQuery(conn," select no,name from jrcms_province where is_show = 1 order by no asc,id"); //调取国家区域信息 areaNation = db.executeQuery(conn," select distinct code from jrcms_network where place!='0' and website_no='20150619082201914' "); //调取网点信息 network = db.executeQuery(conn," select * from jrcms_network where website_no='20150619082201914' and channel_node='20150619091716328' and is_show=1 order by orderno desc"); %>