📄 myattentionlist.jsp
字号:
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,com.netshop.*" %>
<HTML>
<HEAD>
<title>网上商品交易平台</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language=javascript>
<!--
function checkDel()
{
if(!confirm("确定要删除所选项吗？"))
{
return false;
}
else
{
document.all.form1.action="deleteAttention.jsp";
}
}
//-->
</script>
</HEAD>
<BODY>
<jsp:useBean id="attention" scope="page" class="com.netshop.attention"/>
<jsp:useBean id="executeWay" scope="page" class="com.netshop.executeWay"/>
<div align=left>
<form name=form1 method=post target=_self id=form1 onsubmit="checkDel()">
<table width=90% border=1 cellpadding="5" cellspacing="0">
<tr>
<td colspan=4 align=center>
<font size=5>
<b>
所有收藏商品
</b>
</font>
</td>
</tr>
<tr bgcolor="#DFDFDF">
<td align=center width=10%>
<b>
选择
</b>
</td>
<td align=center width=20%>
<b>
商品名
</b>
</td>
<td align=center width=20%>
<b>
类别
</b>
</td>
<td align=center width=30%>
<b>
所属店铺
</b>
</td>
</tr>
<%
String strID = ((com.netshop.user)session.getAttribute("user")).ID + "";
ResultSet rs = attention.showAllAttentions(strID);
while(rs.next())
{
String strSql = "select g.title,gf.name,u.shopName from goods g,goodsField gf,users u where g.goodsField = gf.ID and g.issuer = u.ID and g.ID ="+rs.getLong("goodsID");
ResultSet rs1 = executeWay.exeSqlQuery(strSql);
if(rs1.next())
{
%>
<tr>
<td align=left>
<input type=checkbox name=selAttention value=<%=rs.getLong("ID")%> >
</td>
<td align=left>
<a href=goodsShow.jsp?ID=<%=rs.getLong("ID")%> target=_blank>
<%=rs1.getString("g.title")%>
</a>
</td>
<td align=left>
<%=rs1.getString("gf.name")%>
</td>
<td align=left>
<%=rs1.getString("u.shopName")%>
</td>
</tr>
<%
}
}
%>
</table>
<input type=submit name=submit value=删除 >
</form>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -