📄 repelvip.jsp

📁 用JSP写的一个在线购物网站的代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"' and system='"+"1"+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，您不是系统管理员不能进行相应操作");
history.back();
</script>
<%}}%>
<%
String name=request.getParameter("name");
%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<script language="JavaScript">
function check()
{
  if(document.thisvip.reason.value.length==0)
  {
     alert("请填写拒绝原因");
	 document.thisvip.reason.focus();
	 return false;
  }
}
</script>
<body leftmargin="0" topmargin="0">
<br><br><br><br><br><br>
<form action="" method="post" name="thisvip" onSubmit="return check()">
<input type="hidden" name="repel" value="">
<input type="hidden" name="name" value="<%=name%>">
  <table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr> 
      <td height="20" colspan="3"></td>
    </tr>
    <tr> 
      <td colspan="3"><div align="center">拒绝用户<font color="#FF0000"><%=name%></font>的VIP申请</div></td>
    </tr>
    <tr> 
      <td height="15"></td>
    </tr>
	<tr> 
      <td height="25"><div align="center"><font color="#0000FF">请写明拒绝原因</font></div></td>
    </tr>
    <tr> 
      <td height="25" colspan="3"><div align="center">
          <textarea name="reason" cols="40" rows="8" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></textarea>
        </div></td>
    </tr>
    <tr> 
      <td height="20" colspan="3"></td>
    </tr>
    <tr> 
      <td height="25" colspan="3"><div align="center"> 
          <input type="submit" value="确定" onClick="document.all.repel.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
          <input type="reset" value="重写" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
    </tr>
  </table>
</form>
<%
String repel=request.getParameter("repel");
if(repel!=null && repel.equals("true"))
{
String id=request.getParameter("name");
String reason=request.getParameter("reason");
byte[] tmp=reason.getBytes("ISO8859_1");
reason=new String(tmp);
java.util.Date today=new java.util.Date();
String repeltime=today.toLocaleString();

String sql="update vip set repel='"+"1"+"',reason='"+reason+"',repeltime='"+repeltime+"' where name='"+id+"'";
ResultSet rs=data.executeQuery(sql);

response.sendRedirect("vip_through.jsp");
}%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -