<%@ page import=”tidemedia.cms.system.*,
tidemedia.cms.base.*,
tidemedia.cms.util.*,
tidemedia.cms.user.*,
tidemedia.cms.publish.*,
org.json.*,
magick.*,
java.util.*,
java.sql.*”%>
<%@ page contentType=”text/html;charset=utf-8″ %>
<%@ include file=”../config1.jsp”%>
<%
tidemedia.cms.system.Site defaultSite = tidemedia.cms.system.CmsCache.getDefaultSite();
int gid = getIntParameter(request,”gid”);
TideJson photo_config = CmsCache.getParameter(“sys_config_photo”).getJson();//图片及图片库配置
int id = photo_config.getInt(“channelid”);
System.out.println(“gid1=”+gid);
System.out.println(“id=”+id);//14704
if(id==0)
{
out.println(“图片集频道没有配置.”);
return;
}
Channel channel = CmsCache.getChannel(id);
String Sql = “select * from “+channel.getTableName()+” where Parent=” + gid + ” and Status=1″;
//System.out.println(“Sql4=”+Sql);
TableUtil tu = channel.getTableUtil();
ResultSet Rs = tu.executeQuery(Sql);
String json = “var tide_photos ={‘items’:[“;
//{‘items’:[”,”]};”;
while(Rs.next())
{
String Photo = “”;
Photo = tu.convertNull(Rs.getString(“Photo”));
json+=”‘”+Photo+”‘,”;
}
json = json.substring(0,json.length()-1);
json+=”]};”;
out.println(json);
tu.closeRs(Rs);
//Document doc = CmsCache.getDocument(gid);//globalid
//TableUtil tu=new TableUtil();
//String js = doc.getFullHref();
//String Photo = “”;
//Photo = tu.convertNull(Rs.getString(“Photo”));
//String js=”var tide_photos ={‘items’:[”,”]};”;
//String js=”var tide_photos ={‘items’:[‘/images/2013/6/26/20136261372216492456_201_b.jpg’,’/images/2013/6/26/20136261372216491144_201_b.jpg’]};”;
//out.println(js);
%>
版权声明：本文为hehe520347原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。