<%@page contentType="text/html;charset=utf-8" import="java.sql.*,java.util.*,jerehnet.jsp.database.*,jerehnet.jsp.util.*,java.text.SimpleDateFormat"%><% String no = Common.getFormatPara((String)request.getParameter("no")); PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } Connection conn = null; DataManager db = new DataManager(); try { conn = pool.getConnection(); String query="select * from jrcms_products where website_no='20150610165616246' and id='"+no+"'"; ResultSet rs = db.executeQuery(conn,query); String idOne="";String viewCountOne="";String titleOne="";String contentOne="";String pubDateOne="";String subTitle=""; String summary="";String img="";String infono="";String subContent="";String nname="";String intro="";String prono=""; String parameter="";String resource="";String anli=""; if(rs!=null&&rs.next()){ prono=Common.getFormatStr(rs.getString("no")); infono=Common.getFormatStr(rs.getString("channel_node")); nname=Common.getFormatStr(rs.getString("name")); summary=Common.getFormatStr(rs.getString("main_para")); idOne=Common.getFormatStr(rs.getString("id")); viewCountOne=Common.getFormatStr(rs.getString("view_count")); parameter=Common.getFormatStr(rs.getString("parameter")); intro=Common.getFormatStr(rs.getString("intro")); resource=Common.getFormatStr(rs.getString("resource")); anli=Common.getFormatStr(rs.getString("main_para")); titleOne=Common.getFormatStr(rs.getString("name")); } String preQuery = " select top 1 id,view_count from jrcms_products where id< "+no+" and is_show=1 and website_no='20150610165616246' and channel_node='"+infono+"' order by id desc"; String nexQuery = " select top 1 id,view_count from jrcms_products where id> "+no+" and is_show=1 and website_no='20150610165616246' and channel_node='"+infono+"' order by id asc"; ResultSet rsp = null; ResultSet rsn = null; ResultSet rspic = null; ResultSet anliRs= null; String pid = "";String ptitle="";String ptime=""; String nid = "";String ntitle="";String ntime=""; rsp=db.executeQuery(conn,preQuery); if(rsp!=null && rsp.next()){ pid = Common.getFormatStr(rsp.getString("id")); } rsn = db.executeQuery(conn,nexQuery); if(rsn!=null && rsn.next()){ nid = Common.getFormatStr(rsn.getString("id")); } String product_sql=" select * from jrcms_website_channel_element where website_no='20150610165616246' and channel_no='"+prono+"' and flag=10 order by id "; rspic=db.executeQuery(conn,product_sql); String anli_sql=" select * from jrcms_website_channel_element where website_no='20150610165616246' and channel_no='"+prono+"' and flag=11 order by id "; anliRs=db.executeQuery(conn,anli_sql); %> TC&PT tower crane_Tower crane_PRODUCTS_PRODUCTS_Yantai Meibo Construction Machinery Co.,Ltd.
Meibo,We committed to providing  high-quality  construction machinery

PRODUCTS

Tower crane
<%if(rspic!=null&&rspic.next()){%>
" alt=""/>
<%}%>
    <% rspic.beforeFirst(); while(rspic!=null&&rspic.next()){ %>
  • " alt="" rel="<%=Common.getFormatStr(rspic.getString("more_img"))%>"/>
    • <%}%>

<%=nname%>

<%=summary%>
Order online Service Introduction

Recommendation

Contact us

Click for Phone number
<%=parameter%>
<%=intro%>
    <%while(anliRs!=null&&anliRs.next()){ String anliimg=""; String anlititle=""; anliimg=Common.getFormatStr(anliRs.getString("more_img")); anlititle=Common.getFormatStr(anliRs.getString("title")); %>
  • <%=anlititle%>

    <%=anlititle%>

    • <%}%>
<% } catch (Exception e) { e.printStackTrace(); } finally { pool.freeConnection(conn); } %>