藏品中心 > 隋建国雕塑作品
![点击查看[隋建国雕塑作品]大图](http://img4.artxun.com/img?sp=d134158dbd4e4d0b38b4881fafe4d028&id=1951f9759b7877b0481710869bc4af45&s=c=cG5qMyU3NTM2MjAyMjA0NjAwMjkvcnxlbGdhL2Fkb2BsdX0vb25jcShxYW55dyd3L3ovcDR0aH&is=thumbnail_400_400.jpg)
1
<%@page contentType="text/html;charset=utf-8"%> <%@page import="java.io.*,java.sql.*,java.util.*,com.bobaoo.common.*,com.bobaoo.common.data.*,com.bobaoo.util.*"%> <%@include file="manage/global/core.jsp"%> <% long CacheTime = 1000 * 60 * 60 * 24 * 2; int idx = 0; String shtml = "", eName; File file = null; ResultSet rst = null; Statement stmt = null; Connection conn = null; DBConnectionManager dbMgr = null; /* */ try { idx = Integer.parseInt(request.getParameter("idx")); file = new File(request.getRealPath("/article/" + (idx / 2000 + 1) + "/" + idx + ".htt")); if (file.exists() && (System.currentTimeMillis() - file.lastModified() < CacheTime)) { out.println(FileUtils.readFile(file.getAbsolutePath(), "UTF-8")); return; } shtml = "\r\n";
dbMgr = DBConnectionManager.getInstance();
conn = dbMgr.getConnection("idb");
stmt = conn.createStatement();
rst = stmt.executeQuery("SELECT ID,NAME,KEYWORDS FROM (SELECT /*+ INDEX(BB_PRODUCT BB_PRODUCT_PK)*/ ID,NAME,KEYWORDS FROM BB_PRODUCT WHERE STATE = 3 AND ID > " + idx + ") WHERE ROWNUM < 2");
if (rst.next())
{
eName = rst.getString("KEYWORDS");
eName = null == eName || "".equals(eName) ? "cangping" : Pinyin.getPinYin(eName.replaceAll("^(\\S+).*$", "$1")).replaceAll("\\s+", "");
shtml += " 下一藏品：" + rst.getString("NAME") + "
\r\n"; } rst.close(); rst = stmt.executeQuery("SELECT ID,NAME,KEYWORDS FROM (SELECT /*+ INDEX_DESC(BB_PRODUCT BB_PRODUCT_PK)*/ ID,NAME,KEYWORDS FROM BB_PRODUCT WHERE STATE = 3 AND ID < " + idx + ") WHERE ROWNUM < 2"); if (rst.next()) { eName = rst.getString("KEYWORDS"); eName = null == eName || "".equals(eName) ? "cangping" : Pinyin.getPinYin(eName.replaceAll("^(\\S+).*$", "$1")).replaceAll("\\s+", ""); shtml += " 上一藏品：" + rst.getString("NAME") + "\r\n"; } shtml += "
\r\n";
FileUtils.writeFile(file.getAbsolutePath(), shtml, "UTF-8", false);
out.println(shtml);
}
catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
try { rst.close(); } catch(Exception e) {}
try { stmt.close(); } catch(Exception e) {}
try
{
dbMgr.freeConnection("idb", conn);
dbMgr.release();
}
catch(Exception e) {}
rst = null;
stmt = null;
conn = null;
dbMgr = null;
file = null;
}
%>
\r\n"; } rst.close(); rst = stmt.executeQuery("SELECT ID,NAME,KEYWORDS FROM (SELECT /*+ INDEX_DESC(BB_PRODUCT BB_PRODUCT_PK)*/ ID,NAME,KEYWORDS FROM BB_PRODUCT WHERE STATE = 3 AND ID < " + idx + ") WHERE ROWNUM < 2"); if (rst.next()) { eName = rst.getString("KEYWORDS"); eName = null == eName || "".equals(eName) ? "cangping" : Pinyin.getPinYin(eName.replaceAll("^(\\S+).*$", "$1")).replaceAll("\\s+", ""); shtml += " 上一藏品：" + rst.getString("NAME") + "\r\n"; } shtml += "
标签云
更多>>热门排行
<%@page contentType="text/html;charset=utf-8"%> <%@page import="java.io.*,java.sql.*,java.util.*,com.bobaoo.util.*,com.bobaoo.common.*,com.bobaoo.common.data.*"%> <% long CacheDays = 1000 * 60 * 60 * 24 * 1; String shtml, keyword; File file = null; ResultSet rst = null; Statement stmt = null; Connection conn = null; DBConnectionManager dbMgr = null; try { file = new File(request.getRealPath("/ProductRank.html")); if (file.exists() && (System.currentTimeMillis() - file.lastModified() < CacheDays)) { out.println(FileUtils.readFile(file.getAbsolutePath(), "UTF-8")); return; } dbMgr = DBConnectionManager.getInstance(); conn = dbMgr.getConnection("idb"); stmt = conn.createStatement(); shtml = "| 排行 | 名称 | 关注 |
|---|---|---|
| " + rst.getString("NAME") + " | " + rst.getInt("CLICKS") + "次 |
