é¦å
ç¡®ä¿SQLSERVERæå¡æ£å¨è¿è¡ï¼å¹¶å¯ä»¥å
许è¿ç¨è®¿é®è¿æ¥
ç¶åæå¦ä¸æ¥éª¤è¿è¡è¿æ¥
1.å®è£
JDBC驱å¨
1ï¼ä¸è½½JDBC驱å¨
http://www.microsoft.com/zh-cn/download/details.aspx?id=117742ï¼æ§è¡sqljdbc_4.0.2206.100_chs.exe解å驱å¨æ件
3ï¼æ·è´ä»¥ä¸ç®å½ä¸çsqljdbc_auth.dllå°WindowsçSystem32ç®å½ã对x64çæºåï¼x64çdllæ·å°C:\Windows\System32,x86çdllæ·å°C:\Windows\SysWOW64ç®å½ã
Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\chs\auth\
2.å¨Javaç¨åºä¸è¿æ¥SQL Server
classpathä¸å ä¸å®è£
好çSQL Server jdbc jarå
Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\chs\sqljdbc4.jar
è¿æ¥SQL ServerçJDBC代ç
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:54364;databaseName=master;IntegratedSecurity=True";
Connection con = DriverManager.getConnection(url);
å¨SQL Server Browseræå¡å¼å¯çæ
åµä¸ä¹å¯ä»¥éè¿æå¡åè¿æ¥
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=master;IntegratedSecurity=True";
Connection con = DriverManager.getConnection(url);
3.身份éªè¯æ¨¡å¼
SQL Serveré»è®¤ä½¿ç¨Windows身份éªè¯æ¨¡å¼ï¼è¿ä¹æ¯å®æ¹æ¨èç模å¼ï¼å®å
¨æ§æ´é«ãä¸é¢çè¿æ¥ä¾åå°±æ¯éç¨çWindows认è¯ãå¦æè¦ä½¿ç¨æ··å认è¯æ¨¡å¼ï¼éè¦ä¸è½½SQL Server Management Studio,并éè¿SQL Server Management Studioä¿®æ¹è®¤è¯æ¨¡å¼ä¸ºæ··å认è¯æ¨¡å¼ã
SQL Server Management Studioçä¸è½½å°å
http://www.microsoft.com/zh-cn/download/details.aspx?id=8961ä¿®æ¹SQL Server认è¯æ¨¡å¼çæ¹æ³
http://technet.microsoft.com/zh-cn/library/ms188670(v=sql.105).aspx
æ··å认è¯æ¨¡å¼ä¸ï¼å¯ä»¥ç±æ°æ®åºè¿è¡è®¤è¯ï¼è¿æ¥æ¶éè¦æä¾ç¨æ·ååå¯ç
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:54364;databaseName=master";
Connection con = DriverManager.getConnection(url,"user","password");