{"id":969,"date":"2024-03-20T07:11:46","date_gmt":"2024-03-19T23:11:46","guid":{"rendered":"https:\/\/wp.minicoda.com\/?p=969"},"modified":"2025-05-25T09:09:59","modified_gmt":"2025-05-25T01:09:59","slug":"%e5%90%84%e6%9c%89%e4%b8%8d%e5%90%8c%e7%9a%84%e8%bd%ac%e4%b9%89%e5%ad%97%e7%ac%a6","status":"publish","type":"post","link":"https:\/\/wp.minicoda.com\/index.php\/%e5%90%84%e6%9c%89%e4%b8%8d%e5%90%8c%e7%9a%84%e8%bd%ac%e4%b9%89%e5%ad%97%e7%ac%a6\/","title":{"rendered":"\u5404\u79cd\u4e0d\u540c\u7684\u8f6c\u4e49\u5b57\u7b26"},"content":{"rendered":"\n<p>  \u4ee5\u76ee\u524d\u4e3b\u6d41\u7684\u7f16\u7a0b\u8bed\u8a00\u6765\u770b\uff0c\\\u5b57\u7b26\u4f5c\u4e3a\u901a\u7528\u7684\u8f6c\u4e49\u5b57\u7b26\u3002\u4f46\u5728\u7f16\u7a0b\u8bed\u8a00\u5386\u53f2\u4e0a\uff0c\u8fd9\u5e76\u4e0d\u662f\u552f\u4e00\u9009\u62e9\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li> \u5927\u90e8\u5206\u7f16\u7a0b\u8bed\u8a00\uff0c\u7528\u53cd\u659c\u6760\\\u4f5c\u4e3a\u8f6c\u4e49\u5b57\u7b26\uff0c\u6bd4\u5982'\\n', '\\r', '\\0'\u7b49\u3002<br>C\/ObjC\/C++\/Java\/C#\/Python\/Go\/Swift\/Rust\/JS\/PHP \u7b49<\/li>\n\n\n\n<li>B\u8bed\u8a00\u91c7\u7528*\u4f5c\u4e3a\u8f6c\u4e49\uff0c\u4f8b\u5982*n\u4f5c\u4e3anew line.  \u5373\u5728B\u8bed\u8a00\u4e2d\uff0cputchar('*n');\u4ee3\u8868\u6362\u884c\u3002<\/li>\n\n\n\n<li>VB\u91c7\u7528\u4e86\u4e00\u79cd\u7a0d\u5fae\u4e0d\u540c\u7684\u505a\u6cd5\uff0c\u6ca1\u6709\u8fd9\u79cd\u8f6c\u4e49\u5b57\u7b26\uff0c\u91c7\u7528\u5e38\u6570\u5b9a\u4e49\u6216\u5b57\u7b26\u6570\u503c\u7684\u65b9\u5f0f\u3002<br>\u4f8b\u5982\u6362\u884c\u7b26\u662f<strong>Chr(<\/strong>10<strong>)<\/strong>\u6216\u8005<strong>vbLf<\/strong>.<\/li>\n\n\n\n<li>SQL\u8bed\u8a00\u540c\u6837\u4e5f\u6709\u8f6c\u4e49\u5b57\u7b26\uff0c\u4e0d\u8fc7\u53ef\u901a\u8fc7ESCAPE\u914d\u7f6e\uff0c\u4e0d\u540cSQL\u8bed\u8a00\u8f6c\u4e49\u5b57\u7b26\u6709\u5dee\u522b\uff0c\u6bd4\u5982\u6709\u7684\u7528\u4e24\u4e2a\u5355\u5f15\u53f7\u6216\u4e24\u4e2a\u53cc\u5f15\u53f7\u505a\u8f6c\u4e49\uff0c\u6709\u7684\u7528\u53cd\u659c\u6760\uff0c\u5177\u4f53\u53c2\u7167\u5bf9\u5e94SQL\u8bed\u8a00\u8bf4\u660e\u3002<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6709\u591a\u5c11\u79cd\u8f6c\u4e49\u5b57\u7b26?<\/h3>\n\n\n\n<p>  \u57fa\u672c\u8f6c\u4e49\u5b57\u7b26\uff1a\\a, \\b, \\n, \\r, \\f, \\t, \\v, \\0, \\', \\\", \\\\, \\ddd, \\xhh<br>    \u5176\u4e2d\uff1a\\ddd \u662f\u4e09\u4f4d\u516b\u8fdb\u5236\uff0c\\xhh\u662f\u4e24\u4f4d\u5341\u516d\u8fdb\u5236\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>C\/ObjC\/C++\/PHP \u652f\u6301\u5982\u4e0a\u57fa\u672c\u8f6c\u4e49\u5b57\u7b26\u3002<\/li>\n\n\n\n<li>C# \u652f\u6301\u5982\u4e0a\u57fa\u672c\u8f6c\u4e49\u5b57\u7b26\uff0c\u9664\u4e86\\ddd\u4e0d\u652f\u6301\uff0c\u53e6\u5916\u652f\u6301\\u<strong><em>XXXX<\/em><\/strong>\uff0c\\U<strong><em>XXXXXXXX<\/em><\/strong>\u548c\\x[<strong><em>XXX<\/em><\/strong>]X.<br>\\u\u3001\\U\u548c\\x\u90fd\u6307\u4ee3\u5341\u516d\u8fdb\u5236Unicode\u5b57\u7b26\uff0c\\x\u540e\u9762\u81f3\u5c11\u4e00\u4e2a\u5b57\u8282\uff0c\u524d\u4e09\u4e2a\u5b57\u8282\u53ef\u9009\u3002\n<ul class=\"wp-block-list\">\n<li>\\u\u540e\u9762\u5fc5\u987b\u662f2\u4e2a\u5b57\u8282\u5341\u516d\u8fdb\u5236\uff0c\\U\u540e\u9762\u5fc5\u987b\u662f4\u4e2a\u5b57\u8282\u5341\u516d\u8fdb\u5236\uff0c\\x\u540e\u9762\u5fc5\u987b\u7b26\u5408\u5b57\u7b26\u6240\u5360\u7528\u957f\u5ea6\uff0c\u4e0d\u80fd\u7279\u522b\u8865\u96f6\u3002\u4f8b\u5982'\\x0061'\u5408\u6cd5\uff0c'\\x000061'\u4e0d\u5408\u6cd5\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>PHP\u7684$\u6709\u7279\u6b8a\u542b\u4e49\uff0c\u9700\u8981\u8f6c\u4e49\"\\$\"\u624d\u8868\u8fbe\u5b83\u672c\u8eab\u3002<\/li>\n\n\n\n<li>Kotlin \u652f\u6301\u5982\u4e0a\u57fa\u672c\u8f6c\u4e49\u5b57\u7b26\uff0c\u4f46\\a\uff0c\\0\uff0c\\v\uff0c\\f\u548c\\ddd\u3001\\xhh\u90fd\u4e0d\u652f\u6301\uff0c\u989d\u5916\u652f\u6301 \\$.<\/li>\n\n\n\n<li>\u4ed3\u9889 \u4e0d\u652f\u6301\\a, \\<strong><em>ddd<\/em><\/strong>\u548c\\x<strong><em>hh<\/em><\/strong>, \u989d\u5916\u652f\u6301\\$\u548c\\u{<strong><em>XXXX<\/em><\/strong>}.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">XML\u7684\u8f6c\u4e49\u5b57\u7b26<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>XML \u4e2d\"&gt; &lt; &amp;\"\u662f\u7279\u6b8a\u6807\u8bb0\uff0c\u6570\u636e\u5305\u542b\u8fd9\u4e9b\u5b57\u7b26\u9700\u8981\u7528\u5f62\u5982 \"&amp;gt;\" \u8868\u793a\u3002\u5982\u679c\u6709\u5927\u91cf\u8fd9\u79cd\u5b57\u7b26\uff0c\u53ef\u4ee5\u7528CDATA\u6807\u8bb0\u3002<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u76ee\u524d\u4e3b\u6d41\u7684\u7f16\u7a0b\u8bed\u8a00\u6765\u770b\uff0c\\\u5b57\u7b26\u4f5c\u4e3a\u901a\u7528\u7684\u8f6c\u4e49\u5b57\u7b26\u3002\u4f46\u5728\u7f16\u7a0b\u8bed\u8a00\u5386\u53f2\u4e0a\uff0c\u8fd9\u5e76\u4e0d\u662f\u552f\u4e00\u9009\u62e9\u3002 \u6709\u591a\u5c11\u79cd\u8f6c\u4e49\u5b57\u7b26? \u57fa\u672c\u8f6c\u4e49\u5b57\u7b26\uff1a\\a, \\b, \\n, \\r, \\f, \\t, \\v, \\0, \\', \\&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[299],"tags":[306],"class_list":["post-969","post","type-post","status-publish","format-standard","hentry","category-think","tag-306"],"views":107,"_links":{"self":[{"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/posts\/969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/comments?post=969"}],"version-history":[{"count":13,"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/posts\/969\/revisions"}],"predecessor-version":[{"id":4066,"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/posts\/969\/revisions\/4066"}],"wp:attachment":[{"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/media?parent=969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/categories?post=969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.minicoda.com\/index.php\/wp-json\/wp\/v2\/tags?post=969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}