{"id":2644,"date":"2022-12-19T19:24:52","date_gmt":"2022-12-19T11:24:52","guid":{"rendered":"https:\/\/qaqaq.top\/?p=2644"},"modified":"2022-12-19T20:51:15","modified_gmt":"2022-12-19T12:51:15","slug":"%e4%b9%a6%e5%9f%8e%e9%a1%b9%e7%9b%ae-%e4%bd%bf%e7%94%a8filter%e8%bf%87%e6%bb%a4%e5%99%a8%e5%ae%9e%e7%8e%b0%e5%90%8e%e5%8f%b0%e7%9a%84%e6%9d%83%e9%99%90%e7%ae%a1%e7%90%86%e3%80%81%e4%b9%a6%e5%9f%8e","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=2644","title":{"rendered":"\u4e66\u57ce\u9879\u76ee-\u7b2c\u516b\u9636\u6bb5 \u5b9e\u73b0\u540e\u53f0\u6743\u9650\u7ba1\u7406\u3001\u4e8b\u52a1\u7ba1\u7406\u3001\u5c55\u793a\u53cb\u597d\u7684\u9519\u8bef\u9875\u9762"},"content":{"rendered":"\n<p>\u4e66\u57ce\u9879\u76ee-\u4f7f\u7528Filter\u8fc7\u6ee4\u5668\u5b9e\u73b0\u540e\u53f0\u7684\u6743\u9650\u7ba1\u7406\u3001\u4e66\u57ce\u9879\u76ee-ThreadLocal\u4f7f\u7528\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-\u4f7f\u7528ThreadLocal\u786e\u4fdd\u6240\u6709\u64cd\u4f5c\u90fd\u4f7f\u7528\u540c\u4e00\u4e2aConnection\u6765\u5b9e\u73b0\u4e8b\u52a1\u7ba1\u7406\u3001\u4e66\u57ce\u9879\u76ee-\u4f7f\u7528Filter\u7edf\u4e00\u7ed9\u6240\u6709Service\u65b9\u6cd5\u90fd\u52a0\u4e0atry-catch\u6765\u7ba1\u7406\u4e8b\u52a1\u3001\u4e66\u57ce\u9879\u76ee-\u4f7f\u7528Tomcat\u7edf\u4e00\u7ba1\u7406\u5f02\u5e38\uff0c\u5c55\u793a\u53cb\u597d\u7684\u9519\u8bef\u9875\u9762<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">\u4e66\u57ce\u7b2c\u516b\u9636\u6bb5\uff1a<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">1\u3001\u4f7f\u7528 Filter \u8fc7\u6ee4\u5668\u62e6\u622a\/pages\/manager\/\u6240\u6709\u5185\u5bb9\uff0c\u5b9e<br>\u73b0\u6743\u9650\u68c0\u67e5<\/h2>\n\n\n\n<p>Filter \u4ee3\u7801\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.filter;\n\nimport jakarta.servlet.*;\nimport jakarta.servlet.http.HttpServletRequest;\n\nimport java.io.IOException;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-19 10:43\n *\/\npublic class ManagerFilter implements Filter {\n\n    @Override\n    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {\n        HttpServletRequest httpServletRequest = (HttpServletRequest) servletRequest;\n\n        Object user = httpServletRequest.getSession().getAttribute(\"user\");\n\n        if (user == null) {\n            httpServletRequest.getRequestDispatcher(\"\/pages\/user\/login.jsp\").forward(servletRequest,servletResponse);\n        } else {\n            filterChain.doFilter(servletRequest,servletResponse);\n        }\n\n    }\n\n    @Override\n    public void init(FilterConfig filterConfig) throws ServletException {\n        Filter.super.init(filterConfig);\n    }\n\n    @Override\n    public void destroy() {\n        Filter.super.destroy();\n    }\n}\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;filter&gt;\n        &lt;filter-name&gt;ManagerFilter&lt;\/filter-name&gt;\n        &lt;filter-class&gt;top.qaqaq.filter.ManagerFilter&lt;\/filter-class&gt;\n    &lt;\/filter&gt;\n    &lt;filter-mapping&gt;\n        &lt;filter-name&gt;ManagerFilter&lt;\/filter-name&gt;\n        &lt;url-pattern&gt;\/pages\/manager\/*&lt;\/url-pattern&gt;\n        &lt;url-pattern&gt;\/manager\/bookServlet&lt;\/url-pattern&gt;\n        &lt;url-pattern&gt;\/manager\/orderServlet&lt;\/url-pattern&gt;\n    &lt;\/filter-mapping&gt;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2\u3001ThreadLocal \u7684\u4f7f\u7528<\/h2>\n\n\n\n<p>ThreadLocal \u7684\u4f5c\u7528\uff0c\u5b83\u53ef\u4ee5\u89e3\u51b3\u591a\u7ebf\u7a0b\u7684\u6570\u636e\u5b89\u5168\u95ee\u9898\u3002<\/p>\n\n\n\n<p>ThreadLocal \u5b83\u53ef\u4ee5\u7ed9\u5f53\u524d\u7ebf\u7a0b\u5173\u8054\u4e00\u4e2a\u6570\u636e\uff08\u53ef\u4ee5\u662f\u666e\u901a\u53d8\u91cf\uff0c\u53ef\u4ee5\u662f\u5bf9\u8c61\uff0c\u4e5f\u53ef\u4ee5\u662f\u6570\u7ec4\uff0c\u96c6\u5408\uff09<\/p>\n\n\n\n<p>ThreadLocal \u7684\u7279\u70b9\uff1a<br>1\u3001ThreadLocal \u53ef\u4ee5\u4e3a\u5f53\u524d\u7ebf\u7a0b\u5173\u8054\u4e00\u4e2a\u6570\u636e\u3002\uff08\u5b83\u53ef\u4ee5\u50cf Map \u4e00\u6837\u5b58\u53d6\u6570\u636e\uff0ckey \u4e3a\u5f53\u524d\u7ebf\u7a0b\uff09<br>2\u3001\u6bcf\u4e00\u4e2a ThreadLocal \u5bf9\u8c61\uff0c\u53ea\u80fd\u4e3a\u5f53\u524d\u7ebf\u7a0b\u5173\u8054\u4e00\u4e2a\u6570\u636e\uff0c\u5982\u679c\u8981\u4e3a\u5f53\u524d\u7ebf\u7a0b\u5173\u8054\u591a\u4e2a\u6570\u636e\uff0c\u5c31\u9700\u8981\u4f7f\u7528\u591a\u4e2a<br>ThreadLocal \u5bf9\u8c61\u5b9e\u4f8b\u3002<br>3\u3001\u6bcf\u4e2a ThreadLocal \u5bf9\u8c61\u5b9e\u4f8b\u5b9a\u4e49\u7684\u65f6\u5019\uff0c\u4e00\u822c\u90fd\u662f static \u7c7b\u578b<br>4\u3001ThreadLocal \u4e2d\u4fdd\u5b58\u6570\u636e\uff0c\u5728\u7ebf\u7a0b\u9500\u6bc1\u540e\u3002\u4f1a\u7531 JVM \u865a\u62df\u81ea\u52a8\u91ca\u653e\u3002<\/p>\n\n\n\n<p>\u6d4b\u8bd5\u7c7b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.threadlocal;\n\nimport java.util.Map;\nimport java.util.Random;\nimport java.util.concurrent.ConcurrentHashMap;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-19 11:17\n *\/\npublic class ThreadLocalTest {\n\n    \/\/ \u7ebf\u7a0b\u5b89\u5168\u7684Map\n    public static Map&lt;String,Object&gt; data = new ConcurrentHashMap&lt;&gt;();\n\/\/    public static Map&lt;String,Object&gt; data = new Hashtable&lt;String,Object&gt;();\n\n    public static ThreadLocal&lt;Object&gt; threadLocal = new ThreadLocal&lt;Object&gt;();\n    public static ThreadLocal&lt;Object&gt; threadLocal2 = new ThreadLocal&lt;Object&gt;();\n\n    private static Random random = new Random();\n\n    public static class Task implements Runnable {\n        @Override\n        public void run() {\n\n            \/*threadLocal.set(\"abc\");\n            threadLocal2.set(\"bbj\");\n\n            System.out.println(threadLocal.get());\n            System.out.println(threadLocal2.get());*\/\n\n\n\n            \/\/ \u5728 Run \u65b9\u6cd5\u4e2d\uff0c\u968f\u673a\u751f\u6210\u4e00\u4e2a\u53d8\u91cf\uff08\u7ebf\u7a0b\u8981\u5173\u8054\u7684\u6570\u636e\uff09\uff0c\u7136\u540e\u4ee5\u5f53\u524d\u7ebf\u7a0b\u540d\u4e3a key \u4fdd\u5b58\u5230 map \u4e2d\n            Integer i = random.nextInt(1000);\/\/0-999\n            \/\/ \u83b7\u53d6\u5f53\u524d\u7ebf\u7a0b\u540d\n            String name = Thread.currentThread().getName();\n            System.out.println(\"\u7ebf\u7a0b&#91;\"+name+\"]\u751f\u6210\u7684\u968f\u673a\u6570\u662f\uff1a\" + i);\n\/\/            data.put(name,i);\n            threadLocal.set(i);\n\n            try {\n                Thread.sleep(5000);\n            } catch (InterruptedException e) {\n                throw new RuntimeException(e);\n            }\n\n            new OrderService().createOrder();\n\n            \/\/ \u5728 Run \u65b9\u6cd5\u7ed3\u675f\u4e4b\u524d\uff0c\u4ee5\u5f53\u524d\u7ebf\u7a0b\u540d\u83b7\u53d6\u51fa\u6570\u636e\u5e76\u6253\u5370\u3002\u67e5\u770b\u662f\u5426\u53ef\u4ee5\u53d6\u51fa\u64cd\u4f5c\n\/\/            Object o = data.get(name);\n            Object o = threadLocal.get();\n            System.out.println(\"\u5728\u7ebf\u7a0b&#91;\"+name+\"]\u5feb\u7ed3\u675f\u65f6\u53d6\u51fa\u5173\u8054\u7684\u6570\u636e\u662f\uff1a\" + o);\n\n        }\n    }\n\n    public static void main(String&#91;] args) {\n        for (int i = 0; i &lt; 3; i++) {\n            new Thread(new Task()).start();\n        }\n    }\n}\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.threadlocal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-19 11:31\n *\/\npublic class OrderService {\n\n    public void createOrder(){\n        String name = Thread.currentThread().getName();\n        System.out.println(\"OrderService \u5f53\u524d\u7ebf\u7a0b&#91;\" + name + \"]\u4e2d\u4fdd\u5b58\u7684\u6570\u636e\u662f\uff1a\" + ThreadLocalTest.threadLocal.get());\n        new OrderDao().saveOrder();\n    }\n}\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.threadlocal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-19 11:31\n *\/\npublic class OrderDao {\n\n    public void saveOrder(){\n        String name = Thread.currentThread().getName();\n        System.out.println(\"OrderDao \u5f53\u524d\u7ebf\u7a0b&#91;\" + name + \"]\u4e2d\u4fdd\u5b58\u7684\u6570\u636e\u662f\uff1a\" + ThreadLocalTest.threadLocal.get());\n    }\n}\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3\u3001\u4f7f\u7528 Filter \u548c ThreadLocal \u7ec4\u5408\u7ba1\u7406\u4e8b\u52a1<\/h2>\n\n\n\n<p>3.1\u3001\u4f7f\u7528 ThreadLocal \u6765\u786e\u4fdd\u6240\u6709 dao \u64cd\u4f5c\u90fd\u5728\u540c\u4e00\u4e2a Connection \u8fde\u63a5\u5bf9\u8c61\u4e2d\u5b8c\u6210<\/p>\n\n\n\n<p>\u539f\u7406\u5206\u6790\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-287-1024x510.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" data-original=\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-287-1024x510.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-2645\"  sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>JdbcUtils \u5de5\u5177\u7c7b\u7684\u4fee\u6539\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.utils;\n\nimport com.alibaba.druid.pool.DruidDataSource;\nimport com.alibaba.druid.pool.DruidDataSourceFactory;\n\nimport java.io.InputStream;\nimport java.sql.Connection;\nimport java.sql.SQLException;\nimport java.util.Properties;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-06 \u4e0b\u5348 1:36\n *\/\npublic class JdbcUtils {\n\n    private static DruidDataSource dataSource;\n\n    private static ThreadLocal&lt;Connection&gt; conns = new ThreadLocal&lt;Connection&gt;();\n\n    static {\n        try {\n            Properties properties = new Properties();\n            \/\/ \u8bfb\u53d6 jdbc.properties\u5c5e\u6027\u914d\u7f6e\u6587\u4ef6\n            \/\/ \u6ce8\u610f \u8f83\u65b0\u7684idea\u9700\u8981\u628ajdbc.properties\u653e\u5165resources\u6587\u4ef6\u5939\u4e2d\n            InputStream inputStream = JdbcUtils.class.getClassLoader().getResourceAsStream(\"jdbc.properties\");\n            \/\/ \u4ece\u6d41\u4e2d\u52a0\u8f7d\u6570\u636e\n            properties.load(inputStream);\n            \/\/ \u521b\u5efa \u6570\u636e\u5e93\u8fde\u63a5 \u6c60\n            dataSource = (DruidDataSource) DruidDataSourceFactory.createDataSource(properties);\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n\n    \/**\n     * \u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u4e2d\u7684\u8fde\u63a5\n     *\n     * @return \u5982\u679c\u8fd4\u56denull,\u8bf4\u660e\u83b7\u53d6\u8fde\u63a5\u5931\u8d25 \u6709\u503c\u5c31\u662f\u83b7\u53d6\u8fde\u63a5\u6210\u529f\n     *\/\n    public static Connection getConnection() {\n\n        Connection conn = conns.get();\n\n        if (conn == null) {\n            try {\n                conn = dataSource.getConnection(); \/\/\u4ece\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u4e2d\u83b7\u53d6\u8fde\u63a5\n\n                conns.set(conn); \/\/\u4fdd\u5b58\u5230ThreadLocal\u5bf9\u8c61\u4e2d\uff0c\u4f9b\u540e\u9762\u7684jdbc\u64cd\u4f5c\u4f7f\u7528\n\n                conn.setAutoCommit(false); \/\/\u8bbe\u7f6e\u4e3a\u624b\u52a8\u7ba1\u7406\u4e8b\u52a1\n\n            } catch (SQLException e) {\n                e.printStackTrace();\n            }\n        }\n\n        return conn;\n    }\n\n    \/**\n     * \u63d0\u4ea4\u4e8b\u52a1\uff0c\u5e76\u5173\u95ed\u91ca\u653e\u8fde\u63a5\n     *\/\n    public static void commitAndClose(){\n        Connection connection = conns.get();\n        if (connection != null) { \/\/ \u5982\u679c\u4e0d\u7b49\u4e8enull\uff0c\u8bf4\u660e \u4e4b\u524d\u4f7f\u7528\u8fc7\u8fde\u63a5\uff0c\u64cd\u4f5c\u8fc7\u6570\u636e\u5e93\n\n            try {\n                connection.commit(); \/\/ \u63d0\u4ea4 \u4e8b\u52a1\n            } catch (SQLException e) {\n                e.printStackTrace();\n            } finally {\n                try {\n                    connection.close(); \/\/ \u5173\u95ed\u8fde\u63a5\uff0c\u91ca\u653e\u8d44\u6e90\n                } catch (SQLException e) {\n                    e.printStackTrace();\n                }\n            }\n        }\n        \/\/ \u4e00\u5b9a\u8981\u6267\u884cremove\u64cd\u4f5c\uff0c\u5426\u5219\u5c31\u4f1a\u51fa\u9519\u3002(\u56e0\u4e3aTomcat\u670d\u52a1\u5668\u5e95\u5c42\u4f7f\u7528\u4e86\u7ebf\u7a0b\u6c60\u6280\u672f)\n        conns.remove();\n    }\n\n    \/**\n     * \u56de\u6eda\u4e8b\u52a1\uff0c\u5e76\u5173\u95ed\u91ca\u653e\u8fde\u63a5\n     *\/\n    public static void rollbackAndClose(){\n        Connection connection = conns.get();\n        if (connection != null) { \/\/ \u5982\u679c\u4e0d\u7b49\u4e8enull\uff0c\u8bf4\u660e \u4e4b\u524d\u4f7f\u7528\u8fc7\u8fde\u63a5\uff0c\u64cd\u4f5c\u8fc7\u6570\u636e\u5e93\n\n            try {\n                connection.rollback(); \/\/ \u56de\u6eda \u4e8b\u52a1\n            } catch (SQLException e) {\n                e.printStackTrace();\n            } finally {\n                try {\n                    connection.close(); \/\/ \u5173\u95ed\u8fde\u63a5\uff0c\u91ca\u653e\u8d44\u6e90\n                } catch (SQLException e) {\n                    e.printStackTrace();\n                }\n            }\n        }\n        \/\/ \u4e00\u5b9a\u8981\u6267\u884cremove\u64cd\u4f5c\uff0c\u5426\u5219\u5c31\u4f1a\u51fa\u9519\u3002(\u56e0\u4e3aTomcat\u670d\u52a1\u5668\u5e95\u5c42\u4f7f\u7528\u4e86\u7ebf\u7a0b\u6c60\u6280\u672f)\n        conns.remove();\n    }\n\n    \/**\n     * \u5173\u95ed\u8fde\u63a5\uff0c\u653e\u56de\u6570\u636e\u5e93\u8fde\u63a5\u6c60\n     *\n     * @param conn\n     *\/\n\/*    public static void close(Connection conn) {\n        if (conn != null){\n            try {\n                conn.close();\n            } catch (SQLException e) {\n                e.printStackTrace();\n            }\n        }\n\n    }*\/\n\n}\n<\/code><\/pre>\n\n\n\n<p>\u4fee\u6539 BaseDao<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.dao.impl;\n\nimport org.apache.commons.dbutils.QueryRunner;\nimport org.apache.commons.dbutils.handlers.BeanHandler;\nimport org.apache.commons.dbutils.handlers.BeanListHandler;\nimport org.apache.commons.dbutils.handlers.ScalarHandler;\nimport top.qaqaq.utils.JdbcUtils;\n\nimport java.sql.Connection;\nimport java.sql.SQLException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-06 \u4e0b\u5348 2:22\n *\/\npublic abstract class BaseDao {\n\n    \/\/\u4f7f\u7528DbUtils\u64cd\u4f5c\u6570\u636e\u5e93\n    private QueryRunner queryRunner = new QueryRunner();\n\n    \/**\n     * update() \u65b9\u6cd5\u7528\u6765\u6267\u884c\uff1aInsert\\Update\\Delete\u8bed\u53e5\n     * @return \u5982\u679c\u8fd4\u56de-1\uff0c\u8bf4\u660e\u6267\u884c\u5931\u8d25 \u8fd4\u56de\u5176\u4ed6\u8868\u793a\u5f71\u54cd\u7684\u884c\u6570\n     *\/\n    public int update(String sql, Object ...args){\n\n        System.out.println(\"BaseDao \u7a0b\u5e8f\u5728&#91;\" + Thread.currentThread().getName() + \"]\u4e2d\");\n\n        Connection connection = JdbcUtils.getConnection();\n        try {\n            return queryRunner.update(connection,sql,args);\n        } catch (SQLException e) {\n            e.printStackTrace();\n            throw new RuntimeException(e);\n        }\n    }\n\n    \/**\n     * \u67e5\u8be2\u8fd4\u56de\u4e00\u4e2ajavaBean\u7684sql\u8bed\u53e5\n     * @param type  \u8fd4\u56de\u7684\u5bf9\u8c61\u7c7b\u578b\n     * @param sql   \u6267\u884c\u7684sql\u8bed\u53e5\n     * @param args  sql\u5bf9\u5e94\u7684\u53c2\u6570\u503c\n     * @param &lt;T&gt;   \u8fd4\u56de\u7684\u7c7b\u578b\u7684\u6cdb\u578b\n     * @return\n     *\/\n    public &lt;T&gt; T queryForOne(Class&lt;T&gt; type,String sql,Object ...args){\n        Connection con = JdbcUtils.getConnection();\n        try {\n            return queryRunner.query(con,sql,new BeanHandler&lt;T&gt;(type),args);\n        } catch (SQLException e) {\n            e.printStackTrace();\n            throw new RuntimeException(e);\n        }\n    }\n\n    \/**\n     * \u67e5\u8be2\u8fd4\u56de\u591a\u4e2ajavaBean\u7684sql\u8bed\u53e5\n     * @param type  \u8fd4\u56de\u7684\u5bf9\u8c61\u7c7b\u578b\n     * @param sql   \u6267\u884c\u7684sql\u8bed\u53e5\n     * @param args  sql\u5bf9\u5e94\u7684\u53c2\u6570\u503c\n     * @param &lt;T&gt;   \u8fd4\u56de\u7684\u7c7b\u578b\u7684\u6cdb\u578b\n     * @return\n     *\/\n    public &lt;T&gt; List&lt;T&gt; queryForList(Class&lt;T&gt; type, String sql, Object ...args){\n        Connection con = JdbcUtils.getConnection();\n        try {\n            return queryRunner.query(con,sql,new BeanListHandler&lt;T&gt;(type),args);\n        } catch (SQLException e) {\n            e.printStackTrace();\n            throw new RuntimeException(e);\n        }\n    }\n\n    \/**\n     * \u6267\u884c\u8fd4\u56de\u4e00\u884c\u4e00\u5217\u7684sql\u8bed\u53e5\n     * @param sql   \u6267\u884c\u7684sql\u8bed\u53e5\n     * @param args  sql\u5bf9\u5e94\u7684\u53c2\u6570\u503c\n     * @return\n     *\/\n    public Object queryForSingleValue(String sql, Object ...args){\n        Connection conn = JdbcUtils.getConnection();\n\n        try {\n            return queryRunner.query(conn,sql, new ScalarHandler(),args);\n        } catch (SQLException e) {\n            e.printStackTrace();\n            throw new RuntimeException(e);\n        }\n    }\n}\n<\/code><\/pre>\n\n\n\n<p>3.2\u3001\u4f7f\u7528 Filter \u8fc7\u6ee4\u5668\u7edf\u4e00\u7ed9\u6240\u6709\u7684 Service \u65b9\u6cd5\u90fd\u52a0\u4e0a try-catch\u3002\u6765\u8fdb\u884c\u5b9e\u73b0\u7684\u7ba1\u7406\u3002<\/p>\n\n\n\n<p>\u539f\u7406\u5206\u6790\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-288-1024x422.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" data-original=\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-288-1024x422.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-2646\"  sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>Filter \u7c7b\u4ee3\u7801\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.filter;\n\nimport jakarta.servlet.*;\nimport top.qaqaq.utils.JdbcUtils;\n\nimport java.io.IOException;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-19 17:15\n *\/\npublic class TransactionFilter implements Filter {\n\n    @Override\n    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {\n\n        try {\n            filterChain.doFilter(servletRequest,servletResponse);\n\n            JdbcUtils.commitAndClose(); \/\/ \u63d0\u4ea4\u4e8b\u52a1\n\n        } catch (Exception e) {\n\n            JdbcUtils.rollbackAndClose(); \/\/ \u56de\u6eda\u4e8b\u52a1\n\n            e.printStackTrace();\n            throw new RuntimeException(e); \/\/ \u628a\u5f02\u5e38\u629b\u7ed9Tomcat\u7ba1\u7406\u5c55\u793a\u53cb\u597d\u7684\u9519\u8bef\u9875\u9762\n        }\n    }\n\n    @Override\n    public void init(FilterConfig filterConfig) throws ServletException {\n        Filter.super.init(filterConfig);\n    }\n\n    @Override\n    public void destroy() {\n        Filter.super.destroy();\n    }\n}\n<\/code><\/pre>\n\n\n\n<p>\u5728 web.xml \u4e2d\u7684\u914d\u7f6e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;filter&gt;\n        &lt;filter-name&gt;TransactionFilter&lt;\/filter-name&gt;\n        &lt;filter-class&gt;top.qaqaq.filter.TransactionFilter&lt;\/filter-class&gt;\n    &lt;\/filter&gt;\n    &lt;filter-mapping&gt;\n        &lt;filter-name&gt;TransactionFilter&lt;\/filter-name&gt;\n        &lt;!-- \/* \u8868\u793a\u5f53\u524d\u5de5\u7a0b\u4e0b\u6240\u6709\u8bf7\u6c42 --&gt;\n        &lt;url-pattern&gt;\/*&lt;\/url-pattern&gt;\n    &lt;\/filter-mapping&gt;<\/code><\/pre>\n\n\n\n<p>\u4e00\u5b9a\u8981\u8bb0\u5f97\u628a BaseServlet \u4e2d\u7684\u5f02\u5e38\u5f80\u5916\u629b\u7ed9 Filter \u8fc7\u6ee4\u5668<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServlet;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\n\nimport java.io.IOException;\nimport java.lang.reflect.Method;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 12:28\n *\/\npublic abstract class BaseServlet extends HttpServlet {\n\n    @Override\n    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/        super.doGet(req, resp);\n\n        doPost(req,resp);\n    }\n\n    @Override\n    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/        super.doPost(req, resp);\n\n        String action = req.getParameter(\"action\");\n\n\/\/        System.out.println(acction);\n\n        \/\/\u65b9\u6cd5\u4e00\uff1a\u5199\u4e00\u4e2a\u65b9\u6cd5\u5224\u65ad\u4e00\u6b21\n\/\/        if (\"login\".equals(action)) {\n\/\/            \/\/System.out.println(\"\u5904\u7406\u767b\u5f55\u7684\u9700\u6c42\");\n\/\/            login(req,resp);\n\/\/        } else if (\"regist\".equals(action)) {\n\/\/            \/\/System.out.println(\"\u5904\u7406\u6ce8\u518c\u7684\u9700\u6c42\");\n\/\/            regist(req,resp);\n\/\/        }\n\n        \/\/\u65b9\u6cd5\u4e8c\uff1a\u901a\u8fc7\u53cd\u5c04\u52a8\u6001\u83b7\u53d6\n        try {\n            \/\/ \u901a\u8fc7action\u4e1a\u52a1\u9274\u522b\u5b57\u7b26\u4e32\uff0c\u83b7\u53d6\u76f8\u5e94\u7684\u4e1a\u52a1 \u65b9\u6cd5\u53cd\u5c04\u5bf9\u8c61\n            Method method = this.getClass().getDeclaredMethod(action, HttpServletRequest.class, HttpServletResponse.class);\n\n\/\/            System.out.println(method);\n\n            \/\/ \u8c03\u7528\u76ee\u6807\u4e1a\u52a1 \u65b9\u6cd5\n            method.invoke(this,req,resp);\n        } catch (Exception e) {\n            e.printStackTrace();\n            throw new RuntimeException(e); \/\/ \u628a\u5f02\u5e38\u629b\u7ed9Filter\u8fc7\u6ee4\u5668\n        }\n    }\n}\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-289-1024x167.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"167\" data-original=\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-289-1024x167.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-2647\"  sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3.3\u3001\u5c06\u6240\u6709\u5f02\u5e38\u90fd\u7edf\u4e00\u4ea4\u7ed9 Tomcat\uff0c\u8ba9 Tomcat \u5c55\u793a\u53cb\u597d\u7684\u9519\u8bef\u4fe1\u606f<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">\u9875\u9762\u3002<\/h2>\n\n\n\n<p>\u5728 web.xml \u4e2d\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u9519\u8bef\u9875\u9762\u914d\u7f6e\u6765\u8fdb\u884c\u7ba1\u7406\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!-- error-page\u6807\u7b7e\u914d\u7f6e\uff0c\u670d\u52a1\u5668\u51fa\u9519\u4e4b\u540e\uff0c\u81ea\u52a8\u8df3\u8f6c\u7684\u9875\u9762 --&gt;\n    &lt;error-page&gt;\n        &lt;!-- error-code\u662f\u9519\u8bef\u7c7b\u578b --&gt;\n        &lt;error-code&gt;500&lt;\/error-code&gt;\n        &lt;!-- location\u6807\u7b7e\u8868\u793a\u3002\u8981\u8df3\u8f6c\u53bb\u7684\u9875\u9762\u8def\u5f84 --&gt;\n        &lt;location&gt;\/pages\/error\/error500.jsp&lt;\/location&gt;\n    &lt;\/error-page&gt;\n\n    &lt;!-- error-page\u6807\u7b7e\u914d\u7f6e\uff0c\u670d\u52a1\u5668\u51fa\u9519\u4e4b\u540e\uff0c\u81ea\u52a8\u8df3\u8f6c\u7684\u9875\u9762 --&gt;\n    &lt;error-page&gt;\n        &lt;!-- error-code\u662f\u9519\u8bef\u7c7b\u578b --&gt;\n        &lt;error-code&gt;404&lt;\/error-code&gt;\n        &lt;!-- location\u6807\u7b7e\u8868\u793a\u3002\u8981\u8df3\u8f6c\u53bb\u7684\u9875\u9762\u8def\u5f84 --&gt;\n        &lt;location&gt;\/pages\/error\/error404.jsp&lt;\/location&gt;\n    &lt;\/error-page&gt;<\/code><\/pre>\n\n\n\n<p>error500.jsp<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %&gt;\n&lt;%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %&gt;\n&lt;!DOCTYPE html&gt;\n&lt;html&gt;\n&lt;head&gt;\n&lt;meta charset=\"UTF-8\"&gt;\n&lt;title&gt;\u7535\u5b50\u4ea7\u54c1&lt;\/title&gt;\n\n\t&lt;%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%&gt;\n\t&lt;%@ include file=\"\/pages\/common\/head.jsp\"%&gt;\n\n&lt;\/head&gt;\n&lt;body&gt;\n\t\u5f88\u62b1\u6b49\uff0c\u60a8\u8bbf\u95ee\u7684\u540e\u53f0\u7a0b\u5e8f\u51fa\u73b0\u4e86\u9519\u8bef\uff0c\u7a0b\u5e8f\u733f\u5c0f\u54e5\uff0c\u6b63\u5728\u52aa\u529b\u7684\u4e3a\u60a8\u62a2\u4fee\uff01\uff01\uff01&lt;br\/&gt;\n\t&lt;a href=\"index.jsp\"&gt;\u8fd4\u56de\u9996\u9875&lt;\/a&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n\n\n\n<p>error404.jsp<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %&gt;\n&lt;%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %&gt;\n&lt;!DOCTYPE html&gt;\n&lt;html&gt;\n&lt;head&gt;\n&lt;meta charset=\"UTF-8\"&gt;\n&lt;title&gt;\u7535\u5b50\u4ea7\u54c1&lt;\/title&gt;\n\n\t&lt;%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%&gt;\n\t&lt;%@ include file=\"\/pages\/common\/head.jsp\"%&gt;\n\n&lt;\/head&gt;\n&lt;body&gt;\n\t\u5f88\u62b1\u6b49\u3002\u60a8\u8bbf\u95ee\u7684\u9875\u9762\u4e0d\u5b58\u5728\uff0c\u6216\u5df2\u7ecf\u88ab\u5220\u9664\uff01\uff01\uff01&lt;br\/&gt;\n\t&lt;a href=\"index.jsp\"&gt;\u8fd4\u56de\u9996\u9875&lt;\/a&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e66\u57ce\u9879\u76ee-\u4f7f\u7528Filter\u8fc7\u6ee4\u5668\u5b9e\u73b0\u540e\u53f0\u7684\u6743\u9650\u7ba1\u7406\u3001\u4e66\u57ce\u9879\u76ee-ThreadLocal\u4f7f\u7528\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-\u4f7f\u7528T [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[61],"class_list":["post-2644","post","type-post","status-publish","format-standard","hentry","category-javaweb-code","tag-javaweb"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2644"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2644"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2644\/revisions"}],"predecessor-version":[{"id":2728,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2644\/revisions\/2728"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}