delete_3.jsp

来自「这是一个关于jsp的学习文档.为学习jsp的朋友提供方便」· JSP 代码 · 共 29 行

JSP
29
字号
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=GBK" %>
<%request.setCharacterEncoding("GBK");%>
<html>
	<head>
		<title>删除用户信息-Access 2000</title>
	</head>

	<body>
		<jsp:useBean id="delete" scope="page" class="access.access_dbconnect"/>
		<%
			String number=(String)session.getAttribute("usersno");
			ResultSet rs;
			String sql_1="select*from auser_info where sno='"+number+"'";
			rs=delete.executeQuery(sql_1);
			rs.next();
			String name=rs.getString("name");
			String sql="delete from auser_info where sno='"+number+"'";
			delete.executeUpdate(sql);
		%>
		<center><h2>删除用户信息</h2>
			<hr>
			<font color="blue"><%=name%></font>用户已经删除!
			<form action="index.html" method="post">
				<input type="submit" id="back" name="back" value="返回">
			</form>
		</center>
	</body>
</html>

⌨️ 快捷键说明

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