topnews.jsp

几个非常优秀的JSP系统。可以拿来当课程设计。

<%@ page contentType="text/html;charset=GBK"%>
<%@ page language="java" import="java.sql.*" errorPage="" %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <!--DWLayoutTable-->
  <tr> 
                                  <td width="221" height="74">&nbsp;</td>
                                  <td width="341" align="center" valign="top"> 
                                    <table width="165" border="0" cellspacing="0" cellpadding="1">
        <!--DWLayoutTable-->
        <tr> 
          <td align="center" valign="top" bgcolor="#FFFFFF"> 　 </td>
        </tr>
        <tr> 
          <td valign="top" align="center" bgcolor="#FFFFFF">最新新闻</td>
        </tr>
        <tr> 
          <td valign="top"> 
            <%              
sql="select top 10 * from news order by news_id DESC" ;
rs=mdb.executeQuery(sql);
if(!rs.next())
{
  out.print("暂且没有新闻");         
}else
{ rs.previous();      
   while(rs.next()){
   %>
            <a href="news.jsp?news_id=<%=rs.getInt("news_id")%>" target="_blank"><%=rs.getString("news_title")%></a> 
            <br> 
            <%           
   }        
}       
         
  
                %>
          </td>
        </tr>
        <tr> 
          <td valign="top" align="right"> <a href="allnews.jsp" target="_blank"><img src="img/pics/more.gif" width="45" height="10" border="0"></a></td>
        </tr>
      </table></td>
                                  <td width="224">&nbsp;</td>
                                </tr>
                              </table>