news_dynamic.jsp

JSP课件以及一个网上书店系统程序,带数据库

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<table width="216" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table17">
			<tr>
				<td><img src="pic/newsDyanic.gif" width="216" height="41" /></td>
				</tr>
					<tr>
						<td height="61" bgcolor="#f1f1f1">
							<table width="100%" border="0" cellspacing="0" cellpadding="0" ID="Table18">
		<% rs=dbBean.exeSQL("SELECT top 10 * FROM news");
								while(rs.next()){
								%>
								<tr>
									<td height="22">&nbsp;</td>
									<td valign="middle"><a href="bookinfo.jsp?id=<%=rs.getString("news_id")%>">
									<font color="#FF0000"><%=rs.getString("news_title")%></font></a><img src="pic/new.gif" width="28" height="11" border="0" /></td>
								</tr>
								<tr>
									<td height="3" colspan="2"><img src="pic/newsDyanic_Line.gif" width="216" height="3" /></td>
								</tr><% } %></table>
								</td></tr>
				</table>