{"id":1283,"date":"2026-01-09T14:27:04","date_gmt":"2026-01-09T06:27:04","guid":{"rendered":"https:\/\/www.52runoob.com\/?p=1283"},"modified":"2026-01-09T14:27:04","modified_gmt":"2026-01-09T06:27:04","slug":"jsp%e7%99%bb%e5%bd%95%e6%b3%a8%e5%86%8c%e5%ae%8c%e6%95%b4%e5%ae%9e%e7%8e%b0%e4%bb%a3%e7%a0%81%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%e7%bd%91%e9%a1%b5%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.52runoob.com\/index.php\/2026\/01\/09\/jsp%e7%99%bb%e5%bd%95%e6%b3%a8%e5%86%8c%e5%ae%8c%e6%95%b4%e5%ae%9e%e7%8e%b0%e4%bb%a3%e7%a0%81%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%e7%bd%91%e9%a1%b5%e6%95%b0%e6%8d%ae%e5%ba%93\/","title":{"rendered":"jsp\u767b\u5f55\u6ce8\u518c\u5b8c\u6574\u5b9e\u73b0\u4ee3\u7801(\u589e\u5220\u6539\u67e5+\u7f51\u9875+\u6570\u636e\u5e93)"},"content":{"rendered":"\n

\u4e0b\u9762\u7ed9\u4f60\u4e00\u5957**\u300cJSP + Servlet + MySQL \u767b\u5f55\u6ce8\u518c\u7cfb\u7edf\u3010\u5b8c\u6574 CRUD\uff08\u589e\u5220\u6539\u67e5\uff09\u3011\u5b9e\u73b0\u4ee3\u7801\u300d\uff0c\u8fd9\u662f<\/strong>\u8bfe\u7a0b\u8bbe\u8ba1 \/ \u5b9e\u8bad \/ \u6bd5\u8bbe\u5c0f\u9879\u76ee\u7ea7\u522b**\uff0c\u80fd\u76f4\u63a5\u8dd1\u3001\u80fd\u622a\u56fe\u3001\u80fd\u7b54\u8fa9<\/strong>\u7684\u90a3\u79cd\u3002<\/p>\n\n\n\n

\n

\u6280\u672f\u6808\uff1a
JSP + Servlet + JDBC + MySQL + Session\uff08MVC \u601d\u60f3\uff09<\/strong><\/p>\n<\/blockquote>\n\n\n\n

\n\n\n\n

\u4e00\u3001\u7cfb\u7edf\u529f\u80fd\u603b\u89c8\uff08\u8001\u5e08\u6700\u5173\u5fc3\uff09<\/h1>\n\n\n\n

\u2714 \u7528\u6237\u6ce8\u518c\uff08Create\uff09
\u2714 \u7528\u6237\u767b\u5f55
\u2714 \u7528\u6237\u5217\u8868\u67e5\u8be2\uff08Read\uff09
\u2714 \u4fee\u6539\u7528\u6237\u4fe1\u606f\uff08Update\uff09
\u2714 \u5220\u9664\u7528\u6237\uff08Delete\uff09
\u2714 Session \u767b\u5f55\u63a7\u5236
\u2714 \u6570\u636e\u5e93\u5b58\u50a8<\/p>\n\n\n\n

\n\n\n\n

\u4e8c\u3001\u9879\u76ee\u7ed3\u6784\uff08\u6807\u51c6 MVC\uff09<\/h1>\n\n\n
\njsp-crud\/\n\u2502\n\u251c\u2500\u2500 src\/\n\u2502   \u251c\u2500\u2500 entity\/\n\u2502   \u2502   \u2514\u2500\u2500 User.java\n\u2502   \u251c\u2500\u2500 util\/\n\u2502   \u2502   \u2514\u2500\u2500 DBUtil.java\n\u2502   \u251c\u2500\u2500 dao\/\n\u2502   \u2502   \u2514\u2500\u2500 UserDao.java\n\u2502   \u251c\u2500\u2500 servlet\/\n\u2502   \u2502   \u251c\u2500\u2500 LoginServlet.java\n\u2502   \u2502   \u251c\u2500\u2500 RegisterServlet.java\n\u2502   \u2502   \u251c\u2500\u2500 UserListServlet.java\n\u2502   \u2502   \u251c\u2500\u2500 UserEditServlet.java\n\u2502   \u2502   \u2514\u2500\u2500 UserDeleteServlet.java\n\u2502\n\u251c\u2500\u2500 WebContent\/\n\u2502   \u251c\u2500\u2500 login.jsp\n\u2502   \u251c\u2500\u2500 register.jsp\n\u2502   \u251c\u2500\u2500 userList.jsp\n\u2502   \u251c\u2500\u2500 userEdit.jsp\n\u2502   \u2514\u2500\u2500 success.jsp\n\u2502\n\u2514\u2500\u2500 web.xml\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u4e09\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\uff08MySQL\uff09<\/h1>\n\n\n
\nCREATE DATABASE jsp_crud DEFAULT CHARSET utf8;\n\nUSE jsp_crud;\n\nCREATE TABLE user (\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    username VARCHAR(50) UNIQUE NOT NULL,\n    password VARCHAR(50) NOT NULL\n);\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u56db\u3001\u6570\u636e\u5e93\u5de5\u5177\u7c7b\uff08DBUtil\uff09<\/h1>\n\n\n
\npackage util;\n\nimport java.sql.*;\n\npublic class DBUtil {\n    private static final String URL =\n        "jdbc:mysql:\/\/localhost:3306\/jsp_crud?useUnicode=true&amp;characterEncoding=utf8";\n    private static final String USER = "root";\n    private static final String PASSWORD = "123456";\n\n    static {\n        try {\n            Class.forName("com.mysql.cj.jdbc.Driver");\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n\n    public static Connection getConnection() throws SQLException {\n        return DriverManager.getConnection(URL, USER, PASSWORD);\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u4e94\u3001\u5b9e\u4f53\u7c7b\uff08User.java\uff09<\/h1>\n\n\n
\npackage entity;\n\npublic class User {\n    private int id;\n    private String username;\n    private String password;\n\n    public User() {}\n\n    public User(int id, String username, String password) {\n        this.id = id;\n        this.username = username;\n        this.password = password;\n    }\n\n    \/\/ getter \/ setter\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u516d\u3001DAO \u5c42\uff08\u6838\u5fc3 CRUD\uff09<\/h1>\n\n\n
\npackage dao;\n\nimport entity.User;\nimport util.DBUtil;\n\nimport java.sql.*;\nimport java.util.*;\n\npublic class UserDao {\n\n    \/\/ \u6ce8\u518c\uff08\u589e\uff09\n    public void addUser(User user) throws Exception {\n        String sql = "INSERT INTO user(username,password) VALUES(?,?)";\n        try (Connection c = DBUtil.getConnection();\n             PreparedStatement ps = c.prepareStatement(sql)) {\n            ps.setString(1, user.getUsername());\n            ps.setString(2, user.getPassword());\n            ps.executeUpdate();\n        }\n    }\n\n    \/\/ \u767b\u5f55\uff08\u67e5\uff09\n    public User login(String username, String password) throws Exception {\n        String sql = "SELECT * FROM user WHERE username=? AND password=?";\n        try (Connection c = DBUtil.getConnection();\n             PreparedStatement ps = c.prepareStatement(sql)) {\n            ps.setString(1, username);\n            ps.setString(2, password);\n            ResultSet rs = ps.executeQuery();\n            if (rs.next()) {\n                return new User(\n                    rs.getInt("id"),\n                    rs.getString("username"),\n                    rs.getString("password")\n                );\n            }\n        }\n        return null;\n    }\n\n    \/\/ \u67e5\u8be2\u5168\u90e8\uff08\u67e5\uff09\n    public List&lt;User> findAll() throws Exception {\n        List&lt;User> list = new ArrayList&lt;>();\n        String sql = "SELECT * FROM user";\n        try (Connection c = DBUtil.getConnection();\n             Statement s = c.createStatement();\n             ResultSet rs = s.executeQuery(sql)) {\n            while (rs.next()) {\n                list.add(new User(\n                    rs.getInt("id"),\n                    rs.getString("username"),\n                    rs.getString("password")\n                ));\n            }\n        }\n        return list;\n    }\n\n    \/\/ \u6839\u636e ID \u67e5\u8be2\n    public User findById(int id) throws Exception {\n        String sql = "SELECT * FROM user WHERE id=?";\n        try (Connection c = DBUtil.getConnection();\n             PreparedStatement ps = c.prepareStatement(sql)) {\n            ps.setInt(1, id);\n            ResultSet rs = ps.executeQuery();\n            if (rs.next()) {\n                return new User(\n                    rs.getInt("id"),\n                    rs.getString("username"),\n                    rs.getString("password")\n                );\n            }\n        }\n        return null;\n    }\n\n    \/\/ \u4fee\u6539\uff08\u6539\uff09\n    public void update(User user) throws Exception {\n        String sql = "UPDATE user SET username=?,password=? WHERE id=?";\n        try (Connection c = DBUtil.getConnection();\n             PreparedStatement ps = c.prepareStatement(sql)) {\n            ps.setString(1, user.getUsername());\n            ps.setString(2, user.getPassword());\n            ps.setInt(3, user.getId());\n            ps.executeUpdate();\n        }\n    }\n\n    \/\/ \u5220\u9664\uff08\u5220\uff09\n    public void delete(int id) throws Exception {\n        String sql = "DELETE FROM user WHERE id=?";\n        try (Connection c = DBUtil.getConnection();\n             PreparedStatement ps = c.prepareStatement(sql)) {\n            ps.setInt(1, id);\n            ps.executeUpdate();\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u4e03\u3001Servlet \u5c42\uff08\u63a7\u5236\u5668\uff09<\/h1>\n\n\n\n
1\ufe0f\u20e3 \u6ce8\u518c<\/h2>\n\n\n
\n@WebServlet("\/RegisterServlet")\npublic class RegisterServlet extends HttpServlet {\n    protected void doPost(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException {\n        try {\n            UserDao dao = new UserDao();\n            User user = new User();\n            user.setUsername(req.getParameter("username"));\n            user.setPassword(req.getParameter("password"));\n            dao.addUser(user);\n            resp.sendRedirect("login.jsp");\n        } catch (Exception e) {\n            resp.getWriter().write("\u6ce8\u518c\u5931\u8d25");\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
2\ufe0f\u20e3 \u767b\u5f55<\/h2>\n\n\n
\n@WebServlet("\/LoginServlet")\npublic class LoginServlet extends HttpServlet {\n    protected void doPost(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException {\n        try {\n            UserDao dao = new UserDao();\n            User user = dao.login(\n                req.getParameter("username"),\n                req.getParameter("password")\n            );\n            if (user != null) {\n                req.getSession().setAttribute("user", user);\n                resp.sendRedirect("UserListServlet");\n            } else {\n                resp.getWriter().write("\u767b\u5f55\u5931\u8d25");\n            }\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
3\ufe0f\u20e3 \u7528\u6237\u5217\u8868\uff08\u67e5\uff09<\/h2>\n\n\n
\n@WebServlet("\/UserListServlet")\npublic class UserListServlet extends HttpServlet {\n    protected void doGet(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException, ServletException {\n        try {\n            UserDao dao = new UserDao();\n            req.setAttribute("list", dao.findAll());\n            req.getRequestDispatcher("userList.jsp").forward(req, resp);\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
4\ufe0f\u20e3 \u5220\u9664<\/h2>\n\n\n
\n@WebServlet("\/UserDeleteServlet")\npublic class UserDeleteServlet extends HttpServlet {\n    protected void doGet(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException {\n        try {\n            new UserDao().delete(\n                Integer.parseInt(req.getParameter("id"))\n            );\n            resp.sendRedirect("UserListServlet");\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
5\ufe0f\u20e3 \u4fee\u6539\uff08\u67e5 + \u6539\uff09<\/h2>\n\n\n
\n@WebServlet("\/UserEditServlet")\npublic class UserEditServlet extends HttpServlet {\n\n    protected void doGet(HttpServletRequest req, HttpServletResponse resp)\n            throws ServletException, IOException {\n        try {\n            User user = new UserDao()\n                .findById(Integer.parseInt(req.getParameter("id")));\n            req.setAttribute("user", user);\n            req.getRequestDispatcher("userEdit.jsp").forward(req, resp);\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n\n    protected void doPost(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException {\n        try {\n            User user = new User(\n                Integer.parseInt(req.getParameter("id")),\n                req.getParameter("username"),\n                req.getParameter("password")\n            );\n            new UserDao().update(user);\n            resp.sendRedirect("UserListServlet");\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u516b\u3001JSP \u9875\u9762<\/h1>\n\n\n\n
\u767b\u5f55\uff08login.jsp\uff09<\/h2>\n\n\n
\n&lt;form action="LoginServlet" method="post">\n\u7528\u6237\u540d\uff1a&lt;input name="username">&lt;br>\n\u5bc6\u7801\uff1a&lt;input type="password" name="password">&lt;br>\n&lt;button>\u767b\u5f55&lt;\/button>\n&lt;\/form>\n&lt;a href="register.jsp">\u6ce8\u518c&lt;\/a>\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u6ce8\u518c\uff08register.jsp\uff09<\/h2>\n\n\n
\n&lt;form action="RegisterServlet" method="post">\n\u7528\u6237\u540d\uff1a&lt;input name="username">&lt;br>\n\u5bc6\u7801\uff1a&lt;input type="password" name="password">&lt;br>\n&lt;button>\u6ce8\u518c&lt;\/button>\n&lt;\/form>\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u7528\u6237\u5217\u8868\uff08userList.jsp\uff09<\/h2>\n\n\n
\n&lt;%@ page import="java.util.*,entity.User" %>\n&lt;table border="1">\n&lt;tr>&lt;th>ID&lt;\/th>&lt;th>\u7528\u6237\u540d&lt;\/th>&lt;th>\u64cd\u4f5c&lt;\/th>&lt;\/tr>\n&lt;%\nfor(User u : (List&lt;User>)request.getAttribute("list")){\n%>\n&lt;tr>\n&lt;td>&lt;%=u.getId()%>&lt;\/td>\n&lt;td>&lt;%=u.getUsername()%>&lt;\/td>\n&lt;td>\n&lt;a href="UserEditServlet?id=&lt;%=u.getId()%>">\u7f16\u8f91&lt;\/a>\n&lt;a href="UserDeleteServlet?id=&lt;%=u.getId()%>">\u5220\u9664&lt;\/a>\n&lt;\/td>\n&lt;\/tr>\n&lt;% } %>\n&lt;\/table>\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u4fee\u6539\uff08userEdit.jsp\uff09<\/h2>\n\n\n
\n&lt;%@ page import="entity.User" %>\n&lt;%\nUser u = (User)request.getAttribute("user");\n%>\n&lt;form action="UserEditServlet" method="post">\n&lt;input type="hidden" name="id" value="&lt;%=u.getId()%>">\n\u7528\u6237\u540d\uff1a&lt;input name="username" value="&lt;%=u.getUsername()%>">&lt;br>\n\u5bc6\u7801\uff1a&lt;input name="password" value="&lt;%=u.getPassword()%>">&lt;br>\n&lt;button>\u4fdd\u5b58&lt;\/button>\n&lt;\/form>\n\n<\/pre><\/div>\n\n\n
\n\n\n\n
\u4e5d\u3001\u5b8c\u6574\u6d41\u7a0b\uff08\u7b54\u8fa9\u76f4\u63a5\u80cc\uff09<\/h1>\n\n\n\n
1\ufe0f\u20e3 JSP \u63d0\u4f9b\u754c\u9762
2\ufe0f\u20e3 Servlet \u63a5\u6536\u8bf7\u6c42
3\ufe0f\u20e3 DAO \u64cd\u4f5c MySQL
4\ufe0f\u20e3 ResultSet \u2192 Java \u5bf9\u8c61
5\ufe0f\u20e3 JSP \u5c55\u793a\u6570\u636e
6\ufe0f\u20e3 Session \u7ba1\u7406\u767b\u5f55\u72b6\u6001<\/p>\n\n\n\n
\n\n\n\n
\u5341\u3001\u5982\u679c\u4f60\u8981\u300c\u76f4\u63a5\u4ea4\u4f5c\u4e1a\u300d<\/h1>\n\n\n\n
\u6211\u53ef\u4ee5\u5e2e\u4f60\ud83d\udc47
\u2714 \u5347\u7ea7\u6210 JSTL + EL\uff08\u53bb Scriptlet\uff09<\/strong>
\u2714 \u52a0\u52a8\u6001\u80cc\u666f + \u7f8e\u5316\u9875\u9762<\/strong>
\u2714 \u5199\u8bfe\u7a0b\u8bbe\u8ba1\u62a5\u544a\uff088000 \u5b57\uff09<\/strong>
\u2714 \u6253\u5305 IDEA \/ Eclipse \u9879\u76ee<\/strong>
\u2714 \u52a0\u767b\u5f55\u62e6\u622a\u5668 Filter<\/strong><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e0b\u9762\u7ed9\u4f60\u4e00\u5957**\u300cJSP + Servlet + MySQL \u767b\u5f55\u6ce8\u518c\u7cfb\u7edf\u3010\u5b8c\u6574… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-1283","post","type-post","status-publish","format-standard","hentry","category-jsp"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/posts\/1283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/comments?post=1283"}],"version-history":[{"count":1,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/posts\/1283\/revisions"}],"predecessor-version":[{"id":1284,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/posts\/1283\/revisions\/1284"}],"wp:attachment":[{"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/media?parent=1283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/categories?post=1283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/tags?post=1283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}