1.鍑嗗宸ヤ綔: 鍑嗗鐩稿叧鐨勮蔣浠?Eclipse闄ゅ,寮婧愯蔣浠跺彲浠ヤ粠瀹樼綉涓嬭澆)
<1>.Microsoft SQL server 2005 Express Edition
涓嬭澆鍦板潃:http://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR_CHS.EXE
<2>.SQL Server Management Studio
<3>.SQL Server 2005 driver for JDBC
2.閮戒笅杞藉畬涔嬪悗寮濮嬭繘琛屽畨瑁?,鍓嶄袱涓槸灞炰簬鏁版嵁搴撹蔣浠?姝ｅ父瀹夎鍗沖彲(娉ㄦ剰鏁版嵁搴撶櫥闄嗕笉瑕佷嬌鐢╳indows楠岃瘉)
<1> 灝咼DBC瑙ｅ帇緙╁埌浠繪剰浣嶇疆,姣斿瑙ｅ帇鍒癈鐩榩rogram files涓嬮潰,騫跺湪瀹夎鐩綍閲屾壘鍒皊qljdbc.jar鏂囦歡,寰楀埌鍏惰礬寰勫紑濮嬮厤緗幆澧冨彉閲?/p>
鍦ㄧ幆澧冨彉閲廲lasspath 鍚庨潰榪藉姞 C:\Program Files\Microsoft SQL Server2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar
<2> 璁劇疆SQLEXPRESS鏈嶅姟鍣?
a.鎵撳紑SQL Server Configuration Manager -> SQLEXPRESS鐨勫崗璁?-> TCP/IP
b.鍙抽敭鍗曞嚮鍚姩TCP/IP
c.鍙屽嚮榪涘叆灞炴?鎶奍P鍦板潃涓殑IP all涓殑TCP绔彛璁劇疆涓?433
d.閲嶆柊鍚姩SQL Server 2005鏈嶅姟涓殑SQLEXPRESS鏈嶅姟鍣?br />
e.鍏抽棴SQL Server Configuration Manager
<3> 鎵撳紑鍒氬垰瀹夎濂界殑 SQL Server Management Studio,榪炴帴SQLEXPRESS鏈嶅姟鍣? 鏂板緩鏁版嵁搴?璧峰悕瀛椾負sample
<4> 鎵撳紑Eclipse
a.鏂板緩宸ョ▼-> java -> java project,璧峰悕涓篢est
b.閫夋嫨eclipse->紿楀彛->棣栭夐」->java->installed JRE 緙栬緫宸茬粡瀹夎濂界殑jdk,鏌ユ壘鐩綍娣誨姞sqljdbc.jar
c.鍙抽敭鍗曞嚮鐩綍紿楀彛涓殑Test, 閫夋嫨Build Path ->Configure Build Path..., 娣誨姞鎵╁睍jar鏂囦歡,鍗蟲妸sqljdbc.jar娣誨姞鍒板叾涓?br />
<5> 緙栧啓java浠ｇ爜鏉ユ祴璇曡繛鎺ユ暟鎹簱
紼嬪簭浠ｇ爜:
import java.sql.*;
public class Test {
public static void main(String[] srg) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //鍔犺澆JDBC椹卞姩
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample"; //榪炴帴鏈嶅姟鍣ㄥ拰鏁版嵁搴搒ample
String userName = "sa"; //榛樿鐢ㄦ埛鍚?br />
String userPwd = "123456"; //瀵嗙爜
Connection dbConn;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!"); //濡傛灉榪炴帴鎴愬姛 鎺у埗鍙拌緭鍑篊onnection Successful!
} catch (Exception e) {
e.printStackTrace();
}
}
}
娉?/strong>:
1.鍥犱負SQLexpress鏈嶅姟鍣ㄩ粯璁ゆ槸紱佺敤鐨勫茍涓旂鍙ｅ彿娌℃湁閰嶇疆,鎵浠ヨ榪涜閲嶆柊璁劇疆
2.濡傛灉浣犱互鍓嶇敤java榪炴帴sql server 2000鐨勮瘽灝辮娉ㄦ剰浜?
鍦╯ql server 2000 涓姞杞介┍鍔ㄥ拰URL璺緞鐨勮鍙ユ槸
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=sample";
鑰宻ql server 2005 涓姞杞介┍鍔ㄥ拰url鐨勮鍙ュ垯涓?/p>
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";
濡傛灉鍐欐硶閿欒灝嗕細鎵句笉鍒伴┍鍔?
濂戒簡,搴旇娌′粈涔堢枒闂簡鍚?..鍋舵槸鏈夎繛鎺ュけ璐ョ粡鍘嗘墠鍒嗕韓緇欏ぇ瀹剁殑...
]]>