{"id":711,"date":"2008-12-19T07:38:38","date_gmt":"2008-12-18T22:38:38","guid":{"rendered":"http:\/\/www.kazu.tv\/blog\/?p=711"},"modified":"2008-12-19T07:38:38","modified_gmt":"2008-12-18T22:38:38","slug":"preparedstateme","status":"publish","type":"post","link":"https:\/\/kazu.tv\/blog\/2008\/12\/19\/preparedstateme\/","title":{"rendered":"PreparedStatement\u3001ORDER BY\u306e\u4e2d\u306b\u306f?\u306f\u4f7f\u3048\u306a\u3044\u3002"},"content":{"rendered":"<p>\u30bf\u30a4\u30c8\u30eb\u901a\u308a\u3002<br \/>\n\u3054\u304f\u5358\u7d14\u306aDB\u306e\u4e2d\u8eab\u3092\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u30e1\u30f3\u30c6\u3057\u3066\u3044\u305f\u3002\u5404\u5217\u306e\u898b\u51fa\u3057\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u305d\u306e\u5217\u306e\u5024\u306b\u3088\u3063\u3066\u30bd\u30fc\u30c8\u3055\u308c\u308b\u4ed5\u7d44\u307f\u306b\u306a\u3063\u3066\u305f\u304b\u3089\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306aSQL\u3092prepare\u3057\u3088\u3046\u3068\u3057\u305f\u3051\u3069\u51fa\u6765\u306a\u304b\u3063\u305f\u3002<br \/>\n<code>SELECT * FROM TBL WHERE FIELD1=? ... ORDER BY ?<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30bf\u30a4\u30c8\u30eb\u901a\u308a\u3002 \u3054\u304f\u5358\u7d14\u306aDB\u306e\u4e2d\u8eab\u3092\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u30e1\u30f3\u30c6\u3057\u3066\u3044\u305f\u3002\u5404\u5217\u306e\u898b\u51fa\u3057\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u305d\u306e\u5217\u306e\u5024\u306b\u3088\u3063\u3066\u30bd\u30fc\u30c8\u3055\u308c\u308b\u4ed5\u7d44\u307f\u306b\u306a\u3063\u3066\u305f\u304b\u3089\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306aSQL\u3092prepare\u3057\u3088\u3046\u3068\u3057\u305f\u3051\u3069\u51fa\u6765\u306a\u304b\u3063\u305f\u3002 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[60],"tags":[373,374],"class_list":["post-711","post","type-post","status-publish","format-standard","hentry","category-java","tag-order-by","tag-preparedstatement"],"_links":{"self":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/posts\/711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/comments?post=711"}],"version-history":[{"count":0,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"wp:attachment":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}