bookrec_text.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<table width="95%" border="1" align="center" cellpadding="5" cellspacing="5" bordercolor="#CCCCCC"
			bgcolor="#FFFFFF" ID="Table15">
			<tr>
			<% i=0;
						sql="SELECT top 6 * FROM category where highLevelID=0 order by categoryID desc";
						rs=dbBean.exeSQL(sql);
						while(rs.next()){
						String categoryid=rs.getString("categoryID");	
					    i=i+1;				%>
				<td width="35%" bordercolor="#f8f8f8" bgcolor="#f8f8f8">
					<img src="pic/dot1.jpg" width="10" height="10" /> 【<strong><a href="Book_Leis.jsp?Cateid=<%=categoryid%>"><%=rs.getString("categoryName")%></a></strong>】
					<%
					ResultSet tmprs;
					String str="select top 1  * from tushumingxi where lieID="+categoryid+" and  commend=True";
					tmprs=dbBean.exeSQL(str);
					while(tmprs.next()){
					%>
					<a href="Book_info.jsp?Bookid=<%=tmprs.getString("shuID")%>"><%=tmprs.getString("shu_name")%></a>
			  </td>
					<%}
					tmprs.close();
		if(i%3==0&i>=3)
		{
%>
  </tr>
 <tr>
                <%
         }
	   if(i>=10) {
	      break;
	   }
}
rs.close();
%>
  </tr>
</table>