public class Main {
public static void main(String[] args) throws SQLException {
Connection conn = getConnection();
assert conn != null;
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select count(*) from dbo.tb_realtime");
while (rs.next()) {
System.out.println(rs.getInt(1));
}
}
public static Connection getConnection() {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=some_database";
String user = "sa";
String password = "xxxxxx";
Connection conn;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(url, user, password);
return conn;
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
return null;
}
}
}
新安装的SQL Server记得开启TCP/IP协议
[img]http://dl2.iteye.com/upload/attachment/0110/2196/9c78e5bb-ec03-33ad-9458-cd4437af3b1c.png[/img]