基本设置请参阅“JSP初学者数据库教程(一)查询数据”
数据删除
共有三个页面,del_1.jsp del_2.jsp del_3.jsp
del_1.jsp 代码
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<title>
删除信息——选择学号
</title>
</head>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=369";
String user="sa";
String pass="";
Connection conn=DriverManager.getConnection(url,user,pass);
Statement stmt=conn.createStatement();
%>
<center><h2 class="style3">修改学生信息</h2>
<br>
<form name="form1" method="post" action="del_2.jsp">
<p><span class="style4">请选择要删除的学号</span>
<select name="sno">
<%ResultSet rs=stmt.executeQuery("select * from tb_stu");
while(rs.next())
{
String sno=rs.getString("sno");
%>
<option value="<%=sno%>"><%=sno%></option>
<%}%>
</select>
</p>
<p>
<input type="submit" name="queding" value="确定">
<input type="button" name="back" value="返回"
onClick="javascript:history.go(-1)">
</p>
</form>
</center>
</body>
</html>
del_2.jsp 代码
<%@page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<title>删除记录——信息显示页面</title>
</head>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=369";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ;
String sno = request.getParameter("sno");
String sql = "select * from tb_stu where sno=" + sno;
ResultSet rs = stmt.executeQuery(sql);
%>
<center class="style1">
<span class="style2">确定要删除此学生的记录吗?</span>
<hr>
<form name="form1" method="post" action="del_3.jsp">
<div align="center">
<%
while (rs.next()) {
session.setAttribute("sno", rs.getString("sno"));
%>
</div>
<p align="center"> 姓名:
<%=rs.getString("name")%> </p>
<p align="center"> 年龄:
<%=rs.getString("age")%> </p>
<p align="center"> 学号:
<%=rs.getString("sno")%> </p>
<p align="center"> 密码:
<%=rs.getString("password")%> </p>
<div align="center">
<%
}
rs.close();
stmt.close();
conn.close();
%>
<input type="submit" name="queding" value="确定">
<input type="reset" name="back" value="返回" id="back">
</div>
</form>
</body>
</html>
del_3.jsp 代码
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<title> 删除信息-成功页面</title>
</head>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=369";
String user="sa";
String pass="";
Connection conn=DriverManager.getConnection(url,user,pass);
Statement stmt=conn.createStatement();
String sno=(String)session.getAttribute("sno");
String sql="delete from tb_stu where sno="+sno;
stmt.executeUpdate(sql);
stmt.close();
conn.close();
%>
<center><h2 class="style1">删除信息</h2>
<p><br>
<span class="style3">信息成功删除</span></p>
<form name="form1" method="post" action="del_1.jsp">
<input type="submit" id="back" name="back" value="返回">
</form>
<p>
</p>
</center>
</body>
</html>