|
近日寫一段程序，要求從數據庫表中讀出紀錄，每個紀錄對應硬盤上的文件，這些文件全部是gif和swf文件，要求將這些gif和swf文件已4*4沒頁16個的形式顯示在瀏覽器上，就像ACDSee那樣。
由于數據庫中的紀錄是混亂的，gif和swf的排列順序沒有規則。對于gif文件，很好說，直接用<img src=<%=path%>>就可以顯示出來，可是對于swf文件，就很麻煩，因為swf文件要在頁面上顯示的話，就要用到<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="/download/swflash.cab#version=5,0,0,0" width="480" height="400">
<param name=movie value=http://cfan.net.cn/info/"images/man.swf">
<param name=quality value=high>
<embed src=http://cfan.net.cn/info/"images/man.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="480" height="400">
</embed>
這么長的代碼非常討厭，因此，我想到了一個很方便的方法：就是用iframe：
<iframe src=<%=Url%> scroll=auto marginwidth=0 marginheight=0 height=80% width=80% frameborder=0></iframe>
程序代碼如下：
<%
String sqlStr;
String imgUrl;
String extendName;
ResultSet rs=null;
pageBean.setPageSize(PAGESIZE);
pageBean.setCurrentPage(request);
dbBean.connectIntranetDatabase();
pageBean.setDB(dbBean);
sqlStr="select * from datamanager.res_animation_a where publish=1 order by id desc";
rs=pageBean.page(sqlStr);
int count=0;
%>
<table border=1 cellpadding=0cellspacing=0 bordercolorlight='#666666' width=95% align=center class='font-default' bordercolordark='#FFFFFF' >
<%
if(rs!=null){
do
{
//顯示字段內容
out.println("<tr>");
imgUrl=rs.getString("path");
extendName=rs.getString("filetype");
out.print("<td width=25% align=center valign=middle >");
if (extendName.trim().equals("gif")){
out.print("<a href=");
out.print(imgUrl);
out.print(">");
out.print("<img width='100' border=0 src=" + imgUrl + ">");
out.print("</a>");
}else{
out.print("<iframe src=");
out.print(imgUrl);
out.print(" scroll=auto marginwidth=0 marginheight=0 height=80% width=80% frameborder=0>");
out.print("</iframe>");
}
out.print("<br>");
out.print("<input type='checkbox' value='-1' name='");
out.print(rs.getString("id"));
out.print("'>");
out.print(rs.getString("name"));
out.print(".");
out.print(rs.getString("filetype"));
out.println("</td>");
count++;
out.print("<td width=25% align=center valign=middle >");
if (rs.next()){
imgUrl=rs.getString("path");
extendName=rs.getString("filetype");
if (extendName.trim().equals("gif")){
out.print("<a href=");
out.print(imgUrl);
out.print(">");
out.print("<img width='100' border=0 src=" + imgUrl + ">");
out.print("</a>");
}else{
out.print("<iframe src=");
out.print(imgUrl);
out.print(" scroll=auto marginwidth=0 marginheight=0 height=80% width=80% frameborder=0>");
out.print("</iframe>");
}
out.print("<br>");
out.print("<input type='checkbox' value='-1' name='");
out.print(rs.getString("id"));
out.print("'>");
out.print(rs.getString("name"));
out.print(".");
out.print(rs.getString("filetype"));
count++;
}
else{
out.print(" ");
}
out.println("</td>");
out.print("<td width=25% align=center valign=middle >");
if (rs.next()){
imgUrl=rs.getString("path");
extendName=rs.getString("filetype");
if (extendName.trim().equals("gif")){
out.print("<a href=");
out.print(imgUrl);
out.print(">");
out.print("<img width='100' border=0 src=" + imgUrl + ">");
out.print("</a>");
}else{
out.print("<iframe src=");
out.print(imgUrl);
out.print(" scroll=auto marginwidth=0 marginheight=0 height=80% width=80% frameborder=0>");
out.print("</iframe>");
}
out.print("<br>");
out.print("<input type='checkbox' value='-1' name='");
out.print(rs.getString("id"));
out.print("'>");
out.print(rs.getString("name"));
out.print(".");
out.print(rs.getString("filetype"));
count++;
}
else{
out.print(" ");
}
out.println("</td>");
out.print("<td width=25% align=center valign=middle >");
if (rs.next()){
imgUrl=rs.getString("path");
extendName=rs.getString("filetype");
out.print("<a href=");
out.print(imgUrl);
out.print(">");
out.print("<img width='100' border=0 src=" + imgUrl + ">");
out.print("</a>");
out.print("<br>");
out.print("<input type='checkbox' value='-1' name='");
out.print(rs.getString("id"));
out.print("'>");
out.print(rs.getString("name"));
out.print(".");
out.print(rs.getString("filetype"));
count++;
}
else{
out.print(" ");
}
out.println("</td>");
out.println("</tr>");
}while(rs.next() && count<PAGESIZE);
}
%>
|
