url写错了
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JspDb";conn= DriverManager.getConnection( url ,sa,sa);
这样才对.
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JspDb";conn= DriverManager.getConnection( url ,sa,sa);
这样才对.
##############
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JspDb";
conn= DriverManager.getConnection(url,"sa","sa");#########
运行时这里还是有错误!
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myWork";
String user = "sa";
String password = "sa";
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println("无法连接" + e.getMessage());
}
##############################错误信息:
无法连接[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
##############################
老鸟们帮帮我!谢了!
String user = "sa";
String password = "sa";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection c = DriverManager.getConnection(dbURL, user, password);
或最后一句直接写Connection c = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JspDb", "sa", "sa");个人推荐用第一种方法,便于书写和维护。