sql server jdbc window验证

java code：

package daisy.com.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class App 
{
    public static void main( String[] args )
    {
     String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
     String URL = "jdbc:sqlserver://localhost;integratedSecurity=true;Database=review";
     Connection con = null;
     ResultSet rs = null;
     Statement st = null;
     String sql = "select * from student";
     
     try
     {
      Class.forName(driver);
      con = DriverManager.getConnection(URL);
      st = con.createStatement();
      rs = st.executeQuery(sql);
      while(rs.next()){
      System.out.println(rs.getString(2));
      System.out.println(rs.getInt(1));
      }
      }catch(Exception e){
      System.out.println(e);
      }
    }

}

注意事项：

下载sqljdbc_auth.dll---->copy 到C:\Windows\System32下

maven依赖：

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