inludenotice.jsp

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

<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#D5A384">
              <tr> 
                <td></td>
              </tr>
              <tr> 
                <td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0" height="18">
                    <tr> 
                      <td align="center" bgcolor="#D5A384"> </td>
                    </tr>
                    <tr> 
                      <td align="center" height="20" bgcolor="#D5A384"> <b>站内公告</b></td>
                    </tr>
                    <tr> 
                      <td bgcolor="#F1E0D6"> 
                        <% 
int i=0;
 String title,msg;

sql="select * from pub order by ID DESC";
//sql="select * from pub";
rs=faqBeanid.executeQuery(sql);
if(!rs.next()){
%>
                        <p style="margin:0 5; ">暂-无-公-告!<br>
                        </p>
                      <%
}

else{
  rs=faqBeanid.executeQuery(sql);
  while(rs.next())
        {
			i=i++;
			title=rs.getString("title");
			msg=rs.getString("msg");
			
			out.print("<p style="+"'margin:5;' "+"><b>"+title+"</b><br>"+msg+"<br>"+rs.getDate("pub_date")+"<br> </p>");
            if(i>=3){break;}
         }

 }

%>                      </td>
                    </tr>
                  </table></td>
              </tr>
<tr> </table>