<%@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(); } Connection conn = null; Pagination pagination = new Pagination(); //设置每页显示条数 int pageCount = 6; //pageCount = Integer.parseInt(Common.getFormatInt(request.getParameter("pageCount"))); if(pageCount==0){ pageCount = 10; } pagination.setCountOfPage(pageCount); DataManager db = new DataManager(); String channelNo=Common.getFormatStr(request.getParameter("channelNo")); String keywords=Common.getFormatStr(request.getParameter("keywords")); String sdate=Common.getFormatStr(request.getParameter("sdate")); String edate=Common.getFormatStr(request.getParameter("edate")); String orderword=Common.getFormatStr(request.getParameter("orderword")); try { conn = pool.getConnection(); String offset = Common.getFormatInt(request.getParameter("offset")); String prosqls="select capacity from jrcms_products where id in(select max(id)from jrcms_products where website_no='20150623163145344' and channel_node='20150703141607505' group by capacity having count(*)>0 ) order by orderno"; //String sql= "select * from jrcms_website_channel where website_no='20150623163145344' and no='20150703141607505' and is_show=1 "; ResultSet prors = db.executeQuery(conn,prosqls); String prosql1= "select count(*) as num from jrcms_products where website_no='20150623163145344' and channel_node='20150703141607505' and is_show=1 "; ResultSet prors1 = db.executeQuery(conn,prosql1); String count=""; if(prors1!=null&&prors1.next()){ count=Common.getFormatStr(prors1.getString("num")); } String picsql="select * from jrcms_website_channel_element where website_no='20150623163145344' and channel_no='20150703141607505' and flag=1 and is_show=1"; ResultSet picRs = db.executeQuery(conn,picsql); String picsql1=""; ResultSet picRs1=null; if(picRs==null||!picRs.next()){ picsql1="select * from jrcms_website_channel_element where website_no='20150623163145344' and channel_no='2015062712035361' and flag=1 and is_show=1"; picRs1 = db.executeQuery(conn,picsql1); } %> QLX-D潜水螺旋离心泵_QLX潜水螺旋泵_产品站_奥特
    <% if(!picsql1.equals("")){ String pic_title="";String pic_img="";String pic_url=""; String color=""; while(picRs1!=null&&picRs1.next()){ pic_title=Common.getFormatStr(picRs1.getString("title")); pic_img=Common.getFormatStr(picRs1.getString("more_img")); pic_url=Common.getFormatStr(picRs1.getString("more_url")); color=Common.getFormatStr(picRs1.getString("more_word")); %>
  • <%=pic_title%>
    • <%} %> <%}else{ picRs.beforeFirst(); String pic_title0="";String pic_img0="";String pic_url0=""; String color0=""; while(picRs!=null&&picRs.next()){ pic_title0=Common.getFormatStr(picRs.getString("title")); pic_img0=Common.getFormatStr(picRs.getString("more_img")); pic_url0=Common.getFormatStr(picRs.getString("more_url")); color0=Common.getFormatStr(picRs.getString("more_word")); %>
  • <%=pic_title0%>
    • <%}} %>

QLX-D潜水螺旋离心泵
(共有<%=count%>个产品)

<%while(prors!=null&&prors.next()){ String name=Common.getFormatStr(prors.getString("capacity")); //String no=Common.getFormatStr(prors.getString("no")); %>

<%=name%>

<% String prosql="select * from jrcms_products where website_no='20150623163145344' and channel_node='20150703141607505' and capacity='"+name+"' and is_show=1 order by orderno, id desc "; ResultSet rs = db.executeQuery(conn,prosql); while(rs!=null&&rs.next()){ String proname=Common.getFormatStr(rs.getString("name")); String img=Common.getFormatStr(rs.getString("img")); String resource=Common.getFormatStr(rs.getString("resource")); if(img.equals("")){ img="/product/resources/web/images/default.jpg"; } %>

_for_qlxdqianshuiluoxuanlixinbeng_text.htm" title="<%=proname%>"><%=proname%> _for_qlxdqianshuiluoxuanlixinbeng_text.htm">

价格咨询/产品订购 _for_qlxdqianshuiluoxuanlixinbeng_text.htm" target="_blank" class="act">技术参数查看 产品手册下载 产品手册浏览
<% }}%>
推荐产品
<% } catch (Exception e) { e.printStackTrace(); } finally { pool.freeConnection(conn); } %>