[討論] SQLite query
想請問各位大大
最近重新翻了一遍sqlite
覺得一件奇怪的事情
SQLiteDatabase db = ...;
db.query(..., selection, selectionArgs,...);
通常selection 裡含 "?" 然後在 args 填入值
但事實上
db.query(..., selectionAndArgs, null, ...);
也是可以的
那為什麼要將原本sql與法中where的描述分成 selection和selectionArgs呢?
謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 59.113.208.129
※ 文章網址: https://www.ptt.cc/bbs/AndroidDev/M.1442550415.A.8C0.html
→
09/18 12:58, , 1F
09/18 12:58, 1F
→
09/18 12:58, , 2F
09/18 12:58, 2F
→
09/18 14:58, , 3F
09/18 14:58, 3F
→
09/18 15:08, , 4F
09/18 15:08, 4F
→
09/18 15:24, , 5F
09/18 15:24, 5F
→
09/18 15:24, , 6F
09/18 15:24, 6F
→
09/18 15:25, , 7F
09/18 15:25, 7F
→
09/18 15:25, , 8F
09/18 15:25, 8F
所以 db.rawQuery(...) 本身比較危險的意思嗎?
※ 編輯: issuemylove (59.113.208.129), 09/18/2015 17:23:20
→
09/19 00:14, , 9F
09/19 00:14, 9F
→
09/19 00:14, , 10F
09/19 00:14, 10F
→
09/19 02:13, , 11F
09/19 02:13, 11F