import java.sql.*;
/**
* java 連接sqlserver數據庫語句
* @author Administrator
*
*/
public class Main {
???
??? public static void main(String [] args) throws SQLException {
????????
????????
????????
???????? String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";??????? //加載驅動
???????? String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=Test";??? //地址及數據庫名稱
???
???????? //登錄用戶名和密碼
???????? String userName="sa";
???????? String userPwd="123";
???
????????? try {
?????????????
????????????? Class.forName(driverName);
????????????? Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
????????????? System.out.println("連接數據庫成功");
?????????????
????????? }
?????????
????????? catch(Exception e) {
?????????????? System.out.print("連接失敗");
????????????? e.printStackTrace();
????????? }
???????
???? }
????
}

java 連接sqlserver數據庫語句