灏侀潰锛氬鏍″鏅痻dm锛岀澶у鍋囨湡鎰夊揩锛侊紒馃懆馃捇浠婂ぉ鍚畬銆婅矾杩囦汉闂淬€嬫紨鍞变細鐜板満闄愰噺鐗堬紝鎴戠埍涓婁簡涓€琛屾瓕璇嶃€傝鏉ユ儹鎰э紝浜哄彧瀛︿細鐖憋紝瑙嗘濡傚綊銆?銆佷笟鍔￠渶姹傚涓嬶細鍓嶅彴缁欐垜鍙戜竴涓猟ocumentId鍜屼竴涓狶ist瀵硅薄缁欐垜銆傛墽琛屾潯浠讹細閫氳繃List涓殑杩欎釜documentId鍜孶pdateDocumentAnswer.id淇敼document_answer琛ㄤ腑鐨勬暟鎹€傜畝鍗曟潵璇达細灏辨槸甯屾湜閫氳繃涓€鏉pdate璇彞锛屾牴鎹笉鍚岀殑鎯呭喌锛屾敼鍙樺鏉￠渶瑕佹敼鍙樼殑鏁版嵁銆傛€濊矾涓€锛氭垜浠寜鐓ф垜浠渶绠€鍗曠殑鎬濊矾鏉ユ€濊€冿細灏辨槸鎷嗘垚涓€鍙ヨ瘽鎵ц锛屽湪涓€涓猣or寰幆涓墽琛屽鏉pdate璇彞銆倁pdatedocument_answersetwheredocument_id=#{documentId}andid=#{answer.id}杩欐牱鍐欑殑璇濓紝鎴戜滑mapper灞傛帴鏀跺埌鐨勫弬鏁板簲璇ユ槸锛歩ntpatchByDocumentId(@Param("documentId")LongdocumentId,@Param("绛旀")UpdateDocumentAnswer绛旀);瀹炵幇鏄彲浠ュ疄鐜扮殑锛屼絾鏄敱浜庨渶瑕佹墽琛屽鏉pdate璇彞锛屾晥鐜囧疄鍦ㄤ笉鏁㈡伃缁淬€傚鏋滀綘灏濊瘯杩囷紝浣犲氨浼氱煡閬撳湪for寰幆涓墽琛宻ql璇彞鏄潪甯镐笉鍙彇鐨勩€備竴涓櫘閫氱殑sql鎴戜滑閮借浼樺寲鍐嶄紭鍖栵紝鏇翠綍鍐典竴涓柟娉曢渶瑕佹墽琛屽鏉ql璇彞銆傛墍浠ュ憿锛燂紵鎺ㄨ崘澶у鐢ㄧ櫨搴︺€佸繀搴斻€佽胺姝屾悳绱煈煉昏繖绉嶉棶棰樻垜浠兂鍒颁簡锛屽ぇ姒傜巼鍏朵粬浜轰篃浼氶亣鍒般€傛壘鍟婃壘锛屾灉鐒剁瓟妗堜笉澶氥€傞偅涔堟垜浠户缁€濊€?銆傪煆嶆€濊€?锛氳繕璁板緱鎴戝墠闈㈡枃绔犺鐨勫悧锛氭垜甯屾湜閫氳繃涓€鏉pdate璇彞锛屾牴鎹笉鍚岀殑鏉′欢鏀瑰彉澶氭潯闇€瑕佹敼鍙樼殑鏁版嵁銆傛垜浠洿鎺ユ悳绱竴涓猽pdate鏄浣曚慨鏀瑰鏉′笉鍚屾潯浠剁殑鏁版嵁锛屼細鍙戠幇绫讳技涓嬮潰鐨凷QL璇彞銆倁pdatetablenamesetcolumn1=casewhencondition1thenvalue1whencondition2thenvalue2end,column2=casewhencondition1thenvalue1whencondition2thenvalue2end,wherecondition鑰佸疄璇达紝鐪嬭繖鏉¤鍙ュ湪閭ｄ竴鍒伙紝鎴戣寰楁垜鍐嶄篃娌℃湁瀛﹁繃mysql锛岃繛涓猚rud宸ョ▼甯堥兘绠椾笉涓婏紙鎹傝劯锛夈€傝鏄庯細鎴戜滑瑕佷慨鏀圭1鍒楋紝褰撴弧瓒虫潯浠?鏃讹紝灏嗙1鍒椾慨鏀逛负value1鐒跺悗鏄痶hen锛屽綋婊¤冻鏉′欢2鏃讹紝灏嗙1鍒椾慨鏀逛负value2鐒跺悗鏄痶hen銆傝繖鏍凤紝鎴戜滑灏卞彲浠ユ墽琛屽鏉¤鍙ヤ簡銆?.瀹炵幇鎴戜滑灏嗘敼鍙樹箣鍓峬apper灞傜殑鎺ュ彛浼犲叆鐨勫弬鏁般€俰ntpatchByDocumentId(@Param("documentId")LongdocumentId,@Param("answers")Listanswers);mapper.xml鐨勫疄闄呮儏鍐靛涓嬶細updatedocument_answerwhenid=#{answer.id}then#{answer.templateQuestionId}褰搃d=#{answer.id}鐒跺悗#{answer.answer}褰搃d=#{answer.id}then#{answer.comments}document_id=#{documentId}andidin#{answer.id}鐢熸垚鐨剆ql鏃ュ織updatedocument_answerSETtemplate_question_id=casewhenid=?鐒跺悗锛熷綋id=?鐒跺悗锛熺粨鏉燂紝answer=casewhenid=?鐒跺悗锛熷綋id=?鐒跺悗锛熺粨鏉燂紝璇勮=casewhenid=?鐒跺悗锛熷綋id=?鐒跺悗锛熷湪document_id=?缁撴潫andidin(?,?)鎹笂鎴戜滑鎯宠鐨勪环鍊硷細updatedocument_answerSETtemplate_question_id=casewhenid=1then2whenid=1then3end,answer=casewhenid=1then'content1'whenid=2then'content2'end,comments=casewhenid=1then'comment1'褰搃d=2then'璇勮2'endWHEREdocument_id=2andidin(1,2)鎵ц瑙勫垯锛氫笂杩版柟娉曚腑锛屾洿鏂拌褰曠殑鏉℃暟鍙栧喅浜庡垪琛ㄩ泦鍚堢殑鏉℃暟锛屾瘡鏉¤褰曚腑鐨勫€煎拰瀵瑰簲鐨刬d璁板綍閮戒竴涓€瀵瑰簲瀹屼簡锛屽懆鏃ュ啀鍙戜竴绡囥€傚悗璁颁竴璧峰姫鍔涘ぇ瀹跺ソ锛屾垜鏄崥涓诲畞鍦ㄦ烦锛氶椤靛笇鏈涜繖绡囨枃绔犺兘璁╂偍鏈夋墍鏀惰幏锛侊紒锛佺鎰挎垜浠細鐩歌锛屾湁鎵€鎴愬氨銆傛杩庡ぇ瀹朵竴璧疯璁洪棶棰橉煒侊紝韬轰笅馃泴鐭ヤ箮|瀹佸湪娣崇畝涔瀹佸湪绾疌SDN|瀹佸湪娣虫帢閲憒瀹佸湪娣冲崥瀹㈠洯|
