å 为å¨mybatisä¸ï¼â${xxx}âè¿æ ·æ ¼å¼çåæ°ä¼ç´æ¥åä¸sqlç¼è¯ï¼ä»èä¸è½é¿å æ³¨å ¥æ»å»ãä½æ¶åå°å¨æ表ååååæ¶ï¼åªè½ä½¿ç¨â${xxx}âè¿æ ·çåæ°æ ¼å¼ï¼æ以ï¼è¿æ ·çåæ°éè¦ç¨åºå¼åè å¨ä»£ç ä¸æå·¥è¿è¡å¤çæ¥é²æ¢æ³¨å ¥ã
#xxx# 代表xxxæ¯å±æ§å¼,mapéé¢çkeyæè æ¯ä½ çpojo对象éé¢çå±æ§, ibatisä¼èªå¨å¨å®çå¤é¢å ä¸å¼å·,表ç°å¨sqlè¯å¥æ¯è¿æ ·ç where xxx = 'xxx' ;
$xxx$ åæ¯æxxxä½ä¸ºå符串æ¼æ¥å°sqlè¯å¥ä¸, æ¯å¦ order by topicId , è¯å¥è¿æ ·å ... order by #xxx# ibatis å°±ä¼ç¿»è¯æorder by 'topicId' ï¼è¿æ ·å°±ä¼æ¥éï¼ è¯å¥è¿æ ·å ... order by $xxx$ ibatis å°±ä¼ç¿»è¯æ order by topicId
#å°ä¼ å
¥çæ°æ®é½å½æä¸ä¸ªå符串ï¼ä¼å¯¹èªå¨ä¼ å
¥çæ°æ®å ä¸ä¸ªåå¼å·ãå¦ï¼order by #user_id#ï¼å¦æä¼ å
¥çå¼æ¯111,é£ä¹è§£ææsqlæ¶çå¼ä¸ºorder by "111", å¦æä¼ å
¥çå¼æ¯idï¼å解ææçsql为order by "id".
ãã
2. $å°ä¼ å
¥çæ°æ®ç´æ¥æ¾ç¤ºçæå¨sqlä¸ãå¦ï¼order by $user_id$ï¼å¦æä¼ å
¥çå¼æ¯111,é£ä¹è§£ææsqlæ¶çå¼ä¸ºorder by user_id, å¦æä¼ å
¥çå¼æ¯idï¼å解ææçsql为order by id
æ以说#æ¹å¼è½å¤å¾å¤§ç¨åº¦é²æ¢sqlæ³¨å ¥ã