jsp数据库基础之--从MySQL数据库中删除数据

左手的ㄟ右手 2022-09-25 08:26 48阅读 0赞

项目地址：https://gitee.com/martinHuang/jsp-basic/

jsp数据库基础讲了增、查，下面来说说删，删应该是常用的数据库基础，增删改查中最最简单的了。不多说，马上开始

1、在FormAction文件夹下新建delete.jsp文件

![20160817172720223][]

2、在delete.jsp文件中添加如下内容

<%@ page language="java" contentType="text/html; charset=utf-8"
        pageEncoding="utf-8"%>
    <%@ page import="com.Database.*" %>
    <%@ page import="java.sql.*" %>
    <%
       request.setCharacterEncoding("utf-8");
       String id = request.getParameter("id");
       conDB db = new conDB();
       db.connectDB();
       Statement state = db.getConnection().createStatement();
       String sql = "delete from personinfo where id = "+id;
       int flag= state.executeUpdate(sql);
       if(flag > 0)
       {
    	   out.println("<script>alert('删除成功！');history.go(-1)</script>");
       }
       else
       {
    	   out.println("<script>alert('删除失败！');history.go(-1)</script>");
       }
       state.close();
    %>

![20160817172917005][]  
3、在WebContent文件夹下新建removeData.html文件

![20160817172905195][]

4、在removeData.html文件中添加如下内容

<!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>通过表单删除数据</title>
    </head>
    <body>
       <form action="FormAction/delete.jsp" method="post">
           <input type="text" name="id" placeholder="请输入要删除的ID">
           <input type="submit" value="确定">
       </form>
    </body>
    </html>

![20160817173004478][]

5、测试运行

![20160817173021725][]

我输入4

数据库删除前状态

![20160817173044647][]

点击确定

![20160817173106339][]

再次查看数据库

![20160817173144996][]

OK~

核心部分的方法跟上篇插入的差不多，具体可参考

http://blog.csdn.net/mgsky1/article/details/52232174

[20160817172720223]: /images/20220718/0d3b20e0400d4841bec0d2f1257c9fe1.png
[20160817172917005]: /images/20220718/4b07d98cf8b34cec83a450ebb3bc5d44.png
[20160817172905195]: /images/20220718/dd92b5663d6e424eb5d753163b66566b.png
[20160817173004478]: /images/20220718/da9cb9ec31814819a076410740ae19eb.png
[20160817173021725]: /images/20220718/0f59def0db954ef28385e107e2c9045e.png
[20160817173044647]: /images/20220718/706992e0ea2e4aa38a4218831cecddfa.png
[20160817173106339]: /images/20220718/76fa7ab339ef4a189d37f560c66d0783.png
[20160817173144996]: /images/20220718/affab8852769407f87e5a79cbbdfae89.png