<%@ page language="java" import="java.util.*,java.sql.ResultSet,java.sql.PreparedStatement,com.cbinews.database.CbinewsDataPool,java.sql.Connection,com.cbinews.beans.ColumnAD,com.cbinews.util.StringControl,com.cbinews.beans.Column" pageEncoding="utf-8"%> <% int column_id=692;//基础硬件 Column column=new Column(column_id); ColumnAD column_ad=new ColumnAD(column_id); Connection conn=CbinewsDataPool.getConnection(); PreparedStatement stmt=null; ResultSet rs=null; String sql=""; int i=0; String webUrl="http://www.cbinews.com"; //String today=new SimpleDateFormat("yyyy-MM-dd").format(new Date()); %> <%=column.getName()%>--电脑商情在线 <%@include file="/common/page/top_v13.jsp"%>
<%@include file="/common/page/head_v15.jsp"%>
<%@include file="/common/page/menu_v15.jsp"%>
当前位置:<%=column.getName()%>
<%sql="select title,linkurl,pic from pic_news where column_id="+column_id+" and display=1 order by sort desc limit 0,4";i=1;stmt=conn.prepareStatement(sql); rs=stmt.executeQuery();while(rs.next()){%> <%i++;}%>
    <%sql="select title from pic_news where column_id="+column_id+" and display=1 order by sort desc limit 0,4";i=1;stmt=conn.prepareStatement(sql); rs=stmt.executeQuery();while(rs.next()){%>
  • ">
    <%=rs.getString("title")%>
  • <%i++;}%>
推荐新闻<%if(column_id==592){%><%}%>>more >>
<%sql="select articleid,articletitle,summary,pic,keyword,`name`,article.adddate,articleurl,article.column_id from article,column_new where show_column=1 and article.column_id=column_new.id and column_parent_id=692 union select articleid,articletitle,summary,pic,keyword,`name`,article.adddate,articleurl,article.column_id from article,column_new where show_column=1 and article.column_id=column_new.id and column_parent_id=51 union select articleid,articletitle,summary,pic,keyword,`name`,article.adddate,articleurl,article.column_id from article,column_new where show_column=1 and article.column_id=column_new.id and column_parent_id=56 union select articleid,articletitle,summary,pic,keyword,`name`,article.adddate,articleurl,article.column_id from article,column_new where show_column=1 and article.column_id=column_new.id and column_parent_id=686 order by articleid desc limit 0,9";stmt=conn.prepareStatement(sql); rs=stmt.executeQuery();while(rs.next()){%>
>.htm" target="_blank" title="<%=rs.getString("articletitle")%>">" alt="<%=rs.getString("articletitle")%>" />
<%=rs.getString("summary").length()>106?rs.getString("summary").substring(0,106):rs.getString("summary")%>....htm" target="_blank">查看全文>>
" target="_blank"><%=rs.getString("name")%>关键字:<%String[] k=rs.getString("keyword").split(",");for(int j=0;j<%=k[j]%> <%}%>
<%}%>
<%--left end--%>
<%@include file="/common/page/info_v13.jsp"%>
<%@include file="/common/page/bottom_v15.jsp"%> <%CbinewsDataPool.free(rs, stmt, conn);column=null;column_ad=null;%>