大家好,本人在做一个网页刷新图片的时候,要用到javascript来调用数据库里的数据,具体代码如下:
<%
sql="select * from upimg where dd='0' order by id desc ";
rs=smt.executeQuery(sql);
String img;
%><SCRIPT language=JavaScript1.1><%while(rs.next()){
img=rs.getString("img");
%>
var image<%=i%>=new Image()
image<%=i%>.src="images/move/"+<%=img%>
<%}%></SCRIPT>
请问这段代码有什么问题吗?
我编辑的时候老是不行,在网页上无法显示,有哪个大侠能给个好的建议呢?
<%
sql="select * from upimg where dd='0' order by id desc ";
rs=smt.executeQuery(sql);
String img;
%><SCRIPT language=JavaScript1.1><%while(rs.next()){
img=rs.getString("img");
%>
var image<%=i%>=new Image()
image<%=i%>.src="images/move/"+<%=img%>
<%}%></SCRIPT>
请问这段代码有什么问题吗?
我编辑的时候老是不行,在网页上无法显示,有哪个大侠能给个好的建议呢?
//那里定义了sql?
rs=smt.executeQuery(sql);
//那时定义了rs?
img=rs.getString("img");
//那里定义了img?
---------------
最主要的问题还是
var image<%=i%>=new Image();
---------------------------
var OptionImg = new Array();
OptionImg[<%=i%>] = new Image();
OptionImg[<%=i%>].src="images/move/"+<%=img%>
rollImage = new Image;
rollImage.src = "rollImage1.jpg";
defaultImage = new Image;
defaultImage.src = "image1.jpg";
</script>
<a href="/"myUrl"" onMouseOver="document.myImage.src = rollImage.src;"
onMouseOut="document.myImage.src = defaultImage.src;">
<img src="/"image1.jpg"" name="myImage" width=100 height=100 border=0>
String sql="select * from upimg where dd='0' order by id desc ";
ResultSet rs=smt.executeQuery(sql);
说的对
var image1=new Image()
image1.src="images/move/01.jpg"
这样的数据,完整代码:
<%@page contentType="text/html;charset=gb2312"%>
<%@include file="manage/conn.jsp"%>
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<%
sql="select * from upimg where dd='0' order by id desc ";
rs=smt.executeQuery(sql);
String img;
int i=0;
%><SCRIPT language=JavaScript1.2>
function reapply(){
setTimeout("slideit()",500)
return true
}
window.onerror=reapply
</SCRIPT>
<SCRIPT language=JavaScript1.1>
<%
while(rs.next()){
img=rs.getString("img");
i=i+1;
%>
var image<%=i%>=new Image()
image<%=i%>.src="images/move/"+<%=img%>
<%}%>
</SCRIPT><BODY bgColor=#ffffff leftMargin=0 topMargin=0 onload=slideit() marginwidth="0"
marginheight="0" onselectstart="return false"><META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 onload=slideit() marginwidth="0"
marginheight="0" onselectstart="return false">
<%
sql="select * from upimg where dd='0' order by id desc ";
rs=smt.executeQuery(sql);
if(rs.next())
{
img=rs.getString("img");
%><IMG style="FILTER: revealTrans(Duration=1.0, Transition=23)"
height=248 src="images/move/<%=img%>" width=333 border=0 name=slide>
<SCRIPT>
var number_of_images=23
var speed=3
var step=1
var whichimage=1
function slideit(){
if (!document.images)
return
if (document.all)
slide.filters.item(0).Apply()
document.images.slide.src=eval("image"+step+".src")
if (document.all)
slide.filters.item(0).Play()
whichimage=step
if (step<number_of_images)
step++
else
step=1
if (document.all)
setTimeout("slideit()",speed*1000+1000)
else
setTimeout("slideit()",speed*1000)
}
</SCRIPT>
<%}%>
</BODY></HTML>
var image<%=i%>=new Image()
image<%=i%>.src="images/move/"+<%=img%>这个过程完成了图片的预加载,好!!!2:
eval("image"+step+".src")
这个过程完成图片的src输出,好!!!3:
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 onload=slideit() marginwidth="0"
marginheight="0" onselectstart="return false"><META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 onload=slideit() marginwidth="0"
marginheight="0" onselectstart="return false">
这段重复了,删掉一段看看先;4:
同时注意一下:
document.images.slide与slide.filters.item(0)对象;
alert()一下看看.
sql="select * from upimg where dd='0' order by id desc ";
rs=smt.executeQuery(sql);
String img;
%><SCRIPT language=JavaScript1.1><%while(rs.next()){
img=rs.getString("img");
%>
var image<%=i%>=new Image()
image<%=i%>.src="images/move/"+<%=img%>;<-此处少了一个分号
<%}%></SCRIPT>
那你就看看数据库取数据的问题吧.