本文共 954 字，大约阅读时间需要 3 分钟。

首先添加maven依赖：

   <dependency>            <groupId>com.microsoft.sqlserver</groupId>            <artifactId>sqljdbc4</artifactId>            <version>4.0</version>        </dependency>

示例代码：

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class SQLServerJDBCTest {    public static void main(String[] args)throws Exception {        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");        String url = "jdbc:sqlserver://数据库IP:端口号;database=数据库名称;";        String username = "用户名";        String password="密码";        Connection connection = DriverManager.getConnection(url,username,password);        String sql = "select count(1) from ad.test ";        Statement statement = connection.prepareStatement(sql);        ResultSet rs = statement.executeQuery(sql);        while(rs.next()){            int result = rs.getInt(1);            System.out.println(result);        }    }}