📄 product_query.jsp

📁 JDBC数据库高级编程源代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="jdbcbook.ch08.*" %>
<html>
<head>
<title>商品信息查询结果</title>
<link rel="stylesheet" href="../pub/common.css">
</head>
<body>
<center>
<jsp:useBean id="product" class="jdbcbook.ch08.Product" scope="page">
	<jsp:setProperty name="product" property="*" />
</jsp:useBean>
<jsp:useBean id="categoryBean" class="jdbcbook.ch08.CategoryBean" scope="page" />
<jsp:useBean id="productBean" class="jdbcbook.ch08.ProductBean" scope="page" />
<%
	java.util.Vector categorys = categoryBean.queryCategory( null );
	java.util.Vector products = productBean.queryProduct( product );
	if( null==products || products.isEmpty() )
	{
		out.println( "没有找到符合条件的商品信息！" );
	}
	else
	{
%>
		<table width="500" border="1">
			<tr>
				<td>&nbsp;</td>
				<td align="center"><b>商品名称</b></td>
				<td align="center"><b>生产厂商</b></td>
				<td align="center"><b>商品描述</b></td>
				<td align="center"><b>商品类型</b></td>
				<td align="center"><b>修改</b></td>
				<td align="center"><b>删除</b></td>
			</tr>
<%
		for( int i=0; i<products.size(); i++ )
		{
			Product p = (Product)products.get( i );
%>
			<tr>
				<td align="right"><%=(i+1)%></td>
				<td ><%=p.getName()%></td>
				<td ><%=p.getManufacturer()%></td>
				<td ><%=p.getDescription()%></td>
				<%
					for( int j=0; j<categorys.size(); j++ )
					{
						Category cat = (Category)categorys.get( j );
						if( cat.getCategoryID() == p.getCategoryID() )
						{
							out.println( "<td >" + cat.getName() + "</td>" );
							break;
						}
					}
				%>
				<td align="center">
					<a href="product_updatein.jsp?productID=<%=p.getProductID()%>">修改</a>
				</td>
				<td align="center">
					<a href="product_del.jsp?productID=<%=p.getProductID()%>">删除</a>
				</td>
			</tr>
<%
		}
%>
		</table>
<%
	}
%>
<p>
<jsp:include  page="hotlink.jsp" />
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -