<%@ page language="java" import="java.util.*,news.database.DBTool,java.sql.Connection,news.database.CbiNewsPool,java.sql.Statement,java.sql.ResultSet,cbinews.news.NewsContent,news.util.TokenPage" pageEncoding="GBK"%> <%String column_id="7"; String column_name="渠道工具"; String column_eName="tools"; String sTitle=column_name+"-成功案例--电脑商情在线"; String sUrl="/tools/"; Connection conn=CbiNewsPool.getConnection(); Statement stmt=conn.createStatement(); String sql=""; ResultSet rs=null; String word=request.getParameter("word"); if(word==null||word.indexOf("script")>=0||word.indexOf("Script")>=0){ word=""; }else{ word =new String(word.getBytes("GBK")); } String p=request.getParameter("p"); if(p==null||p.equals(""))p="1"; int pageSize=50; int num=(Integer.parseInt(p)-1)*pageSize; String count=DBTool.getValue("SELECT count(id) as count FROM cases where columnname = '"+word+"'","count"); int pageNum=((int)Math.ceil(Integer.parseInt(count)/pageSize)==0)?1:(int)Math.ceil(Integer.parseInt(count)/pageSize); ArrayList adlist=new ArrayList(); sql="select * from column_ad where column_id="+column_id; rs=stmt.executeQuery(sql); while(rs.next()){ adlist.add(rs.getString("inside_ad1")); adlist.add(rs.getString("inside_ad2")); adlist.add(rs.getString("inside_ad3")); adlist.add(rs.getString("inside_ad4")); adlist.add(rs.getString("inside_ad9"));//方块广告 adlist.add(rs.getString("inside_ad10")); adlist.add(rs.getString("inside_ad11")); adlist.add(rs.getString("baidu_code"));//7 adlist.add(rs.getString("monitor_code"));//8 //adlist.add(rs.getString("inside_ad13")); //8 } int i=0; %> <%=sTitle%> <%@ include file="/column/page/include/topbar.jsp"%> <%if(adlist.get(0).equals("1")){%>
<%}%> <%if(adlist.get(1).equals("1")){%>
<%}%>
<%@include file="/column/page/include/menu.jsp" %> <%if (adlist.get(2).equals("1")){%>
<%}%> <%if (adlist.get(3).equals("1")){%>
<%}%>

位置:首页 > <%=column_name%> > <%=word%> 成功案例

<% sql="SELECT id,case_name,adddatetime FROM cases where columnname = '"+word+"' order by id desc limit "+num+","+pageSize; rs=stmt.executeQuery(sql); while(rs.next()){%> <%}%>
  • 共<%=count%>条信息
  • <%=p%>/<%=pageNum%>页
  • <%=pageNum!=Integer.parseInt(p)?"尾页":"尾页"%>
  • <%=Integer.parseInt(p)下一页":"下一页"%>
  • <%=Integer.parseInt(p)>1?"上一页":"上一页"%>
  • <%=Integer.parseInt(p)>1?"首页":"首页"%>
<%--article_body end--%>
<%@include file="/column/page/include/qq_and_other.jsp" %>
<%@include file="/column/page/include/bottom_info.jsp" %>
<%=adlist.get(7)%> <%=adlist.get(8)%>
<%if(rs!=null){rs.close();rs=null;}if(conn!=null){conn.close();conn=null;}%>