news.jsp

JSP图书管理系统 包括会员管理 图书管理 借阅管理 等等 是非常好的图书管理软件

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*,java.util.*" errorPage="" %>
<%@ include file="inc/conn.jsp"%>
<link href="css.css" rel="stylesheet" type="text/css">
   <script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script> 
	<style type="text/css">
<!--
.style1 {font-size: 12pt}
.style2 {font-size: 10pt}
.styleac{color: #000000}
-->
    </style>
<table width="429" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" >
      <!--DWLayoutTable-->
      <tr>
        <td height="25" colspan="2" align="center" valign="middle"><span class="style1">站 内 新 闻</span></td>
      </tr>
      <tr><td width="229" height="13" valign="middle"><span class="style2">新闻标题</span></td>
        <td width="200" align="center" valign="middle"><span class="style2">发布时间</span></td>
      </tr>
	  <tr bgcolor="#FFCC99">
             <td  height="1" colspan="2" valign="top" ></td>
  </tr>
	  <%
     String sql="select * from news ";
      ResultSet rs=stmt.executeQuery(sql);
     while(rs.next())
      {%>
           <tr> 
              <td  height="25" valign="middle" ><a href=# onClick="MM_openBrWindow('newslist.jsp?id=<%=rs.getString("news_id")%>','','width=400,height=550')"><%=rs.getString("news_title")%></a></td>
              <td align="center" valign="middle" ><%=rs.getDate("news_date")%>                         </tr>
           <tr>
             <td height="1" colspan="2" valign="top" background="image/dian.gif"></td>
           </tr>
			
 <%}
%>
          </table>
		  <table width="430">
		  <tr><td align="right" valign="middle" ><a href="Javascript:window.close()" class="styleac">关闭本页</a></td>
		  </tr>
</table>