book_categorys.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table5">
	<tr>
		<td class="left1"><strong> 分 类：</strong></td>
	</tr>
	<tr>
		<td height="20">
			<%
						sql="SELECT  * FROM category where highLevelID=0 ";
						rs=dbBean.exeSQL(sql);
						while(rs.next()){
						String categoryid=rs.getString("categoryID");	
					   		%>
			<font color="#FF0000">·</font> <a href="Book_Leis.jsp?Cateid=<%=categoryid%>" target="_blank">
				<u><font color="#990000">
						<%=rs.getString("categoryName")%></font></u></a>&nbsp;
			<%
					ResultSet tmprs;
					String str="select * from category where highLevelID="+categoryid;
					tmprs=dbBean.exeSQL(str);
					while(tmprs.next()){
					%>
			·<a href="Book_Leis.jsp?Cateid=<%=tmprs.getString("categoryID")%>" target="_blank"><u><%=tmprs.getString("categoryName")%></u></a><%}
					tmprs.close();						
						}%></td>
	</tr>
</table>