首先添加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);
}
}
}