newsbook_text.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
//public String getaBook(Connection db,int aid){
//ResultSet tmprs;
//					String str="select * from tushumingxi where lieID="+aid;
//					Statement stmt=db.createStatement();
//        //ResultSet rs=stmt.executeQuery("select * from tushumingxi");
//					tmprs=stmt.executeQuery(str);
//					out.print(str);
//					while(tmprs.next()){
//					
//					}
//}
%>
<table width="100%" 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>】
					<%//getaBook(dbBean.con,1);
					ResultSet tmprs;
					String str="select top 1 * from tushumingxi where lieID="+categoryid;
					tmprs=dbBean.exeSQL(str);
					//out.print(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>