学习 对了就着这个机会请教大家一个问题<%@ page contentType="text/html; charset=GBK"
import="java.sql.*" %>
<%request.setCharacterEncoding("GB2312");com.prime.db.DBTrans mydb = new com.prime.db.DBTrans();
try {
String strSql=" select * from (select PICPATH ,PICID,PICTITLE from m_picture"
+" where classid='04' and lan_flag='1' and PICSTUS='2' order by picid desc) where rownum<=5";
ResultSet rs=mydb.executeQuery(strSql);%>
<!--滚动图片资料 begin-->
<style type="text/css">
.RollPic{
border:1px solid #999999;
padding:4px 4px 4px 4px;
background-color:#fff;
overflow:hidden;
}.RollTitle{color:#fff;line-height:19px;}
</style>
<table width="575" border="0" cellspacing="0" cellpadding="0"align=center>
<tr>
<td bgcolor="#eaeaea"align=center>
<div id=demo style="overflow:hidden;width:550px;height:145px;margin-top:5px;">
<table cellSpacing=0 cellpadding=0 border=0>
<tr>
<td id=demo1> <table cellspacing=0 width=100% >
<tr>
<% boolean bNotFound=true;
int i=1;
while (rs.next()){ bNotFound = false;
String strPICPATH=rs.getString("PICPATH");
String strPICID=rs.getString("PICID");
String strPICTITLE=rs.getString("PICTITLE");%>
<td><table>
<tr>
<td class=RollPic><img src="/infopub/inputpicture/upload/<%=strPICPATH%>" width=100 height=100 border=0></a></td>
</tr>
<tr height='24'>
<td class=RollPic align="center" valign="middle"><a target="_blank" href="/en/public/entpjjshow.jsp?picid=<%=strPICID%>">
<%=strPICTITLE.length()>14?strPICTITLE.substring(0,14)+"…":strPICTITLE%>
</a></td>
</tr>
</table></td>
<% i++;
}
%>
</tr>
</table>
<%if (bNotFound) {%>
<table width="100%" height="100%">
<tr>
<td class=RollPic align="center" valign="middle">没有推介图片.</td>
</tr>
</table>
<%}%>
<%} catch (Exception ex) {
} finally {
try {
mydb.close();
mydb=null;
} catch (Exception ex) { }
}%>
</td>
<td id=demo2></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#eaeaea"><a href="/en/tpjj.jsp" target="_blank">more...</a></td>
</tr>
</table>
<script>
var speed=40//速度数值越大速度越慢
demo2.innerHTML=demo1.innerHTML
function Marquee(){
if(demo2.offsetWidth-demo.scrollLeft<=1)
demo.scrollLeft-=demo1.offsetWidth
else{
demo.scrollLeft++
}
}
var MyMar=setInterval(Marquee,speed)
demo.onmouseover=function() {clearInterval(MyMar)}
demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}
</script>
<!--滚动图片资料 end--> 这段程序是从数据库中调用图片 如果我要是从一个指定的目录下调用.jpg文件 该怎么写(动态调用 也就是说从该目录下直接读取) 如d:\images下面调用图片 不从数据库中调用 那位大侠可以告诉一下
import="java.sql.*" %>
<%request.setCharacterEncoding("GB2312");com.prime.db.DBTrans mydb = new com.prime.db.DBTrans();
try {
String strSql=" select * from (select PICPATH ,PICID,PICTITLE from m_picture"
+" where classid='04' and lan_flag='1' and PICSTUS='2' order by picid desc) where rownum<=5";
ResultSet rs=mydb.executeQuery(strSql);%>
<!--滚动图片资料 begin-->
<style type="text/css">
.RollPic{
border:1px solid #999999;
padding:4px 4px 4px 4px;
background-color:#fff;
overflow:hidden;
}.RollTitle{color:#fff;line-height:19px;}
</style>
<table width="575" border="0" cellspacing="0" cellpadding="0"align=center>
<tr>
<td bgcolor="#eaeaea"align=center>
<div id=demo style="overflow:hidden;width:550px;height:145px;margin-top:5px;">
<table cellSpacing=0 cellpadding=0 border=0>
<tr>
<td id=demo1> <table cellspacing=0 width=100% >
<tr>
<% boolean bNotFound=true;
int i=1;
while (rs.next()){ bNotFound = false;
String strPICPATH=rs.getString("PICPATH");
String strPICID=rs.getString("PICID");
String strPICTITLE=rs.getString("PICTITLE");%>
<td><table>
<tr>
<td class=RollPic><img src="/infopub/inputpicture/upload/<%=strPICPATH%>" width=100 height=100 border=0></a></td>
</tr>
<tr height='24'>
<td class=RollPic align="center" valign="middle"><a target="_blank" href="/en/public/entpjjshow.jsp?picid=<%=strPICID%>">
<%=strPICTITLE.length()>14?strPICTITLE.substring(0,14)+"…":strPICTITLE%>
</a></td>
</tr>
</table></td>
<% i++;
}
%>
</tr>
</table>
<%if (bNotFound) {%>
<table width="100%" height="100%">
<tr>
<td class=RollPic align="center" valign="middle">没有推介图片.</td>
</tr>
</table>
<%}%>
<%} catch (Exception ex) {
} finally {
try {
mydb.close();
mydb=null;
} catch (Exception ex) { }
}%>
</td>
<td id=demo2></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#eaeaea"><a href="/en/tpjj.jsp" target="_blank">more...</a></td>
</tr>
</table>
<script>
var speed=40//速度数值越大速度越慢
demo2.innerHTML=demo1.innerHTML
function Marquee(){
if(demo2.offsetWidth-demo.scrollLeft<=1)
demo.scrollLeft-=demo1.offsetWidth
else{
demo.scrollLeft++
}
}
var MyMar=setInterval(Marquee,speed)
demo.onmouseover=function() {clearInterval(MyMar)}
demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}
</script>
<!--滚动图片资料 end--> 这段程序是从数据库中调用图片 如果我要是从一个指定的目录下调用.jpg文件 该怎么写(动态调用 也就是说从该目录下直接读取) 如d:\images下面调用图片 不从数据库中调用 那位大侠可以告诉一下
<!--滚动图片资料 begin-->
<style type="text/css">
.RollPic{
border:1px solid #999999;
padding:4px 4px 4px 4px;
background-color:#fff;
overflow:hidden;
}.RollTitle{color:#fff;line-height:19px;}
</style>
<table width="600" height="113" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <div id=demo style=overflow:hidden;height:113;width:600;color:#ffffff><table width="600" height="113" border=0 align=center cellpadding=0 cellspace=0>
<tr>
<td id=demo1 valign=top> <img src="file:///D|/images/111.jpg" width="150" height="113" border="1"><img src="file:///D|/images/111.jpg" width="150" height="113" border="1"><img src="file:///D|/images/111.jpg" width="150" height="113" border="1"><img src="file:///D|/images/111.jpg" width="150" height="113" border="1"></td>
<td id=demo2 valign=top></td></tr></table></div><script>
var speed=40//速度数值越大速度越慢
demo2.innerHTML=demo1.innerHTML
function Marquee(){
if(demo2.offsetWidth-demo.scrollLeft<=1)
demo.scrollLeft-=demo1.offsetWidth
else{
demo.scrollLeft++
}
}
var MyMar=setInterval(Marquee,speed)
demo.onmouseover=function() {clearInterval(MyMar)}
demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}
</script>
<!--滚动图片资料 end--> 这是静态调用图片 滚动 要是动态调用呢??