topnews.jsp

来自「叮当购物系统(ACCESS版): 主要功能: 客户在线购物, 管理员可发送」· JSP 代码 · 共 53 行

<table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <!--DWLayoutTable-->
                                <tr> 
                                  <td width="107" height="74">&nbsp;</td>
                                  <td width="165" align="center" valign="top"> 
                                    <table width="165" border="1" cellspacing="0" cellpadding="0" bordercolor="#D5A384">
                                      <!--DWLayoutTable-->
                                      <tr> 
                                        <td valign="top" align="center" bgcolor="#FFFFFF"> 
                                          　</td>
                                      </tr>
                                      <tr> 
                                        <td align="center" valign="top" bgcolor="#D5A384"><!--DWLayoutEmptyCell-->&nbsp; </td>
                                      </tr>
                                      <tr> 
                                        <td valign="top" align="center" bgcolor="#D5A384">最新新闻</td>
                                      </tr>
                                      <tr> <td valign="baseline" bgcolor="#F1E0D6"> 
                                          <%              

sql="select * from news order by news_id DESC" ;
rs=faqBeanid.executeQuery(sql);

//try
{// rs.previous();  
  int m=0;    
   while(rs.next()&&m<10){
   m++;
   %> 
                                       
                                          <img src="img/dot.gif" width="15" height="15">                                        <a href="news.jsp?news_id=<%=rs.getInt("news_id")%>" target="_blank"><%=rs.getString("news_title")%></a> 
                                          <br>  </td>
                                      </tr>
									       <tr> <td valign="baseline" bgcolor="#F1E0D6"> 
                                          <%           
   }        
}       
// catch (Exception e)
//{
 // out.print("暂且没有新闻");         
//}        

                %>
                                    <br>
</td>
                                      </tr>    
                                      <tr> 
                                        <td valign="bottom" 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="107">&nbsp;</td>
                                </tr>
                              </table>