常用数据库的链接方法.docVIP

常用数据库的链接方法 甯哥敤鏁版嵁搴撶殑閾炬帴鏂规硶棣栭〉鏂伴椈璁哄潧缇ょ粍Blog鏂囨。涓嬭浇璇讳功Tag缃戞憳鎼滅储.NETJava娓告垙瑙嗛浜烘墠澶栧寘鍩硅鏁版嵁搴撲功搴楃▼搴忓憳 娆㈣繋鎮?娓稿 | 閫€鍑?| 鐧诲綍 娉ㄥ唽 甯姪 鎴戠殑甯栧瓙鎴戝弬涓庣殑甯栧瓙鎴戠殑绌洪棿鎴戠殑缃戞憳 CSDNCSDN绀惧尯JavaJ2SE / 鍩虹绫诲皢甯栧瓙鎻愬墠 鏀捐繘鎴戠殑缃戞憳 鎺ㄨ崘缁欏ソ鍙?鎴戣鎻愰棶 甯栧瓙鍔犲垎 鐢熸垚甯栧瓙 缃《 鎺ㄨ崘(鍔犵簿) 鍙栨秷鎺ㄨ崘(鍔犵簿) 閿佸畾甯栧瓙 绉诲姩甯栧瓙 鍙栨秷寮曠敤缁撳笘鍘?.. 绠＄悊鑿滃崟 椤甸潰椋庢牸鍒囨崲鏍囧噯椋庢牸鑰佺増鏈鍧? 甯哥敤鏁版嵁搴撶殑閾炬帴鏂规硶 [宸茬粨甯?缁撳笘浜?AwL_1124] 鍔犱负濂藉弸 鍙戦€佺淇? 鍦ㄧ嚎鑱婂ぉ AwL_1124 鍙扮悆 绛夌骇: 鍙敤鍒嗙瓑绾э細瀵屽啘 鎬绘妧鏈垎锛?81 鎬绘妧鏈垎鎺掑悕锛?7444 缁撳笘鐜囷細100.00% 鍙戣〃浜庯細2008-05-02 09:14:01 妤间富 鑷繁鏀惰棌鐨? 鎻愪緵缁欏ぇ瀹? Java codeMySQL锛? String Driver=com.mysql.jdbc.Driver; //椹卞姩绋嬪簭 String URL=jdbc:mysql://localhost:3306/db_name?useUnicode=trueamp;characterEncoding=UTF-8; //杩炴帴鐨刄RL,db_name涓烘暟鎹簱鍚嶏紝娉ㄦ剰淇敼缂栫爜绫诲瀷 String Username=username; //鐢ㄦ埛鍚? String Password=password; //瀵嗙爜 Class.forName(Driver).new Instance(); Connection con=DriverManager.getConnection(URL,Username,Password); Microsoft SQL Server 2.0椹卞姩(3涓猨ar鐨勯偅涓?: String Driver=com.microsoft.jdbc.sqlserver.SQLServerDriver; //杩炴帴SQL鏁版嵁搴撶殑鏂规硶 String URL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name; //db_name涓烘暟鎹簱鍚? String Username=username; //鐢ㄦ埛鍚? String Password=password; //瀵嗙爜 Class.forName(Driver).new Instance(); //鍔犺浇鏁版嵁鍙┍鍔? Connection con=DriverManager.getConnection(URL,UserName,Password); // Microsoft SQL Server 3.0椹卞姩(1涓猨ar鐨勯偅涓?: // 鑰佺传绔瑰畬鍠? String Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver; //杩炴帴SQL鏁版嵁搴撶殑鏂规硶 String URL=jdbc:sqlserver://localhost:1433;DatabaseName=db_name; //db_name涓烘暟鎹簱鍚? String Username=username; //鐢ㄦ埛鍚? String Password=password; //瀵嗙爜 Class.forName(Driver).new Instance(); //鍔犺浇鏁版嵁鍙┍鍔? Connection con=DriverManager.getConnection(URL,UserName,Password); // Sysbase: String Driver=com.sybase.jdbc.SybDriver; //椹卞姩绋嬪簭