📄 repel.jsp

📁 用JSP写的一个在线购物网站的代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<%
String manager=(String)session.getValue("manager");
if(manager=="" && manager==null)
{%>
<script language="JavaScript">
alert("请登陆后再进入用户管理后台");
history.back();
</script>
<%}else{
String sql="select * from manager where name='"+manager+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="JavaScript">
alert("对不起，您的用户名不存在或已被删除");
history.back();
</script>
<%}else{
String id=request.getParameter("mid");
sql="select name from manager where id='"+id+"'";
rs=data.executeQuery(sql);
rs.next();
String name=rs.getString("name");
rs.close();
sql="select reason,repeltime from vip where name='"+name+"'";
rs=data.executeQuery(sql);
rs.next();
String reason=rs.getString("reason");
String repeltime=rs.getString("repeltime").substring(0,16);
rs.close();
%>
<body leftmargin="0" topmargin="0">
<table width="250" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="15" colspan="3"></td>
</tr>
<tr>
<td width="100" height="20"><div align="right">申请人:</div></td>
<td width="10"></td>
<td width="140"><font color="#FF0000"><%=name%></font></td>
</tr>
<tr>
<td height="20"><div align="right">拒绝时间:</div></td>
<td></td>
<td><%=repeltime%></td>
</tr>
<tr>
<td height="20"><div align="right">拒绝原因:</div></td>
<td></td>
<td><%=reason%></td>
</tr>
</table>
<%}}%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -