{"id":2491,"date":"2022-09-28T01:42:47","date_gmt":"2022-09-27T17:42:47","guid":{"rendered":"https:\/\/lonelinerd.com\/?p=2491"},"modified":"2022-10-16T22:09:01","modified_gmt":"2022-10-16T14:09:01","slug":"u3d-net-7","status":"publish","type":"post","link":"https:\/\/lonelinerd.com\/index.php\/2022\/09\/28\/u3d-net-7\/","title":{"rendered":"\u300aUnity3D\u7db2\u7d61\u904a\u6232\u5be6\u8e10\u300b\uff08\u7b2c2\u7248\uff09\u8981\u9ede\u6458\u9304 – \u300c\u901a\u7528\u670d\u52d9\u7aef\u6846\u67b6\u300d"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u66f8\u540d\uff1a<\/b>\u300aUnity3D\u7db2\u7d61\u904a\u6232\u5be6\u8e10\u300b\uff08\u7b2c2\u7248\uff09<\/strong><\/p>

\u4f5c\u8005\uff1a\u7f85\u57f9\u7fbd<\/strong><\/p>

\u6240\u8b80\u7248\u672c\uff1a\u6a5f\u68b0\u5de5\u696d\u51fa\u7248\u793e<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Server Framework Code 7z(Google Drive):<\/strong><\/span><\/h4>

https:\/\/drive.google.com\/file\/d\/1Up5WeOsL9Ug7hXs__wbdGxOLY_qumgXT\/view?usp=sharing<\/a><\/h4>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u901a\u7528\u670d\u52d9\u7aef\u6846\u67b6\u53ca\u5167\u90e8\u908f\u8f2f<\/span><\/strong><\/span><\/h4>

  • \u7e3d\u9ad4\u67b6\u69cb<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t

    • \u670d\u52d9\u7aef\u7a0b\u5e8f\u7684\u5169\u5927\u6838\u5fc3\uff1a<\/span>\u8655\u7406\u5ba2\u6236\u7aef\u6d88\u606f\u3001\u5b58\u5132\u73a9\u5bb6\u6578\u64da<\/span><\/span><\/span><\/p><\/li>

    • \u6a21\u584a\u5283\u5206<\/span><\/p><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t
        • \u7db2\u7d61\u5e95\u5c64<\/span><\/span><\/span>

          • \u8655\u7406\u7db2\u7d61\u9023\u63a5<\/span><\/p><\/li>

          • \u7c98\u5305\u534a\u5305\u8655\u7406\/\u89e3\u6790\u5354\u8b70\u7b49\u7b49<\/span><\/p><\/li>

          • 4\u500b\u90e8\u5206<\/span><\/span><\/span><\/p>

            • \u76e3\u807d\u6d88\u606f<\/span><\/span><\/span>\u4e26\u9032\u884c\u8655\u7406\u7684\u985e\uff08MsgHandler\uff09<\/span><\/p><\/li>

            • \u76e3\u807d\u7db2\u7d61\u4e8b\u4ef6<\/span><\/span><\/span>\u4e26\u9032\u884c\u8655\u7406\u7684\u985e\uff08EventHandler\uff09<\/span><\/p><\/li>

            • \u5b9a\u7fa9\u5ba2\u6236\u7aef\u4fe1\u606f<\/span><\/span><\/span>\u7684ClientState\u985e<\/span><\/p>

              • public<\/span> class<\/span> ClientState<\/span><\/span>
                {<\/span>
                 \u00a0 \u00a0public<\/span> Socket<\/span> socket<\/span>; \/\/\u8207\u5ba2\u6236\u7aef\u9023\u63a5\u7684socket<\/span><\/span>
                 \u00a0 \u00a0public<\/span> ByteArray<\/span> readBuff<\/span> =<\/span> new<\/span> ByteArray<\/span>(); \/\/\u8b80\u7de9\u6c96\u5340<\/span><\/span>
                 \u00a0 \u00a0<\/span>
                 \u00a0 \u00a0public<\/span> long<\/span> lastPingTime<\/span> =<\/span> 0<\/span>; \/\/\u4e0a\u6b21\u5ba2\u6236\u7aef\u767c\u4f86Ping\u7684\u6642\u9593\u8a18\u9304<\/span><\/span>
                 \u00a0 \u00a0public<\/span> Player<\/span> player<\/span>; \/\/\u5c0d\u73a9\u5bb6\u5c0d\u8c61\u7684\u5f15\u7528<\/span><\/span>
                }<\/span><\/pre><\/li><\/ul><\/li>
              • \u8655\u7406Select\u591a\u8def\u8907\u7528<\/span><\/span><\/span>\u7684\u7db2\u7d61\u7ba1\u7406\u5668<\/span><\/p>
                • \u5275\u5efa\u76e3\u807dSocket -> \u7d81\u5b9a\u7aef\u53e3 -> \u958b\u555f\u76e3\u807d -> \u9032\u5165Select\u5faa\u74b0<\/span><\/span><\/span><\/p><\/li>
                • Select\u5faa\u74b0\uff1a\u5224\u65b7Select\u8fd4\u56de\u7684\u53ef\u8b80\u5217\u8868\u4e2d\u7684\u6709\u6548\u5143\u7d20\u662f\u76e3\u807d\u7aef\u9084\u662f\u5ba2\u6236\u7aef\uff0c\u524d\u8005\u4ee3\u8868\u6709\u65b0\u9023\u63a5\uff0c\u5f8c\u8005\u4ee3\u8868\u5ba2\u6236\u7aef\u767c\u4f86\u4e86\u6d88\u606f<\/span><\/p><\/li>
                • public<\/span> static<\/span> void<\/span> StartLoop<\/span>(int<\/span> listenPort<\/span>)<\/span>
                  {<\/span>
                   \u00a0 \u00a0\/\/Socket\u5275\u5efa<\/span><\/span>
                   \u00a0  \/\/...<\/span>
                   \u00a0 \u00a0\/\/\u7d81\u5b9a\u7aef\u53e3
                  <\/span><\/span>    \/\/...
                  <\/span><\/span>    \/\/\u958b\u555f\u76e3\u807d
                      \/\/...
                   \u00a0 \u00a0\/\/Select\u5faa\u74b0<\/span><\/span>
                   \u00a0 \u00a0while<\/span> (true<\/span>)<\/span>
                   \u00a0  {<\/span>
                   \u00a0 \u00a0 \u00a0  \/\/\u91cd\u7f6echeckRead
                  <\/span><\/span>        \/\/...
                   \u00a0 \u00a0 \u00a0 \u00a0Socket<\/span>.Select<\/span>(checkRead<\/span>, null<\/span>, null<\/span>, 1000<\/span>);<\/span>
                   \u00a0 \u00a0 \u00a0 \u00a0for<\/span> (int<\/span> i<\/span> =<\/span> 0<\/span>; i<\/span> <<\/span> checkRead<\/span>.Count<\/span>; i<\/span>++<\/span>)<\/span>
                   \u00a0 \u00a0 \u00a0  {<\/span>
                   \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Socket<\/span> s<\/span> =<\/span> checkRead<\/span>[i<\/span>];<\/span>
                   \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0if<\/span>(s<\/span> ==<\/span> listenfd<\/span>){\/\/\u6709\u65b0\u9023\u63a5}<\/span><\/span>
                   \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0else{\/\/\u5ba2\u6236\u7aef\u767c\u4f86\u6d88\u606f<\/span>}<\/span><\/span>
                   \u00a0 \u00a0 \u00a0  }<\/span>
                   \u00a0  }<\/span>
                  }<\/span><\/pre><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                  \n\t\t\t\t\t\t
                  \n\t\t\t\t\t\t\t
                  \n\t\t\t\t\t
                  \n\t\t\t
                  \n\t\t\t\t\t\t\t
                  \n\t\t\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t\t
                  \n\t\t\t\t
                          • \u65b0\u9023\u63a5\u7684\u8655\u7406<\/span><\/span><\/span><\/p>
                            • \u8abf\u7528Accept\u63a5\u53d7\u5ba2\u6236\u7aef\u9023\u63a5<\/span><\/span><\/span><\/p><\/li>
                            • \u65b0\u5efa\u4e00\u500b\u5ba2\u6236\u7aef\u4fe1\u606f\u5c0d\u8c61\uff0c\u5b58\u5165\u5ba2\u6236\u7aef\u4fe1\u606f\u5217\u8868<\/span><\/span><\/span><\/p><\/li>
                            • public<\/span> static<\/span> void<\/span> ReadListenfd<\/span>(Socket<\/span> listenfd<\/span>)<\/span>
                              {<\/span>
                               \u00a0 \u00a0try<\/span> <\/span>
                               \u00a0  {<\/span>
                               \u00a0 \u00a0 \u00a0 \u00a0\/\/\u65b0\u5efa\u4e00\u500bsocket\u4f86\u63a5\u53d7\u5ba2\u6236\u7aef\u9023\u63a5<\/span><\/span>
                               \u00a0 \u00a0 \u00a0 \u00a0Socket<\/span> clientfd<\/span> =<\/span> listenfd<\/span>.Accept<\/span>();<\/span>
                               \u00a0 \u00a0 \u00a0 \u00a0\/\/\u586b\u5145\u5ba2\u6236\u7aef\u4fe1\u606f\u5217\u8868<\/span><\/span>
                               \u00a0 \u00a0 \u00a0 \u00a0ClientState<\/span> state<\/span> =<\/span> new<\/span> ClientState<\/span>();<\/span>
                               \u00a0 \u00a0 \u00a0 \u00a0state<\/span>.socket<\/span> =<\/span> clientfd<\/span>;<\/span>
                               \u00a0 \u00a0 \u00a0 \u00a0clients<\/span>.Add<\/span>(clientfd<\/span>, state<\/span>);<\/span>
                               \u00a0  }
                              <\/span>    \/\/...
                              }<\/span><\/pre><\/li><\/ul><\/li>
                            • \u5ba2\u6236\u7aef\u7684\u8655\u7406<\/span><\/span><\/span><\/p>
                              • \u8abf\u7528Receive\u63a5\u6536\u6578\u64da\uff0c\u5c07\u6578\u64da\u4fdd\u5b58\u5728\u7de9\u6c96\u5340<\/span><\/span><\/span><\/p><\/li>
                              • \u8655\u7406\u7c98\u5305\u554f\u984c\uff0c\u89e3\u6790\u51fa\u5354\u8b70\u540d\u548c\u5354\u8b70\u9ad4<\/span><\/span><\/span><\/p><\/li>
                              • \u6839\u64da\u5354\u8b70\u540d\u7372\u53d6\u6d88\u606f\uff0c\u4ee5\u5354\u8b70\u9ad4\u70ba\u53c3\u6578\u5206\u767c\u6d88\u606f<\/span><\/span><\/span><\/p><\/li>
                              • public<\/span> static<\/span> void<\/span> ReadClientfd<\/span>(Socket<\/span> clientfd<\/span>)<\/span>
                                {<\/span>
                                 \u00a0 \u00a0\/\/\u63a5\u6536\u6578\u64da\uff0c\u5c07\u6578\u64da\u4fdd\u5b58\u5728\u7de9\u5b58\u5340<\/span><\/span>
                                 \u00a0 \u00a0ClientState<\/span> state<\/span> =<\/span> clients<\/span>[clientfd<\/span>];<\/span>
                                 \u00a0 \u00a0ByteArray<\/span> readBuff<\/span> =<\/span> state<\/span>.readBuff<\/span>;<\/span>
                                 \u00a0 \u00a0int<\/span> count<\/span> =<\/span> 0<\/span>;<\/span>

                                 \u00a0 \u00a0\/\/\u7de9\u5b58\u5340\u4e0d\u5920\u7684\u8655\u7406<\/span><\/span>
                                 \u00a0 \u00a0if<\/span>(readBuff<\/span>.remain<\/span> <=<\/span> 0<\/span>)<\/span>
                                 \u00a0  {<\/span>
                                 \u00a0 \u00a0 \u00a0 \u00a0OnReceiveData<\/span>(state<\/span>);<\/span>
                                 \u00a0 \u00a0 \u00a0 \u00a0readBuff<\/span>.MoveBytes<\/span>();<\/span>
                                 \u00a0  }<\/span>
                                 \u00a0 \u00a0if<\/span>(readBuff<\/span>.remain<\/span> <=<\/span> 0<\/span>)<\/span>
                                 \u00a0  {<\/span>
                                 \u00a0 \u00a0 \u00a0 \u00a0Close<\/span>(state<\/span>);<\/span>
                                 \u00a0 \u00a0 \u00a0 \u00a0return<\/span>;<\/span>
                                 \u00a0  }<\/span>

                                 \u00a0  \/\/\u63a5\u6536\u5ba2\u6236\u7aef\u4fe1\u606f<\/span><\/span>
                                <\/span>    \/\/...

                                 \u00a0 \u00a0\/\/\u6d88\u606f\u8655\u7406
                                <\/span><\/span>    \/\/...
                                 \u00a0 \u00a0OnReceiveData<\/span>(state<\/span>);<\/span>
                                 \u00a0 \u00a0\/\/\u79fb\u52d5\u7de9\u6c96\u5340<\/span><\/span>
                                 \u00a0 \u00a0readBuff<\/span>.CheckAndMoveBytes<\/span>();<\/span>
                                }<\/span><\/pre><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                                \n\t\t\t\t
                                \n\t\t\t\t\t\t\t\t
                                \n\t\t\t\t
                                          • \u6578\u64da\u8655\u7406<\/span><\/span><\/span>
                                            • public<\/span> static<\/span> void<\/span> OnReceiveData<\/span>(ClientState<\/span> state<\/span>)<\/span>
                                              {<\/span>
                                               \u00a0 \u00a0\/\/\u89e3\u6790\u5354\u8b70\u540d
                                              <\/span><\/span>    \/\/...
                                               \u00a0 \u00a0\/\/\u89e3\u6790\u5354\u8b70\u9ad4<\/span><\/span>
                                               \u00a0  \/\/...<\/span>
                                               \u00a0 \u00a0\/\/\u5206\u767c\u6d88\u606f<\/span><\/span>
                                               \u00a0 \u00a0MethodInfo<\/span> mi<\/span> =<\/span> typeof<\/span>(MsgHandler<\/span>).GetMethod<\/span>(protoName<\/span>);<\/span>
                                               \u00a0 \u00a0object<\/span>[] o<\/span> =<\/span> { state<\/span>, msgBase<\/span> };<\/span>
                                               \u00a0 \u00a0if<\/span>(mi<\/span> !=<\/span> null<\/span>)<\/span>
                                               \u00a0  {<\/span>
                                               \u00a0 \u00a0 \u00a0 \u00a0mi<\/span>.Invoke<\/span>(null<\/span>, o<\/span>);<\/span>
                                               \u00a0  }<\/span> \u00a0 <\/span>
                                              \u200b<\/span>
                                               \u00a0 \u00a0\/\/\u7e7c\u7e8c\u8b80\u53d6\u6d88\u606f<\/span><\/span>
                                               \u00a0 \u00a0if<\/span>(readBuff<\/span>.length<\/span> ><\/span> 2<\/span>)<\/span>
                                               \u00a0  {<\/span>
                                               \u00a0 \u00a0 \u00a0 \u00a0OnReceiveData<\/span>(state<\/span>);<\/span>
                                               \u00a0  }<\/span>
                                              }<\/span><\/pre><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                                              \n\t\t\t\t\t\t
                                              \n\t\t\t\t\t\t\t
                                              \n\t\t\t\t\t
                                              \n\t\t\t
                                              \n\t\t\t\t\t\t\t
                                              \n\t\t\t\t\t\t
                                              \n\t\t\t\t
                                              \n\t\t\t\t\t\t\t\t
                                              \n\t\t\t\t
                                                • \u908f\u8f2f\u5c64<\/span><\/span><\/span><\/p>
                                                  • \u6d88\u606f\u8655\u7406<\/span><\/span><\/span><\/p>
                                                    • \u5ba2\u6236\u7aef\u6d88\u606f\/\u540c\u6b65\u8acb\u6c42\u7684\u8655\u7406\/\u628a\u4e00\u4e9b\u6d88\u606f\u8f49\u767c\u7d66\u6240\u6709\u76f8\u95dc\u7684\u5ba2\u6236\u7aef<\/span><\/span><\/span><\/p><\/li><\/ul><\/li>
                                                    • \u4e8b\u4ef6\u8655\u7406<\/span><\/span><\/span><\/p>
                                                      • \u73a9\u5bb6\u9023\u63a5\u4e8b\u4ef6\u7684\u8655\u7406\uff0c\u5982\u4e0a\/\u4e0b\u7dda\u6642\u7684\u521d\u59cb\u5316\u3001\u6578\u64da\u8a18\u9304<\/span><\/span><\/span><\/p><\/li><\/ul><\/li>
                                                      • \u5b58\u5132\u7d50\u69cb<\/span><\/span><\/span><\/p>
                                                        • \u6307\u5b9a\u9700\u8981\u4fdd\u5b58\u7684\u6578\u64da<\/span><\/p><\/li><\/ul><\/li><\/ul><\/li>
                                                        • \u6578\u64da\u5eab\u5e95\u5c64<\/span><\/span><\/span><\/p>
                                                          • \u4fdd\u5b58\/\u8b80\u53d6\u73a9\u5bb6\u6578\u64da<\/span><\/span><\/span><\/p><\/li><\/ul><\/li><\/ul><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                                                            \n\t\t\t\t\t\t
                                                            \n\t\t\t\t\t\t\t
                                                            \n\t\t\t\t\t
                                                            \n\t\t\t
                                                            \n\t\t\t\t\t\t\t
                                                            \n\t\t\t\t\t\t
                                                            \n\t\t\t\t
                                                            \n\t\t\t\t\t\t\t\t
                                                            \n\t\t\t\t
                                                            • \u6d41\u7a0b<\/span><\/p>
                                                              • \u9023\u63a5<\/span><\/span><\/span><\/p>
                                                                • \u9023\u63a5\u672a\u767b\u9304<\/span><\/span><\/span><\/p>
                                                                  • \u5ba2\u6236\u7aef\u8abf\u7528Connect\u9023\u63a5\u670d\u52d9\u7aef<\/span><\/p><\/li>
                                                                  • \u6b64\u6642\u670d\u52d9\u7aef\u4e0d\u77e5\u9053\u73a9\u5bb6\u5177\u9ad4\u662f\u54ea\u500b\u89d2\u8272<\/span><\/span><\/span><\/p><\/li><\/ul><\/li>
                                                                  • \u767b\u9304\u6210\u529f<\/span><\/span><\/span><\/p>
                                                                    • \u5ba2\u6236\u7aef\u767c\u9001\u4e00\u689d\u5305\u542b\u300c\u7528\u6236\u540d\u3001\u5bc6\u78bc\u300d\u7b49\u4fe1\u606f\u7684\u767b\u9304\u5354\u8b70<\/span><\/p><\/li>
                                                                    • \u670d\u52d9\u7aef\u5c0d\u4fe1\u606f\u9032\u884c\u6aa2\u9a57\uff0c\u5c07\u9023\u63a5\u8207\u89d2\u8272\u5c0d\u61c9\uff0c\u5f9e\u6578\u64da\u5eab\u4e2d\u7372\u53d6\u89d2\u8272\u7684\u6578\u64da<\/span><\/span><\/span><\/p><\/li><\/ul><\/li><\/ul><\/li>
                                                                    • \u4ea4\u4e92\uff1a\u96d9\u7aef\u4e92\u901a\u5354\u8b70<\/span><\/span><\/span><\/p>
                                                                      • \u70ba\u4e86\u8b93\u96d9\u7aef\u6e9d\u901a\uff0c\u5354\u8b70\u6587\u4ef6\u9700\u8981\u540c\u6642\u5b58\u5728\u65bc\u670d\u52d9\u7aef\u8207\u5ba2\u6236\u7aef\u4e2d<\/span><\/span><\/span><\/p><\/li><\/ul><\/li>
                                                                      • \u767b\u51fa\uff1a\u73a9\u5bb6\u4e0b\u7dda\uff0c\u6578\u64da\u4fdd\u5b58\u5230\u6578\u64da\u5eab<\/span><\/span><\/span><\/p><\/li><\/ul><\/li>
                                                                      • \u5fc3\u8df3\u6a5f\u5236<\/span><\/span><\/span><\/p>
                                                                        • \u5ba2\u6236\u7aef\u5b9a\u6642\u6703\u5411\u5c07Ping\u5354\u8b70\u767c\u9001\u81f3\u670d\u52d9\u7aef\uff0c\u670d\u52d9\u7aef\u628a\u6536\u5230Ping\u7684\u6642\u9593\u4fdd\u5b58\u8d77\u4f86\uff0c\u7136\u5f8c\u767c\u9001Pong\u5354\u8b70\u56de\u5ba2\u6236\u7aef<\/span><\/span><\/span><\/p>
                                                                          • \/\/\u5ba2\u6236\u7aef\u5217\u8868<\/span><\/span>
                                                                            public<\/span> static<\/span> Dictionary<\/span><<\/span>Socket<\/span>, ClientState<\/span>><\/span> clients<\/span> =<\/span> new<\/span> Dictionary<\/span><<\/span>Socket<\/span>, ClientState<\/span>><\/span>();<\/span>
                                                                            \u200b<\/span>
                                                                            \/\/\u5ba2\u6236\u7aef\u4fe1\u606f\u985e<\/span><\/span>
                                                                            public<\/span> class<\/span> ClientState<\/span><\/span>
                                                                            {<\/span>
                                                                             \u00a0 \u00a0\/\/...<\/span><\/span>
                                                                             \u00a0 \u00a0public<\/span> long<\/span> lastPingTime<\/span> =<\/span> 0<\/span>; \/\/\u6700\u5f8c\u6536\u5230MsgPing\u5354\u8b70\u7684\u6642\u9593<\/span><\/span>
                                                                            }<\/span>
                                                                            \u200b<\/span>
                                                                            \/\/SysMsgHandler.cs <\/span><\/span>
                                                                            \/\/\u670d\u52d9\u7aef\u6536\u5230MsgPing\u5354\u8b70\uff0c\u66f4\u65b0\u8a72\u5ba2\u6236\u7aef\u4e0a\u6b21Ping\u7684\u6642\u9593\uff0c\u56de\u61c9Pong\u81f3\u8a72\u5ba2\u6236\u7aef<\/span><\/span>
                                                                            public<\/span> static<\/span> void<\/span> MsgPing<\/span>(ClientState<\/span> state<\/span>, MsgBase<\/span> msgBase<\/span>)<\/span>
                                                                            {<\/span>
                                                                             \u00a0 \u00a0state<\/span>.lastPingTime<\/span> =<\/span> NetManager<\/span>.GetTimeStamp<\/span>();<\/span>
                                                                             \u00a0 \u00a0MsgPong<\/span> msgPong<\/span> =<\/span> new<\/span> MsgPong<\/span>();<\/span>
                                                                             \u00a0 \u00a0NetManager<\/span>.Send<\/span>(state<\/span>, msgPong<\/span>);<\/span>
                                                                            }<\/span>
                                                                            \u200b<\/span>
                                                                            \/\/NetManager.cs<\/span><\/span>
                                                                            \/\/\u9023\u63a5\u6210\u529f\u6642\u5148\u8a18\u9304\u4e00\u6b21<\/span><\/span>
                                                                            public<\/span> static<\/span> void<\/span> ReadListenfd<\/span>(Socket<\/span> listenfd<\/span>)<\/span>
                                                                            {<\/span>
                                                                             \u00a0 \u00a0\/\/...<\/span><\/span>
                                                                             \u00a0 \u00a0state<\/span>.lastPingTime<\/span> =<\/span> GetTimeStamp<\/span>();<\/span>
                                                                             \u00a0 \u00a0\/\/...<\/span><\/span>
                                                                            }<\/span><\/pre><\/li><\/ul><\/li>
                                                                          • \u670d\u52d9\u7aef\u5b9a\u6642\u5668\u5faa\u74b0\u5c0d\u5ba2\u6236\u7aef\u5217\u8868\u904d\u6b77\u5224\u65b7\u7576\u524d\u6642\u9593 – \u4e0a\u6b21\u5ba2\u6236\u7aef\u767c\u51faPing\u6642\u9593\u662f\u5426\u5df2\u8d85\u6642\uff0c\u662f\u5247\u65b7\u958b\u8a72\u5ba2\u6236\u7aef\u9023\u63a5<\/span><\/span><\/span><\/p>
                                                                            • Timer<\/span><\/p>
                                                                              • static<\/span> void<\/span> Timer<\/span>()<\/span>
                                                                                {<\/span>
                                                                                 \u00a0 \u00a0\/\/\u6d88\u606f\u5206\u767c<\/span><\/span>
                                                                                 \u00a0 \u00a0MethodInfo<\/span> mi<\/span> =<\/span> typeof<\/span>(EventHandler<\/span>).GetMethod<\/span>(\"OnTimer\"<\/span>);<\/span>
                                                                                 \u00a0 \u00a0object<\/span>[] obj<\/span> =<\/span> { };<\/span>
                                                                                 \u00a0 \u00a0mi<\/span>.Invoke<\/span>(null<\/span>, obj<\/span>);<\/span>
                                                                                }<\/span><\/pre><\/li>
                                                                              • public<\/span> partial<\/span> class<\/span> EventHandler<\/span><\/span>
                                                                                {<\/span>
                                                                                 \u00a0 \u00a0public<\/span> static<\/span> void<\/span> OnTimer<\/span>()<\/span>
                                                                                 \u00a0  {<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0\/\/\u5ba2\u6236\u7aef\u5fc3\u8df3\u8d85\u6642\u8655\u7406<\/span><\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0CheckPing<\/span>();<\/span>
                                                                                 \u00a0  }<\/span>
                                                                                \u200b<\/span>
                                                                                 \u00a0 \u00a0\/\/ Ping\u6aa2\u67e5<\/span><\/span>
                                                                                 \u00a0 \u00a0public<\/span> static<\/span> void<\/span> CheckPing<\/span>()<\/span>
                                                                                 \u00a0  {<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0long<\/span> timeNow<\/span> =<\/span> NetManager<\/span>.GetTimeStamp<\/span>();<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0foreach<\/span> (ClientState<\/span> state<\/span> in<\/span> NetManager<\/span>.clients<\/span>.Values<\/span>)<\/span>
                                                                                 \u00a0 \u00a0 \u00a0  {<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0if<\/span>(timeNow<\/span> -<\/span> state<\/span>.lastPingTime<\/span> ><\/span> NetManager<\/span>.pingInterval<\/span> *<\/span> 4<\/span>)<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  {<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0NetManager<\/span>.Close<\/span>(state<\/span>);<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0return<\/span>;<\/span>
                                                                                 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  }<\/span>
                                                                                 \u00a0 \u00a0 \u00a0  }<\/span>
                                                                                 \u00a0  }<\/span>
                                                                                }<\/span><\/pre><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                                                                                \n\t\t\t\t\t\t
                                                                                \n\t\t\t\t\t\t\t
                                                                                \n\t\t\t\t\t
                                                                                \n\t\t\t
                                                                                \n\t\t\t\t\t\t\t
                                                                                \n\t\t\t\t\t\t
                                                                                \n\t\t\t\t
                                                                                \n\t\t\t\t\t
                                                                                \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                                                                                \n\t\t\t\t\t\t
                                                                                \n\t\t\t\t\t\t\t
                                                                                \n\t\t\t\t\t
                                                                                \n\t\t\t
                                                                                \n\t\t\t\t\t\t\t
                                                                                \n\t\t\t\t\t\t
                                                                                \n\t\t\t\t
                                                                                \n\t\t\t\t\t\t\t\t
                                                                                \n\t\t\t\t
                                                                                \u6578\u64da\u5eab\u4ea4\u4e92<\/span><\/strong><\/span><\/h4>
                                                                                • \u73a9\u5bb6\u6578\u64da<\/span><\/p>
                                                                                  • \u5b58\u76e4\u6578\u64da<\/span><\/span><\/span><\/p><\/li>
                                                                                  • \u4e0d\u5b58\u76e4\u6578\u64da<\/span><\/span><\/span><\/p><\/li>
                                                                                  • \u5c0dClientState\u7684\u5f15\u7528<\/span><\/p><\/li>
                                                                                  • \/\/ \u73a9\u5bb6\u6578\u64da\uff08\u5b58\u76e4 + \u4e0d\u5b58\u76e4\uff09<\/span><\/span>
                                                                                    public<\/span> class<\/span> Player<\/span><\/span>
                                                                                    {<\/span>
                                                                                     \u00a0 \u00a0\/\/\u4e0d\u5b58\u76e4\u6578\u64da<\/span><\/span>
                                                                                     \u00a0 \u00a0\/\/...<\/span><\/span>
                                                                                     \u00a0 \u00a0<\/span>
                                                                                     \u00a0 \u00a0\/\/\u5b58\u76e4\u6578\u64da<\/span><\/span>
                                                                                     \u00a0 \u00a0public<\/span> PlayerData<\/span> data<\/span>;<\/span>
                                                                                     \u00a0 \u00a0<\/span>
                                                                                     \u00a0 \u00a0\/\/\u6307\u5411\u6301\u6709\u8a72Player\u7684ClientState\uff0c\u7528\u65bc\u8b93\u5176\u4ed6Player\u901a\u904eid\u4f86\u627e\u5230\u5c0d\u61c9\u7684ClientState\u57f7\u884c\u4e00\u4e9b\u908f\u8f2f\u64cd\u4f5c<\/span><\/span>
                                                                                     \u00a0 \u00a0public<\/span> ClientState<\/span> state<\/span>;<\/span>
                                                                                    }<\/span><\/pre><\/li><\/ul><\/li>
                                                                                  • \u6578\u64da\u5eab\uff08\u4ee5MySQL\u70ba\u4f8b\uff09<\/span><\/span><\/span><\/p>
                                                                                    • \u914d\u7f6e<\/span><\/p>
                                                                                      • \u670d\u52d9\u5668\u88e1\u65b0\u5efa\u9700\u8981\u7684\u6578\u64da\u5eab<\/span><\/span><\/span><\/p><\/li>
                                                                                      • \u670d\u52d9\u7aef\u5de5\u7a0b\u589e\u52a0<\/span>\u5c0d\u6578\u64da\u5eab\u7db2\u683c\u6578\u64da\u9032\u884c\u89e3\u6790\u7684\u5de5\u5177<\/span><\/span><\/span>\u5f15\u7528<\/span><\/p>
                                                                                        • \u5982MySQL\u9700\u8981\u589e\u52a0\u5c0dMysql.Data.dll\u7684\u5f15\u7528\uff08connector\uff09<\/span><\/p><\/li><\/ul><\/li>
                                                                                        • \u555f\u52d5\u670d\u52d9\u5668\uff08\u5982MySQL\uff09\uff0c\u76e3\u807d\u6307\u5b9a\u7aef\u53e3<\/span><\/p><\/li>
                                                                                        • \u7528\u7b2c\u4e09\u65b9\u5eab<\/span>\u7de8\u78bc\u548c\u89e3\u78bcMySQL\u7279\u5b9a\u5f62\u5f0f\u7684\u5354\u8b70<\/span><\/span><\/span><\/p><\/li><\/ul><\/li>
                                                                                        • \u4f8b\u5b50\u5de5\u5177<\/span><\/p>
                                                                                          • Xampp + Navicat for MySQL<\/span><\/p><\/li><\/ul><\/li>
                                                                                          • \u6578\u64da\u5eab\u64cd\u4f5c\u6d41\u7a0b<\/span><\/p>
                                                                                            • \u9023\u63a5\u670d\u52d9\u5668<\/span><\/span><\/span><\/p>
                                                                                              • \/\/\u975c\u614b\u6578\u64da\u5eab\u9023\u63a5\u5c0d\u8c61<\/span><\/span>
                                                                                                public<\/span> static<\/span> MySqlConnection<\/span> mysql<\/span>;<\/span>
                                                                                                \u200b<\/span>
                                                                                                \/\/\u9023\u63a5\u6578\u64da\u5eab<\/span><\/span>
                                                                                                \/\/\u6578\u64da\u5eab\u540d; ip\u5730\u5740; \u6578\u64da\u5eab\u7aef\u53e3\u865f; \u7528\u6236\u540d; \u5bc6\u78bc<\/span><\/span>
                                                                                                public<\/span> static<\/span> bool<\/span> Connect<\/span>(string<\/span> db<\/span>, string<\/span> ip<\/span>, int<\/span> port<\/span>, string<\/span> user<\/span>, string<\/span> password<\/span>)<\/span>
                                                                                                {<\/span>
                                                                                                 \u00a0 \u00a0mysql<\/span> =<\/span> new<\/span> MySqlConnection<\/span>();<\/span>
                                                                                                 \u00a0 \u00a0\/\/\u7d44\u88dd\u9023\u63a5\u4fe1\u606f\u5b57\u7b26\u4e32<\/span><\/span>
                                                                                                 \u00a0 \u00a0string<\/span> s<\/span> =<\/span> string<\/span>.Format<\/span>(\"Database={0}; Data Source={1}; port={2}; User Id={3}; Password={4}\"<\/span>, db<\/span>, ip<\/span>, port<\/span>, user<\/span>, password<\/span>);<\/span>
                                                                                                 \u00a0 \u00a0mysql<\/span>.ConnectionString<\/span> =<\/span> s<\/span>;<\/span>
                                                                                                \u200b<\/span>
                                                                                                 \u00a0 \u00a0\/\/\u5617\u8a66\u9023\u63a5<\/span><\/span>
                                                                                                 \u00a0  mysql<\/span>.Open<\/span>();
                                                                                                <\/span>    \/\/...
                                                                                                }<\/span><\/pre><\/li><\/ul><\/li>
                                                                                              • \u9078\u64c7\u6578\u64da\u5eab<\/span><\/p><\/li>
                                                                                              • \u57f7\u884cSQL\u8a9e\u53e5<\/span><\/span><\/span><\/p>
                                                                                                • \u5275\u5efa\u6307\u4ee4<\/span><\/p>
                                                                                                  • string<\/span> sql<\/span> =<\/span> string<\/span>.Format<\/span>(\"insert into account set id ='{0}', password = '{1}';\"<\/span>, id<\/span>, password<\/span>);<\/span>
                                                                                                    try<\/span><\/span>
                                                                                                    {<\/span>
                                                                                                     \u00a0 \u00a0MySqlCommand<\/span> cmd<\/span> =<\/span> new<\/span> MySqlCommand<\/span>(sql<\/span>, mysql<\/span>);<\/span>
                                                                                                     \u00a0 \u00a0cmd<\/span>.ExecuteNonQuery<\/span>(); \/\/\u57f7\u884c\u975e\u67e5\u8a62\u547d\u4ee4 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  <\/span><\/span>
                                                                                                    }
                                                                                                    \/\/...<\/span><\/pre><\/li><\/ul><\/li>
                                                                                                  • \u9632\u6b62SQL\u6ce8\u5165<\/span><\/span><\/span><\/p>
                                                                                                    • SQL\u6ce8\u5165\uff1a\u901a\u904e\u8f38\u5165\u8acb\u6c42\uff0c\u628aSQL\u547d\u4ee4\u63d2\u5165\u5230SQL\u8a9e\u53e5\u4e2d\uff0c\u6b3a\u9a19\u670d\u52d9\u5668\u57f7\u884c\u60e1\u610fSQL\u547d\u4ee4<\/span><\/span><\/span><\/p><\/li>
                                                                                                    • \/\/\u9632\u6b62SQL\u6ce8\u5165<\/span><\/span>
                                                                                                      private<\/span> static<\/span> bool<\/span> IsSafeString<\/span>(string<\/span> str<\/span>)<\/span>
                                                                                                      {<\/span>
                                                                                                       \u00a0 \u00a0return<\/span> !<\/span>Regex<\/span>.IsMatch<\/span>(str<\/span>, @\"[-|;|,|\\\/|\\(|\\)|\\[|\\]|\\}|\\{|%|@|\\*|!|\\']\"<\/span>);<\/span>
                                                                                                      }<\/span><\/pre><\/li><\/ul><\/li><\/ul><\/li>
                                                                                                    • \u95dc\u9589\u6578\u64da\u5eab<\/span><\/p><\/li><\/ul><\/li>
                                                                                                    • \u57fa\u790e\u529f\u80fd\uff08\u4ee5\u73a9\u5bb6\u6578\u64da\u70ba\u4f8b\uff09<\/span><\/p>
                                                                                                      • \u6ce8\u518a<\/span><\/p>
                                                                                                        • string<\/span> sql<\/span> =<\/span> string<\/span>.Format<\/span>(\"insert into account set id ='{0}', password = '{1}';\"<\/span>, id<\/span>, password<\/span>);<\/span>
                                                                                                          MySqlCommand<\/span> cmd<\/span> =<\/span> new<\/span> MySqlCommand<\/span>(sql<\/span>, mysql<\/span>);<\/span>
                                                                                                          cmd<\/span>.ExecuteNonQuery<\/span>(); \/\/\u57f7\u884c\u975e\u67e5\u8a62\u547d\u4ee4 \u00a0 \u00a0 \u00a0<\/span><\/span><\/pre><\/li><\/ul><\/li>
                                                                                                        • \u5275\u5efa\u89d2\u8272<\/span><\/p>
                                                                                                          • \/\/\u5e8f\u5217\u5316<\/span><\/span>
                                                                                                            PlayerData<\/span> playerData<\/span> =<\/span> new<\/span> PlayerData<\/span>();<\/span>
                                                                                                            string<\/span> data<\/span> =<\/span> js<\/span>.Serialize<\/span>(playerData<\/span>);<\/span>
                                                                                                            \/\/\u5beb\u5165\u6578\u64da\u5eab<\/span><\/span>
                                                                                                            string<\/span> sql<\/span> =<\/span> string<\/span>.Format<\/span>(\"insert into player set id='{0}', data='{1}';\"<\/span>, id<\/span>, data<\/span>);<\/span>
                                                                                                            MySqlCommand<\/span> cmd<\/span> =<\/span> new<\/span> MySqlCommand<\/span>(sql<\/span>, mysql<\/span>);<\/span>
                                                                                                            cmd<\/span>.ExecuteNonQuery<\/span>();<\/span><\/pre><\/li><\/ul><\/li>
                                                                                                          • \u5bc6\u78bc\u6821\u9a57<\/span><\/p>
                                                                                                            • string<\/span> sql<\/span> =<\/span> string<\/span>.Format<\/span>(\"select * from account where id='{0}' and password='{1}';\"<\/span>, id<\/span>, password<\/span>);<\/span>
                                                                                                              MySqlCommand<\/span> cmd<\/span> =<\/span> new<\/span> MySqlCommand<\/span>(sql<\/span>, mysql<\/span>);<\/span>
                                                                                                              MySqlDataReader<\/span> dataReader<\/span> =<\/span> cmd<\/span>.ExecuteReader<\/span>();<\/span>
                                                                                                              bool<\/span> hasRows<\/span> =<\/span> dataReader<\/span>.HasRows<\/span>;<\/span><\/pre><\/li><\/ul><\/li>
                                                                                                            • \u7372\u53d6\u6578\u64da<\/span><\/p>
                                                                                                              • string<\/span> sql<\/span> =<\/span> string<\/span>.Format<\/span>(\"select * from player where id='{0}';\"<\/span>, id<\/span>);<\/span>
                                                                                                                \u200b<\/span>
                                                                                                                MySqlCommand<\/span> cmd<\/span> =<\/span> new<\/span> MySqlCommand<\/span>(sql<\/span>, mysql<\/span>);<\/span>
                                                                                                                MySqlDataReader<\/span> dataReader<\/span> =<\/span> cmd<\/span>.ExecuteReader<\/span>();<\/span>
                                                                                                                \u200b<\/span>
                                                                                                                \/\/\u7121\u6578\u64da<\/span><\/span>
                                                                                                                if<\/span> (!<\/span>dataReader<\/span>.HasRows<\/span>)<\/span>
                                                                                                                {<\/span>
                                                                                                                 \u00a0 \u00a0dataReader<\/span>.Close<\/span>();<\/span>
                                                                                                                 \u00a0 \u00a0return<\/span> null<\/span>;<\/span>
                                                                                                                }<\/span>
                                                                                                                \u200b<\/span>
                                                                                                                \/\/\u8b80\u53d6\u6578\u64da<\/span><\/span>
                                                                                                                dataReader<\/span>.Read<\/span>();<\/span>
                                                                                                                string<\/span> data<\/span> =<\/span> dataReader<\/span>.GetString<\/span>(\"data\"<\/span>);<\/span>
                                                                                                                \/\/\u53cd\u5e8f\u5217\u5316<\/span><\/span>
                                                                                                                PlayerData<\/span> playerData<\/span> =<\/span> js<\/span>.Deserialize<\/span><<\/span>PlayerData<\/span>><\/span>(data<\/span>);<\/span>
                                                                                                                dataReader<\/span>.Close<\/span>();<\/span><\/pre><\/li><\/ul><\/li>
                                                                                                              • \u66f4\u65b0\u6578\u64da<\/span><\/p>
                                                                                                                • \/\/\u5e8f\u5217\u5316<\/span><\/span>
                                                                                                                  string<\/span> data<\/span> =<\/span> js<\/span>.Serialize<\/span>(playerData<\/span>);<\/span>
                                                                                                                  \/\/sql<\/span><\/span>
                                                                                                                  string<\/span> sql<\/span> =<\/span> string<\/span>.Format<\/span>(\"update player set data='{0}' where id='{1}';\"<\/span>, data<\/span>, id<\/span>);<\/span>
                                                                                                                  MySqlCommand<\/span> cmd<\/span> =<\/span> new<\/span> MySqlCommand<\/span>(sql<\/span>, mysql<\/span>);<\/span>
                                                                                                                  cmd<\/span>.ExecuteNonQuery<\/span>();<\/span><\/pre><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul>
                                                                                                                  <\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"
                                                                                                                  \u66f8\u540d\uff1a\u300aUnity3D\u7db2\u7d61\u904a\u6232\u5be6\u8e10\u300b\uff08\u7b2c2\u7248\uff09\u4f5c\u8005\uff1a\u7f85\u57f9\u7fbd \u6240\u8b80\u7248\u672c\uff1a\u6a5f\u68b0\u5de5\u696d\u51fa\u7248\u793e<\/p>\n","protected":false},"author":1,"featured_media":947,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,18,25],"tags":[],"class_list":["post-2491","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-reading-notes","category-developing","category-u3d-net"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/lonelinerd.com\/wp-content\/uploads\/2021\/03\/FeatureCover_ReadingNotes.png","_links":{"self":[{"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/posts\/2491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/comments?post=2491"}],"version-history":[{"count":36,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/posts\/2491\/revisions"}],"predecessor-version":[{"id":2534,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/posts\/2491\/revisions\/2534"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/media\/947"}],"wp:attachment":[{"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/media?parent=2491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/categories?post=2491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lonelinerd.com\/index.php\/wp-json\/wp\/v2\/tags?post=2491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}