inludenotice.jsp

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

<%@ page contentType="text/html;charset=GBK"%>
<%@ page language="java" import="java.sql.*" errorPage="" %>

<table width="100%" border="1" cellspacing="0" cellpadding="0">
  <tr> 
                <td>　</td>
              </tr>
              <tr> 
                <td align="center"><table width="100%" border="0" cellspacing="1" cellpadding="1" height="18">
        <tr> 
          <td align="center"> <b>站内公告</b></td>
        </tr>
        <tr> 
          <td bgcolor="#FFFFFF"> 
            <% 
 int i=0;
sql="select * from pub order by ID DESC";
rs=mdb.executeQuery(sql);
if(!rs.next())
 {
            %>
            <p style="margin:0 5; ">暂无公告<br>
              <%
 }
else{

  rs.previous();
  while(rs.next())
  {
			i=i+1;
			%>
            <p style="margin:5; "><b><%=rs.getString("title")%></b><br>
              <%=rs.getString("msg")%> <br>
              <%=rs.getDate("date")%></p>
            <%
   if(i>=3){
   break;
   } 

  }
}

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