\u306f\u3058\u3081\u306b\u301cAndroid\u306b\u304a\u3051\u308b\u30bb\u30ad\u30e5\u30a2\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u610f\u7fa9\u301c<\/strong><\/h1>\n\n\n\nAndroid\u306e\u60c5\u52e2<\/h2>\n\n\n\n
\u6628\u4eca\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u5e02\u5834\u306e\u6210\u9577\u304c\u6025\u62e1\u5927\u3057\u3001\u7279\u306bAndroid\u306e\u30e6\u30fc\u30b6\u6570\u304c\u6025\u901f\u306b\u5897\u3048\u3066\u3044\u307e\u3059\u3002
2011\u5e7412\u6708\u306b\u306f\u3001\u516c\u5f0f\u306eAndroidMarket\uff08\u73fe\u5728\u306fGoogle Play\uff09\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30a2\u30d7\u30ea\u306e\u6570\u304c100\u5104\u306b\u9054\u3057\u30012012\u5e749\u6708\u306b\u306f250\u5104\u306b\u9054\u3057\u307e\u3057\u305f\u3002
\u5b9f\u969b\u30012012\u5e74\u306e\u5e74\u521d\u306f1000\u500b\u3060\u3063\u305fAndroid\u4e0d\u6b63\u30a2\u30d7\u30ea\u306f\u3001\u5e74\u672b\u307e\u3067\u306b35\u4e07\u500b\u3078\u3068\u6025\u5897\u3057\u3066\u304a\u308a\u3001PC\u306e\u8105\u5a01\u306e\u5909\u9077\u3068\u6bd4\u3079\u308b\u3068\u7d044\u500d\u306e\u30b9\u30d4\u30fc\u30c9\u3067\u6210\u9577\u3057\u3066\u3044\u307e\u3059\u3002
\u3053\u3046\u3057\u305f\u4e2d\u3067\u3001\u30b5\u30a4\u30d0\u30fc\u72af\u7f6a\u8005\u305f\u3061\u306b\u3068\u3063\u3066Android\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u306f\u300c\u683c\u597d\u306e\u30bf\u30fc\u30b2\u30c3\u30c8\u300d\u3068\u306a\u308b\u3053\u3068\u306f\u9593\u9055\u3044\u3042\u308a\u307e\u305b\u3093\u3002
Android\u30e6\u30fc\u30b6\u306fAndroid\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u69cb\u9020\u3092\u6b63\u3057\u304f\u7406\u89e3\u3057\u3001\u30b5\u30a4\u30d0\u30fc\u72af\u7f6a\u8005\u304b\u3089\u306e\u653b\u6483\u3092\u672a\u7136\u306b\u9632\u3050\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u307e\u305f\u3001Android\u30a2\u30d7\u30ea\u4f5c\u6210\u8005\u3082\u60aa\u610f\u306e\u3042\u308b\u4e0d\u6b63Android\u30a2\u30d7\u30ea\u304b\u3089\u306e\u653b\u6483\u3092\u9632\u3050\u3088\u3046\u30bb\u30ad\u30e5\u30a2\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u77e5\u8b58\u304c\u6c42\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
Android\u5185\u3067\u4fdd\u8b77\u304c\u5fc5\u8981\u306a\u60c5\u5831<\/h2>\n\n\n\n
Android\u7aef\u672b\u3092\u5229\u7528\u3057\u305f\u69d8\u3005\u306a\u30b5\u30fc\u30d3\u30b9\u306e\u4e2d\u306b\u306f\u3001\u500b\u4eba\u60c5\u5831\u3092\u6271\u3046\u3082\u306e\u304c\u5c11\u306a\u304f\u3042\u308a\u307e\u305b\u3093\u3002
\u4f8b\u3048\u3070\u3001\u9023\u7d61\u5148\u30a2\u30d7\u30ea\u306b\u306f\u6c0f\u540d\u3001\u96fb\u8a71\u756a\u53f7\u3001\u4f4f\u6240\u3001email\u30a2\u30c9\u30ec\u30b9\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u307e\u3059\u3002
\u307e\u305f\u3001\u30aa\u30d5\u30a3\u30b9\u7cfb\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u4ed5\u4e8b\u306e\u8cc7\u6599\u3092\u5165\u308c\u3066\u3044\u308b\u5834\u5408\u3082\u3042\u308a\u5f97\u307e\u3059\u3002
\u3053\u308c\u3089\u304cAndroid\u4e0d\u6b63\u30a2\u30d7\u30ea\u306b\u3088\u3063\u3066\u6d41\u51fa\u3057\u3001\u4e0d\u6b63\u306b\u5229\u7528\u3055\u308c\u305f\u5834\u5408\u3001\u500b\u4eba\u3078\u306e\u88ab\u5bb3\u306f\u3082\u3061\u308d\u3093\u306e\u3053\u3068\u3001\u4f1a\u793e\u306b\u5bfe\u3057\u3066\u3082\u640d\u5bb3\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
\u7279\u306b\u4e0a\u8a18\u3067\u6319\u3052\u305f\u300c\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u60c5\u5831\u300d\u306f\u53b3\u91cd\u306b\u7ba1\u7406\u3055\u308c\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u7a2e\u985e\u3068\u611f\u67d3\u7d4c\u8def<\/h2>\n\n\n\n
2012\u5e74\u306b\u4e16\u754c\u3067\u78ba\u8a8d\u3055\u308c\u305fAndroid\u5411\u3051\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u7a2e\u985e\u306b\u306f\u4ee5\u4e0b\u306e\u50be\u5411\u304c\u898b\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
1.\u9ad8\u984d\u6599\u91d1\u304c\u767a\u751f\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u3092\u60aa\u7528\u3059\u308b\u3082\u306e(40%)
2.\u30e6\u30fc\u30b6\u306e\u610f\u56f3\u3057\u306a\u3044\u30a2\u30c9\u30a6\u30a7\u30a2\u3092\u8868\u793a\u3055\u305b\u308b\u3082\u306e(38%)
3.\u60c5\u5831\u3092\u7a83\u53d6\u3059\u308b\u3082\u306e(25%)
4.\u4e0d\u6b63\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3082\u306e(23%)<\/p>
\u203b\u4e0d\u6b63\u30a2\u30d7\u30ea\u306f\u91cd\u8907\u3057\u305f\u7a2e\u985e\u3092\u3082\u3064\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p><\/blockquote>\n\n\n\n
Android\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u7279\u5fb4\u3068\u3057\u3066\u81ea\u52d5\u7684\u306b\u62e1\u6563\u3059\u308b\u30a6\u30a3\u30eb\u30b9\u306f\u307e\u305a\u3042\u308a\u5f97\u307e\u305b\u3093\u3002
\u5f8c\u306e\u7ae0\u3067\u8aac\u660e\u3057\u307e\u3059\u304c\u3001Android\u3067\u306f\u30e6\u30fc\u30b6\u304c\u660e\u793a\u7684\u306b\u300c\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u300d\u3092\u8a2d\u5b9a\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u306a\u3051\u308c\u3070\u3001Android\u30a2\u30d7\u30ea\u3092\u5229\u7528\u3067\u304d\u306a\u3044\u69cb\u9020\u306b\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3067\u3059\u3002
\u305d\u306e\u305f\u3081\u3001Android\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u6b86\u3069\u306f\u30e6\u30fc\u30b6\u81ea\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u611f\u67d3\u3057\u307e\u3059\u3002
\u5f93\u3063\u3066\u3001\u4e00\u822c\u7684\u306bAndroid\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u611f\u67d3\u7d4c\u8def\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3082\u306e\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
1.Google Play\u306a\u3069\u306e\u3055\u307e\u3056\u307e\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b9\u30c8\u30a2\u304b\u3089\u4e0d\u6b63\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b
2.\u30e1\u30fc\u30eb\u306b\u6dfb\u4ed8\u3055\u308c\u305f\u4e0d\u6b63\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b
3.USB\u63a5\u7d9a\u3057\u305fPC\u304b\u3089\u4e0d\u6b63\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff08adb\u30b7\u30a7\u30eb\u3092\u7d4c\u7531\uff09<\/p><\/blockquote>\n\n\n\n
Android\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30a4\u30f3\u30b7\u30c7\u30f3\u30c8<\/h2>\n\n\n\n
\u3053\u3053\u3067\u306f\u3001Android\u3067\u767a\u751f\u3057\u305f\u4ee3\u8868\u7684\u306a\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30a4\u30f3\u30b7\u30c7\u30f3\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
DroidDreamLight(2011.6)<\/h3>\n\n\n\n
Android\u7aef\u672b\u3092\u72d9\u3046\u969b\u306b\u3088\u304f\u4f7f\u308f\u308c\u308b\u306e\u304c\u300cDroidDreamLight\u300d\u3067\u3059\u3002
DroidDreamLight\u306fAndroid\u7aef\u672b\u5411\u3051\u306e\u5404\u7a2e\u30a2\u30d7\u30ea\u3092\u30c8\u30ed\u30a4\u306e\u6728\u99ac\u5316\u3057\u3001\u516c\u5f0f\u30de\u30fc\u30b1\u30c3\u30c8(Google Play\u7b49)\u306b\u516c\u958b\u3057\u307e\u3059\u3002
\u30e6\u30fc\u30b6\u306f\u516c\u5f0f\u30de\u30fc\u30b1\u30c3\u30c8\u304b\u3089\u30c8\u30ed\u30a4\u306e\u6728\u99ac\u5316\u3055\u308c\u305f\u30a2\u30d7\u30ea\u3092\u81ea\u5206\u306e\u7aef\u672b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u3067\u611f\u67d3\u3057\u307e\u3059\u3002
\u611f\u67d3\u5f8c\u3001\u30e6\u30fc\u30b6\u7aef\u672b\u304b\u3089\u500b\u4eba\u60c5\u5831\u7b49\u304c\u6d41\u51fa\u3057\u307e\u3059\u3002
2011\u5e746\u6708\u306b\u78ba\u8a8d\u3055\u308c\u305f\u4ee5\u5f8c\u3082\u4e9c\u7a2e\u304c\u6b21\u3005\u3068\u767b\u5834\u3057\u3001\u60c5\u5831\u53ce\u96c6\u6a5f\u80fd\u7b49\u304c\u3088\u308a\u5206\u304b\u308a\u96e3\u304f\u306a\u3063\u3066\u304a\u308a\u3001\u691c\u51fa\u304c\u56f0\u96e3\u306b\u306a\u3063\u3066\u304d\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
Skype(2011.4)<\/h3>\n\n\n\n
\u60aa\u8cea\u306a\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3\u30fc\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092Android\u7aef\u672b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u3001\u7aef\u672b\u306b\u4fdd\u5b58\u3055\u308c\u305fSkype\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u3068\u306a\u308b\u8106\u5f31\u6027\u304c\u767a\u898b\u3055\u308c\u307e\u3057\u305f\u3002
\u6d41\u51fa\u306e\u6050\u308c\u304c\u3042\u308b\u60c5\u5831\u306b\u306f\u3001Skype\u306b\u767b\u9332\u3057\u305f\u500b\u4eba\u60c5\u5831\u3001Skype\u30b3\u30f3\u30bf\u30af\u30c8\u60c5\u5831\u3001\u30c1\u30e3\u30c3\u30c8\u5c65\u6b74\u306a\u3069\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u542b\u307e\u308c\u307e\u3059\u3002
\u3053\u308c\u306fSkype\u304cAndoidOS\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u3067\u4fdd\u8b77\u3055\u308c\u306a\u3044\u5834\u6240\u306b\u60c5\u5831\u3092\u4fdd\u5b58\u3057\u3066\u3044\u308b\u3053\u3068\u3067\u767a\u751f\u3057\u307e\u3057\u305f\u3002
\u203b\u73fe\u5728\u306f\u4fee\u6b63\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
Geinimi(2010.12)<\/h3>\n\n\n\n
\u300cGeinimi\u300d\u306f\u3001Android OS\u3092\u642d\u8f09\u3057\u305f\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u3084\u60c5\u5831\u7aef\u672b\u3092\u6a19\u7684\u3068\u3057\u305f\u30dc\u30c3\u30c8\u578b\u306e\u30a6\u30a3\u30eb\u30b9\u3067\u3059\u3002
\u3053\u306e\u30a6\u30a3\u30eb\u30b9\u306f\u3001\u8907\u6570\u306e\u611f\u67d3\u3057\u305f\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u540c\u58eb\u3067\u300c\u30dc\u30c3\u30c8\u30cd\u30c3\u30c8\u300d\u3092\u69cb\u6210\u3059\u308b\u300c\u30dc\u30c3\u30c8\u300d\u578b\u306e\u30a6\u30a3\u30eb\u30b9\u306e\u4e00\u7a2e\u3067\u3059\u3002
\u611f\u67d3\u3059\u308b\u3068\u3001\u60aa\u610f\u3042\u308b\u72af\u7f6a\u8005\u306e\u6307\u4ee4\u306b\u5fdc\u3058\u3066\u610f\u56f3\u3057\u306a\u3044\u96fb\u8a71\u767a\u4fe1\u3084\u30e1\u30fc\u30eb\u306e\u9001\u53d7\u4fe1\u3001\u500b\u4eba\u60c5\u5831\u306e\u6f0f\u3048\u3044\u306a\u3069\u306e\u88ab\u5bb3\u3092\u5f15\u304d\u8d77\u3053\u3059\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
\u72ec\u7acb\u884c\u653f\u6cd5\u4eba\u3000\u60c5\u5831\u51e6\u7406\u63a8\u9032\u6a5f\u69cb(IPA)\u306b\u3088\u308b\u3068\u3001Geinimi\u306f2010\u5e74\u672b\u9803\u3088\u308a\u78ba\u8a8d\u3055\u308c\u307e\u3057\u305f\u304c\u3001Android\u3092\u6a19\u7684\u3068\u3057\u305f\u30dc\u30c3\u30c8\u578b\u30a6\u30a3\u30eb\u30b9\u304c\u78ba\u8a8d\u3055\u308c\u305f\u306e\u306f\u521d\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002
\u73fe\u5728\u3067\u3082\u4e2d\u56fd\u3092\u4e2d\u5fc3\u306b\u51fa\u56de\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
Droid09(2010.1)<\/h3>\n\n\n\n
\u300cDroid09\u300d\u3068\u3044\u3046\u533f\u540d\u306e\u958b\u767a\u8005\u304c\u3001\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30f3\u30ad\u30f3\u30b0\u30a2\u30d7\u30ea\u306b\u898b\u305b\u304b\u3051\u3066\u4f5c\u6210\u3057\u305f\u3082\u306e\u3067\u3059\u3002
\u5b9f\u5728\u306e\u91d1\u878d\u6a5f\u95a2\u540d\u3092\u304b\u305f\u308a\u3001Android Market Place\uff08\u73fe\u5728\u306eGoogle Play\uff09\u3067\u8ca9\u58f2\u3057\u3066\u3044\u307e\u3057\u305f\u3002
\u540d\u524d\u3092\u4f7f\u308f\u308c\u305f\u91d1\u878d\u6a5f\u95a2\u306f\u7c73\u56fd\u306e\u9280\u884c\u3084\u4fe1\u7528\u7d44\u5408\u306a\u3069\u591a\u6570\u306b\u4e0a\u308a\u3001\u3044\u305a\u308c\u3082\u30a2\u30d7\u30ea\u306f\u7121\u8a31\u53ef\u3067\u958b\u767a\u3055\u308c\u305f\u3082\u306e\u3067\u3001Android\u7aef\u672b\u4e0a\u3067\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30f3\u30ad\u30f3\u30b0\u306eWeb\u753b\u9762\u3092\u958b\u304f\u3060\u3051\u3067\u3001\u5b9f\u969b\u306e\u53d6\u5f15\u306b\u306f\u5229\u7528\u3067\u304d\u305a\u3001\u30e6\u30fc\u30b6\u540d\u3084\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3069\u306e\u60c5\u5831\u304c\u76d7\u307f\u51fa\u3055\u308c\u305f\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
<\/p>\n\n\n\n
Android\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3<\/h1>\n\n\n\nAndroid\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u69cb\u6210\u3059\u308b\u5404\u8981\u7d20<\/h2>\n\n\n\n\u7f72\u540d<\/h3>\n\n\n\n
\u3059\u3079\u3066\u306eAndroid\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u8a3c\u660e\u66f8\u3067\u306e\u7f72\u540d\u304c\u5fc5\u8981\u3067\u3001\u305d\u306e\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u9375\u306f\u958b\u767a\u8005\u304c\u4fdd\u7ba1\u3057\u307e\u3059\u3002(\u81ea\u5df1\u8a3c\u660e\u66f8)
\u7f72\u540d\u304c\u306a\u3044\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3001\u8d77\u52d5\u304c\u3067\u304d\u305a\u3001\u307e\u305fGoogle Play\u3067\u306e\u516c\u958b\u3082\u3067\u304d\u307e\u305b\u3093\u3002
(Eclipse\u3067\u8d77\u52d5\u3067\u304d\u308b\u306e\u306f\u3001ADT[Android Development Tools]\u304c\u81ea\u52d5\u3067\u7f72\u540d\u3092\u884c\u306a\u3063\u3066\u3044\u308b\u70ba)<\/p>\n\n\n\n
\u7f72\u540d\u306e\u76ee\u7684<\/h4>\n\n\n\n
\u30fb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u4f5c\u6210\u8005\u3092\u8b58\u5225 (\u540c\u3058\u7f72\u540d\u3067\u306f\u306a\u3044\u3068\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u51fa\u6765\u306a\u3044\u306a\u3069)
\u30fbsharedUserId\u3092\u4f7f\u3063\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u9023\u643a (\u8a73\u3057\u304f\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u9023\u643a)<\/p>\n\n\n\n
\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9<\/h3>\n\n\n\n
Android \u306f\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u3068\u3044\u3046\u6982\u5ff5\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u3092\u5f37\u5236\u7684\u306b\u5206\u96e2\u3057\u3066\u3044\u307e\u3059\u3002
\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\uff08sandbox\uff1a\u7802\u7bb1\uff0c\u7802\u5834 \uff09\uff1a \u5916\u90e8\u304b\u3089\u53d7\u3051\u53d6\u3063\u305f\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4fdd\u8b77\u3055\u308c\u305f\u9818\u57df\u3067\u52d5\u4f5c\u3055\u305b\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u30b7\u30b9\u30c6\u30e0\u304c\u4e0d\u6b63\u306b\u64cd\u4f5c\u3055\u308c\u308b\u306e\u3092\u9632\u3050\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30e2\u30c7\u30eb\u306e\u3053\u3068\u3067\u3059\u3002
\u5b9f\u884c\u3055\u308c\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u4fdd\u8b77\u3055\u308c\u305f\u9818\u57df\u306b\u5165\u308a\u3001\u307b\u304b\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3084\u30c7\u30fc\u30bf\u306a\u3069\u3092\u64cd\u4f5c\u3067\u304d\u306a\u3044\u72b6\u614b\u306b\u3055\u308c\u3066\u52d5\u4f5c\u3059\u308b\u305f\u3081\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u66b4\u8d70\u3057\u305f\u308a\u30a6\u30a4\u30eb\u30b9\u3092\u52d5\u4f5c\u3055\u305b\u3088\u3046\u3068\u3057\u3066\u3082\u30b7\u30b9\u30c6\u30e0\u306b\u5f71\u97ff\u304c\u53ca\u3070\u306a\u3044\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\u30e6\u30fc\u30b6ID<\/h3>\n\n\n\n
\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305fAndroid\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u306f\u3001\u305d\u308c\u305e\u308c\u4e00\u610f\u306e Linux \u30e6\u30fc\u30b6ID \u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u5bfe\u5fdc\u3059\u308b\u56fa\u6709\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002
\u3053\u308c\u306b\u3088\u308a\u3001\u4ed6\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u4e92\u3044\u306b\u5f71\u97ff\u3092\u53ca\u307c\u3055\u306a\u3044\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u5316\u304c\u306a\u3055\u308c\u307e\u3059\u3002
\u3053\u306e\u30e6\u30fc\u30b6ID \u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30c7\u30d0\u30a4\u30b9\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b\u3068\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30c7\u30d0\u30a4\u30b9\u4e0a\u306b\u751f\u5b58\u3057\u3066\u3044\u308b\u9593\u3001\u56fa\u5b9a\u5024\u3068\u3057\u3066\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002
<\/p>\n\n\n\n
\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u5916\u306e\u30ea\u30bd\u30fc\u30b9\u306b\u5bfe\u3059\u308b\u30a2\u30af\u30bb\u30b9\u65b9\u6cd5<\/h2>\n\n\n\n\u30c7\u30d0\u30a4\u30b9\u306e\u4fdd\u8b77\u3055\u308c\u305f\u6a5f\u80fd\u3084\u30ea\u30bd\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9<\/h3>\n\n\n\n\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3(users-permission)<\/h4>\n\n\n\n
\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30fb\u30d5\u30a1\u30a4\u30eb(AndroidManifest.xml)\u3092\u901a\u3058\u3066\u3001\u30c7\u30d0\u30a4\u30b9\u306e\u4fdd\u8b77\u3055\u308c\u305f\u6a5f\u80fd\u3084\u30ea\u30bd\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u3092\u8981\u6c42\u3057\u307e\u3059\u3002(\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u4e00\u5207\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u307e\u305b\u3093)
\u3053\u306e\u8981\u6c42\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u8868\u793a\u3055\u308c\u3001\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u307e\u305f\u306f\u62d2\u5426\u3092\u30e6\u30fc\u30b6\u30fc\u306b\u3088\u3063\u3066\u6c7a\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u9023\u643a<\/h3>\n\n\n\nContentProvider<\/h4>\n\n\n\n
Android\u306b\u306f\u3001ContentProvider\u3092\u7d4c\u7531\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u3067\u60c5\u5831\u5171\u6709\u3067\u304d\u308b\u4ed5\u7d44\u307f\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002
ContentProvider\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u5f8c\u306e\u7ae0\u3067\u8a73\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
sharedUserId (\u30e6\u30fc\u30b6\u30fcID\u306e\u5171\u6709)<\/h4>\n\n\n\n
\u7570\u306a\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u540c\u3058\u30e6\u30fc\u30b6ID\u3092\u5272\u308a\u5f53\u3066\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u3059\u3079\u3066\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u304a\u4e92\u3044\u306b\u8aad\u307f\u66f8\u304d\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002
\u30e6\u30fc\u30b6\u30fcID\u3092\u5171\u6709\u3059\u308b\u306b\u306f\u4ee5\u4e0b\u306e\u6761\u4ef6\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002
\u30fb\u540c\u3058\u7f72\u540d\u3092\u53d7\u3051\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u3042\u308b\u3053\u3068
\u30fbAndroidManaifest.xml\u5185\u3067\u3001\u540c\u3058android:sharedUserId\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u3053\u3068<\/p>\n\n\n\n
\u30d5\u30a1\u30a4\u30eb\u751f\u6210\u6642\u306e\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u6307\u5b9a<\/h4>\n\n\n\n
openFileOutput()\u3001getSharedPreferences()\u3001openOrCreateDatabase()\u306a\u3069\u3067\u30d5\u30a1\u30a4\u30eb\u3092\u751f\u6210\u3059\u308b\u969b\u3001\u4ee5\u4e0b\u306e\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u30d5\u30e9\u30b0\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u4ed6\u306e\u30a2\u30d7\u30ea\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u3092\u5236\u5fa1\u3067\u304d\u307e\u3059\u3002
\u30fbMODE_PRIVATE : \u30a2\u30af\u30bb\u30b9\u4e0d\u53ef\u30e2\u30fc\u30c9(\u30c7\u30d5\u30a9\u30eb\u30c8)
\u30fbMODE_WORLD_READABLE : \u8aad\u307f\u8fbc\u307f\u53ef\u80fd\u30e2\u30fc\u30c9
\u30fbMODE_WORLD_WRITEABLE : \u66f8\u304d\u8fbc\u307f\u53ef\u80fd\u30e2\u30fc\u30c9
\u307e\u305f\u3001”| “\u3092\u4f7f\u7528\u3057\u3066\u3001\u8907\u6570\u306e\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059(\uff0a\u6ce8\u610f : \u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u304c\u885d\u7a81\u3057\u305f\u5834\u5408\u3001\u7de9\u3044\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u304c\u512a\u5148\u3055\u308c\u307e\u3059)\u3002
\u203b\u305f\u3060\u3057\u3001\u4e0d\u7279\u5b9a\u591a\u6570\u3078\u306e\u8a2d\u5b9a\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
SQLite\u3092\u7528\u3044\u305fAndroid\u30a2\u30d7\u30ea\u306e\u30c7\u30fc\u30bf\u7ba1\u7406\u65b9\u6cd5<\/h1>\n\n\n\nSQLite\u3068Android\u30a2\u30d7\u30ea\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u65b9\u6cd5<\/h2>\n\n\n\nSQLite<\/h3>\n\n\n\n
SQLite\u3068\u306f\u3001\u30b5\u30fc\u30d0\u3068\u3057\u3066\u3067\u306f\u306a\u304f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u7d44\u307f\u8fbc\u3093\u3067\u4f7f\u7528\u3059\u308b\u8457\u4f5c\u6a29\u30d5\u30ea\u30fc\u3067\u8efd\u91cf\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002
SQLite\u306f\u975e\u5e38\u306b\u8efd\u91cf\u3067\u9ad8\u901f\u3067\u3042\u308b\u305f\u3081\u3001Android\u3067\u3082\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5185\u90e8\u30c7\u30fc\u30bf\u3092\u7ba1\u7406\u3059\u308b\u305f\u3081\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3068\u3057\u3066\u3001\u6a19\u6e96\u3067\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
Android\u30a2\u30d7\u30ea\u304b\u3089\u306eSQLite\u306e\u5229\u7528\u65b9\u6cd5<\/h3>\n\n\n\n
Android\u3067SQLite\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u3001SQLiteOpenHelper\u3092\u7d99\u627f\u3057\u305fHelper\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
SQLite\u3068ContentProvider<\/h3>\n\n\n\n
Android\u3067\u306f\u3001\u901a\u5e38\u306fSQLite\u306e\u30c7\u30fc\u30bf\u3082\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u56fa\u6709\u306e\u5185\u90e8\u30c7\u30fc\u30bf\u3068\u3057\u3066\u7ba1\u7406\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u5916\u90e8\u30a2\u30d7\u30ea\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\u5f93\u3063\u3066\u3001\u8907\u6570\u306e\u30a2\u30d7\u30ea\u3067\u5171\u901a\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u3001ContentProvider\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
ContentProvider\u5229\u7528\u6642\u306b\u304a\u3051\u308bSQL Injection\u5bfe\u7b56<\/h1>\n\n\n\nContentProvider\u5229\u7528\u306b\u304a\u3051\u308b\u554f\u984c\u70b9<\/h2>\n\n\n\n
\u4ee5\u4e0b\u306f\u3001\u4f1a\u8b70\u5ba4\u4e88\u7d04\u30c7\u30fc\u30bf\u3092\u7ba1\u7406\u3059\u308b\u30a2\u30d7\u30ea\u3068\u3001\u305d\u306e\u7ba1\u7406\u30c7\u30fc\u30bf\u3092\u7167\u4f1a\u3059\u308b\u6a5f\u80fd\u3092\u6301\u3064\u30a2\u30d7\u30ea\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002
SampleApp\u3067\u4f5c\u6210\u3057\u305f\u4f1a\u8b70\u5ba4\u4e88\u7d04DB\u306e\u5185\u5bb9\u3092ContentProvider\u3092\u901a\u3058\u3066MalwareApp\u3067\u53c2\u7167\u3057\u307e\u3059\u304c\u3001\u305d\u306e\u969b\u3001\u610f\u56f3\u7684\u306bSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u3092\u7528\u3044\u3066\u3001SampleApp\u5074\u3067\u60f3\u5b9a\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u30c7\u30fc\u30bf\u3082\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
SampleApp<\/h3>\n\n\n\n
\u3010helper\u30af\u30e9\u30b9\u3011<\/p>\n\n\n\n
[java]\npublic class SampleDBHelper extends SQLiteOpenHelper {\n \/**\n * \u30b3\u30f3\u30b9\u30c8\u30e9\u30af\u30bf\n * @param context\n *\/\n public SampleDBHelper(Context context) {\n \/\/ \u4efb\u610f\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u540d\u3068\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u6307\u5b9a\u3059\u308b\n super(context, "sample.db", null, 1);\n }\n\n \/**\n * \u3053\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u521d\u3081\u3066\u4f7f\u7528\u3059\u308b\u6642\u306b\u5b9f\u884c\u3055\u308c\u308b\u51e6\u7406\n *\/\n @Override\n public void onCreate(SQLiteDatabase db) {\n db.execSQL(\n "create table schedule_tbl ("\n + "_id INTEGER primary key autoincrement not null, "\n + "title TEXT, "\n + "content TEXT, "\n + "date TEXT, "\n + "place TEXT, "\n + "timestamp TEXT );");\n db.execSQL(\n "create table user_tbl ("\n + "_id INTEGER primary key autoincrement not null, "\n + "name TEXT, "\n + "phone TEXT, "\n + "email TEXT, "\n + "timestamp TEXT );");\n }\n}\n[\/java]<\/pre>\n\n\n\n\u3010\u8106\u5f31\u6027\u306e\u3042\u308bContentProvider\u3011<\/p>\n\n\n\n
[java]\npublic class SampleWeakProvider extends ContentProvider {\n\n SampleDBHelper databaseHelper;\n\n @Override\n public boolean onCreate() {\n databaseHelper = new SampleDBHelper(getContext());\n return true;\n }\n\n @Override\n public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {\n SQLiteDatabase db = databaseHelper.getReadableDatabase();\n SQLiteQueryBuilder qb = new SQLiteQueryBuilder();\n qb.setTables("schedule_tbl");\n projection = new String[] { "title", "content", "date" };\n selection = "content LIKE '%" + selectionArgs[0] + "%'";\n selectionArgs = null;\n Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, null);\n return c;\n }\n}\n[\/java]<\/pre>\n\n\n\nMalwareApp<\/h3>\n\n\n\n
\u3010\u547c\u3073\u51fa\u3057\u5143\u3011<\/p>\n\n\n\n
[java]\npublic class MainActivity extends Activity {\n\n private static final int REQ = 1;\n\n @Override\n protected void onCreate(Bundle savedInstanceState) {\n super.onCreate(savedInstanceState);\n setContentView(R.layout.activity_main);\n\n Button btn2 = (Button) this.findViewById(R.id.button2);\n btn2.setOnClickListener(new View.OnClickListener() {\n @Override\n public void onClick(View arg0) {\n \/\/ \u3053\u3053\u3067\u7b2c4\u5f15\u6570(selectionArgs)\u306b\u4e0d\u6b63\u306aSQL\u3092\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\n String keyword = "a%' or 1 = 1) UNION ALL select name, phone, email from user_tbl where ('%' = '";\n Uri contentUri = Uri.parse("content:\/\/jp.co.opentone.fsol.sampleweakprovider");\n\n try {\n Cursor cur = getContentResolver().query(contentUri, null,\n null, new String[] { keyword },\n null);\n\n StringBuilder sb = new StringBuilder();\n sb.append("----------");\n while (cur.moveToNext()) {\n sb.append(cur.getString(0));\n sb.append(" \/ ");\n sb.append(cur.getString(1));\n sb.append(" \/ ");\n sb.append(cur.getString(2));\n sb.append("\\n");\n }\n sb.append("----------");\n TextView txt = (TextView) findViewById(R.id.textView1);\n txt.setText(sb.toString());\n } catch (Exception e) {\n TextView txt = (TextView) findViewById(R.id.textView1);\n txt.setText(e.getMessage());\n }\n }\n });\n}\n[\/java]<\/pre>\n\n\n\nContentProvider\u3092\u4f7f\u3063\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u9023\u4fc2\u3092\u5b9f\u73fe\u3059\u308b\u5834\u5408\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u5148\u3067\u3042\u308b\u547c\u3073\u51fa\u3057\u5074\u306e\u30a2\u30d7\u30ea\u3067query()\u30e1\u30bd\u30c3\u30c9\u3092\u547c\u3073\u51fa\u3059\u305f\u3081\u3001ContentProvider\u3068\u306a\u308b\u30c7\u30fc\u30bf\u63d0\u4f9b\u5074\u306e\u30a2\u30d7\u30ea\u3067SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u3092\u5b9f\u65bd\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001MainActivity\u30af\u30e9\u30b9\u306e15\u884c\u76ee\u3067\u3001query\u30e1\u30bd\u30c3\u30c9\u306e\u7b2c4\u5f15\u6570(selectionArgs)\u306b\u4e0d\u6b63\u306aSQL\u3092\u57cb\u3081\u8fbc\u3093\u3067\u3044\u307e\u3059\u3002
\u547c\u3070\u308c\u308b\u5074\u306e\u30a2\u30d7\u30ea\u3067\u3053\u306e\u3088\u3046\u306a\u547c\u3073\u51fa\u3057\u65b9\u3092\u60f3\u5b9a\u3057\u3066\u5bfe\u7b56\u3092\u3057\u3066\u3044\u306a\u3044\u3068\u3001\u60f3\u5b9a\u5916\u306eSQL\u304c\u767a\u884c\u3055\u308c\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u4e0d\u6b63\u306b\u30c7\u30fc\u30bf\u3092\u629c\u304d\u53d6\u3089\u308c\u3066\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
ContentProvider\u3067\u306eSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56<\/h2>\n\n\n\n
\u4e0a\u8a18\u306e\u3088\u3046\u306b\u3001\u547c\u3073\u51fa\u3057\u5074\u3067\u610f\u56f3\u7684\u306bSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u3066\u3057\u307e\u3046\u305f\u3081\u3001ContentProvider\u306f\u305d\u306e\u3088\u3046\u306a\u4e0d\u6b63\u306a\u547c\u3073\u51fa\u3057\u65b9\u3092\u3055\u308c\u308b\u3053\u3068\u3092\u60f3\u5b9a\u3057\u3066\u8a2d\u8a08\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u4ee5\u4e0b\u306e\u30b5\u30f3\u30d7\u30eb\u306f\u3001\u5bfe\u7b56\u3092\u65bd\u3057\u305fContentProvider\u306e\u5b9f\u88c5\u3067\u3059\u3002
\u30dd\u30a4\u30f3\u30c8\u306f\u3001ContentProvider\u3092\u5b9f\u88c5\u3057\u305f\u30af\u30e9\u30b9\u3067query()\u30e1\u30bd\u30c3\u30c9\u3092\u30aa\u30fc\u30d0\u30fc\u30e9\u30a4\u30c9\u3057\u3001\u305d\u306equery()\u30e1\u30bd\u30c3\u30c9\u5185\u3067\u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u6e21\u3055\u308c\u308b\u6587\u5b57\u5217\u3092\u30a8\u30b9\u30b1\u30fc\u30d7\u3057\u3066\u3044\u307e\u3059(8\u884c\u76ee\u30019\u884c\u76ee)\u3002<\/p>\n\n\n\n
SampleApp<\/h3>\n\n\n\n
\u3010\u8106\u5f31\u6027\u5bfe\u7b56\u3092\u65bd\u3057\u305fContentProvider\u3011\uff08query()\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u88c5\u7b87\u6240\u3092\u629c\u7c8b\uff09<\/p>\n\n\n\n
[java]\npublic Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {\n try {\n SQLiteDatabase db = databaseHelper.getReadableDatabase();\n SQLiteQueryBuilder qb = new SQLiteQueryBuilder();\n qb.setTables("schedule_tbl");\n projection = new String[] { "title", "content", "date" };\n \/\/ \u7b2c4\u5f15\u6570(selectionArgs)\u306e\u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u30a8\u30b9\u30b1\u30fc\u30d7\u3057\u3066\u3001SQLiteQueryBuilder.query()\u306e\u7b2c3\u5f15\u6570(selection)\u306b\u8a2d\u5b9a\n String condition = selectionArgs[0].replaceAll("'", "''");\n selection = "content LIKE '%" + condition + "%'";\n selectionArgs = null;\n Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, null);\n return c;\n } catch (Exception e) {\n Log.e(e.getClass().getName(), e.getMessage());\n return null;\n }\n}\n[\/java]<\/pre>\n\n\n\n\u307e\u3068\u3081<\/h1>\n\n\n\n
Android\u81ea\u4f53\u306b\u306f\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u4ed5\u7d44\u307f\u304c\u5099\u308f\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u305d\u306e\u4ed5\u7d44\u307f\u3092\u7406\u89e3\u305b\u305a\u306b\u30a2\u30d7\u30ea\u3092\u958b\u767a\u3059\u308b\u3068\u3001\u601d\u308f\u306c\u8106\u5f31\u6027\u3092\u7d44\u307f\u8fbc\u3093\u3067\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002
\u30e6\u30fc\u30b6\u304c\u60aa\u610f\u3092\u6301\u3063\u305f\u30a2\u30d7\u30ea\u3092\u305d\u308c\u3068\u77e5\u3089\u305a\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u30a2\u30d7\u30ea\u304c\u6c42\u3081\u308b\u6a29\u9650\u3092\u7591\u3044\u3082\u306a\u304f\u4e0e\u3048\u3066\u3057\u307e\u3046\u3053\u3068\u306b\u3088\u308a\u3001\u96fb\u8a71\u5e33\u306e\u30c7\u30fc\u30bf\u3092\u629c\u304d\u53d6\u3089\u308c\u308b\u3068\u3044\u3046\u3088\u3046\u306a\u4e8b\u4ef6\u3082\u5b9f\u969b\u306b\u8d77\u304d\u3066\u3044\u307e\u3059\u3002
\u4eca\u5f8c\u3001\u6211\u3005\u30a8\u30f3\u30b8\u30cb\u30a2\u306f\u3053\u306e\u3088\u3046\u306a\u4e00\u898b\u7121\u5bb3\u306a\u30a2\u30d7\u30ea\u304b\u3089\u500b\u4eba\u60c5\u5831\u306a\u3069\u306e\u6a5f\u5bc6\u30c7\u30fc\u30bf\u3092\u4fdd\u8b77\u3059\u308b\u305f\u3081\u306b\u3001\u4fdd\u8b77\u5bfe\u8c61\u3068\u3059\u308b\u30c7\u30fc\u30bf\u306f\u7aef\u672b\u5074\u306b\u4fdd\u5b58\u3057\u306a\u3044\u3001\u307e\u305f\u306f\u3084\u3080\u3092\u5f97\u305a\u7aef\u672b\u5074\u306b\u4fdd\u5b58\u3059\u308b\u3068\u3057\u3066\u3082\u3001\u6697\u53f7\u5316\u3057\u3066\u4fdd\u5b58\u3059\u308b\u3088\u3046\u306a\u5bfe\u7b56\u3092\u65bd\u3059\u3053\u3068\u304c\u6c42\u3081\u3089\u308c\u3066\u304f\u308b\u3067\u3057\u3087\u3046\u3002
\u3057\u304b\u3057\u3001\u4eca\u56de\u306e\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u305f\u3088\u3046\u306b\u3001ContentProvider\u306e\u4ed5\u7d44\u307f\u3092\u4e0d\u9069\u5207\u306b\u4f7f\u7528\u3057\u3066\u3057\u307e\u3046\u3068\u3001\u305f\u3068\u3048\u4e0a\u8a18\u306e\u3088\u3046\u306a\u5bfe\u7b56\u3092\u65bd\u3057\u305f\u3068\u3057\u3066\u3082\u3001\u81ea\u5206\u304c\u958b\u767a\u3057\u305f\u30a2\u30d7\u30ea\u7d4c\u7531\u3067\u6a5f\u5bc6\u30c7\u30fc\u30bf\u3092\u629c\u304d\u53d6\u3089\u308c\u308b\u3088\u3046\u306a\u8106\u5f31\u6027\u3092\u542b\u3093\u3067\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002
Andorid\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u8005\u306f\u3001\u4eca\u56de\u7d39\u4ecb\u3057\u305fSQL Injection\u5bfe\u7b56\u306f\u3082\u3061\u308d\u3093\u3001Android\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u4ed5\u7d44\u307f\u3068\u5371\u967a\u6027\u3092\u5341\u5206\u306b\u7406\u89e3\u3057\u305f\u4e0a\u3067\u30a2\u30d7\u30ea\u958b\u767a\u3092\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u306b\u306a\u3063\u3066\u304d\u307e\u3059\u3002 <\/p>\n
2011\u5e7412\u6708\u306b\u306f\u3001\u516c\u5f0f\u306eAndroidMarket\uff08\u73fe\u5728\u306fGoogle Play\uff09\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u305f\u30a2\u30d7\u30ea\u306e\u6570\u304c100\u5104\u306b\u9054\u3057\u30012012\u5e749\u6708\u306b\u306f250\u5104\u306b\u9054\u3057\u307e\u3057\u305f\u3002
\u5b9f\u969b\u30012012\u5e74\u306e\u5e74\u521d\u306f1000\u500b\u3060\u3063\u305fAndroid\u4e0d\u6b63\u30a2\u30d7\u30ea\u306f\u3001\u5e74\u672b\u307e\u3067\u306b35\u4e07\u500b\u3078\u3068\u6025\u5897\u3057\u3066\u304a\u308a\u3001PC\u306e\u8105\u5a01\u306e\u5909\u9077\u3068\u6bd4\u3079\u308b\u3068\u7d044\u500d\u306e\u30b9\u30d4\u30fc\u30c9\u3067\u6210\u9577\u3057\u3066\u3044\u307e\u3059\u3002
\u3053\u3046\u3057\u305f\u4e2d\u3067\u3001\u30b5\u30a4\u30d0\u30fc\u72af\u7f6a\u8005\u305f\u3061\u306b\u3068\u3063\u3066Android\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u306f\u300c\u683c\u597d\u306e\u30bf\u30fc\u30b2\u30c3\u30c8\u300d\u3068\u306a\u308b\u3053\u3068\u306f\u9593\u9055\u3044\u3042\u308a\u307e\u305b\u3093\u3002
Android\u30e6\u30fc\u30b6\u306fAndroid\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u69cb\u9020\u3092\u6b63\u3057\u304f\u7406\u89e3\u3057\u3001\u30b5\u30a4\u30d0\u30fc\u72af\u7f6a\u8005\u304b\u3089\u306e\u653b\u6483\u3092\u672a\u7136\u306b\u9632\u3050\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u307e\u305f\u3001Android\u30a2\u30d7\u30ea\u4f5c\u6210\u8005\u3082\u60aa\u610f\u306e\u3042\u308b\u4e0d\u6b63Android\u30a2\u30d7\u30ea\u304b\u3089\u306e\u653b\u6483\u3092\u9632\u3050\u3088\u3046\u30bb\u30ad\u30e5\u30a2\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u77e5\u8b58\u304c\u6c42\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
\u4f8b\u3048\u3070\u3001\u9023\u7d61\u5148\u30a2\u30d7\u30ea\u306b\u306f\u6c0f\u540d\u3001\u96fb\u8a71\u756a\u53f7\u3001\u4f4f\u6240\u3001email\u30a2\u30c9\u30ec\u30b9\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u307e\u3059\u3002
\u307e\u305f\u3001\u30aa\u30d5\u30a3\u30b9\u7cfb\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u4ed5\u4e8b\u306e\u8cc7\u6599\u3092\u5165\u308c\u3066\u3044\u308b\u5834\u5408\u3082\u3042\u308a\u5f97\u307e\u3059\u3002
\u3053\u308c\u3089\u304cAndroid\u4e0d\u6b63\u30a2\u30d7\u30ea\u306b\u3088\u3063\u3066\u6d41\u51fa\u3057\u3001\u4e0d\u6b63\u306b\u5229\u7528\u3055\u308c\u305f\u5834\u5408\u3001\u500b\u4eba\u3078\u306e\u88ab\u5bb3\u306f\u3082\u3061\u308d\u3093\u306e\u3053\u3068\u3001\u4f1a\u793e\u306b\u5bfe\u3057\u3066\u3082\u640d\u5bb3\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
\u7279\u306b\u4e0a\u8a18\u3067\u6319\u3052\u305f\u300c\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u60c5\u5831\u300d\u306f\u53b3\u91cd\u306b\u7ba1\u7406\u3055\u308c\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
1.\u9ad8\u984d\u6599\u91d1\u304c\u767a\u751f\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u3092\u60aa\u7528\u3059\u308b\u3082\u306e(40%)
2.\u30e6\u30fc\u30b6\u306e\u610f\u56f3\u3057\u306a\u3044\u30a2\u30c9\u30a6\u30a7\u30a2\u3092\u8868\u793a\u3055\u305b\u308b\u3082\u306e(38%)
3.\u60c5\u5831\u3092\u7a83\u53d6\u3059\u308b\u3082\u306e(25%)
4.\u4e0d\u6b63\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3082\u306e(23%)<\/p>
\u203b\u4e0d\u6b63\u30a2\u30d7\u30ea\u306f\u91cd\u8907\u3057\u305f\u7a2e\u985e\u3092\u3082\u3064\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p><\/blockquote>\n\n\n\n
Android\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u7279\u5fb4\u3068\u3057\u3066\u81ea\u52d5\u7684\u306b\u62e1\u6563\u3059\u308b\u30a6\u30a3\u30eb\u30b9\u306f\u307e\u305a\u3042\u308a\u5f97\u307e\u305b\u3093\u3002
\u5f8c\u306e\u7ae0\u3067\u8aac\u660e\u3057\u307e\u3059\u304c\u3001Android\u3067\u306f\u30e6\u30fc\u30b6\u304c\u660e\u793a\u7684\u306b\u300c\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u300d\u3092\u8a2d\u5b9a\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u306a\u3051\u308c\u3070\u3001Android\u30a2\u30d7\u30ea\u3092\u5229\u7528\u3067\u304d\u306a\u3044\u69cb\u9020\u306b\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3067\u3059\u3002
\u305d\u306e\u305f\u3081\u3001Android\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u6b86\u3069\u306f\u30e6\u30fc\u30b6\u81ea\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u611f\u67d3\u3057\u307e\u3059\u3002
\u5f93\u3063\u3066\u3001\u4e00\u822c\u7684\u306bAndroid\u4e0d\u6b63\u30a2\u30d7\u30ea\u306e\u611f\u67d3\u7d4c\u8def\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3082\u306e\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
1.Google Play\u306a\u3069\u306e\u3055\u307e\u3056\u307e\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b9\u30c8\u30a2\u304b\u3089\u4e0d\u6b63\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b
2.\u30e1\u30fc\u30eb\u306b\u6dfb\u4ed8\u3055\u308c\u305f\u4e0d\u6b63\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b
3.USB\u63a5\u7d9a\u3057\u305fPC\u304b\u3089\u4e0d\u6b63\u30a2\u30d7\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff08adb\u30b7\u30a7\u30eb\u3092\u7d4c\u7531\uff09<\/p><\/blockquote>\n\n\n\nAndroid\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30a4\u30f3\u30b7\u30c7\u30f3\u30c8<\/h2>\n\n\n\n
\u3053\u3053\u3067\u306f\u3001Android\u3067\u767a\u751f\u3057\u305f\u4ee3\u8868\u7684\u306a\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30a4\u30f3\u30b7\u30c7\u30f3\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
DroidDreamLight(2011.6)<\/h3>\n\n\n\n
Android\u7aef\u672b\u3092\u72d9\u3046\u969b\u306b\u3088\u304f\u4f7f\u308f\u308c\u308b\u306e\u304c\u300cDroidDreamLight\u300d\u3067\u3059\u3002
DroidDreamLight\u306fAndroid\u7aef\u672b\u5411\u3051\u306e\u5404\u7a2e\u30a2\u30d7\u30ea\u3092\u30c8\u30ed\u30a4\u306e\u6728\u99ac\u5316\u3057\u3001\u516c\u5f0f\u30de\u30fc\u30b1\u30c3\u30c8(Google Play\u7b49)\u306b\u516c\u958b\u3057\u307e\u3059\u3002
\u30e6\u30fc\u30b6\u306f\u516c\u5f0f\u30de\u30fc\u30b1\u30c3\u30c8\u304b\u3089\u30c8\u30ed\u30a4\u306e\u6728\u99ac\u5316\u3055\u308c\u305f\u30a2\u30d7\u30ea\u3092\u81ea\u5206\u306e\u7aef\u672b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u3067\u611f\u67d3\u3057\u307e\u3059\u3002
\u611f\u67d3\u5f8c\u3001\u30e6\u30fc\u30b6\u7aef\u672b\u304b\u3089\u500b\u4eba\u60c5\u5831\u7b49\u304c\u6d41\u51fa\u3057\u307e\u3059\u3002
2011\u5e746\u6708\u306b\u78ba\u8a8d\u3055\u308c\u305f\u4ee5\u5f8c\u3082\u4e9c\u7a2e\u304c\u6b21\u3005\u3068\u767b\u5834\u3057\u3001\u60c5\u5831\u53ce\u96c6\u6a5f\u80fd\u7b49\u304c\u3088\u308a\u5206\u304b\u308a\u96e3\u304f\u306a\u3063\u3066\u304a\u308a\u3001\u691c\u51fa\u304c\u56f0\u96e3\u306b\u306a\u3063\u3066\u304d\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\nSkype(2011.4)<\/h3>\n\n\n\n
\u60aa\u8cea\u306a\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3\u30fc\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092Android\u7aef\u672b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\u3001\u7aef\u672b\u306b\u4fdd\u5b58\u3055\u308c\u305fSkype\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u3068\u306a\u308b\u8106\u5f31\u6027\u304c\u767a\u898b\u3055\u308c\u307e\u3057\u305f\u3002
\u6d41\u51fa\u306e\u6050\u308c\u304c\u3042\u308b\u60c5\u5831\u306b\u306f\u3001Skype\u306b\u767b\u9332\u3057\u305f\u500b\u4eba\u60c5\u5831\u3001Skype\u30b3\u30f3\u30bf\u30af\u30c8\u60c5\u5831\u3001\u30c1\u30e3\u30c3\u30c8\u5c65\u6b74\u306a\u3069\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u542b\u307e\u308c\u307e\u3059\u3002
\u3053\u308c\u306fSkype\u304cAndoidOS\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u3067\u4fdd\u8b77\u3055\u308c\u306a\u3044\u5834\u6240\u306b\u60c5\u5831\u3092\u4fdd\u5b58\u3057\u3066\u3044\u308b\u3053\u3068\u3067\u767a\u751f\u3057\u307e\u3057\u305f\u3002
\u203b\u73fe\u5728\u306f\u4fee\u6b63\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\nGeinimi(2010.12)<\/h3>\n\n\n\n
\u300cGeinimi\u300d\u306f\u3001Android OS\u3092\u642d\u8f09\u3057\u305f\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u3084\u60c5\u5831\u7aef\u672b\u3092\u6a19\u7684\u3068\u3057\u305f\u30dc\u30c3\u30c8\u578b\u306e\u30a6\u30a3\u30eb\u30b9\u3067\u3059\u3002
\u3053\u306e\u30a6\u30a3\u30eb\u30b9\u306f\u3001\u8907\u6570\u306e\u611f\u67d3\u3057\u305f\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u540c\u58eb\u3067\u300c\u30dc\u30c3\u30c8\u30cd\u30c3\u30c8\u300d\u3092\u69cb\u6210\u3059\u308b\u300c\u30dc\u30c3\u30c8\u300d\u578b\u306e\u30a6\u30a3\u30eb\u30b9\u306e\u4e00\u7a2e\u3067\u3059\u3002
\u611f\u67d3\u3059\u308b\u3068\u3001\u60aa\u610f\u3042\u308b\u72af\u7f6a\u8005\u306e\u6307\u4ee4\u306b\u5fdc\u3058\u3066\u610f\u56f3\u3057\u306a\u3044\u96fb\u8a71\u767a\u4fe1\u3084\u30e1\u30fc\u30eb\u306e\u9001\u53d7\u4fe1\u3001\u500b\u4eba\u60c5\u5831\u306e\u6f0f\u3048\u3044\u306a\u3069\u306e\u88ab\u5bb3\u3092\u5f15\u304d\u8d77\u3053\u3059\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
\u72ec\u7acb\u884c\u653f\u6cd5\u4eba\u3000\u60c5\u5831\u51e6\u7406\u63a8\u9032\u6a5f\u69cb(IPA)\u306b\u3088\u308b\u3068\u3001Geinimi\u306f2010\u5e74\u672b\u9803\u3088\u308a\u78ba\u8a8d\u3055\u308c\u307e\u3057\u305f\u304c\u3001Android\u3092\u6a19\u7684\u3068\u3057\u305f\u30dc\u30c3\u30c8\u578b\u30a6\u30a3\u30eb\u30b9\u304c\u78ba\u8a8d\u3055\u308c\u305f\u306e\u306f\u521d\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002
\u73fe\u5728\u3067\u3082\u4e2d\u56fd\u3092\u4e2d\u5fc3\u306b\u51fa\u56de\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\nDroid09(2010.1)<\/h3>\n\n\n\n
\u300cDroid09\u300d\u3068\u3044\u3046\u533f\u540d\u306e\u958b\u767a\u8005\u304c\u3001\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30f3\u30ad\u30f3\u30b0\u30a2\u30d7\u30ea\u306b\u898b\u305b\u304b\u3051\u3066\u4f5c\u6210\u3057\u305f\u3082\u306e\u3067\u3059\u3002
\u5b9f\u5728\u306e\u91d1\u878d\u6a5f\u95a2\u540d\u3092\u304b\u305f\u308a\u3001Android Market Place\uff08\u73fe\u5728\u306eGoogle Play\uff09\u3067\u8ca9\u58f2\u3057\u3066\u3044\u307e\u3057\u305f\u3002
\u540d\u524d\u3092\u4f7f\u308f\u308c\u305f\u91d1\u878d\u6a5f\u95a2\u306f\u7c73\u56fd\u306e\u9280\u884c\u3084\u4fe1\u7528\u7d44\u5408\u306a\u3069\u591a\u6570\u306b\u4e0a\u308a\u3001\u3044\u305a\u308c\u3082\u30a2\u30d7\u30ea\u306f\u7121\u8a31\u53ef\u3067\u958b\u767a\u3055\u308c\u305f\u3082\u306e\u3067\u3001Android\u7aef\u672b\u4e0a\u3067\u30aa\u30f3\u30e9\u30a4\u30f3\u30d0\u30f3\u30ad\u30f3\u30b0\u306eWeb\u753b\u9762\u3092\u958b\u304f\u3060\u3051\u3067\u3001\u5b9f\u969b\u306e\u53d6\u5f15\u306b\u306f\u5229\u7528\u3067\u304d\u305a\u3001\u30e6\u30fc\u30b6\u540d\u3084\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3069\u306e\u60c5\u5831\u304c\u76d7\u307f\u51fa\u3055\u308c\u305f\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
<\/p>\n\n\n\nAndroid\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3<\/h1>\n\n\n\n
Android\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u69cb\u6210\u3059\u308b\u5404\u8981\u7d20<\/h2>\n\n\n\n
\u7f72\u540d<\/h3>\n\n\n\n
\u3059\u3079\u3066\u306eAndroid\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u8a3c\u660e\u66f8\u3067\u306e\u7f72\u540d\u304c\u5fc5\u8981\u3067\u3001\u305d\u306e\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u9375\u306f\u958b\u767a\u8005\u304c\u4fdd\u7ba1\u3057\u307e\u3059\u3002(\u81ea\u5df1\u8a3c\u660e\u66f8)
\u7f72\u540d\u304c\u306a\u3044\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3001\u8d77\u52d5\u304c\u3067\u304d\u305a\u3001\u307e\u305fGoogle Play\u3067\u306e\u516c\u958b\u3082\u3067\u304d\u307e\u305b\u3093\u3002
(Eclipse\u3067\u8d77\u52d5\u3067\u304d\u308b\u306e\u306f\u3001ADT[Android Development Tools]\u304c\u81ea\u52d5\u3067\u7f72\u540d\u3092\u884c\u306a\u3063\u3066\u3044\u308b\u70ba)<\/p>\n\n\n\n\u7f72\u540d\u306e\u76ee\u7684<\/h4>\n\n\n\n
\u30fb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u4f5c\u6210\u8005\u3092\u8b58\u5225 (\u540c\u3058\u7f72\u540d\u3067\u306f\u306a\u3044\u3068\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u51fa\u6765\u306a\u3044\u306a\u3069)
\u30fbsharedUserId\u3092\u4f7f\u3063\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u9023\u643a (\u8a73\u3057\u304f\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u9023\u643a)<\/p>\n\n\n\n\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9<\/h3>\n\n\n\n
Android \u306f\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u3068\u3044\u3046\u6982\u5ff5\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u3092\u5f37\u5236\u7684\u306b\u5206\u96e2\u3057\u3066\u3044\u307e\u3059\u3002
\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\uff08sandbox\uff1a\u7802\u7bb1\uff0c\u7802\u5834 \uff09\uff1a \u5916\u90e8\u304b\u3089\u53d7\u3051\u53d6\u3063\u305f\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4fdd\u8b77\u3055\u308c\u305f\u9818\u57df\u3067\u52d5\u4f5c\u3055\u305b\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u30b7\u30b9\u30c6\u30e0\u304c\u4e0d\u6b63\u306b\u64cd\u4f5c\u3055\u308c\u308b\u306e\u3092\u9632\u3050\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30e2\u30c7\u30eb\u306e\u3053\u3068\u3067\u3059\u3002
\u5b9f\u884c\u3055\u308c\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u4fdd\u8b77\u3055\u308c\u305f\u9818\u57df\u306b\u5165\u308a\u3001\u307b\u304b\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3084\u30c7\u30fc\u30bf\u306a\u3069\u3092\u64cd\u4f5c\u3067\u304d\u306a\u3044\u72b6\u614b\u306b\u3055\u308c\u3066\u52d5\u4f5c\u3059\u308b\u305f\u3081\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u66b4\u8d70\u3057\u305f\u308a\u30a6\u30a4\u30eb\u30b9\u3092\u52d5\u4f5c\u3055\u305b\u3088\u3046\u3068\u3057\u3066\u3082\u30b7\u30b9\u30c6\u30e0\u306b\u5f71\u97ff\u304c\u53ca\u3070\u306a\u3044\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n\u30e6\u30fc\u30b6ID<\/h3>\n\n\n\n
\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305fAndroid\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u306f\u3001\u305d\u308c\u305e\u308c\u4e00\u610f\u306e Linux \u30e6\u30fc\u30b6ID \u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u5bfe\u5fdc\u3059\u308b\u56fa\u6709\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002
\u3053\u308c\u306b\u3088\u308a\u3001\u4ed6\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u4e92\u3044\u306b\u5f71\u97ff\u3092\u53ca\u307c\u3055\u306a\u3044\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u5316\u304c\u306a\u3055\u308c\u307e\u3059\u3002
\u3053\u306e\u30e6\u30fc\u30b6ID \u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30c7\u30d0\u30a4\u30b9\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b\u3068\u5272\u308a\u5f53\u3066\u3089\u308c\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u30c7\u30d0\u30a4\u30b9\u4e0a\u306b\u751f\u5b58\u3057\u3066\u3044\u308b\u9593\u3001\u56fa\u5b9a\u5024\u3068\u3057\u3066\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002
<\/p>\n\n\n\n\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u5916\u306e\u30ea\u30bd\u30fc\u30b9\u306b\u5bfe\u3059\u308b\u30a2\u30af\u30bb\u30b9\u65b9\u6cd5<\/h2>\n\n\n\n
\u30c7\u30d0\u30a4\u30b9\u306e\u4fdd\u8b77\u3055\u308c\u305f\u6a5f\u80fd\u3084\u30ea\u30bd\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9<\/h3>\n\n\n\n
\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3(users-permission)<\/h4>\n\n\n\n
\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u30fb\u30d5\u30a1\u30a4\u30eb(AndroidManifest.xml)\u3092\u901a\u3058\u3066\u3001\u30c7\u30d0\u30a4\u30b9\u306e\u4fdd\u8b77\u3055\u308c\u305f\u6a5f\u80fd\u3084\u30ea\u30bd\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u3092\u8981\u6c42\u3057\u307e\u3059\u3002(\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u4e00\u5207\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u307e\u305b\u3093)
\u3053\u306e\u8981\u6c42\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u8868\u793a\u3055\u308c\u3001\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u307e\u305f\u306f\u62d2\u5426\u3092\u30e6\u30fc\u30b6\u30fc\u306b\u3088\u3063\u3066\u6c7a\u3081\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u9023\u643a<\/h3>\n\n\n\n
ContentProvider<\/h4>\n\n\n\n
Android\u306b\u306f\u3001ContentProvider\u3092\u7d4c\u7531\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u3067\u60c5\u5831\u5171\u6709\u3067\u304d\u308b\u4ed5\u7d44\u307f\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002
ContentProvider\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u5f8c\u306e\u7ae0\u3067\u8a73\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\nsharedUserId (\u30e6\u30fc\u30b6\u30fcID\u306e\u5171\u6709)<\/h4>\n\n\n\n
\u7570\u306a\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u540c\u3058\u30e6\u30fc\u30b6ID\u3092\u5272\u308a\u5f53\u3066\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u3059\u3079\u3066\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u304a\u4e92\u3044\u306b\u8aad\u307f\u66f8\u304d\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002
\u30e6\u30fc\u30b6\u30fcID\u3092\u5171\u6709\u3059\u308b\u306b\u306f\u4ee5\u4e0b\u306e\u6761\u4ef6\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002
\u30fb\u540c\u3058\u7f72\u540d\u3092\u53d7\u3051\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u3042\u308b\u3053\u3068
\u30fbAndroidManaifest.xml\u5185\u3067\u3001\u540c\u3058android:sharedUserId\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u3053\u3068<\/p>\n\n\n\n\u30d5\u30a1\u30a4\u30eb\u751f\u6210\u6642\u306e\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u6307\u5b9a<\/h4>\n\n\n\n
openFileOutput()\u3001getSharedPreferences()\u3001openOrCreateDatabase()\u306a\u3069\u3067\u30d5\u30a1\u30a4\u30eb\u3092\u751f\u6210\u3059\u308b\u969b\u3001\u4ee5\u4e0b\u306e\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u30d5\u30e9\u30b0\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u4ed6\u306e\u30a2\u30d7\u30ea\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u3092\u5236\u5fa1\u3067\u304d\u307e\u3059\u3002
\u30fbMODE_PRIVATE : \u30a2\u30af\u30bb\u30b9\u4e0d\u53ef\u30e2\u30fc\u30c9(\u30c7\u30d5\u30a9\u30eb\u30c8)
\u30fbMODE_WORLD_READABLE : \u8aad\u307f\u8fbc\u307f\u53ef\u80fd\u30e2\u30fc\u30c9
\u30fbMODE_WORLD_WRITEABLE : \u66f8\u304d\u8fbc\u307f\u53ef\u80fd\u30e2\u30fc\u30c9
\u307e\u305f\u3001”| “\u3092\u4f7f\u7528\u3057\u3066\u3001\u8907\u6570\u306e\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059(\uff0a\u6ce8\u610f : \u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u304c\u885d\u7a81\u3057\u305f\u5834\u5408\u3001\u7de9\u3044\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u304c\u512a\u5148\u3055\u308c\u307e\u3059)\u3002
\u203b\u305f\u3060\u3057\u3001\u4e0d\u7279\u5b9a\u591a\u6570\u3078\u306e\u8a2d\u5b9a\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\nSQLite\u3092\u7528\u3044\u305fAndroid\u30a2\u30d7\u30ea\u306e\u30c7\u30fc\u30bf\u7ba1\u7406\u65b9\u6cd5<\/h1>\n\n\n\n
SQLite\u3068Android\u30a2\u30d7\u30ea\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u65b9\u6cd5<\/h2>\n\n\n\n
SQLite<\/h3>\n\n\n\n
SQLite\u3068\u306f\u3001\u30b5\u30fc\u30d0\u3068\u3057\u3066\u3067\u306f\u306a\u304f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u7d44\u307f\u8fbc\u3093\u3067\u4f7f\u7528\u3059\u308b\u8457\u4f5c\u6a29\u30d5\u30ea\u30fc\u3067\u8efd\u91cf\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002
SQLite\u306f\u975e\u5e38\u306b\u8efd\u91cf\u3067\u9ad8\u901f\u3067\u3042\u308b\u305f\u3081\u3001Android\u3067\u3082\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5185\u90e8\u30c7\u30fc\u30bf\u3092\u7ba1\u7406\u3059\u308b\u305f\u3081\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3068\u3057\u3066\u3001\u6a19\u6e96\u3067\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\nAndroid\u30a2\u30d7\u30ea\u304b\u3089\u306eSQLite\u306e\u5229\u7528\u65b9\u6cd5<\/h3>\n\n\n\n
Android\u3067SQLite\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u3001SQLiteOpenHelper\u3092\u7d99\u627f\u3057\u305fHelper\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
SQLite\u3068ContentProvider<\/h3>\n\n\n\n
Android\u3067\u306f\u3001\u901a\u5e38\u306fSQLite\u306e\u30c7\u30fc\u30bf\u3082\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u56fa\u6709\u306e\u5185\u90e8\u30c7\u30fc\u30bf\u3068\u3057\u3066\u7ba1\u7406\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u5916\u90e8\u30a2\u30d7\u30ea\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\u5f93\u3063\u3066\u3001\u8907\u6570\u306e\u30a2\u30d7\u30ea\u3067\u5171\u901a\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u3001ContentProvider\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\nContentProvider\u5229\u7528\u6642\u306b\u304a\u3051\u308bSQL Injection\u5bfe\u7b56<\/h1>\n\n\n\n
ContentProvider\u5229\u7528\u306b\u304a\u3051\u308b\u554f\u984c\u70b9<\/h2>\n\n\n\n
\u4ee5\u4e0b\u306f\u3001\u4f1a\u8b70\u5ba4\u4e88\u7d04\u30c7\u30fc\u30bf\u3092\u7ba1\u7406\u3059\u308b\u30a2\u30d7\u30ea\u3068\u3001\u305d\u306e\u7ba1\u7406\u30c7\u30fc\u30bf\u3092\u7167\u4f1a\u3059\u308b\u6a5f\u80fd\u3092\u6301\u3064\u30a2\u30d7\u30ea\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002
SampleApp\u3067\u4f5c\u6210\u3057\u305f\u4f1a\u8b70\u5ba4\u4e88\u7d04DB\u306e\u5185\u5bb9\u3092ContentProvider\u3092\u901a\u3058\u3066MalwareApp\u3067\u53c2\u7167\u3057\u307e\u3059\u304c\u3001\u305d\u306e\u969b\u3001\u610f\u56f3\u7684\u306bSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u3092\u7528\u3044\u3066\u3001SampleApp\u5074\u3067\u60f3\u5b9a\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u30c7\u30fc\u30bf\u3082\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\nSampleApp<\/h3>\n\n\n\n
\u3010helper\u30af\u30e9\u30b9\u3011<\/p>\n\n\n\n
[java]\npublic class SampleDBHelper extends SQLiteOpenHelper {\n \/**\n * \u30b3\u30f3\u30b9\u30c8\u30e9\u30af\u30bf\n * @param context\n *\/\n public SampleDBHelper(Context context) {\n \/\/ \u4efb\u610f\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u540d\u3068\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u6307\u5b9a\u3059\u308b\n super(context, "sample.db", null, 1);\n }\n\n \/**\n * \u3053\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u521d\u3081\u3066\u4f7f\u7528\u3059\u308b\u6642\u306b\u5b9f\u884c\u3055\u308c\u308b\u51e6\u7406\n *\/\n @Override\n public void onCreate(SQLiteDatabase db) {\n db.execSQL(\n "create table schedule_tbl ("\n + "_id INTEGER primary key autoincrement not null, "\n + "title TEXT, "\n + "content TEXT, "\n + "date TEXT, "\n + "place TEXT, "\n + "timestamp TEXT );");\n db.execSQL(\n "create table user_tbl ("\n + "_id INTEGER primary key autoincrement not null, "\n + "name TEXT, "\n + "phone TEXT, "\n + "email TEXT, "\n + "timestamp TEXT );");\n }\n}\n[\/java]<\/pre>\n\n\n\n\u3010\u8106\u5f31\u6027\u306e\u3042\u308bContentProvider\u3011<\/p>\n\n\n\n
[java]\npublic class SampleWeakProvider extends ContentProvider {\n\n SampleDBHelper databaseHelper;\n\n @Override\n public boolean onCreate() {\n databaseHelper = new SampleDBHelper(getContext());\n return true;\n }\n\n @Override\n public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {\n SQLiteDatabase db = databaseHelper.getReadableDatabase();\n SQLiteQueryBuilder qb = new SQLiteQueryBuilder();\n qb.setTables("schedule_tbl");\n projection = new String[] { "title", "content", "date" };\n selection = "content LIKE '%" + selectionArgs[0] + "%'";\n selectionArgs = null;\n Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, null);\n return c;\n }\n}\n[\/java]<\/pre>\n\n\n\nMalwareApp<\/h3>\n\n\n\n
\u3010\u547c\u3073\u51fa\u3057\u5143\u3011<\/p>\n\n\n\n
[java]\npublic class MainActivity extends Activity {\n\n private static final int REQ = 1;\n\n @Override\n protected void onCreate(Bundle savedInstanceState) {\n super.onCreate(savedInstanceState);\n setContentView(R.layout.activity_main);\n\n Button btn2 = (Button) this.findViewById(R.id.button2);\n btn2.setOnClickListener(new View.OnClickListener() {\n @Override\n public void onClick(View arg0) {\n \/\/ \u3053\u3053\u3067\u7b2c4\u5f15\u6570(selectionArgs)\u306b\u4e0d\u6b63\u306aSQL\u3092\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\n String keyword = "a%' or 1 = 1) UNION ALL select name, phone, email from user_tbl where ('%' = '";\n Uri contentUri = Uri.parse("content:\/\/jp.co.opentone.fsol.sampleweakprovider");\n\n try {\n Cursor cur = getContentResolver().query(contentUri, null,\n null, new String[] { keyword },\n null);\n\n StringBuilder sb = new StringBuilder();\n sb.append("----------");\n while (cur.moveToNext()) {\n sb.append(cur.getString(0));\n sb.append(" \/ ");\n sb.append(cur.getString(1));\n sb.append(" \/ ");\n sb.append(cur.getString(2));\n sb.append("\\n");\n }\n sb.append("----------");\n TextView txt = (TextView) findViewById(R.id.textView1);\n txt.setText(sb.toString());\n } catch (Exception e) {\n TextView txt = (TextView) findViewById(R.id.textView1);\n txt.setText(e.getMessage());\n }\n }\n });\n}\n[\/java]<\/pre>\n\n\n\nContentProvider\u3092\u4f7f\u3063\u3066\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u9023\u4fc2\u3092\u5b9f\u73fe\u3059\u308b\u5834\u5408\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u5148\u3067\u3042\u308b\u547c\u3073\u51fa\u3057\u5074\u306e\u30a2\u30d7\u30ea\u3067query()\u30e1\u30bd\u30c3\u30c9\u3092\u547c\u3073\u51fa\u3059\u305f\u3081\u3001ContentProvider\u3068\u306a\u308b\u30c7\u30fc\u30bf\u63d0\u4f9b\u5074\u306e\u30a2\u30d7\u30ea\u3067SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u3092\u5b9f\u65bd\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001MainActivity\u30af\u30e9\u30b9\u306e15\u884c\u76ee\u3067\u3001query\u30e1\u30bd\u30c3\u30c9\u306e\u7b2c4\u5f15\u6570(selectionArgs)\u306b\u4e0d\u6b63\u306aSQL\u3092\u57cb\u3081\u8fbc\u3093\u3067\u3044\u307e\u3059\u3002
\u547c\u3070\u308c\u308b\u5074\u306e\u30a2\u30d7\u30ea\u3067\u3053\u306e\u3088\u3046\u306a\u547c\u3073\u51fa\u3057\u65b9\u3092\u60f3\u5b9a\u3057\u3066\u5bfe\u7b56\u3092\u3057\u3066\u3044\u306a\u3044\u3068\u3001\u60f3\u5b9a\u5916\u306eSQL\u304c\u767a\u884c\u3055\u308c\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u4e0d\u6b63\u306b\u30c7\u30fc\u30bf\u3092\u629c\u304d\u53d6\u3089\u308c\u3066\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\nContentProvider\u3067\u306eSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56<\/h2>\n\n\n\n
\u4e0a\u8a18\u306e\u3088\u3046\u306b\u3001\u547c\u3073\u51fa\u3057\u5074\u3067\u610f\u56f3\u7684\u306bSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u3066\u3057\u307e\u3046\u305f\u3081\u3001ContentProvider\u306f\u305d\u306e\u3088\u3046\u306a\u4e0d\u6b63\u306a\u547c\u3073\u51fa\u3057\u65b9\u3092\u3055\u308c\u308b\u3053\u3068\u3092\u60f3\u5b9a\u3057\u3066\u8a2d\u8a08\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u4ee5\u4e0b\u306e\u30b5\u30f3\u30d7\u30eb\u306f\u3001\u5bfe\u7b56\u3092\u65bd\u3057\u305fContentProvider\u306e\u5b9f\u88c5\u3067\u3059\u3002
\u30dd\u30a4\u30f3\u30c8\u306f\u3001ContentProvider\u3092\u5b9f\u88c5\u3057\u305f\u30af\u30e9\u30b9\u3067query()\u30e1\u30bd\u30c3\u30c9\u3092\u30aa\u30fc\u30d0\u30fc\u30e9\u30a4\u30c9\u3057\u3001\u305d\u306equery()\u30e1\u30bd\u30c3\u30c9\u5185\u3067\u30d1\u30e9\u30e1\u30fc\u30bf\u306b\u6e21\u3055\u308c\u308b\u6587\u5b57\u5217\u3092\u30a8\u30b9\u30b1\u30fc\u30d7\u3057\u3066\u3044\u307e\u3059(8\u884c\u76ee\u30019\u884c\u76ee)\u3002<\/p>\n\n\n\nSampleApp<\/h3>\n\n\n\n
\u3010\u8106\u5f31\u6027\u5bfe\u7b56\u3092\u65bd\u3057\u305fContentProvider\u3011\uff08query()\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u88c5\u7b87\u6240\u3092\u629c\u7c8b\uff09<\/p>\n\n\n\n
[java]\npublic Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {\n try {\n SQLiteDatabase db = databaseHelper.getReadableDatabase();\n SQLiteQueryBuilder qb = new SQLiteQueryBuilder();\n qb.setTables("schedule_tbl");\n projection = new String[] { "title", "content", "date" };\n \/\/ \u7b2c4\u5f15\u6570(selectionArgs)\u306e\u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u30a8\u30b9\u30b1\u30fc\u30d7\u3057\u3066\u3001SQLiteQueryBuilder.query()\u306e\u7b2c3\u5f15\u6570(selection)\u306b\u8a2d\u5b9a\n String condition = selectionArgs[0].replaceAll("'", "''");\n selection = "content LIKE '%" + condition + "%'";\n selectionArgs = null;\n Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, null);\n return c;\n } catch (Exception e) {\n Log.e(e.getClass().getName(), e.getMessage());\n return null;\n }\n}\n[\/java]<\/pre>\n\n\n\n\u307e\u3068\u3081<\/h1>\n\n\n\n
Android\u81ea\u4f53\u306b\u306f\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u4ed5\u7d44\u307f\u304c\u5099\u308f\u3063\u3066\u3044\u307e\u3059\u304c\u3001\u305d\u306e\u4ed5\u7d44\u307f\u3092\u7406\u89e3\u305b\u305a\u306b\u30a2\u30d7\u30ea\u3092\u958b\u767a\u3059\u308b\u3068\u3001\u601d\u308f\u306c\u8106\u5f31\u6027\u3092\u7d44\u307f\u8fbc\u3093\u3067\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002
\u30e6\u30fc\u30b6\u304c\u60aa\u610f\u3092\u6301\u3063\u305f\u30a2\u30d7\u30ea\u3092\u305d\u308c\u3068\u77e5\u3089\u305a\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u30a2\u30d7\u30ea\u304c\u6c42\u3081\u308b\u6a29\u9650\u3092\u7591\u3044\u3082\u306a\u304f\u4e0e\u3048\u3066\u3057\u307e\u3046\u3053\u3068\u306b\u3088\u308a\u3001\u96fb\u8a71\u5e33\u306e\u30c7\u30fc\u30bf\u3092\u629c\u304d\u53d6\u3089\u308c\u308b\u3068\u3044\u3046\u3088\u3046\u306a\u4e8b\u4ef6\u3082\u5b9f\u969b\u306b\u8d77\u304d\u3066\u3044\u307e\u3059\u3002
\u4eca\u5f8c\u3001\u6211\u3005\u30a8\u30f3\u30b8\u30cb\u30a2\u306f\u3053\u306e\u3088\u3046\u306a\u4e00\u898b\u7121\u5bb3\u306a\u30a2\u30d7\u30ea\u304b\u3089\u500b\u4eba\u60c5\u5831\u306a\u3069\u306e\u6a5f\u5bc6\u30c7\u30fc\u30bf\u3092\u4fdd\u8b77\u3059\u308b\u305f\u3081\u306b\u3001\u4fdd\u8b77\u5bfe\u8c61\u3068\u3059\u308b\u30c7\u30fc\u30bf\u306f\u7aef\u672b\u5074\u306b\u4fdd\u5b58\u3057\u306a\u3044\u3001\u307e\u305f\u306f\u3084\u3080\u3092\u5f97\u305a\u7aef\u672b\u5074\u306b\u4fdd\u5b58\u3059\u308b\u3068\u3057\u3066\u3082\u3001\u6697\u53f7\u5316\u3057\u3066\u4fdd\u5b58\u3059\u308b\u3088\u3046\u306a\u5bfe\u7b56\u3092\u65bd\u3059\u3053\u3068\u304c\u6c42\u3081\u3089\u308c\u3066\u304f\u308b\u3067\u3057\u3087\u3046\u3002
\u3057\u304b\u3057\u3001\u4eca\u56de\u306e\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u305f\u3088\u3046\u306b\u3001ContentProvider\u306e\u4ed5\u7d44\u307f\u3092\u4e0d\u9069\u5207\u306b\u4f7f\u7528\u3057\u3066\u3057\u307e\u3046\u3068\u3001\u305f\u3068\u3048\u4e0a\u8a18\u306e\u3088\u3046\u306a\u5bfe\u7b56\u3092\u65bd\u3057\u305f\u3068\u3057\u3066\u3082\u3001\u81ea\u5206\u304c\u958b\u767a\u3057\u305f\u30a2\u30d7\u30ea\u7d4c\u7531\u3067\u6a5f\u5bc6\u30c7\u30fc\u30bf\u3092\u629c\u304d\u53d6\u3089\u308c\u308b\u3088\u3046\u306a\u8106\u5f31\u6027\u3092\u542b\u3093\u3067\u3057\u307e\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002
Andorid\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u8005\u306f\u3001\u4eca\u56de\u7d39\u4ecb\u3057\u305fSQL Injection\u5bfe\u7b56\u306f\u3082\u3061\u308d\u3093\u3001Android\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u4ed5\u7d44\u307f\u3068\u5371\u967a\u6027\u3092\u5341\u5206\u306b\u7406\u89e3\u3057\u305f\u4e0a\u3067\u30a2\u30d7\u30ea\u958b\u767a\u3092\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u306b\u306a\u3063\u3066\u304d\u307e\u3059\u3002 <\/p>\n
![\"\"](\"https:\/\/www.opentone.co.jp\/ot-lab\/wp-content\/uploads\/sites\/11\/2023\/02\/twitter_backlogskt_new.jpg\")
<\/a><\/div>","protected":false},"excerpt":{"rendered":"