?? delete.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="beans.Condb"%>
<%@ page import="beans.Strto" %>
<% Strto strto=new Strto();
Condb con=new Condb();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>目錄添加</title>
<style type="text/css">
<!--
.style1 {font-family: "方正硬筆楷書簡體"}
.style2 {font-size: 16px}
-->
</style>
</head>
<link rel="stylesheet" href="../../Css/style.css">
<body topmargin="0" leftmargin="0">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="558" height="110" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#bdcbd6">
<tr>
<td width="567" height="26" valign="bottom" background="../../Image/skintop2.gif"><div align="center" class="style1 style2">
<div align="center"><font style="color:#FFFFFF;">會 員 信 息 操 作 成 功</font> </div>
</div></td>
</tr>
<tr>
<td><table width="559" align="center" cellpadding="0" cellspacing="0" bordercolor="#9caab5">
<tr>
<td height="92"><table width="404" height="90" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#216184" class="wenbenkuang">
<tr>
<td width="402" valign="top"><table width="400" border="0" align="center" cellpadding="0" cellspacing="0" style="color:#ffffff ">
<tr>
<td height="15"> </td>
</tr>
<tr>
<td height="50"><div align="right" class="style1"></div>
<div align="left" class="style1">
<div align="center"><img src="../../Image/Memdel.gif" alt="" width="400" height="50"></div>
</div></td>
</tr>
<tr>
<td height="50" >
<div align="center"><a href="../Manager.jsp?action=Member"><font color="#FFFFFF"> 確 認 </font></a>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<% String edit=request.getParameter("edit");
String id=request.getParameter("id");
String grade="",grade1="";
if(edit.equals("ice"))
{
String sqledit="select * from tb_Account where ID='"+id+"'";
ResultSet rsedit=con.executeQuery(sqledit);
while(rsedit.next())
{
grade=rsedit.getString("Whether");
}
if(grade.equals("未凍結"))
{
String sqlwhether="update tb_Account set Whether='凍結' where ID='"+id+"'";
ResultSet rswhether=con.executeQuery(sqlwhether);
}
else if(grade.equals("凍結"))
{
String sqlwhether="update tb_Account set Whether='未凍結' where ID='"+id+"'";
ResultSet rswhether=con.executeQuery(sqlwhether);
}
}
else if(edit.equals("del"))
{
String sqldel="delete from tb_Account where ID='"+id+"'";
ResultSet rsdel=con.executeQuery(sqldel);
}
else if(edit.equals("grade"))
{
String sqlgrade="select * from tb_Account where ID='"+id+"'";
ResultSet rsgrade=con.executeQuery(sqlgrade);
while(rsgrade.next())
{
grade1=rsgrade.getString("Grade");
}
if(grade1.equals("高級會員"))
{
String sqlwhether="update tb_Account set Grade='普通會員' where ID='"+id+"'";
ResultSet rswhether=con.executeQuery(sqlwhether);
}
else if(grade1.equals("普通會員"))
{
String sqlwhether="update tb_Account set Grade='高級會員' where ID='"+id+"'";
ResultSet rswhether=con.executeQuery(sqlwhether);
}
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -