📄 mgrproduct.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="my.shop.db.*"%>
<%-- 会话过滤 --%>
<%@ include file="sessionfilter.jsp" %>
<%
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>产品管理</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 24px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<jsp:include page="top.html"></jsp:include>
<div align="center"><a href="addProduct.jsp">添加产品</a></div><br>
<hr>
<div align="center"><h3>所有产品</h3></div>
<table width="1024" border="0" align="center">
<tr>
<td bgcolor="#3366CC"><div align="center">ID</div></td>
<td bgcolor="#3366CC"><div align="center">产品名称</div></td>
<td bgcolor="#3366CC"><div align="center">产品价格</div></td>
<td bgcolor="#3366CC"><div align="center">图片</div></td>
<td bgcolor="#3366CC"><div align="center">所属类别</div></td>
<td bgcolor="#3366CC"><div align="center">删除</div></td>
</tr>
<%
//从数据库中取出当前的合法注册用户信息
String sql = "select * from product" ;
Connection conn = DBConnection.getInstance().getConnection() ;
PreparedStatement pstmt = conn.prepareStatement(sql) ;
ResultSet rs = pstmt.executeQuery() ;
while(rs.next()){
String id = rs.getString(1) ;
int cateid = Integer.parseInt(rs.getString(5)) ;
ResultSet rs2 = conn.createStatement().executeQuery("select name from category where id="+cateid);
%>
<tr>
<td bgcolor="#899BE4"><%=id %></td>
<td bgcolor="#899BE4"><%=rs.getString(2) %></td>
<td bgcolor="#899BE4"><%=rs.getString(3) %></td>
<td bgcolor="#899BE4"><%=rs.getString(4) %></td>
<td bgcolor="#899BE4"><%=rs2.next()?rs2.getString(1):"没有指定类别" %></td>
<td bgcolor="#899BE4"><a href="delproduct.jsp?id=<%=id %>">删除</a></td>
</tr>
<%rs2.close() ;
}
rs.close() ;
pstmt.close() ;
conn.close() ;
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -