<%@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 =10; //pageCount = Integer.parseInt(Common.getFormatInt(request.getParameter("pageCount"))); if(pageCount==0){ pageCount = 10; } pagination.setCountOfPage(pageCount); DataManager db = new DataManager(); String keywords=Common.getFormatStr(request.getParameter("keywords")); if(keywords.indexOf("关键词")>=0){ keywords=""; } String sdate=Common.getFormatStr(request.getParameter("sdate")); String edate=Common.getFormatStr(request.getParameter("edate")); try { conn = pool.getConnection(); String offset = Common.getFormatInt(request.getParameter("offset")); String topid="";//专题新闻 String querytop="select top 1 * from jrcms_special where website_no='20150619082201914' and channel_visualize_image_alt='1' order by pub_date desc "; String no=""; ResultSet rstop = db.executeQuery(conn,querytop); if(rstop!=null&&rstop.next()){ no=rstop.getString("no"); } rstop.beforeFirst(); String elementsql="select top 3 * from jrcms_information where website_no='20150619082201914' and special_No='"+no+"' and is_show=1 order by orderno desc,id desc "; ResultSet rsele = db.executeQuery(conn,elementsql); String searchStr = " where website_no='20150619082201914' and is_show=1 and no not in('"+no+"') "; searchStr += " order by pub_date desc,id desc"; String query = "select * from jrcms_special" + searchStr; ResultSet rs = pagination.getQueryResult(query, request, conn); int showPages = 10;//底部页数显示个数 String orderword = Common.getFormatStr(request.getParameter("orderword")); int pageindex=0; %> 专题报道_新闻_天津奥特泵业

您当前的位置： 首页 > 新闻 > 专题报道

新闻
公司公告
新闻动态
专题报道
行业资讯
媒体视角
视频中心

专题报道

<% if(rstop!=null&&rstop.next()){%>
_for_zhuantibaodao_text.htm" title="<%=rstop.getString("title")%>" class="img">" alt="<%=rstop.getString("title")%>">

_for_zhuantibaodao_text.htm" title="<%=rstop.getString("title")%>"><%=rstop.getString("title")%>

<% String themesummary=""; while(rsele!=null&&rsele.next()){ themesummary=Common.getFormatStr(rstop.getString("summary")); if(themesummary.length()>75){ themesummary=themesummary.substring(0,75)+"..."; } %> _for_zhuantibaodao_text_content.htm" title="<%=rsele.getString("title")%>" class="db t el">[<%=rsele.getString("title")%>] <%}%>

_for_zhuantibaodao_text.htm" title="<%=rstop.getString("title")%>"> <%=themesummary%>

<%}%>
专题检索
日期范围： -
<%=keywords%><%}else{%>关键词搜索<%}%>" onclick="this.value=''">
排序:class="red"<%}%> id="bydate">按发布时间class="red"<%}%>>按关注度
加载更多内容
<% } catch (Exception e) { e.printStackTrace(); } finally { pool.freeConnection(conn); } %>