?? 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 + -