gdlist.jsp

来自「华东粮油电子交易市场网站源码华东粮油电子交易市场网站源码华东粮油电子交易市场网站」· JSP 代码 · 共 12 行

<%@ page contentType="text/html; charset=GBK" %>
<%
	String strDataArray[][] = site.business.DataUtilBusiness.getValues("SELECT ID,TITLE,ADDTIME FROM (SELECT ID,TITLE,ADDTIME,ROW_NUMBER() OVER (ORDER BY ADDTIME DESC) AS RSNUM FROM TAB_IGECNEWS WHERE DELFLAG='0' AND PASSFLAG='1' AND GDFLAG='1') AS YL_TEMP_TABLE WHERE RSNUM<=8 ORDER BY ADDTIME DESC");
  if(strDataArray!=null){  	
  	out.println("document.write('<MARQUEE onmouseover=\"this.stop();\" onmouseout=\"this.start();\" scrollAmount=2 width=\"404\">');");
  	for(int i=0;i<strDataArray.length;i++){
  			out.println("document.write('· <a href=\"" + site.bean.SitePara.strVirtualName + "/ShowNews.do?id=" + strDataArray[i][0] + "\" target=\"_blank\">" + strDataArray[i][1] + "</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;');");   
    }
    out.println("document.write('</MARQUEE>');");
  }
%>