java 连接 sqlserver

1.下载jdbc：Download - JDBC Driver for SQL Server | Microsoft Docs

2.提取jdbc的内容：

 

 3.导入jar包到eclipse

 

 

 

 

输入代码，运行：

 

 

 

package test;

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

public class cc {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		
		
		 
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 

        String connectionUrl = "jdbc:sqlserver://localhost:1433;databaseName=AA;user=sa;password=123456;";  
 
        Connection conn = DriverManager.getConnection(connectionUrl);  
        
        Statement stmt = conn.createStatement(); 
        
        ResultSet rs = stmt.executeQuery("SELECT * FROM test");
        //如果有数据，rs.next()返回true
        while(rs.next()){
            System.out.println(rs.getString("ID")+" 年龄："+rs.getInt("value"));
        }
            
	}

}