{"id":1285,"date":"2026-01-09T14:28:27","date_gmt":"2026-01-09T06:28:27","guid":{"rendered":"https:\/\/www.52runoob.com\/?p=1285"},"modified":"2026-01-09T14:28:27","modified_gmt":"2026-01-09T06:28:27","slug":"%e5%9f%ba%e4%ba%8ejavawebmysql%e7%9a%84jspservlet%e5%ae%bf%e8%88%8d%e7%ae%a1%e7%90%86%e7%b3%bb%e7%bb%9f%e8%b6%85%e7%ba%a7%e7%ae%a1%e7%90%86%e5%91%98%e3%80%81%e5%ae%bf%e8%88%8d%e7%ae%a1%e7%90%86","status":"publish","type":"post","link":"https:\/\/www.52runoob.com\/index.php\/2026\/01\/09\/%e5%9f%ba%e4%ba%8ejavawebmysql%e7%9a%84jspservlet%e5%ae%bf%e8%88%8d%e7%ae%a1%e7%90%86%e7%b3%bb%e7%bb%9f%e8%b6%85%e7%ba%a7%e7%ae%a1%e7%90%86%e5%91%98%e3%80%81%e5%ae%bf%e8%88%8d%e7%ae%a1%e7%90%86\/","title":{"rendered":"\u57fa\u4e8ejavaweb+mysql\u7684jsp+servlet\u5bbf\u820d\u7ba1\u7406\u7cfb\u7edf(\u8d85\u7ea7\u7ba1\u7406\u5458\u3001\u5bbf\u820d\u7ba1\u7406\u5458\u3001\u5b66\u751f)"},"content":{"rendered":"\n

\u4e0b\u9762\u7ed9\u4f60\u4e00\u5957**\u300c\u57fa\u4e8e JavaWeb + MySQL \u7684 JSP + Servlet \u5bbf\u820d\u7ba1\u7406\u7cfb\u7edf\u300d\u5b8c\u6574\u8bbe\u8ba1\u4e0e\u5b9e\u73b0\u65b9\u6848**\uff0c\u4e09\u89d2\u8272\u6743\u9650\u6e05\u6670<\/strong>\uff0c\u529f\u80fd\u5b8c\u6574<\/strong>\uff0c\u975e\u5e38\u9002\u5408\u8bfe\u7a0b\u8bbe\u8ba1 \/ \u5b9e\u8bad \/ \u7b54\u8fa9<\/strong>\u3002<\/p>\n\n\n\n

\n

\u8fd9\u662f\u8001\u5e08\u6700\u8ba4\u53ef\u7684 \u4f20\u7edf JavaWeb MVC \u67b6\u6784<\/strong>
\u6280\u672f\u6808\uff1aJSP + Servlet + JDBC + MySQL + Session + Filter<\/strong><\/p>\n<\/blockquote>\n\n\n\n

\n\n\n\n

\u4e00\u3001\u7cfb\u7edf\u89d2\u8272\u4e0e\u6743\u9650\u8bbe\u8ba1\uff08\u91cd\u70b9\uff09<\/h1>\n\n\n\n

1\ufe0f\u20e3 \u89d2\u8272\u5212\u5206<\/h2>\n\n\n\n
\u89d2\u8272<\/th>\u6743\u9650<\/th><\/tr><\/thead>
\u8d85\u7ea7\u7ba1\u7406\u5458<\/td>\u7ba1\u7406\u5bbf\u820d\u7ba1\u7406\u5458\u3001\u697c\u680b\u3001\u5bbf\u820d\u3001\u5b66\u751f<\/td><\/tr>
\u5bbf\u820d\u7ba1\u7406\u5458<\/td>\u7ba1\u7406\u5b66\u751f\u3001\u5bbf\u820d\u3001\u536b\u751f\u3001\u62a5\u4fee<\/td><\/tr>
\u5b66\u751f<\/td>\u67e5\u770b\u4e2a\u4eba\u4fe1\u606f\u3001\u5bbf\u820d\u4fe1\u606f\u3001\u62a5\u4fee<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

2\ufe0f\u20e3 \u529f\u80fd\u6a21\u5757\u603b\u89c8<\/h2>\n\n\n\n

\ud83d\udd11 \u516c\u5171\u6a21\u5757<\/h3>\n\n\n\n
    \n
  • \u767b\u5f55 \/ \u9000\u51fa<\/li>\n\n\n\n
  • \u6743\u9650\u63a7\u5236\uff08Filter\uff09<\/li>\n<\/ul>\n\n\n\n

    \ud83d\udc51 \u8d85\u7ea7\u7ba1\u7406\u5458<\/h3>\n\n\n\n
      \n
    • \u5bbf\u820d\u7ba1\u7406\u5458 CRUD<\/li>\n\n\n\n
    • \u697c\u680b\u7ba1\u7406<\/li>\n\n\n\n
    • \u5bbf\u820d\u7ba1\u7406<\/li>\n\n\n\n
    • \u5b66\u751f\u4fe1\u606f\u7ba1\u7406<\/li>\n<\/ul>\n\n\n\n

      \ud83c\udfe0 \u5bbf\u820d\u7ba1\u7406\u5458<\/h3>\n\n\n\n
        \n
      • \u5b66\u751f\u5165\u4f4f \/ \u8fc1\u51fa<\/li>\n\n\n\n
      • \u536b\u751f\u68c0\u67e5\u8bb0\u5f55<\/li>\n\n\n\n
      • \u62a5\u4fee\u5904\u7406<\/li>\n<\/ul>\n\n\n\n

        \ud83c\udf93 \u5b66\u751f<\/h3>\n\n\n\n
          \n
        • \u67e5\u770b\u4e2a\u4eba\u4fe1\u606f<\/li>\n\n\n\n
        • \u67e5\u770b\u5bbf\u820d\u4fe1\u606f<\/li>\n\n\n\n
        • \u63d0\u4ea4\u62a5\u4fee\u7533\u8bf7<\/li>\n<\/ul>\n\n\n\n
          \n\n\n\n

          \u4e8c\u3001\u7cfb\u7edf\u6574\u4f53\u67b6\u6784\uff08MVC\uff09<\/h1>\n\n\n
          \nJSP (View)\n  \u2193\nServlet (Controller)\n  \u2193\nDAO (Model)\n  \u2193\nMySQL\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u4e09\u3001\u9879\u76ee\u7ed3\u6784\uff08\u6807\u51c6\u7b54\u8fa9\u7ed3\u6784\uff09<\/h1>\n\n\n
          \nDormitorySystem\/\n\u2502\n\u251c\u2500\u2500 src\/\n\u2502   \u251c\u2500\u2500 entity\/\n\u2502   \u2502   \u251c\u2500\u2500 User.java\n\u2502   \u2502   \u251c\u2500\u2500 Dorm.java\n\u2502   \u2502   \u251c\u2500\u2500 Building.java\n\u2502   \u2502   \u2514\u2500\u2500 Repair.java\n\u2502   \u2502\n\u2502   \u251c\u2500\u2500 dao\/\n\u2502   \u2502   \u251c\u2500\u2500 UserDao.java\n\u2502   \u2502   \u251c\u2500\u2500 DormDao.java\n\u2502   \u2502   \u2514\u2500\u2500 RepairDao.java\n\u2502   \u2502\n\u2502   \u251c\u2500\u2500 servlet\/\n\u2502   \u2502   \u251c\u2500\u2500 LoginServlet.java\n\u2502   \u2502   \u251c\u2500\u2500 LogoutServlet.java\n\u2502   \u2502   \u251c\u2500\u2500 AdminServlet.java\n\u2502   \u2502   \u251c\u2500\u2500 DormManagerServlet.java\n\u2502   \u2502   \u2514\u2500\u2500 StudentServlet.java\n\u2502   \u2502\n\u2502   \u251c\u2500\u2500 filter\/\n\u2502   \u2502   \u2514\u2500\u2500 AuthFilter.java\n\u2502   \u2502\n\u2502   \u2514\u2500\u2500 util\/\n\u2502       \u2514\u2500\u2500 DBUtil.java\n\u2502\n\u251c\u2500\u2500 WebContent\/\n\u2502   \u251c\u2500\u2500 admin\/\n\u2502   \u251c\u2500\u2500 manager\/\n\u2502   \u251c\u2500\u2500 student\/\n\u2502   \u251c\u2500\u2500 login.jsp\n\u2502   \u2514\u2500\u2500 index.jsp\n\u2502\n\u2514\u2500\u2500 web.xml\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u56db\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\uff08MySQL\uff09<\/h1>\n\n\n\n
          1\ufe0f\u20e3 \u7528\u6237\u8868\uff08\u4e09\u89d2\u8272\uff09<\/h2>\n\n\n
          \nCREATE TABLE user (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  username VARCHAR(50),\n  password VARCHAR(50),\n  role INT COMMENT '0\u8d85\u7ea7\u7ba1\u7406\u5458 1\u5bbf\u820d\u7ba1\u7406\u5458 2\u5b66\u751f'\n);\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          2\ufe0f\u20e3 \u697c\u680b\u8868<\/h2>\n\n\n
          \nCREATE TABLE building (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  name VARCHAR(50)\n);\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          3\ufe0f\u20e3 \u5bbf\u820d\u8868<\/h2>\n\n\n
          \nCREATE TABLE dorm (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  building_id INT,\n  dorm_no VARCHAR(20),\n  capacity INT,\n  current_num INT\n);\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          4\ufe0f\u20e3 \u5b66\u751f\u4fe1\u606f\u8868<\/h2>\n\n\n
          \nCREATE TABLE student (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  user_id INT,\n  dorm_id INT,\n  name VARCHAR(50),\n  gender VARCHAR(10)\n);\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          5\ufe0f\u20e3 \u62a5\u4fee\u8868<\/h2>\n\n\n
          \nCREATE TABLE repair (\n  id INT PRIMARY KEY AUTO_INCREMENT,\n  student_id INT,\n  content VARCHAR(200),\n  status VARCHAR(20)\n);\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u4e94\u3001\u6570\u636e\u5e93\u5de5\u5177\u7c7b\uff08DBUtil\uff09<\/h1>\n\n\n
          \npublic class DBUtil {\n    private static final String URL =\n      "jdbc:mysql:\/\/localhost:3306\/dormitory?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
          \u516d\u3001\u5b9e\u4f53\u7c7b\u793a\u4f8b\uff08User\uff09<\/h1>\n\n\n
          \npublic class User {\n    private int id;\n    private String username;\n    private String password;\n    private int role; \/\/ 0 admin 1 manager 2 student\n    \/\/ getter \/ setter\n}\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u4e03\u3001\u767b\u5f55\u6a21\u5757\uff08\u6838\u5fc3\uff09<\/h1>\n\n\n\n
          LoginServlet<\/h2>\n\n\n
          \n@WebServlet("\/LoginServlet")\npublic class LoginServlet extends HttpServlet {\n    protected void doPost(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException {\n        String u = req.getParameter("username");\n        String p = req.getParameter("password");\n\n        User user = new UserDao().login(u, p);\n        if (user != null) {\n            req.getSession().setAttribute("user", user);\n            if (user.getRole() == 0) resp.sendRedirect("admin\/index.jsp");\n            else if (user.getRole() == 1) resp.sendRedirect("manager\/index.jsp");\n            else resp.sendRedirect("student\/index.jsp");\n        } else {\n            resp.getWriter().write("\u767b\u5f55\u5931\u8d25");\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u516b\u3001\u6743\u9650\u8fc7\u6ee4\u5668\uff08Filter\uff0c\u52a0\u5206\u9879\uff09<\/h1>\n\n\n
          \n@WebFilter("\/*")\npublic class AuthFilter implements Filter {\n    public void doFilter(ServletRequest req, ServletResponse res, FilterChain chain)\n            throws IOException, ServletException {\n\n        HttpServletRequest request = (HttpServletRequest) req;\n        HttpSession session = request.getSession();\n        String uri = request.getRequestURI();\n\n        if (uri.contains("login.jsp") || uri.contains("LoginServlet")) {\n            chain.doFilter(req, res);\n            return;\n        }\n\n        if (session.getAttribute("user") == null) {\n            request.getRequestDispatcher("login.jsp").forward(req, res);\n            return;\n        }\n        chain.doFilter(req, res);\n    }\n}\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u4e5d\u3001\u793a\u4f8b\u529f\u80fd\uff1a\u5b66\u751f\u62a5\u4fee<\/h1>\n\n\n\n
          RepairServlet\uff08\u5b66\u751f\uff09<\/h2>\n\n\n
          \n@WebServlet("\/StudentRepairServlet")\npublic class StudentRepairServlet extends HttpServlet {\n    protected void doPost(HttpServletRequest req, HttpServletResponse resp)\n            throws IOException {\n        int studentId = Integer.parseInt(req.getParameter("studentId"));\n        String content = req.getParameter("content");\n\n        new RepairDao().add(studentId, content);\n        resp.sendRedirect("student\/repair.jsp");\n    }\n}\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u5341\u3001JSP \u793a\u4f8b\uff08\u5b66\u751f\u9996\u9875\uff09<\/h1>\n\n\n
          \n&lt;h2>\u5b66\u751f\u5bbf\u820d\u7ba1\u7406\u7cfb\u7edf&lt;\/h2>\n&lt;p>\u6b22\u8fce\uff1a${sessionScope.user.username}&lt;\/p>\n&lt;a href="repair.jsp">\u63d0\u4ea4\u62a5\u4fee&lt;\/a>\n\n<\/pre><\/div>\n\n\n
          \n\n\n\n
          \u5341\u4e00\u3001\u7cfb\u7edf\u8fd0\u884c\u6d41\u7a0b\uff08\u7b54\u8fa9\u5fc5\u80cc\uff09<\/h1>\n\n\n\n
          1\ufe0f\u20e3 \u7528\u6237\u767b\u5f55
          2\ufe0f\u20e3 Session \u4fdd\u5b58\u7528\u6237\u4fe1\u606f
          3\ufe0f\u20e3 Filter \u63a7\u5236\u8bbf\u95ee\u6743\u9650
          4\ufe0f\u20e3 Servlet \u5904\u7406\u4e1a\u52a1\u903b\u8f91
          5\ufe0f\u20e3 DAO \u64cd\u4f5c MySQL
          6\ufe0f\u20e3 JSP \u5c55\u793a\u6570\u636e<\/p>\n\n\n\n
          \n\n\n\n
          \u5341\u4e8c\u3001\u8bfe\u7a0b\u8bbe\u8ba1\u52a0\u5206\u5efa\u8bae\uff08\u975e\u5e38\u91cd\u8981\uff09<\/h1>\n\n\n\n
          \u2705 \u4e09\u89d2\u8272\u6743\u9650\u63a7\u5236
          \u2705 Filter \u767b\u5f55\u62e6\u622a
          \u2705 MVC \u5206\u5c42\u6e05\u6670
          \u2705 \u6570\u636e\u5e93\u8bbe\u8ba1\u89c4\u8303
          \u2705 \u529f\u80fd\u5b8c\u6574\u53ef\u6f14\u793a<\/p>\n\n\n\n
          \n\n\n\n
          \u5341\u4e09\u3001\u6211\u53ef\u4ee5\u7ee7\u7eed\u5e2e\u4f60\u505a\u5230\u4ec0\u4e48\u7a0b\u5ea6\uff1f<\/h1>\n\n\n\n
          \u6211\u53ef\u4ee5\ud83d\udc47
          \u2714 \u8865\u5168\u6240\u6709 CRUD Servlet + JSP \u9875\u9762<\/strong>
          \u2714 \u9875\u9762\u7f8e\u5316\uff08\u540e\u53f0\u7ba1\u7406\u98ce\u683c\uff09<\/strong>
          \u2714 \u5199\u5b8c\u6574\u8bfe\u7a0b\u8bbe\u8ba1\u62a5\u544a\uff081\uff5e1.2 \u4e07\u5b57\uff09<\/strong>
          \u2714 \u753b\u7cfb\u7edf\u7ed3\u6784\u56fe + \u6d41\u7a0b\u56fe<\/strong>
          \u2714 \u6253\u5305\u6210\u53ef\u76f4\u63a5\u8fd0\u884c\u9879\u76ee<\/strong><\/p>\n\n\n\n
          <\/p>\n","protected":false},"excerpt":{"rendered":"
          \u4e0b\u9762\u7ed9\u4f60\u4e00\u5957**\u300c\u57fa\u4e8e JavaWeb + MySQL \u7684 JSP + Serv… 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-1285","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\/1285","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=1285"}],"version-history":[{"count":1,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/posts\/1285\/revisions"}],"predecessor-version":[{"id":1286,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/posts\/1285\/revisions\/1286"}],"wp:attachment":[{"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/media?parent=1285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/categories?post=1285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52runoob.com\/index.php\/wp-json\/wp\/v2\/tags?post=1285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}