<%@ page import = "SQLDATA" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312" %>
<jsp:useBean id="sqlbean" class="SQLDATA" scope="session"/>
<html>
<body background="../images/back.jpg">
<p align="center"><font size="6" face="楷体_GB2312">毛泽东思想概论</font></p>
<%
String aa,bb,cc,dd,ee,ff;
ResultSet rs=sqlbean.executeQuery("SELECT * FROM MAOGAI");
int i=1,j=0;
while(rs.next())
{
aa=rs.getString("SECTIONTYPE");
bb=rs.getString("SECTIONNAME");
cc=rs.getString("INDEXFILE");
ee=rs.getString("ZIPFILE");
ff=rs.getString("ONLINEFILE");
dd=rs.getString("SESSIONID");
if(aa.indexOf('章')>-1)
{
if(j==1)
{
i=i+1;
out.println("</table></div>");
}
j=0;
out.println(" ");
out.println("<div align='center'>");
out.println("<center>");
out.println("<table border='0' width='90%' height='0' cellspacing='0' cellpadding='0'>");
out.println("<tr>");
out.println("<td height='0'><img name='img"+String.valueOf(i)+"' border='0' src='../images/fclosed.gif' onclick='ShowAndHide(div"+String.valueOf(i)+","+"img"+String.valueOf(i)+")'>");
out.print(bb+"</td></tr></table></center></div>");
}
else
{
if(j==0)
{
j=1;
out.println("<div style='display:none' id=div"+String.valueOf(i)+" align='center'>");
out.println("<center>");
out.println("<table border='0' width='90%' height='0' cellspacing='0' cellpadding='0'>");
out.println("<tr><td height='30'> <img border='0' src='../images/file.gif'>");
out.print("<a href='windowsopen.jsp?indexfile=maogai/"+cc+"&sessionid="+dd+"&zipfile="+ee+"&onlinefile="+ff+"'>"+bb+"</a></td></tr>");
}
else
{
out.println("<tr><td height='30'> <img border='0' src='../images/file.gif'>");
out.print("<a href='windowsopen.jsp?indexfile=maogai/"+cc+"&sessionid="+dd+"&zipfile="+ee+"&onlinefile="+ff+"'>"+bb+"</a></td></tr>");
}
}
}
%>
</body>
</html>
<script language=javascript>
function ShowAndHide(divname,imgname)
{
if (divname.style.display == "block")
{
divname.style.display = "none";
imgname.src="../images/fclosed.gif";
self.focus();
}
else
{
divname.style.display = "block";
imgname.src="../images/fopen.gif";
self.focus();
}
}
</script>
转:http://www.cnjsp.org
