JSP初学者数据库教程(二)删除数据

基本设置请参阅“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="确定">
  &nbsp;
  <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="确定">
              &nbsp;
              <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>&nbsp;
  </p>
</center>
</body>
</html>

 



评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值