A. 鐓х墖鏁版嵁褰曞叆
1錛夐夋嫨鐓х墖搴擄紝鐐瑰嚮鈥滃姞鈥濓紝鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑緙栬緫閽誨瓟鐓х墖淇℃伅錛堝浘 15.6.1錛夈
鍥 15.6.1 鏂板為捇瀛旂収鐗
2錛夌収鐗囦俊鎮涓涓昏佸綍鍏モ滅収鐗囩紪鍙封濃滅収鐗囧簭鍙封濃滀綅緗鏍囪瘑鈥濃滈暅澶存柟鍚戔濅互鍙婂潗鏍 X銆乊 絳夈
鍏朵腑鈥滅収鐗囧簭鍙封濅腑闇瑕佸～鍐欏瑰簲鏁扮爜鐓х墖鐨勬枃浠跺悕錛堝叏鍚嶇殑鍚庡嚑浣嶆暟瀛楀嵆鍙錛夛紝鍏佽稿瑰簲澶氫釜鐓х墖錛岀収鐗囩紪鍙峰傛灉榪炵畫錛岀敤鈥-鈥濓紙鑻辨枃錛夐棿闅旓紝濡傛灉涓嶈繛緇錛岀敤鈥滐紝鈥濓紙鑻辨枃錛夐棿闅斻傚傦紝鏈 3 寮犵収鐗囨枃浠跺悕涓 IMG5037銆両MG5038銆両MG5039錛屽彲浠ュ～鍐欎負鈥5037-5039鈥濄傚綋鏁版嵁瀵煎叆妗岄潰緋葷粺鏃訛紝鍙浠ュ埄鐢ㄧ収鐗囧煎叆鍔熻兘灝嗘暟鐮佺収鐗囧煎叆鏁版嵁搴撲腑銆
鐓х墖鏁版嵁褰曞叆瀹屽悗錛屾寜鈥滅『瀹氣濆悗錛屾暟鎹鑷鍔ㄥ煎叆鍒楄〃妗嗭紝浠ユ柟渚挎祻瑙堬紙鍥15.6.2錛夈
鍥 15.6.2 嫻忚堝拰緙栬緫鐓х墖搴
3錛夎嫢瑕佺戶緇杈撳叆鏁版嵁錛岄噸澶 1 鑷 2 姝ュ嵆鍙銆
B. 濡備綍鍚慜RACLE鏁版嵁搴撹〃涓瀛樺叆甯﹀浘鐗囩殑鏂囦歡錛
create table test
(
NID VARCHAR2(1) not null,
IMG BLOB,
zhengqueFlag VARCHAR2(1),
cuowuFlag VARCHAR2(1)
)
璇存槑錛
1銆両MG瀛楁靛彧闇瑕佷繚瀛樺浘鐗囷紝灝嗗浘鐗囦俊鎮緇忚繃Base64緙栫爜錛屽瓨鍒版暟鎹搴揃LOB瀛楁典腑銆傛樉紺虹殑鏃跺欒佺粡榪嘊ase64瑙ｇ爜銆
2銆佸逛簬鍍忊滄ｇ『鈥濄佲滈敊璇鈥濈敤鏍囧織浣嶅湪鍖哄埆銆備綘鍙浠ョ敤1琛ㄧず姝ｇ『銆0琛ㄧず閿欒銆傚綋鐒朵綘涔熷彲浠ョ敤奼夊瓧鐨勪繚瀛樿繖鏍風殑淇℃伅銆傝嚜宸辨潵璁捐°
鐒跺悗浣犲埌緗戜笂鏌ヤ竴涓嬫庝箞鏍峰笲LOB瀛楁佃繘琛屾搷浣溿傚傛灉涓嶈岋紝鎴戝湪澧炲姞鍥炲嶃