<td style="color:#FFFFFF" id="t1" onmouseover="showInfo(1);" onmouseout="clearF(1);">公告</td>
<td id="t2" onmouseover="showInfo(2);" onmouseout="clearF(2);">拟建</td>
<td id="t3" onmouseover="showInfo(3);" onmouseout="clearF(3);">在建</td>
<td id="t4" onmouseover="showInfo(4);" onmouseout="clearF(4;)">经典</td>
<td width="13%" height="25" align="center" valign="middle" ><span class="STYLE4"><a href="../project/index.jsp">更多>></a></span> </td><td valign="top" bgcolor="#FFFFFF"><table id="popasp_table1">
<% (这里是连接数据库的) 《JSP》
Statement Stmt_1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_1 = "select top 8 * from News_Site where Class1 = '15' and Class2 = '501' order by id desc";
ResultSet rs_1 = Stmt_1.executeQuery(sql_1);int t = 0;
String color;
while(rs_1.next()){
if ((t % 2)==0){ %>
<tr>
<%}%>
<td width="23" height="22" valign="middle" class="font04"><div align="center"><img src="image/style_dd.gif" width="13" height="26" /></div></td>
<td width="" valign="middle" class="font04" height="22"><div align="left">
<a href = "../project/text.jsp?id=<%=rs_1.getString("id")%>"><%=ymd.LeftSize(rs_1.getString("News_Name"),14)%></a></div></td>
<td align="left" style="color:#011d8b" class="font04"> -<%=rs_1.getString("News_Date")%> </td>
<%if((t%2)==1){ %>
</tr> <%}
t++;
}
//while 循环
rs_1.close();
Stmt_1.close();
%> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0" id="popasp_table2" style="display:none;">
<%
Statement Stmt_2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_2 = "select top 8 * from News_Site where Class1 = '15' and Class2 = '502' order by id desc";
ResultSet rs_2 = Stmt_2.executeQuery(sql_2);int t_2 = 0;while(rs_2.next()){
if ((t_2 % 2)==0){ %>
<tr>
<%}%>
<td width="23" height="22" valign="middle" class="font04"><div align="center"><img src="image/style_dd.gif" width="13" height="26" /></div></td>
<td width="" valign="middle" class="font04" height="22"><div align="left">
<a href = "../project/text.jsp?id=<%=rs_2.getString("id")%>"><%=ymd.LeftSize(rs_2.getString("News_Name"),14)%></a></div></td>
<td align="left" style="color:#011d8b" class="font04"> -<%=rs_2.getString("News_Date")%> </td>
<%if((t_2 %2)==1){ %>
</tr> <%}
t_2 ++;
}
//while 循环
rs_2.close();
Stmt_2.close();
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="popasp_table3" style="display:none;">
<tr>
<td height="22"><span class="font04">企业收入 2008-04-09</span></td>
<td><span class="font04">企业收入 2008-04-09</span></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="popasp_table4" style="display:none;">
<%
Statement Stmt_4=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_4 = "select top 8 * from News_Site where Class1 = '15' and Class2 = '504' order by id desc";
ResultSet rs_4 = Stmt_4.executeQuery(sql_4);int t_4 = 0;while(rs_4.next()){
if ((t_4 % 2)==0){ %>
<tr>
<%}%>
<td width="23" height="22" valign="middle" class="font04"><div align="center"><img src="image/style_dd.gif" width="13" height="26" /></div></td>
<td width="" valign="middle" class="font04" height="22"><div align="left">
<a href = "text.jsp?id=<%=rs_4.getString("id")%>"><%=ymd.LeftSize(rs_4.getString("News_Name"),12)%></a></div> </td>
<td align="left" style="color:#011d8b" class="font04"> -<%=rs_4.getString("News_Date")%> </td>
<%if((t_4 %2)==1){ %>
</tr> <%}
t_4 ++;
}
//while 循环
rs_4.close();
Stmt_4.close();
%>
</table>
<td id="t2" onmouseover="showInfo(2);" onmouseout="clearF(2);">拟建</td>
<td id="t3" onmouseover="showInfo(3);" onmouseout="clearF(3);">在建</td>
<td id="t4" onmouseover="showInfo(4);" onmouseout="clearF(4;)">经典</td>
<td width="13%" height="25" align="center" valign="middle" ><span class="STYLE4"><a href="../project/index.jsp">更多>></a></span> </td><td valign="top" bgcolor="#FFFFFF"><table id="popasp_table1">
<% (这里是连接数据库的) 《JSP》
Statement Stmt_1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_1 = "select top 8 * from News_Site where Class1 = '15' and Class2 = '501' order by id desc";
ResultSet rs_1 = Stmt_1.executeQuery(sql_1);int t = 0;
String color;
while(rs_1.next()){
if ((t % 2)==0){ %>
<tr>
<%}%>
<td width="23" height="22" valign="middle" class="font04"><div align="center"><img src="image/style_dd.gif" width="13" height="26" /></div></td>
<td width="" valign="middle" class="font04" height="22"><div align="left">
<a href = "../project/text.jsp?id=<%=rs_1.getString("id")%>"><%=ymd.LeftSize(rs_1.getString("News_Name"),14)%></a></div></td>
<td align="left" style="color:#011d8b" class="font04"> -<%=rs_1.getString("News_Date")%> </td>
<%if((t%2)==1){ %>
</tr> <%}
t++;
}
//while 循环
rs_1.close();
Stmt_1.close();
%> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0" id="popasp_table2" style="display:none;">
<%
Statement Stmt_2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_2 = "select top 8 * from News_Site where Class1 = '15' and Class2 = '502' order by id desc";
ResultSet rs_2 = Stmt_2.executeQuery(sql_2);int t_2 = 0;while(rs_2.next()){
if ((t_2 % 2)==0){ %>
<tr>
<%}%>
<td width="23" height="22" valign="middle" class="font04"><div align="center"><img src="image/style_dd.gif" width="13" height="26" /></div></td>
<td width="" valign="middle" class="font04" height="22"><div align="left">
<a href = "../project/text.jsp?id=<%=rs_2.getString("id")%>"><%=ymd.LeftSize(rs_2.getString("News_Name"),14)%></a></div></td>
<td align="left" style="color:#011d8b" class="font04"> -<%=rs_2.getString("News_Date")%> </td>
<%if((t_2 %2)==1){ %>
</tr> <%}
t_2 ++;
}
//while 循环
rs_2.close();
Stmt_2.close();
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="popasp_table3" style="display:none;">
<tr>
<td height="22"><span class="font04">企业收入 2008-04-09</span></td>
<td><span class="font04">企业收入 2008-04-09</span></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="popasp_table4" style="display:none;">
<%
Statement Stmt_4=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_4 = "select top 8 * from News_Site where Class1 = '15' and Class2 = '504' order by id desc";
ResultSet rs_4 = Stmt_4.executeQuery(sql_4);int t_4 = 0;while(rs_4.next()){
if ((t_4 % 2)==0){ %>
<tr>
<%}%>
<td width="23" height="22" valign="middle" class="font04"><div align="center"><img src="image/style_dd.gif" width="13" height="26" /></div></td>
<td width="" valign="middle" class="font04" height="22"><div align="left">
<a href = "text.jsp?id=<%=rs_4.getString("id")%>"><%=ymd.LeftSize(rs_4.getString("News_Name"),12)%></a></div> </td>
<td align="left" style="color:#011d8b" class="font04"> -<%=rs_4.getString("News_Date")%> </td>
<%if((t_4 %2)==1){ %>
</tr> <%}
t_4 ++;
}
//while 循环
rs_4.close();
Stmt_4.close();
%>
</table>
<tr>
<td height="22"> <span class="font04">企业收入 2008-04-09 </span> </td>
<td> <span class="font04">企业收入 2008-04-09 </span> </td>
</tr>
</table>
这个出不来??
查出来了,这里有错误