08. JDBC note.docVIP

08. JDBC note JDBC閮ㄥ垎 缁堢杩涘叆mysql锛?mysql -u root鍥炶溅 缁堢杩涘叆oracle锛?telnet 3 鐒跺悗sqlplus openlab/open123 MySQL甯哥敤鍛戒护锛?show databases; use databaseName; show tables; 涓€銆佹杩癑DBC JDBC浠庣墿鐞嗙粨鏋勪笂璇村氨鏄疛ava璇█璁块棶鏁版嵁搴撶殑涓€濂楁帴鍙ｉ泦鍚堛€? 浠庢湰璐ㄤ笂鏉ヨ灏辨槸璋冪敤鑰?绋嬪簭鍛?鍜屽疄鐜拌€?鏁版嵁搴撳巶鍟?涔嬮棿鐨勫崗璁€? JDBC API 浣垮緱寮€鍙戜汉鍛樺彲浠ヤ娇鐢ㄧ函Java鐨勬柟寮忔潵杩炴帴鏁版嵁搴擄紝骞惰繘琛屾搷浣溿€? ODBC锛氬熀浜嶤璇█鐨勬暟鎹簱璁块棶鎺ュ彛銆? JDBC锛氭槸Java鐗堢殑ODBC銆? JDBC 鐗规€э細楂樺害鐨勪竴鑷存€с€佺畝鍗曟€?甯哥敤鐨勬帴鍙ｅ彧鏈?銆?涓?銆? 椹卞姩绋嬪簭鎸夌収宸ヤ綔鏂瑰紡鍒嗕负鍥涚被锛? 1銆丣DBC-ODBC bridge + ODBC 椹卞姩 JDBC-ODBC bridge妗ラ┍鍔ㄥ皢JDBC璋冪敤缈昏瘧鎴怬DBC璋冪敤锛屽啀鐢監DBC椹卞姩缈昏瘧鎴愯闂暟鎹簱鍛戒护銆? 浼樼偣锛氬彲浠ュ埄鐢ㄧ幇瀛樼殑ODBC鏁版嵁婧愭潵璁块棶鏁版嵁搴撱€? 缂虹偣锛氫粠鏁堢巼鍜屽畨鍏ㄦ€х殑瑙掑害鏉ヨ鐨勬瘮杈冨樊銆備笉閫傚悎鐢ㄤ簬瀹為檯椤圭洰銆? 2銆佸熀浜庢湰鍦癆PI鐨勯儴鍒咼ava椹卞姩 鎴戜滑搴旂敤绋嬪簭閫氳繃鏈湴鍗忚璺熸暟鎹簱鎵撲氦閬撱€傜劧鍚庡皢鏁版嵁搴撴墽琛岀殑缁撴灉閫氳繃椹卞姩绋嬪簭涓殑Java閮ㄥ垎杩斿洖缁欏鎴风绋嬪簭銆? 浼樼偣锛氭晥鐜囪緝楂樸€? 缂虹偣锛氬畨鍏ㄦ€ц緝宸€? 3銆佺函Java鐨勭綉缁滈┍鍔? (涓棿鍗忚) (鏈湴鍗忚) app JDBC 绾疛ava 涓棿鏈嶅姟鍣? DB 缂虹偣锛氫袱娈甸€氫俊锛屾晥鐜囨瘮杈冨樊 浼樼偣锛氬畨鍏ㄤ俊杈冨ソ 4銆佺函Java鏈湴鍗忚锛氶€氳繃鏈湴鍗忚鐢ㄧ函Java鐩存帴璁块棶鏁版嵁搴撱€? 鐗圭偣锛氭晥鐜囬珮锛屽畨鍏ㄦ€уソ銆? 浜屻€丣DBC 缂栫▼鐨勬楠? import java.sql.*; 0.鍙傛暟鍖? String driverName = com.mysql.jdbc.Driver; String url = jdbc:mysql://localhost:3306/test; //鍗忚锛涘簱鎴栨湇鍔″櫒鍚嶇О锛涙湇鍔″櫒IP锛岀鍙? String username = root; String password=; /* Oracle鐨勮繛鎺? String driverName = oracle.jdbc.driver.OracleDriver; String url = jdbc:oracle:thin:@3:1521:ora10g; String username = openlab; String password=open123;*/ //浠ヤ笅杩欎簺閮介渶瑕佸啓鍦ㄦ湁寮傚父鐨勪唬鐮佸潡閲岋紝鎵€浠ラ渶瑕佹彁鍙栧嚭鏉ャ€? Connection conn = null; Statement stmt = null; ResultSet rs = null;//寤鸿鐢≒reparedStatement 1.鍔犺浇鍜屾敞鍐屾暟鎹簱椹卞姩 Class.forName(driverName);//鑷姩娉ㄥ唽锛涢渶瑕佹妸椹卞姩鐨刯ar鍖呭杩涙潵锛涢渶澶勭悊寮傚父 /*鏂规硶浜岋細瀹炰緥鍖栧叿浣撶殑Driver椹卞姩锛岃繖鍐欐硶涓€鑸笉鐢?涓嶈兘鍙傛暟鍖栭┍鍔ㄥ悕锛屼笉澶熺伒娲? Driver driver = new com.mysql.jdbc.Driver(); DriverManager.registerDriver(driv