{"height":"190","version":"1.0","title":"mybatis \u3067\u56fa\u5b9a\u5024\u3092SQL Map\u3067\u6307\u5b9a\u3059\u308b\u306b\u306fOGNL\u5f0f\u3092\u4f7f\u3046","url":"https://oboe2uran.hatenablog.com/entry/2022/07/02/153753","provider_url":"https://hatena.blog","width":"100%","description":"\u958b\u767a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u65b9\u91dd\u306bSQL\u6587\u306b\u56fa\u5b9a\u5024\u3092\u8a18\u8ff0\u3059\u308b\u306e\u3092\u7d76\u5bfe\u306b\u7981\u6b62\u3068\u304b \u878d\u901a\u306e\u52b9\u304b\u306a\u3044\u3001\u8cdb\u540c\u3067\u304d\u306a\u3044\u3053\u3068\u304c\u6642\u3005\u3042\u308b\u3002 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u3088\u3063\u3066\u305d\u3046\u3044\u3046\u306e\u3082\u3042\u3063\u3066\u82e6\u52b4\u3059\u308b\u306e\u3060\u304c\u3001mybatis \u306b\u306f OGNL\u66f8\u5f0f\u304c\u4f7f\u3048\u308b OGNL\uff08Object Graph Navigation Language\uff09 \u306e\u3053\u3068\u3067\u3042\u308b\u3002\u4f8b\uff09 <select id=\"getItems\" resultType=\"org.sample.dto.Gstore\"> SELECT g.* FROM group_stores g LEFT JOIN (SELECT id FROM items WHERE view_code IN ( '1\u2026","provider_name":"Hatena Blog","blog_title":"Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332","published":"2022-07-02 15:37:53","blog_url":"https://oboe2uran.hatenablog.com/","type":"rich","author_url":"https://blog.hatena.ne.jp/posturan/","image_url":null,"author_name":"posturan","categories":["mybatis"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foboe2uran.hatenablog.com%2Fentry%2F2022%2F07%2F02%2F153753\" title=\"mybatis \u3067\u56fa\u5b9a\u5024\u3092SQL Map\u3067\u6307\u5b9a\u3059\u308b\u306b\u306fOGNL\u5f0f\u3092\u4f7f\u3046 - Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}