Java web项目01 停车管理系统实现删除用户信息(六)

最新推荐文章于 2024-08-05 16:03:37 发布

凯耐

最新推荐文章于 2024-08-05 16:03:37 发布

阅读量4.6k

点赞数

本文链接：https://blog.csdn.net/weixin_36279318/article/details/78773770

版权

Java Web 专栏收录该内容

30 篇文章 9 订阅

订阅专栏

(一)显示所有用户信息界面

<%@include file="/common/sub_header.jsp"%>
<%@ page language="java"
    import="java.util.*,java.sql.*,com.wang.db.*"
    pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <base href="<%=basePath%>">

        <link rel="stylesheet" type="text/css" href="css/common.css" />
        <link rel="stylesheet" type="text/css" href="css/main.css" />
        <script type="text/javascript" src="js/libs/modernizr.min.js">
</script>
    </head>
    <body>
        <jsp:include page="/top.jsp"></jsp:include>
        <jsp:include page="/left.jsp"></jsp:include>
            <!--/sidebar-->
            <div class="main-wrap">

                <div class="crumb-wrap">
                    <div class="crumb-list">
                        <span class="crumb-name">管理员管理</span>
                    </div>
                </div>
                <div class="search-wrap">
                    <div class="search-content">
                        <form action="<%=path %>/admin/list.jsp" method="post">
                            <table class="search-tab">
                                <tr>

                                    <th width="150">
                                        请输入管理员名称:
                                    </th>
                                    <td>
                                        <input class="common-text" placeholder="关键字" name="queryName"
                                            value="" id="" type="text">
                                    </td>
                                    <td>
                                        <input class="btn btn-primary btn2" name="sub" value="查询"
                                            type="submit">
                                    </td>
                                </tr>
                            </table>
                        </form>
                    </div>
                </div>
                <div class="result-wrap">
                    <form name="myform" id="myform" method="post">
                        <div class="result-title">
                            <div class="result-list">
                                <a href="<%=path %>/admin/addAdmin.jsp"><i class="icon-font"></i>新增管理员</a>

                            </div>
                        </div>
                        <div class="result-content">
                            <table class="result-tab" width="100%">
                                <tr>


                                    <th>
                                        ID
                                    </th>
                                    <th>
                                        登录名
                                    </th>
                                    <th>
                                        密码
                                    </th>

                                    <th>
                                        操作
                                    </th>
                                </tr>
                                <%
                        DBManager dbm = new DBManager();
                        Connection conn = dbm.getConnection();
                        String queryName = request.getParameter("queryName");
                        String sql = "select * from admin";
                        if (queryName != null) {
                            sql = "select * from admin where userName like '%" + queryName
                                    + "%'";
                        }
                        PreparedStatement pstmt = conn.prepareStatement(sql);
                        ResultSet rs = pstmt.executeQuery();

                        while (rs.next()) {
                            String id = rs.getString("id");
                    %>
                                <tr>


                                    <td>
                                        <%=id%>
                                    </td>
                                    <td title="">
                                        <%=rs.getString("userName")%>
                                    </td>
                                    <td>
                                        <%=rs.getString("userPw")%>
                                    </td>

                                    <td>
                                        <a class="link-update" href="<%=path %>/admin/modAdmin.jsp?id=<%=id %>">修改</a>
                                        <a class="link-del" href="<%=path %>/DelAdminAction?id=<%=id %>">删除</a>
                                    </td>
                                </tr>
                                    <%
                        }
                        if (rs != null)
                            rs.close();
                        if (pstmt != null)
                            pstmt.close();
                        if (conn != null)
                            conn.close();
                    %> 
                            </table>
                            <div class="list-page">

                            </div>
                        </div>
                    </form>
                </div>
            </div>

    </body>
</html>

核心代码：

    <a class="link-del" href="<%=path %>/DelAdminAction?id=<%=id %>">删除</a>

(二)通过DelAdminAction类删除一条用户记录

package com.wang.action;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.wang.db.DBManager;

/**
 * 删除管理员
 *
 */
public class DelAdminAction extends HttpServlet {

    private static final long serialVersionUID = 1L;

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        String id = request.getParameter("id");

        DBManager dbm = new DBManager();
        //删除管理员
        String sql = "delete from admin where id="+id;

        Statement stat = null;
        Connection conn = null;
        try {
            conn = dbm.getConnection();
            stat = conn.createStatement();
            stat.execute(sql);

        } catch (SQLException e) {

            e.printStackTrace();
        } finally {
            try {
                if (stat != null)
                    stat.close();
                if (conn != null)
                    conn.close();
            } catch (SQLException e) {

                e.printStackTrace();
            }
        }
        //删除记录后，跳转到list.jsp页面
        response.sendRedirect("admin/list.jsp");
        out.flush();
        out.close();
    }

}