代码如下：
需要特别注意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) {} } }