import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
public class SQLServerConnection {
    public static void main(String[] args) {
        String url = "jdbc:sqlserver://localhost:1433;databaseName=YourDatabaseName;integratedSecurity=true";
        String username = "YourWindowsUserName"; // 此處填入你的 Windows 用戶名
        String password = ""; // 由于使用 Windows 身份驗(yàn)證，密碼為空
 
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection connection = DriverManager.getConnection(url, username, password);
            // 連接成功后，可以執(zhí)行SQL語句等操作
            System.out.println("Connected to SQL Server!");
            connection.close();
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>9.2.1.jre8</version><!-- 請使用最新的版本號 -->
</dependency>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
import com.microsoft.sqlserver.jdbc.SQLServerDriver;
 
public class SQLServerConnectionExample {
 
    public static void main(String[] args) {
        String server = "your_server_name"; // 例如："localhost"
        String database = "your_database_name";
        String username = "your_windows_username"; // 使用Windows身份驗(yàn)證的用戶名
        String password = "your_password"; // 用戶的密碼
 
        try {
            // 加載SQL Server JDBC驅(qū)動(dòng)
            Class.forName(SQLServerDriver.class.getName());
 
            // 使用Windows身份驗(yàn)證連接SQL Server
            String url = "jdbc:sqlserver://" + server + ";databaseName=" + database + ";integratedSecurity=true";
            Connection connection = DriverManager.getConnection(url);
 
            // 執(zhí)行SQL查詢
            // 假設(shè)你有一個(gè)表名為"Employees"的表，并且有一個(gè)名為"ID"的主鍵
            String query = "SELECT * FROM Employees WHERE ID = ?";
            PreparedStatement statement = connection.prepareStatement(query);
            statement.setInt(1, 1); // 假設(shè)你想查詢ID為1的員工
            ResultSet resultSet = statement.executeQuery();
 
            // 處理結(jié)果集
            while (resultSet.next()) {
                // 獲取結(jié)果集中的數(shù)據(jù)
                int empId = resultSet.getInt("ID");
                String empName = resultSet.getString("Name");
                System.out.println("Employee ID: " + empId + ", Name: " + empName);
            }
 
            // 關(guān)閉資源
            resultSet.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
}

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>latest-version</version>
</dependency>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.sql.DataSource;
 
public class SQLServerConnection {
 
    public static void main(String[] args) {
        String server = "your-server-name"; // 例如: localhost
        String database = "your-database-name";
 
        // 使用DataSource獲取Connection
        try (Connection connection = getDataSourceConnection(server, database)) {
            // 執(zhí)行SQL語句或操作
            System.out.println("Connection established successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
 
    private static Connection getDataSourceConnection(String server, String database) throws SQLException {
        // 創(chuàng)建DataSource對象
        DataSource dataSource = createDataSource();
 
        // 獲取Connection
        return dataSource.getConnection(server, database);
    }
 
    private static DataSource createDataSource() {
        // 創(chuàng)建DataSource對象
        DataSource dataSource = new DataSource() {
            // 實(shí)現(xiàn)DataSource的getConnection方法
            @Override
            public Connection getConnection() throws SQLException {
                return getConnection(null, null);
            }
 
            @Override
            public Connection getConnection(String username, String password) throws SQLException {
                // 這里不需要提供用戶名和密碼，因?yàn)槭褂玫氖荳indows身份驗(yàn)證
                if (username != null && password != null) {
                    throw new IllegalArgumentException("Windows身份驗(yàn)證不需要用戶名和密碼。");
                }
 
                // 使用DriverManager.getConnection來獲取Connection
                return DriverManager.getConnection("jdbc:sqlserver://" + server + ";databaseName=" + database);
            }
        };
 
        return dataSource;
    }
}