📄 newmerchantlist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*,com.netshop.*" %>
<jsp:useBean scope="page" id="user" class="com.netshop.user" />
<jsp:useBean scope="page" id="executeWay" class="com.netshop.executeWay" />
<html>
<head>
<title>网上商品交易平台</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<div align=center>
<p align="center"><font size="5">未审批店铺信息</font></p>
<form name=form1 action=merchantAdmit.jsp method=post>
<table width="90%" border=0>
<tr bgcolor="#F0F0F0">
<td align="center" width="15%"><font size="4">选择</font></td>
<td align="center" width="30%"><font size="4">店名</font></td>
<td align="center" width="20%"><font size="4">店主</font></td>
<td align="center" width="20%"><font size="4">经营项目</font></td>
<td align="center" width="15%"><font size="4">操作</font></td>
</tr>
<%
ResultSet rs = user.showAllMerchants("0");
while(rs.next())
{
String strSql1 = "select name from goodsField where ID = '"+rs.getLong("mainFields")+"'";
ResultSet rs1 = executeWay.exeSqlQuery(strSql1);
rs1.first();
%>
<tr>
<td align="center"><input type=checkbox name=admitID value=<%=rs.getLong("ID")%>></td>
<td> <%=rs.getString("shopName")%></td>
<td> <%=rs.getString("shopper")%></td>
<td> <%=rs1.getString("name")%></td>
<td> <a href='../sendMail.jsp?receiver=<%=rs.getString("userName")%>' target="_self" >发邮件</a></td>
</tr>
<%
}
%>
</table>
<p align=center><input type=submit name=pass value="审批通过"></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -