JAVA-JDBC闈㈣瘯棰?- 鐧惧害鏂囧簱

鏂板缓

涓婁紶

棣栭〉

鍔╂墜

鏈�杩?/div>

璧勬枡搴?/div>

宸ュ叿

1 Class.forName()

鏂规硶鏈変粈涔堜綔鐢�锛�

 

鍒濆�嬪寲鍙傛暟鎸囧畾鐨勭被锛屽苟涓旇繑鍥炴�ょ被瀵瑰簲鐨?/p>

Class 

瀵硅薄

 

 

2 PreparedStatement

姣?/p>

Statement

鏈変粈涔堜紭鍔匡紵

 

PreparedStatements

鏄?/p>

棰?/p>

缂?/p>

璇?/p>

鐨?/p>

锛?/p>

鍥?/p>

姝?/p>

锛?/p>

鎬?/p>

鑳?/p>

浼?/p>

鏇?/p>

濂?/p>

銆?/p>

鍚?/p>

鏃?/p>

锛?/p>

涓?/p>

鍚?/p>

鐨?/p>

鏌?/p>

璇?/p>

鍙?/p>

鏁?/p>

鍊?/p>

锛?/p>

PreparedStatement

鍙�浠ラ噸鐢ㄣ�?/p>

 

 

3 

浠�涔堟椂鍊欎娇鐢?/p>

CallableStatement

锛熺敤鏉ュ噯澶?/p>

CallableStatement

鐨勬柟娉曟槸浠�涔堬紵

 

CallableStatement

鐢ㄦ潵鎵ц�屽瓨鍌ㄨ繃绋嬨�傚瓨鍌ㄨ繃绋嬫槸鐢辨暟鎹�搴撳瓨鍌ㄥ拰鎻愪緵鐨勩�傚瓨鍌ㄨ繃绋嬪彲浠ユ帴

鍙楄緭鍏ュ弬鏁帮紝涔熷彲浠ユ湁杩斿洖缁撴灉銆傞潪甯搁紦鍔变娇鐢ㄥ瓨鍌ㄨ繃绋嬶紝鍥犱负瀹冩彁渚涗簡瀹夊叏鎬у拰妯″潡鍖栥�?/p>

鍑嗗�囦竴涓?/p>

CallableStatement

鐨勬柟娉曟槸锛?/p>

 

CallableStatement Connection.prepareCall();

 

 

4 

鏁版嵁搴撹繛鎺ユ睜鏄�浠�涔堟剰鎬濓紵

 

鍍忔墦寮�鍏抽棴鏁版嵁搴撹繛鎺ヨ繖绉嶅拰鏁版嵁搴撶殑浜や簰鍙�鑳芥槸寰堣垂鏃剁殑锛�

灏ゅ叾鏄�褰撳�㈡埛绔�鏁伴噺澧炲姞鐨勬�?/p>

鍊欙紝

浼氭秷鑰楀ぇ閲忕殑璧勬簮锛?/p>

鎴愭湰鏄�闈炲父楂樼殑銆?/p>

鍙�浠ュ湪搴旂敤鏈嶅姟鍣ㄥ惎鍔ㄧ殑鏃跺�欏缓绔嬪緢澶氫釜鏁版嵁搴?/p>

杩炴帴骞剁淮鎶ゅ湪涓�涓�姹犱腑銆?/p>

杩炴帴璇锋眰鐢辨睜涓�鐨勮繛鎺ユ彁渚涖�?/p>

鍦ㄨ繛鎺ヤ娇鐢ㄥ畬姣曚互鍚庯紝

鎶婅繛鎺ュ綊杩樺埌

姹犱腑锛屼互鐢ㄤ簬婊¤冻灏嗘潵鏇村�氱殑璇锋眰銆?/p>

 

 

5 

瑙ｉ噴涓?/p>

Serialization

鍜?/p>

Deserialization

銆?/p>

 

Java

鎻愪緵浜嗕竴绉嶅彨鍋氬�硅薄搴忓垪鍖栫殑鏈哄埗锛�

浠栨妸瀵硅薄琛ㄧず鎴愪竴杩炰覆鐨勫瓧鑺傦紝

閲岄潰鍖呭惈浜嗗�硅薄鐨�

鏁版嵁锛?/p>

瀵硅薄鐨勭被鍨嬩俊鎭�锛�

瀵硅薄鍐呴儴鐨勬暟鎹�鐨勭被鍨嬩俊鎭�绛夌瓑銆傚洜姝わ紝

搴忓垪鍖栧彲浠ョ湅鎴愭槸涓轰簡鎶?/p>

瀵硅薄瀛樺偍鍦ㄧ�佺洏涓婃垨鑰呮槸浠庣�佺洏涓婅�诲嚭鏉ュ苟閲嶅缓瀵硅薄鑰屾妸瀵硅薄鎵佸钩鍖栫殑涓�绉嶆柟寮忋�?/p>

鍙嶅簭鍒楀寲

鏄�鎶婂�硅薄浠庢墎骞崇姸鎬佽浆鍖栨垚娲诲姩瀵硅薄鐨勭浉鍙嶇殑姝ラ�ゃ�?/p>

 

 

 

6 

浠�涔堟槸

JDBC

锛屽湪浠�涔堟椂鍊欎細鐢ㄥ埌瀹冿紵

 

 

JDBC

鐨勫叏绉版槸

Java DataBase Connection

锛屼篃灏辨槸

Java

鏁版嵁搴撹繛鎺ワ紝鎴戜滑鍙�浠ョ敤瀹冩潵鎿嶄綔鍏�

绯诲瀷鏁版嵁搴撱�?/p>

JDBC

鎺ュ彛鍙婄浉鍏崇被鍦?/p>

java.sql

鍖呭拰

javax.sql

鍖呴噷銆?/p>

鎴戜滑鍙�浠ョ敤瀹冩潵杩炴帴鏁版嵁搴擄�?/p>

鎵ц��

SQL

鏌ヨ��锛屽瓨鍌ㄨ繃绋嬶紝骞跺�勭悊杩斿洖鐨勭粨鏋溿�?/p>