package cn.baidu.ch03;import java.sql.DriverManager;
import java.sql.Connection;public class Test {
public static void main(String[] args){
Connection conn = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=HOUSE","sa","123");
System.out.println("成功");
} catch (Exception e) {
e.printStackTrace();
}
}
}
我导入了sqlserver的类库,可是还是不行,为什么
";"?
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at cn.baidu.ch03.Test.main(Test.java:11)
我也是啊,用jdbc-odbc方式都没问题,纠结了很久,最后换了mysql
然后确认是否监听在1433这个端口