Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
-------------------------------------------------------------
jdbc:microsoft:sqlserver://MYSQLSERVER:1433;DatabaseName=pubs
String url;
url = "jdbc:microsoft:sqlserver://192.168.0.100:1433;DatabaseName=test";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String user="sa";
String password="123456";
Connection conn = DriverManager.getConnection(url,user,password);
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select count(*) from sysobjects");
rs.next();
System.out.println(rs.getInt(1));
}
catch (Exception e) {
System.out.println("Connection to the database Error!" + e);
}
之后getconnection(userdata,"用户名","密码")
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection(strConn);
不是默认实例,local所以不能用普通连接方法