{"id":4281,"date":"2018-08-21T14:25:24","date_gmt":"2018-08-21T05:25:24","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=4281"},"modified":"2018-09-26T22:45:40","modified_gmt":"2018-09-26T13:45:40","slug":"dbmoto%e6%9a%97%e5%8f%b7%e5%8c%96%e3%81%97%e3%81%9f%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e5%be%a9%e5%8f%b7%e3%81%97%e4%bf%9d%e5%ad%98%e3%81%99%e3%82%8b%e3%83%87%e3%83%bc%e3%82%bf%e9%80%a3%e6%90%ba","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/4281","title":{"rendered":"[DBMoto]\u6697\u53f7\u5316\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5fa9\u53f7\u3057\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9023\u643a\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/4271\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3067\u306f\u3001\u30c7\u30fc\u30bf\u3092\u6697\u53f7\u5316\u3057\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001\u3053\u306e\u6697\u53f7\u5316\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5fa9\u53f7\u3057\u3066\u30c7\u30fc\u30bf\u9023\u643a\u3092\u884c\u3046\u624b\u6cd5\u30923\u30b9\u30c6\u30c3\u30d7\u3067\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4285\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image-1.png\" alt=\"\" width=\"1933\" height=\"836\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image-1.png 1933w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image-1-300x130.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image-1-768x332.png 768w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image-1-1024x443.png 1024w\" sizes=\"auto, (max-width: 1933px) 100vw, 1933px\" \/><\/a><strong>\u624b\u98061.\u3000\u5fa9\u53f7\u95a2\u6570\u306e\u4f5c\u6210<\/strong><\/p>\n<p>\u6697\u53f7\u5316\u306b\u3088\u308b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u7d39\u4ecb\u3057\u305f\u6642\u3068\u540c\u69d8\u306b\u3001DBMoto\u306e\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u5fa9\u53f7\u3092\u884c\u3046Decrypt\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u4e0b\u8a18\u306fAES\u65b9\u5f0f\u306e\u5fa9\u53f7\u3092\u884c\u3046\u95a2\u6570\u3092\u5b9f\u88c5\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3059\u3002<\/p>\n<pre class=\"brush: cpp; title: ; notranslate\" title=\"\">\r\nusing System;\r\nusing System.Data;\r\nusing DBMotoPublic;\r\nusing DBMotoScript;\r\n\r\nusing System.IO;\r\nusing System.Security.Cryptography;\r\nusing System.Text;\r\n\r\nnamespace DBRS{\r\n\r\n public class GlobalScript : IGlobalScript{\r\n  public static string Decrypt(string cipher, string iv, string key){\r\n   using (RijndaelManaged myRijndael = new RijndaelManaged()){\r\n    myRijndael.BlockSize = 128;\r\n    myRijndael.KeySize = 128;\r\n    myRijndael.IV = Encoding.UTF8.GetBytes(iv);\r\n    myRijndael.Key = Encoding.UTF8.GetBytes(key);\r\n\r\n    ICryptoTransform decryptor = myRijndael.CreateDecryptor(myRijndael.Key, myRijndael.IV);\r\n\r\n    string plain = string.Empty;\r\n    using (MemoryStream mStream = new MemoryStream(System.Convert.FromBase64String(cipher))){\r\n     using (CryptoStream ctStream = new CryptoStream(mStream, decryptor, CryptoStreamMode.Read)){\r\n      using (StreamReader sr = new StreamReader(ctStream)){\r\n       plain = sr.ReadLine();\r\n      }\r\n     }\r\n    }\r\n    return plain;\r\n   }\r\n  }\r\n } \r\n}\r\n<\/pre>\n<p><strong>\u624b\u98062.\u3000\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u8a2d\u5b9a<\/strong><\/p>\n<p>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3059\u308b\u969b\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u8a2d\u5b9a\u306b\u3066\u3001\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u8a18\u8f09\u3057\u305fDecrypt\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3088\u3046\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4282\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1.png\" alt=\"\" width=\"910\" height=\"611\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1.png 910w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-300x201.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-768x516.png 768w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><\/a><\/p>\n<p>\u3082\u3057\u3001\u30b7\u30f3\u30af\u30ed\u30ca\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30e2\u30fc\u30c9\u3067\u3001\u8907\u88fd\u5148\u304b\u3089\u8907\u88fd\u5143\u3078\u306e\u9006\u65b9\u5411\u306e\u8ee2\u9001\u6642\u306b\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u5834\u5408\u306b\u306f\u3001\u4e0b\u8a18\u753b\u50cf\u306e\u8d64\u67a0\u306e\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u9006\u65b9\u5411\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u304c\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4283\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-1.png\" alt=\"\" width=\"889\" height=\"674\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-1.png 889w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-1-300x227.png 300w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image2-1-1-768x582.png 768w\" sizes=\"auto, (max-width: 889px) 100vw, 889px\" \/><\/a><\/p>\n<p><strong>\u624b\u98063.\u3000\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u884c<\/strong><\/p>\n<p>\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u305f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002Decrypt\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306e\u30c7\u30fc\u30bf\u304c\u8907\u88fd\u5148\u30c6\u30fc\u30d6\u30eb\u3067\u5fa9\u53f7\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image3-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4284\" src=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image3-1.png\" alt=\"\" width=\"771\" height=\"779\" srcset=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image3-1.png 771w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image3-1-297x300.png 297w, https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-content\/uploads\/2018\/08\/image3-1-768x776.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/a><\/p>\n<p>\u3053\u306e\u3088\u3046\u306b\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u6697\u53f7\u5316\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u5fa9\u53f7\u3057\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\u307e\u305f\u3001\u53cc\u65b9\u5411\u5dee\u5206\u8ee2\u9001\u30e2\u30fc\u30c9\u306e\u30b7\u30f3\u30af\u30ed\u30ca\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u88fd\u5143\u3067\u306f\u5e73\u6587\u3067\u30c7\u30fc\u30bf\u3092\u3001\u8907\u88fd\u5148\u3067\u306f\u6697\u53f7\u5316\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\u3059\u308b\u3088\u3046\u306a\u904b\u7528\u3082\u53ef\u80fd\u3067\u3059\u3002\u500b\u4eba\u60c5\u5831\u3084\u5927\u5207\u306a\u30c7\u30fc\u30bf\u3092\u4fdd\u7ba1\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u79fb\u884c\u3084\u9023\u643a\u7b49\u3067\u3001\u305c\u3072DBMoto\u3092\u3054\u691c\u8a0e\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.slideshare.net\/slideshow\/embed_code\/key\/FoAACl9aM92ch3\" width=\"595\" height=\"485\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"\/\/www.slideshare.net\/climb_soft\/db-116651245\" title=\"\u91cd\u8981\u306a\u60c5\u5831\u306e\u307f\u6697\u53f7\u5316!DB\u306e\u30c7\u30fc\u30bf\u6f0f\u3048\u3044\u5bfe\u7b56\u624b\u6cd5\u3092\u7d39\u4ecb!!\" target=\"_blank\">\u91cd\u8981\u306a\u60c5\u5831\u306e\u307f\u6697\u53f7\u5316!DB\u306e\u30c7\u30fc\u30bf\u6f0f\u3048\u3044\u5bfe\u7b56\u624b\u6cd5\u3092\u7d39\u4ecb!!<\/a> <\/strong> from <strong><a href=\"\/\/www.slideshare.net\/climb_soft\" target=\"_blank\">Climb, Inc.<\/a><\/strong> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3061\u3089\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30c7\u30fc\u30bf\u3092\u6697\u53f7\u5316\u3057\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001\u3053\u306e\u6697\u53f7\u5316\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5fa9\u53f7\u3057\u3066\u30c7\u30fc\u30bf\u9023\u643a\u3092\u884c\u3046\u624b\u6cd5\u30923\u30b9\u30c6\u30c3\u30d7\u3067\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\u624b\u98061.\u3000\u5fa9\u53f7\u95a2\u6570\u306e\u4f5c\u6210 \u6697\u53f7\u5316\u306b\u3088\u308b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 &hellip; <a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/4281\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-4281","post","type-post","status-publish","format-standard","hentry","category-syniti"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/4281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=4281"}],"version-history":[{"count":7,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/4281\/revisions"}],"predecessor-version":[{"id":4302,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/4281\/revisions\/4302"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=4281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=4281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=4281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}