- 下载对应版本的JDBC Driver,解压并安装
- 使用 System.out.println(System.getProperty("java.library.path")); 查看java.library.path: 将sqljdbc_auth.dll复制到其中一个目录
代码如下:
需要特别注意Windows身份验证的连接URL写法,官方文档上有
//Use the JDBC driver
import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;
public class Test {
// Connect to your database.
// Replace server name, user name, and password with your credentials
public static void main(String[] args) {
String connectionString = "jdbc:sqlserver://localhost;" +
"integratedSecurity=true;" + "databaseName=test;";
// Declare the JDBC objects.
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection(connectionString);
// Create and execute a SELECT SQL statement.
String selectSql = "SELECT sname from student";
statement = connection.createStatement();
resultSet = statement.executeQuery(selectSql);
// Print results from select statement
while (resultSet.next())
{
System.out.println(resultSet.getString(1));
}
}
catch (Exception e) {
e.printStackTrace();
}
finally {
if (connection != null) try { connection.close(); } catch(Exception e) {}
if (statement != null) try { statement.close(); } catch(Exception e) {}
if (connection != null) try { connection.close(); } catch(Exception e) {}
}
}