import java.sql.Connection;
import java.sql.DriverManager;
public class testsqlserver2005
{
public static void main(String args[])
{
Vector Member=new Vector();
String dbDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbUrl="jdbc:sqlserver://localhost;DatabaseName=BookOrder";
Connection dbConnection;
try{
Class.forName(dbDriver);
dbConnection=DriverManager.getConnection(dbUrl,"sa","12345678");
System.out.println("Connection Successful!");
}
catch (Exception e)
{
e.printStackTrace(); }
}
运行后出现如下错误:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at testsqlserver2005.main(testsqlserver2005.java:43)
不知道是什么原因,谢谢诸位大虾了
import java.sql.DriverManager;
public class testsqlserver2005
{
public static void main(String args[])
{
Vector Member=new Vector();
String dbDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbUrl="jdbc:sqlserver://localhost;DatabaseName=BookOrder";
Connection dbConnection;
try{
Class.forName(dbDriver);
dbConnection=DriverManager.getConnection(dbUrl,"sa","12345678");
System.out.println("Connection Successful!");
}
catch (Exception e)
{
e.printStackTrace(); }
}
运行后出现如下错误:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at testsqlserver2005.main(testsqlserver2005.java:43)
不知道是什么原因,谢谢诸位大虾了
sqlserver是1433
好像SQL的是1433吧
实在不行就把协议先全部移除再添加;
连接不被允许一定要打开SQL服务器;
这一句好像也不对吧,应该是这样的
String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";