{"id":10020540,"date":"2024-12-23T11:39:23","date_gmt":"2024-12-23T03:39:23","guid":{"rendered":"https:\/\/itmax.cn\/?p=10020540"},"modified":"2024-12-23T11:39:23","modified_gmt":"2024-12-23T03:39:23","slug":"%e7%94%b1-mybatis-%e6%ba%90%e7%a0%81%e7%95%85%e8%b0%88%e8%bd%af%e4%bb%b6%e8%ae%be%e8%ae%a1%ef%bc%88%e4%ba%8c%ef%bc%89%ef%bc%9amappedstatement-%e5%92%8c-sqlsource","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10020540","title":{"rendered":"\u7531 Mybatis \u6e90\u7801\u7545\u8c08\u8f6f\u4ef6\u8bbe\u8ba1\uff08\u4e8c\uff09\uff1aMappedStatement \u548c SqlSource"},"content":{"rendered":"

\u4f5c\u8005\uff1a\u4eac\u4e1c\u4fdd\u9669 \u738b\u5955\u9f99<\/p>\n

\u672c\u8282\u6211\u4eec\u6765\u4ecb\u7ecd org.apache.ibatis.mapping.MappedStatement<\/code>\uff08\u6620\u5c04SQL\u8bed\u53e5\u58f0\u660e\u7684\u7c7b\uff09\uff0c\u5b83\u662f MyBatis \u6846\u67b6\u4e2d\u7684\u4e00\u4e2a\u6838\u5fc3\u7c7b\uff0c\u4e5f\u662f\u5411\u540e\u4e0d\u65ad\u5b66\u4e60 Mybatis \u6e90\u7801\u7684\u57fa\u7840\u3002\u5728\u8fd9\u90e8\u5206\u6e90\u7801\u4e2d\uff0c\u6700\u503c\u5f97\u5173\u6ce8\u7684\u8bbe\u8ba1\u539f\u5219\u662f\u201c\u4fe1\u606f\u9690\u85cf<\/strong>\u201d\uff0c\u5b83\u662f\u5728\u300a\u8f6f\u4ef6\u8bbe\u8ba1\u54f2\u5b66\u300b\u4e2d\u63d0\u5230\u7684\u4e00\u4e2a\u89c2\u70b9\uff0c\u7b80\u5355\u6765\u8bf4\u5c31\u662f\u5c06\u628a\u5916\u90e8\u7c7b\u4e0d\u9700\u8981\u4e86\u89e3\u7684\u4fe1\u606f\u9690\u85cf\u5728\u7c7b\u5185\u90e8\uff0c\u9075\u5faa\u6700\u5c0f\u77e5\u8bc6\u539f\u5219\uff0c\u5728\u4e0e MappedStatement<\/code> \u76f8\u5173\u7684\u7c7b\u4e2d\uff0c\u5b9a\u4e49\u4e86\u5f88\u591a\u5185\u90e8\u7c7b\u548c\u5185\u90e8\u63a5\u53e3\uff0c\u5b83\u4eec\u53ea\u5728\u67d0\u4e9b\u7c7b\u5185\u8bbf\u95ee\u3002\u6b64\u5916\uff0cMappedStatement<\/code> \u7684\u521b\u5efa\u5b8c\u7f8e\u5730\u9075\u5faa\u4e86 \u5efa\u9020\u8005\u6a21\u5f0f<\/strong>\uff0c\u8fd9\u4e5f\u662f\u5b66\u4e60\u8be5\u6a21\u5f0f\u5f88\u597d\u7684\u5b9e\u4f8b\u3002\u8fd9\u90e8\u5206\u6e90\u7801\u8f83\u591a\uff0c\u5728\u770b\u8fd9\u90e8\u5206\u6e90\u7801\u65f6\uff0c\u4e5f\u9700\u8981\u7559\u610f\u4e00\u4e0b\u65b9\u6cd5\u7684\u957f\u5ea6\uff0c\u5c1d\u8bd5\u7740\u7406\u89e3\u5728\u300a\u4ee3\u7801\u6574\u6d01\u4e4b\u9053\u300b\u4e2d\u5f3a\u8c03\u7684\u201c\u6bcf\u4e2a\u65b9\u6cd5\u53ea\u505a\u4e00\u4ef6\u4e8b<\/strong>\u201d\u7684\u539f\u5219\uff0c\u8003\u8651\u4e66\u4e2d\u63d0\u5230\u7684\u6309\u7167\u65b9\u6cd5\u884c\u6570\u62c6\u5206\u591a\u4e2a\u5c0f\u65b9\u6cd5\u7684\u539f\u5219\u5230\u5e95\u5408\u9002\u4e0d\u5408\u9002\uff0c\u5e76\u5173\u6ce8\u65b9\u6cd5\u7684\u7f16\u6392\u987a\u5e8f\uff0c\u5b83\u662f\u80e1\u4e71\u7684\u5b89\u6392\u65b9\u6cd5\u7684\u4f4d\u7f6e\u8fd8\u662f\u6709\u4e00\u5b9a\u89c4\u5f8b\uff1f\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u6b65\u5165\u6b63\u6587\u3002<\/p>\n

MappedStatement<\/code> \u8d1f\u8d23\u5b58\u50a8\u548c\u7ba1\u7406\u6620\u5c04 SQL \u8bed\u53e5\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u6bcf\u4e2a MappedStatement<\/code> \u5bf9\u8c61\u5bf9\u5e94 XML \u6620\u5c04\u6587\u4ef6\u4e2d\u4e00\u4e2a <select><\/code>, <insert><\/code>, <update><\/code>, \u6216 <delete><\/code> \u6807\u7b7e\uff0c\u5176\u4e2d\u91cd\u8981\u5b57\u6bb5\u5185\u5bb9\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n

public final class MappedStatement {\n    \n    \/\/ \u6bcf\u4e2a MappedStatement \u5bf9\u8c61\u90fd\u6709\u4e00\u4e2a\u552f\u4e00\u7684 ID\uff0c\u7528\u4e8e\u5728 MyBatis \u914d\u7f6e\u4e2d\u6807\u8bc6\u548c\u5f15\u7528\u8be5\u8bed\u53e5\uff08Mapper\u63a5\u53e3\u4e2d\u7684\u65b9\u6cd5\u7684\u5168\u8def\u5f84\u540d\u79f0\uff09\n    \/\/ eg: org.apache.ibatis.domain.blog.mappers.AuthorMapper.selectAuthor\n    private String id;\n    \/\/ sqlSource \u5b58\u50a8 SQL \u8bed\u53e5\uff0c\u533a\u5206\u9759\u6001\u3001\u52a8\u6001SQL\n    private SqlSource sqlSource;\n    \/\/ \u63cf\u8ff0\u8f93\u5165\u53c2\u6570\u7684\u7c7b\u578b\u548c\u6620\u5c04\u5173\u7cfb\n    private ParameterMap parameterMap;\n    \/\/ \u63cf\u8ff0\u8fd4\u56de\u7ed3\u679c\u7684\u7c7b\u578b\u548c\u6620\u5c04\u5173\u7cfb\n    private List<ResultMap> resultMaps;\n    \/\/ SQL \u7c7b\u578b\n    private SqlCommandType sqlCommandType;\n    \/\/ \u6570\u636e\u5e93\u5382\u5546\u6807\u8bc6\uff0c\u7528\u4e8e\u591a\u6570\u636e\u5e93\u652f\u6301\n    private String databaseId;\n    \/\/ Mapper.xml \u6587\u4ef6\u7684\u8def\u5f84\uff0ceg: org\/apache\/ibatis\/builder\/AuthorMapper.xml\n    private String resource;\n    \n    \/\/ ...\n}\n<\/code><\/pre>\n
org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode<\/code> \u65b9\u6cd5\u662f\u5c06 xml \u6587\u4ef6\u4e2d\u914d\u7f6e\u7684 SQL \u5b9e\u4f8b\u5316\u6210 MappedStatement<\/code> \u5bf9\u8c61\u7684\u65b9\u6cd5\uff1a<\/p>\n
public class XMLStatementBuilder extends BaseBuilder {\n\n    \/\/ ...\n    \n    private final MapperBuilderAssistant builderAssistant;\n\n    public void parseStatementNode() {\n        \/\/ \u5904\u7406\u914d\u7f6e\u7684\u53c2\u6570 \n        boolean flushCache = context.getBooleanAttribute("flushCache", !isSelect);\n        \/\/ ...\n        \n        \/\/ \u521b\u5efa SqlSource\n        SqlSource sqlSource = langDriver.createSqlSource(configuration, context, parameterTypeClass);\n        \/\/ ...\n        \n        \/\/ \u521b\u5efa MappedStatement \u5bf9\u8c61\n        builderAssistant.addMappedStatement(id, sqlSource, statementType, sqlCommandType, fetchSize, timeout, parameterMap,\n                parameterTypeClass, resultMap, resultTypeClass, resultSetTypeEnum, flushCache, useCache, resultOrdered,\n                keyGenerator, keyProperty, keyColumn, databaseId, langDriver, resultSets, dirtySelect);\n    }\n}\n<\/code><\/pre>\n
\u9a8c\u8bc1\u521b\u5efa MappedStatement<\/code> \u5bf9\u8c61\u8fc7\u7a0b\u903b\u8f91\u91c7\u7528\u7684\u5355\u6d4b\u4e3a org.apache.ibatis.session.SqlSessionTest.shouldExecuteSelectOneAuthorUsingMapperClass<\/code>\uff0c\u89e3\u6790\u7684 xml \u6587\u4ef6\u4e3a AuthorMapper.xml<\/code>\u3002<\/p>\n
\u5728\u4e0a\u8ff0\u6e90\u7801\u6b65\u9aa4\u4e2d SqlSource<\/code> \u7684\u521b\u5efa\u975e\u5e38\u91cd\u8981\uff0c\u8be5\u63a5\u53e3\u7684\u6e90\u7801\u6ce8\u91ca\u5982\u4e0b\uff1a<\/p>\n
Represents the content of a mapped statement read from an XML file or an annotation. It creates the SQL that will be passed to the database out of the input parameter received from the user.<\/p><\/blockquote>\n
\u8868\u793a\u4ece XML \u6587\u4ef6\u6216\u6ce8\u91ca\u8bfb\u53d6\u7684 SQL \u8bed\u53e5\uff0c\u5b83\u53ef\u4ee5\u6839\u636e\u7528\u6237\u8f93\u5165\u7684\u53c2\u6570\u521b\u5efa\u4e4b\u540e\u4f20\u9012\u7ed9\u6570\u636e\u5e93\u7684SQL\uff08org.apache.ibatis.mapping.SqlSource#getBoundSql<\/code> \u65b9\u6cd5\uff09\u3002\u63a5\u4e0b\u6765\u6211\u4eec\u91cd\u70b9\u770b\u4e0b\u8fd9\u4e2a\u63a5\u53e3\uff1a<\/p>\n
public interface SqlSource {\n\n    \/\/ \u63a5\u53d7\u53c2\u6570\u5bf9\u8c61\uff0c\u5e76\u8fd4\u56de BoundSql \u5bf9\u8c61\u3002BoundSql \u5305\u542b\u4e86\u751f\u6210\u7684 SQL \u8bed\u53e5\u4ee5\u53ca\u76f8\u5e94\u7684\u53c2\u6570\u4fe1\u606f\n    BoundSql getBoundSql(Object parameterObject);\n\n}\n<\/code><\/pre>\n
MyBatis \u63d0\u4f9b\u4e86\u51e0\u4e2a SqlSource<\/code> \u7684\u5b9e\u73b0\u7c7b\uff0c\u6bcf\u4e2a\u5b9e\u73b0\u7c7b\u9002\u7528\u4e8e\u4e0d\u540c\u7684\u573a\u666f\uff1a<\/p>\n
    \n
  1. StaticSqlSource<\/code><\/strong>: \u7528\u4e8e\u5904\u7406\u9759\u6001 SQL \u8bed\u53e5<\/li>\n
  2. DynamicSqlSource<\/code><\/strong>: \u7528\u4e8e\u5904\u7406\u52a8\u6001 SQL \u8bed\u53e5\uff08\u5305\u542b ${}<\/code> \u5360\u4f4d\u7b26\u548c <if><\/code>, <choose><\/code>, <when><\/code>, <otherwise><\/code>, <foreach><\/code> \u7b49\u52a8\u6001\u6807\u7b7e\uff09<\/li>\n
  3. RawSqlSource<\/code><\/strong>: \u8fd9\u4e2a\u5b9e\u73b0\u7c7b\u7528\u4e8e\u89e3\u6790\u5305\u542b #{}<\/code> \u5360\u4f4d\u7b26\u7684 SQL \u8bed\u53e5\uff0c\u5176\u5185\u90e8\u5b9e\u73b0\u4f9d\u7136\u662f StaticSqlSource<\/code><\/li>\n
  4. ProviderSqlSource<\/code><\/strong>: \u7528\u4e8e\u5904\u7406\u4f7f\u7528 @Provider<\/code> \u6ce8\u89e3\u7684 SQL<\/li>\n<\/ol>\n
    \u5b83\u7684\u5b9e\u4f8b\u5316\u501f\u52a9\u4e86 XMLScriptBuilder<\/code> \u5b9e\u73b0\uff1a<\/p>\n
    public class XMLLanguageDriver implements LanguageDriver {\n    \/\/ ...\n\n    @Override\n    public SqlSource createSqlSource(Configuration configuration, XNode script, Class<?> parameterType) {\n        XMLScriptBuilder builder = new XMLScriptBuilder(configuration, script, parameterType);\n        return builder.parseScriptNode();\n    }\n}\n<\/code><\/pre>\n
    XMLScriptBuilder<\/code> \u4e2d\u5b9a\u4e49\u4e86 \u5185\u90e8\u63a5\u53e3<\/strong> \u52a8\u6001\u6807\u7b7e\u89e3\u6790\u5668 NodeHandler<\/code>\uff0c\u5b83\u5bf9\u591a\u79cd\u6807\u7b7e\u89e3\u6790\u505a\u4e86\u5b9e\u73b0\uff0c\u8d1f\u8d23\u5c06\u4e0d\u540c\u6807\u7b7e\u5185\u5bb9\u89e3\u6790\u6210\u4e0d\u540c\u7684 SqlNode<\/code> \u5bf9\u8c61\uff1a<\/p>\n
    public class XMLScriptBuilder extends BaseBuilder {\n    \n    private final Map<String, NodeHandler> nodeHandlerMap = new HashMap<>();\n\n    public XMLScriptBuilder(Configuration configuration, XNode context, Class<?> parameterType) {\n        super(configuration);\n        this.context = context;\n        this.parameterType = parameterType;\n        \/\/ \u521d\u59cb\u5316SQL\u8282\u70b9\u5904\u7406\u5668\n        initNodeHandlerMap();\n    }\n    \n    private void initNodeHandlerMap() {\n        nodeHandlerMap.put("trim", new TrimHandler());\n        nodeHandlerMap.put("where", new WhereHandler());\n        nodeHandlerMap.put("set", new SetHandler());\n        nodeHandlerMap.put("foreach", new ForEachHandler());\n        nodeHandlerMap.put("if", new IfHandler());\n        nodeHandlerMap.put("choose", new ChooseHandler());\n        nodeHandlerMap.put("when", new IfHandler());\n        nodeHandlerMap.put("otherwise", new OtherwiseHandler());\n        nodeHandlerMap.put("bind", new BindHandler());\n    }\n\n    \/\/ \u5b9a\u4e49\u5185\u90e8\u63a5\u53e3\uff0c\u56e0\u4e3a\u5176\u53ea\u4e0e XMLScriptBuilder \u76f8\u5173\uff0c\u9690\u85cf\u5728\u5185\u90e8\u4e0d\u6cc4\u9732\u77e5\u8bc6\uff0c\u964d\u4f4e\u590d\u6742\u5ea6\n    private interface NodeHandler {\n        void handleNode(XNode nodeToHandle, List<SqlNode> targetContents);\n    }\n\n    private class WhereHandler implements NodeHandler {\n        \/\/ ...\n    }\n    \n    \/\/ ...\n}\n<\/code><\/pre>\n
    org.apache.ibatis.scripting.xmltags.XMLScriptBuilder.NodeHandler#handleNode<\/code> \u65b9\u6cd5\u7684\u7b2c 2 \u4e2a\u5165\u53c2\u4e3a SQL \u7684\u8282\u70b9\u5224\u65ad\u4fe1\u606f\uff0c\u6211\u4eec\u9700\u8981\u4e86\u89e3\u4e0b SqlNode<\/code> \u63a5\u53e3\uff1a<\/p>\n
    public interface SqlNode {\n\n    \/**\n     * \u8d1f\u8d23\u5c06\u5f53\u524d\u8282\u70b9\u7684 SQL \u7247\u6bb5\u5e94\u7528\u5230\u4e0a\u4e0b\u6587\u4e2d\n     *\/\n    boolean apply(DynamicContext context);\n    \n}\n<\/code><\/pre>\n
    \u5b83\u7684\u5b9e\u73b0\u7c7b\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n
    \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n
      \n
    • StaticTextSqlNode<\/code> \u7528\u4e8e\u5904\u7406\u4e0d\u5305\u542b\u5360\u4f4d\u7b26\u7684\u7eaf\u6587\u672c\u8282\u70b9<\/li>\n
    • TextSqlNode<\/code> \u7528\u4e8e\u5904\u7406\u5305\u542b ${}<\/code> \u5360\u4f4d\u7b26\u7684\u6587\u672c\u8282\u70b9\uff0c\u5b83\u4f1a \u76f4\u63a5\u5c06\u5360\u4f4d\u7b26\u4e2d\u7684\u5185\u5bb9\u62fc\u63a5\u5230 SQL \u4e0a<\/strong>\uff0c\u6240\u4ee5\u5b83\u80fd\u5b9e\u73b0 \u52a8\u6001 SQL<\/strong>\uff0c\u4e0e\u5904\u7406 #{}<\/code> \u5360\u4f4d\u7b26\u4e0d\u540c\uff0c#{}<\/code> \u5360\u4f4d\u7b26\u5728\u5904\u7406\u5b57\u7b26\u4e32\u7c7b\u578b\u65f6\uff0c\u4f1a\u6dfb\u52a0\u4e0a '<\/code> \u5355\u5f15\u53f7\uff0c\u907f\u514d SQL \u6ce8\u5165\u95ee\u9898\uff0c\u6ce8\u610f\u5b83\u4eec\u7684\u533a\u522b\uff0c\u540e\u7eed\u9488\u5bf9\u52a8\u6001 SQL \u95ee\u9898\u8fd8\u4f1a\u8bb2\u89e3<\/li>\n
    • MixedSqlNode<\/code> \u6bd4\u8f83\u7279\u6b8a\uff0c\u56e0\u4e3a SQL \u88ab\u89e3\u6790\u5b8c\u6bd5\u540e\uff0c\u4f1a\u6709\u591a\u4e2a\u8282\u70b9\u7247\u6bb5\uff0c\u8fd9\u4e2a\u5bf9\u8c61\u662f\u5c06\u6240\u6709\u7684\u8282\u70b9\uff08SqlNode<\/code>\uff09\u4fdd\u5b58\u8d77\u6765\uff0c\u901a\u8fc7\u904d\u5386\u6765\u89e6\u53d1\u5c06 SQL \u5e94\u7528\u5230\u4e0a\u4e0b\u6587\u7684 apply<\/code> \u65b9\u6cd5\uff1a<\/li>\n<\/ul>\n
      <!—-><\/p>\n
      public class MixedSqlNode implements SqlNode {\n    \/\/ \u4fdd\u5b58 SQL \u4e2d\u6240\u6709\u7684\u8282\u70b9\u7247\u6bb5\n    private final List<SqlNode> contents;\n\n    public MixedSqlNode(List<SqlNode> contents) {\n        this.contents = contents;\n    }\n\n    @Override\n    public boolean apply(DynamicContext context) {\n        contents.forEach(node -> node.apply(context));\n        return true;\n    }\n}\n<\/code><\/pre>\n
      \u5176\u4ed6\u5b9e\u73b0\u7c7b\u6839\u636e\u5176\u547d\u540d\u8868\u793a SQL \u4e2d\u5bf9\u5e94\u7684\u4e0d\u540c\u6807\u7b7e\u8282\u70b9\uff0c\u975e\u5e38\u7b80\u5355\u5c31\u4e0d\u518d\u8d58\u8ff0\u4e86\u3002\u6211\u4eec\u7ee7\u7eed\u56de\u5230 XMLScriptBuilder#<\/code>parseScriptNode\/` \u65b9\u6cd5\uff0c\u5b83\u4f1a\u5bf9 xml \u6587\u4ef6\u4e2d\u5b9a\u4e49\u7684 SQL \u8fdb\u884c\u89e3\u6790\uff1a<\/p>\n
      public class XMLScriptBuilder extends BaseBuilder {\n    \/\/ ...\n    \n    public SqlSource parseScriptNode() {\n        \/\/ \u5c06 xml \u6587\u4ef6\u4e2d\u5b9a\u4e49\u7684 SQL \u89e3\u6790\u6210\u4e0d\u540c\u7684 SqlNode \u5bf9\u8c61\uff0c\u5e76\u90fd\u8bb0\u5f55\u5728 MixedSqlNode \u5bf9\u8c61\u4e2d\n        MixedSqlNode rootSqlNode = parseDynamicTags(context);\n        SqlSource sqlSource;\n        if (isDynamic) {\n            \/\/ \u5305\u542b\u52a8\u6001\u6807\u7b7e\u7684 SQL\n            sqlSource = new DynamicSqlSource(configuration, rootSqlNode);\n        } else {\n            \/\/ \u9759\u6001 SQL \u4f1a\u5c06\u5360\u4f4d\u7b26 #{} \u66ff\u6362\u6210 ?\n            sqlSource = new RawSqlSource(configuration, rootSqlNode, parameterType);\n        }\n        return sqlSource;\n    }\n    \n    \/\/ ...\n}\n<\/code><\/pre>\n
      \u53ef\u4ee5\u53d1\u73b0\u5b83\u4f1a\u6839\u636e\u9759\u6001\u6216\u52a8\u6001 SQL \u521b\u5efa\u4e0d\u540c\u7684 SqlSource<\/code> \u5bf9\u8c61\uff0c\u90a3\u4e48\u6211\u4eec\u63a5\u4e0b\u6765\u5206\u522b\u770b\u4e00\u4e0b\u4e24\u79cd\u4e0d\u540c SQL \u7684\u89e3\u6790\u8fc7\u7a0b\u3002<\/p>\n
      \u9759\u6001 SQL \u7684\u89e3\u6790<\/h3>\n
      \u4ee5\u5982\u4e0b SQL \u4e3a\u4f8b\uff1a<\/p>\n
      <select id="selectAuthor" parameterMap="selectAuthor" resultMap="selectAuthor">\n    select id, username, password, email, bio, favourite_section\n    from author where id = #{id,jdbcType=INTEGER, javaType=int}\n<\/select>\n<\/code><\/pre>\n
      org.apache.ibatis.scripting.xmltags.XMLScriptBuilder.parseDynamicTags<\/code> \u65b9\u6cd5\u4f1a\u6267\u884c\u5177\u4f53\u7684 SQL \u89e3\u6790\u903b\u8f91\uff0c\u5b83\u4f1a\u6267\u884c\u5982\u4e0b\u903b\u8f91\uff1a\u5982\u679c\u5305\u542b ${}<\/code> \u5360\u4f4d\u7b26\uff0c\u4f1a\u88ab\u6807\u8bc6\u4e3a\u52a8\u6001 SQL\uff0c\u5bf9\u5e94\u7684\u7c7b\u578b\u4e3a TextSqlNode<\/code>\uff0c\u5426\u5219\u4e3a StaticTextSqlNode<\/code> \u5bf9\u8c61\uff0c\u5982\u4e0b\u903b\u8f91\uff1a<\/p>\n
      public class XMLScriptBuilder extends BaseBuilder {\n\n    public SqlSource parseScriptNode() {\n        \/\/ \u5c06 xml \u6587\u4ef6\u4e2d\u5b9a\u4e49\u7684 SQL \u89e3\u6790\u6210\u4e0d\u540c\u7684 SqlNode \u5bf9\u8c61\uff0c\u5e76\u90fd\u8bb0\u5f55\u5728 MixedSqlNode \u5bf9\u8c61\u4e2d\n        MixedSqlNode rootSqlNode = parseDynamicTags(context);\n        \/\/ ...\n    }\n    \n    protected MixedSqlNode parseDynamicTags(XNode node) {\n        List<SqlNode> contents = new ArrayList<>();\n\n        NodeList children = node.getNode().getChildNodes();\n        for (int i = 0; i < children.getLength(); i++) {\n            XNode child = node.newXNode(children.item(i));\n            if (child.getNode().getNodeType() == Node.CDATA_SECTION_NODE || child.getNode().getNodeType() == Node.TEXT_NODE) {\n                String data = child.getStringBody("");\n                TextSqlNode textSqlNode = new TextSqlNode(data);\n                \/\/ \u5305\u542b ${} \u5360\u4f4d\u7b26\u7684\u4f1a\u88ab\u5224\u65ad\u4e3a\u52a8\u6001 SQL\uff0c\u5e76\u88ab\u8bb0\u5f55\u4e3a TextSqlNode\n                if (textSqlNode.isDynamic()) {\n                    contents.add(textSqlNode);\n                    isDynamic = true;\n                } else {\n                    contents.add(new StaticTextSqlNode(data));\n                }\n            } else if (child.getNode().getNodeType() == Node.ELEMENT_NODE) {\n                \/\/ ...\n            }\n        }\n\n        return new MixedSqlNode(contents);\n    }\n    \n}\n<\/code><\/pre>\n
      \u5176\u4e2d textSqlNode.isDynamic()<\/code> \u6b65\u9aa4\u9700\u8981\u5173\u6ce8\u3002TextSqlNode<\/code> \u5bf9\u8c61\u4e2d\u5b9a\u4e49\u4e86 DynamicCheckerTokenParser<\/code> \u5185\u90e8\u7c7b<\/strong>\uff0c\u5b83\u5b9e\u73b0\u4e86 TokenHandler<\/code> \u63a5\u53e3\uff0c\u5728\u8def\u5f84 org.apache.ibatis.parsing<\/code> \u4e0b\uff0c\u6839\u636e\u5305\u8def\u5f84\u63cf\u8ff0 \u201cParsing utils\u201d\uff0c\u53ef\u77e5\u8be5\u63a5\u53e3\u662f\u89e3\u6790\u5de5\u5177\u7c7b\u901a\u7528\u63a5\u53e3\uff0c\u4e0d\u8fc7 DynamicCheckerTokenParser<\/code> \u5e76\u6ca1\u6709\u505a\u4ec0\u4e48\u9700\u8981\u7279\u522b\u5173\u6ce8\u7684\u903b\u8f91\uff0c\u53ea\u662f\u7528\u4e8e\u6807\u8bb0 SQL \u4e3a\u9759\u6001 SQL \u8fd8\u662f\u52a8\u6001 SQL\uff08isDynamic<\/code> \u5b57\u6bb5\uff09\uff1a<\/p>\n
      private static class DynamicCheckerTokenParser implements TokenHandler {\n\n    private boolean isDynamic;\n\n    public DynamicCheckerTokenParser() {\n        \/\/ Prevent Synthetic Access\n    }\n\n    public boolean isDynamic() {\n        return isDynamic;\n    }\n\n    @Override\n    public String handleToken(String content) {\n        this.isDynamic = true;\n        return null;\n    }\n}\n<\/code><\/pre>\n
      \u5728 textSqlNode.isDynamic()<\/code> \u65b9\u6cd5\u4e2d\uff0c\u521b\u5efa\u4e86 DynamicCheckerTokenParser<\/code> \u5bf9\u8c61\u548c GenericTokenParser<\/code> \u5bf9\u8c61\u3002<\/p>\n
      public class TextSqlNode implements SqlNode {\n\n    \/\/ ...\n\n    public boolean isDynamic() {\n        DynamicCheckerTokenParser checker = new DynamicCheckerTokenParser();\n        GenericTokenParser parser = createParser(checker);\n        parser.parse(text);\n        return checker.isDynamic();\n    }\n\n    \/\/ ...\n}\n<\/code><\/pre>\n
      GenericTokenParser<\/code> \u8bd1\u4e3a\u901a\u7528\u7684 Token \u89e3\u6790\u5668\uff0c\u540c\u6837\u4e5f\u5728 org.apache.ibatis.parsing<\/code> \u5305\u8def\u5f84\u4e0b\uff0c\u5b83\u4f1a\u5b8c\u6210\u5224\u65ad\u662f\u5426\u4e3a\u52a8\u6001 SQL \u7684\u903b\u8f91\uff08\u4ec5\u5224\u65ad\u662f\u5426\u5305\u542b ${}<\/code> \u5360\u4f4d\u7b26\uff09\uff0c\u4e4b\u540e\u4f1a\u7ecf\u5e38\u770b\u5230\u5b83\u7684\u8eab\u5f71\uff0c\u5176\u4e2d\u5305\u542b\u4e09\u4e2a\u5b57\u6bb5\uff1a<\/p>\n
      public class GenericTokenParser {\n\n    \/\/ \u8981\u5339\u914d\u7684 \u5360\u4f4d\u7b26\u5de6\u8fb9\u754c\u4fe1\u606f\n    private final String openToken;\n    \/\/ \u8981\u5339\u914d\u7684 \u5360\u4f4d\u7b26\u53f3\u8fb9\u754c\u4fe1\u606f\n    private final String closeToken;\n    \/\/ \u7ec4\u5408 TokenHandler \u6765\u5b9e\u73b0\u201c\u66ff\u6362\u5360\u4f4d\u7b26\u201d\u7684\u529f\u80fd\uff0c\u7b26\u5408\u5355\u4e00\u804c\u8d23\u7684\u539f\u5219\n    private final TokenHandler handler;\n\n    \/\/ ...\n    \n    \/\/ \u89e3\u6790 SQL \u64cd\u4f5c\n    public String parse(String text) {\n        \/\/ ...\n    }\n    \n}\n<\/code><\/pre>\n
      \u7ee7\u7eed\u56de\u5230 org.apache.ibatis.scripting.xmltags.XMLScriptBuilder.parseDynamicTags<\/code> \u65b9\u6cd5\uff0c\u5982\u679c\u5728 SQL \u4e2d\u5339\u914d\u5230 ${}<\/code> \u5219 DynamicCheckerTokenParser<\/code> \u4f1a\u5c06 isDynamic<\/code> \u6807\u8bb0\u4e3a true<\/code>\uff0c\u5f53\u524d SQL \u8282\u70b9\u4f1a\u88ab\u5b9a\u4e49\u4e3a TextSqlNode<\/code> \u7c7b\u578b\uff0c\u5426\u5219\u4e3a StaticTextSqlNode<\/code> \u7c7b\u578b\uff0c\u56e0\u4e3a\u5728\u793a\u4f8b\u4e2d\u5b9a\u4e49\u7684 SQL \u662f\u5e26\u6709 #{}<\/code> \u5360\u4f4d\u7b26\u7684 SQL\uff0c\u6240\u4ee5 SqlSource<\/code> \u4f1a\u88ab\u89e3\u6790\u6210 RawSqlSource<\/code> \u7c7b\u578b\uff0c\u5e76\u5728\u5176\u4e2d\u7ec4\u5408 StaticSqlSource<\/code> \u5bf9\u8c61\u3002<\/p>\n
      public class RawSqlSource implements SqlSource {\n\n    private final SqlSource sqlSource;\n\n    public RawSqlSource(Configuration configuration, String sql, Class<?> parameterType) {\n        SqlSourceBuilder sqlSourceParser = new SqlSourceBuilder(configuration);\n        Class<?> clazz = parameterType == null ? Object.class : parameterType;\n        \/\/ \u9759\u6001 SQL \u5728\u6b64\u5904\u88ab\u89e3\u6790\uff0c\u5305\u542b #{} \u5360\u4f4d\u7b26\u7684\u4f1a\u88ab\u66ff\u6362\u4e3a ?\n        sqlSource = sqlSourceParser.parse(sql, clazz, new HashMap<>());\n    }\n\n    \/\/ ...\n}\n<\/code><\/pre>\n
      \u5728 RawSqlSource<\/code> \u7684\u6784\u9020\u65b9\u6cd5\u4e2d\uff0c\u5b8c\u6210\u4e86\u66ff\u6362\u5360\u4f4d\u7b26\u7684\u64cd\u4f5c\uff0cSqlSourceBuilder<\/code> \u5bf9\u8c61\u9700\u8981\u91cd\u70b9\u5173\u6ce8\uff0c\u7531\u5176\u547d\u540d\u6765\u770b\uff0c\u5b83\u662f SqlSource<\/code> \u5bf9\u8c61\u7684\u201c\u5efa\u9020\u8005\uff08Builder\uff09\u201d\uff0c\u4f46\u662f\u5b83\u5e76\u6ca1\u6709\u4e25\u683c\u9075\u5b88\u5efa\u9020\u8005\u6a21\u5f0f\uff0c\u4e0d\u8fc7\u662f\u5c06\u590d\u6742\u7684\u6784\u9020\u5bf9\u8c61\u7684\u903b\u8f91\u9690\u85cf\u8d77\u6765\uff08\u4fe1\u606f\u9690\u85cf<\/strong>\uff09\uff1a<\/p>\n
      public class SqlSourceBuilder extends BaseBuilder {\n\n    public SqlSource parse(String originalSql, Class<?> parameterType, Map<String, Object> additionalParameters) {\n        \/\/ \u7528\u4e8e\u5c06\u5360\u4f4d\u7b26\u66ff\u6362\u4e3a ? \u7684 handler\n        ParameterMappingTokenHandler handler = new ParameterMappingTokenHandler(configuration, parameterType,\n                additionalParameters);\n        GenericTokenParser parser = new GenericTokenParser("#{", "}", handler);\n        String sql;\n        \/\/ \u914d\u7f6e\u662f\u5426\u53bb\u6389 SQL \u4e2d\u7684\u7a7a\u683c\n        if (configuration.isShrinkWhitespacesInSql()) {\n            sql = parser.parse(removeExtraWhitespaces(originalSql));\n        } else {\n            \/\/ \u5728\u8fd9\u91cc\u5c06 #{} \u5360\u4f4d\u7b26 \u66ff\u6362\u4e3a ?\uff0c\u5e76\u7531 ParameterMappingTokenHandler \u89e3\u6790\u53c2\u6570\u6620\u5c04\u4fe1\u606f\n            sql = parser.parse(originalSql);\n        }\n        \/\/ \u6700\u7ec8\u53c2\u6570\u6620\u5c04\u4fe1\u606f\u4f1a\u4fdd\u5b58\u5728 StaticSqlSource \u4e2d\n        return new StaticSqlSource(configuration, sql, handler.getParameterMappings());\n    }\n\n}\n<\/code><\/pre>\n
      ParameterMappingTokenHandler<\/code> \u662f SqlSourceBuilder<\/code> \u4e2d\u7684 \u5185\u90e8\u7c7b<\/strong>\uff0c\u5b83\u540c\u6837\u5b9e\u73b0\u4e86 TokenHandler<\/code> \u63a5\u53e3\uff0c\u4e5f\u662f\u4e00\u4e2a\u89e3\u6790\u5de5\u5177\u7c7b\uff0c\u4e0e\u4e0a\u6587\u63d0\u5230\u8fc7\u7684 GenericTokenParser<\/code> \u89e3\u6790\u5668\u7ec4\u5408\u4f7f\u7528\u3002\u5b83\u4f1a\u5c06\u5360\u4f4d\u7b26\u4e2d\u7684\u4fe1\u606f\u89e3\u6790\u4e3a ParameterMapping<\/code> \u4fe1\u606f\uff0c\u5e76\u5c06\u5360\u4f4d\u7b26\u66ff\u6362\u4e3a ? \uff08handleToken<\/code> \u65b9\u6cd5\uff09\uff1a<\/p>\n
      private static class ParameterMappingTokenHandler extends BaseBuilder implements TokenHandler {\n\n    \/\/ \u53c2\u6570\u6620\u5c04\u4fe1\u606f\n    private final List<ParameterMapping> parameterMappings = new ArrayList<>();\n    private final Class<?> parameterType;\n    private final MetaObject metaParameters;\n\n    public ParameterMappingTokenHandler(Configuration configuration, Class<?> parameterType,\n                                        Map<String, Object> additionalParameters) {\n        super(configuration);\n        this.parameterType = parameterType;\n        this.metaParameters = configuration.newMetaObject(additionalParameters);\n    }\n\n    public List<ParameterMapping> getParameterMappings() {\n        return parameterMappings;\n    }\n\n    @Override\n    public String handleToken(String content) {\n        parameterMappings.add(buildParameterMapping(content));\n        return "?";\n    }\n\n    private ParameterMapping buildParameterMapping(String content) {\n        \/\/ \u89e3\u6790\u8868\u8fbe\u5f0f\u4e2d\u7684\u53c2\u6570\u6620\u5c04\u4fe1\u606f\n        Map<String, String> propertiesMap = parseParameterMapping(content);\n        \/\/ \u53c2\u6570\u5b57\u6bb5\n        String property = propertiesMap.get("property");\n        \/\/ ... \u5904\u7406 parameterType \u914d\u7f6e\n        \n        \/\/ ... \u5904\u7406\u5360\u4f4d\u7b26\u53c2\u6570\u4e2d\u6807\u8bb0\u7684 javaType, jdbcType \u7b49\u914d\u7f6e\n        \/\/ ... \u5c01\u88c5 TypeHandler\n        \n    }\n}\n<\/code><\/pre>\n
      ParameterMappingTokenHandler#buildParameterMapping<\/code> \u65b9\u6cd5\u4f1a\u5bf9\u53c2\u6570\u6620\u5c04\u4fe1\u606f\u8fdb\u884c\u5c01\u88c5\uff0c\u5b9e\u9645\u7684\u5360\u4f4d\u7b26\u4e2d\u8868\u8fbe\u5f0f\u7684\u89e3\u6790\u662f\u5728 parseParameterMapping<\/code> \u4e2d\u5b8c\u6210\u7684\uff0c\u4f1a\u7ee7\u7eed\u8c03\u7528\u5230 ParameterExpression<\/code> \u7684\u6784\u9020\u65b9\u6cd5\u5b8c\u6210\u89e3\u6790\uff0cParameterExpression<\/code> \u7ee7\u627f\u4e86 HashMap<\/code>\uff0c\u4f1a\u5c06\u89e3\u6790\u7ed3\u679c\u4ee5\u952e\u503c\u5bf9\u7684\u5f62\u5f0f\u4fdd\u5b58\uff1a<\/p>\n
      public class ParameterExpression extends HashMap<String, String> {\n\n    private static final long serialVersionUID = -2417552199605158680L;\n\n    public ParameterExpression(String expression) {\n        parse(expression);\n    }\n\n    private void parse(String expression) {\n        int p = skipWS(expression, 0);\n        if (expression.charAt(p) == '(') {\n            \/\/ org\/apache\/ibatis\/builder\/SqlSourceBuilder.java:140\uff0cexpression \u8868\u8fbe\u5f0f\u5185\u5bb9\u6682\u4e0d\u652f\u6301\uff0c\u5ffd\u7565\u8fd9\u6bb5\u903b\u8f91\n            expression(expression, p + 1);\n        } else {\n            \/\/ \u53ea\u5173\u6ce8\u8fd9\u91cc\u5373\u53ef\n            property(expression, p);\n        }\n    }\n\n    \/\/ ... \n}\n<\/code><\/pre>\n
      \u53ea\u9700\u5173\u6ce8 property<\/code> \u65b9\u6cd5\u5373\u53ef\uff0c\u5b83\u7684\u4f5c\u7528\u662f\u5bf9\u5360\u4f4d\u7b26\u8868\u8fbe\u5f0f\u4e2d\u7684 javaType, jdbcType, mode, numericScale, resultMap, typeHandler, jdbcTypeName<\/code> \u5c5e\u6027\u8fdb\u884c\u89e3\u6790\uff0c\u5176\u4e2d\u5e38\u7528\u5e38\u89c1\u7684\u662f javaType,jdbcType<\/code>\uff0c\u793a\u4f8b SQL \u4f1a\u88ab\u89e3\u6790\u4e3a\u5982\u4e0b\u5185\u5bb9\u5e76\u4fdd\u5b58\u4e0b\u6765\uff1a<\/p>\n
      {\n  "property": "id",\n  "jdbcType": "INTEGER",\n  "javaType": "int"\n}\n<\/code><\/pre>\n
      \u5927\u5bb6\u53ef\u4ee5\u770b\u4e00\u4e0b ParameterExpression<\/code> \u7684\u5177\u4f53\u5b9e\u73b0\uff0c\u8be5\u7c7b\u7684\u5b9e\u73b0\u9075\u5faa\u4e86\u300a\u4ee3\u7801\u6574\u6d01\u4e4b\u9053\u300b\u4e2d \u6bcf\u4e2a\u65b9\u6cd5\u53ea\u505a\u4e00\u4ef6\u4e8b\uff0c\u4e14\u65b9\u6cd5\u8db3\u591f\u77ed\u5c0f<\/strong> \u7684\u539f\u5219\uff0c\u5e76\u5c06\u65b9\u6cd5\u81ea\u4e0a\u800c\u4e0b\u6392\u5217\uff0c\u8bfb\u8fd9\u4e2a\u7c7b\u7684\u4ee3\u7801\u5c31\u50cf\u8bfb\u62a5\u7eb8\u4e00\u6837\uff0c\u88ab\u4f9d\u8d56\u6b21\u6570\u8d8a\u591a\u7684\u65b9\u6cd5\u8d8a\u9760\u4e0b\uff0c\u8fd9\u4e5f\u6697\u793a \u8d8a\u9760\u8fd1\u7c7b\u4e0b\u65b9\u7684\u65b9\u6cd5\u8d8a\u901a\u7528<\/strong>\u3002<\/p>\n
      SQL \u4e2d\u5360\u4f4d\u7b26\u88ab\u66ff\u6362\u4e3a ?<\/code>\uff0c\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n
      select id, username, password, email, bio, favourite_section from author where id = ?\n<\/code><\/pre>\n
      \u6700\u7ec8\u4f1a\u88ab\u4fdd\u5b58\u5728 StaticSqlSource<\/code> \u4e2d\u7684 sql<\/code> \u5b57\u6bb5\u4e2d\uff0c\u8868\u793a\u5c01\u88c5\u7684\u662f\u9759\u6001 SQL\uff1a<\/p>\n
      public class StaticSqlSource implements SqlSource {\n    \n    \/\/ \u66ff\u6362\u5b8c\u6210 #{} \u5360\u4f4d\u7b26\u7684 SQL \u5185\u5bb9\n    private final String sql;\n    \/\/ \u5df2\u7ecf\u89e3\u6790\u5b8c\u6210\u7684 ParameterMapping \u5bf9\u8c61\n    private final List<ParameterMapping> parameterMappings;\n    private final Configuration configuration;\n\n    \/\/ ...\n}\n<\/code><\/pre>\n
      \u73b0\u5728 RawSqlSource<\/code> \u7684\u6784\u9020\u65b9\u6cd5\u5df2\u6267\u884c\u5b8c\u6bd5\uff0c\u5176\u5185\u90e8\u7ec4\u5408\u7684 SqlSource<\/code> \u5bf9\u8c61\u4e3a StaticSqlSource<\/code>\uff0c\u81f3\u6b64 MappedStatement<\/code> \u4e2d SqlSource<\/code> \u5bf9\u8c61\u7684\u89e3\u6790\u4fbf\u5b8c\u6bd5\u4e86\u3002<\/p>\n
      public class RawSqlSource implements SqlSource {\n    \/\/ StaticSqlSource\n    private final SqlSource sqlSource;\n    \n    \/\/ ...\n}\n<\/code><\/pre>\n
      \u52a8\u6001 SQL \u7684\u89e3\u6790<\/h3>\n
      \u63a5\u4e0b\u6765\u6211\u4eec\u770b\u4e00\u4e2a\u5e26\u6709\u52a8\u6001\u6807\u7b7e\u7684 SQL \u662f\u5982\u4f55\u89e3\u6790\u7684\uff0c\u4ee5 org.apache.ibatis.session.SqlSessionTest#dynamicSqlParse<\/code> \u4e3a\u4f8b\uff0c\u5b83\u7684 SQL \u5982\u4e0b\uff1a<\/p>\n
          <select id="selectAuthor" parameterMap="selectAuthor" resultMap="selectAuthor">\n        select id, username, password, email, bio, favourite_section\n        from author\n        <where>\n            <if test="id != null">\n                id = #{id}\n            <\/if>\n        <\/where>\n    <\/select>\n<\/code><\/pre>\n
      \u5b83\u4f1a\u88ab\u5206\u6210\u4e24\u90e8\u5206\uff0c\u5206\u522b\u4e3a\uff1a<\/p>\n
          <select id="selectAuthor" parameterMap="selectAuthor" resultMap="selectAuthor">\n        select id, username, password, email, bio, favourite_section\n        from author\n    <\/select>\n<\/code><\/pre>\n
      <!—-><\/p>\n
          <where>\n        <if test="id != null">\n            id = #{id}\n        <\/if>\n    <\/where>\n<\/code><\/pre>\n
      \u5bf9\u4e8e\u7b2c\u4e00\u90e8\u5206\u7684\u5904\u7406\u4e0e\u4e0a\u8ff0\u9759\u6001 SQL \u89e3\u6790\u7684\u8fc7\u7a0b\u4e00\u81f4\uff0c\u4e0d\u518d\u8d58\u8ff0\u3002\u7b2c\u4e8c\u90e8\u5206\u662f\u5904\u7406\u5305\u542b\u52a8\u6001\u6807\u7b7e <where><\/code> \u548c <if><\/code> \u7684\u5185\u5bb9\uff0c\u5b83\u4f1a\u6267\u884c\u5230 XMLScriptBuilder#parseDynamicTags<\/code> \u65b9\u6cd5\u7684\u5904\u7406 ELEMENT_NODE<\/code> \u7684\u903b\u8f91\u4e2d\uff1a<\/p>\n
      public class XMLScriptBuilder extends BaseBuilder {\n    \/\/ ...\n    \n    protected MixedSqlNode parseDynamicTags(XNode node) {\n        List<SqlNode> contents = new ArrayList<>();\n\n        NodeList children = node.getNode().getChildNodes();\n        for (int i = 0; i < children.getLength(); i++) {\n            XNode child = node.newXNode(children.item(i));\n            if (child.getNode().getNodeType() == Node.CDATA_SECTION_NODE || child.getNode().getNodeType() == Node.TEXT_NODE) {\n                \/\/ ...\n            } else if (child.getNode().getNodeType() == Node.ELEMENT_NODE) {\n                \/\/ \u6839\u636e node \u8282\u70b9\u540d\u79f0\u9009\u62e9\u5bf9\u5e94\u7684 Handler\n                String nodeName = child.getNode().getNodeName();\n                NodeHandler handler = nodeHandlerMap.get(nodeName);\n                if (handler == null) {\n                    throw new BuilderException("Unknown element <" + nodeName + "> in SQL statement.");\n                }\n                \/\/ \u6307\u5b9a\u5bf9\u5e94\u7684\u5904\u7406\u65b9\u6cd5\n                handler.handleNode(child, contents);\n                isDynamic = true;\n            }\n        }\n\n        return new MixedSqlNode(contents);\n    }\n}\n<\/code><\/pre>\n
      \u5b83\u4f1a\u6839\u636e\u6807\u7b7e\u7c7b\u578b\u83b7\u53d6\u5230\u5bf9\u5e94\u7684 NodeHandler<\/code>\uff0c\u6267\u884c\u76f8\u5e94\u7684\u5904\u7406\u65b9\u6cd5\u3002\u5176\u4e2d\u90e8\u5206 Handler<\/code> \u4f1a\u518d\u8c03\u7528\u5230 XMLScriptBuilder#parseDynamicTags<\/code> \u65b9\u6cd5\uff0c\u51fa\u73b0\u9012\u5f52\u8c03\u7528\uff0c\u4e0d\u8fc7\u5177\u4f53\u7684\u6267\u884c\u8fc7\u7a0b\u76f8\u5bf9\u7b80\u5355\uff0c\u4f46\u4e5f\u9700\u8981\u81ea\u5df1 Debug \u8ddf\u8e2a\u9a8c\u8bc1\u3002<\/p>\n
      \u4e0a\u8ff0 SQL \u88ab\u89e3\u6790\u5b8c\u6210\u540e\uff0cSqlNode<\/code> \u8868\u793a\u4e3a\uff1a
      \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n
      \u518d\u56de\u5230 XMLScriptBuilder#parseScriptNode<\/code> \u65b9\u6cd5\uff1a<\/p>\n
      public class XMLScriptBuilder extends BaseBuilder {\n    \/\/ ...\n    \n    public SqlSource parseScriptNode() {\n        \/\/ \u5c06 xml \u6587\u4ef6\u4e2d\u5b9a\u4e49\u7684 SQL \u89e3\u6790\u6210\u4e0d\u540c\u7684 SqlNode \u5bf9\u8c61\uff0c\u5e76\u90fd\u8bb0\u5f55\u5728 MixedSqlNode \u5bf9\u8c61\u4e2d\n        MixedSqlNode rootSqlNode = parseDynamicTags(context);\n        SqlSource sqlSource;\n        if (isDynamic) {\n            \/\/ \u5305\u542b\u52a8\u6001\u6807\u7b7e\u7684 SQL\n            sqlSource = new DynamicSqlSource(configuration, rootSqlNode);\n        } else {\n            \/\/ ...\n        }\n        return sqlSource;\n    }\n}\n<\/code><\/pre>\n
      \u52a8\u6001 SQL \u4f1a\u88ab\u6807\u8bb0\u4e3a isDynamic == true<\/code>\uff0c\u6700\u7ec8\u4f1a\u88ab\u89e3\u6790\u6210 DynamicSqlSource<\/code> \u5bf9\u8c61\uff0c\u5982\u4e0b\u662f\u5b83\u7684\u6784\u9020\u65b9\u6cd5\uff1a<\/p>\n
      public class DynamicSqlSource implements SqlSource {\n\n    private final Configuration configuration;\n    private final SqlNode rootSqlNode;\n\n    public DynamicSqlSource(Configuration configuration, SqlNode rootSqlNode) {\n        this.configuration = configuration;\n        this.rootSqlNode = rootSqlNode;\n    }\n\n    \/\/ ...\n}\n<\/code><\/pre>\n
      \u975e\u5e38\u7b80\u5355\uff0c\u4ec5\u4ec5\u662f\u8d4b\u503c\u64cd\u4f5c\uff0c\u56e0\u4e3a\u5b83\u662f\u52a8\u6001 SQL\uff0c\u4f1a\u6839\u636e\u5165\u53c2\u751f\u6210 SQL \u4fe1\u606f\u3002\u5230\u8fd9\u91cc\uff0c\u52a8\u6001 SQL \u7684\u89e3\u6790\u64cd\u4f5c\u4e5f\u5b8c\u6210\u4e86\u3002\u4e0b\u9762\u6211\u4eec\u6765\u770b\u4e00\u4e0b\u521b\u5efa MappedStatement<\/code> \u4f7f\u7528\u5230\u7684 \u5efa\u9020\u8005\u6a21\u5f0f<\/strong>\uff1a<\/p>\n
      \u5efa\u9020\u8005\u6a21\u5f0f<\/h3>\n
      \u5728 org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode<\/code> \u65b9\u6cd5\u6267\u884c org.apache.ibatis.builder.MapperBuilderAssistant#addMappedStatement<\/code> \u903b\u8f91\u521b\u5efa MappedStatement<\/code> \u5bf9\u8c61\u65f6\u4f7f\u7528\u4e86 \u5efa\u9020\u8005\u6a21\u5f0f<\/strong>\uff1a<\/p>\n
          public void parseStatementNode() {\n        \/\/ \u5b9a\u4e49\u76f8\u5173\u5b57\u6bb5\u7684\u903b\u8f91...\n  \n        \/\/ \u65b9\u6cd5\u7684\u5165\u53c2\u975e\u5e38\u591a\uff0c\u4e4b\u6240\u4ee5\u80fd\u8fd9\u4e48\u5199\uff0c\u653e\u5f03\u53ef\u590d\u7528\u6027\uff0c\u90a3\u4e48\u8be5\u65b9\u6cd5\u4e0d\u4f1a\u8f7b\u6613\u53d1\u751f\u53d8\u66f4\n        builderAssistant.addMappedStatement(id, sqlSource, statementType, sqlCommandType, fetchSize, timeout, parameterMap,\n                parameterTypeClass, resultMap, resultTypeClass, resultSetTypeEnum, flushCache, useCache, resultOrdered,\n                keyGenerator, keyProperty, keyColumn, databaseId, langDriver, resultSets, dirtySelect);\n    }\n<\/code><\/pre>\n
      \u5b9e\u73b0\u8be5\u6a21\u5f0f\u5bf9\u5e94\u7684\u7c7b\u56fe\u5173\u7cfb\u5982\u4e0b\uff1a
      \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n