下面的是我的连接数据库的类package myutil;
import java.sql.*;//数据库的驱动加载\连接public class DBConn { public static Connection getConn(){// String className="sun.jdbc.odbc.JdbcOdbcDriver"; //数据源方式的驱动程序串
String className="com.microsoft.jdbc.sqlserver.SQLServerDriver"; //SQL Server驱动方式的驱动程序串// String url="jdbc:odbc:aa"; //数据源方式的URL,数据源的名字为aa
//纯驱动,SQL Server方式的URL,数据库的名字为houseRent
String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=ccit";
Connection con=null;
try {
Class.forName(className);
con=DriverManager.getConnection(url,"sa","123");
//2.创建连接
System.out.println("数据库连接成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
return con;
}
}
public static void main(String args[]){
DBConn.getConn();
}
}运行后出现的错误如下:java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at myutil.DBConn.getConn(DBConn.java:28)
at myutil.DBConn.main(DBConn.java:46)求解是怎么回事啊???java , myeclipse
import java.sql.*;//数据库的驱动加载\连接public class DBConn { public static Connection getConn(){// String className="sun.jdbc.odbc.JdbcOdbcDriver"; //数据源方式的驱动程序串
String className="com.microsoft.jdbc.sqlserver.SQLServerDriver"; //SQL Server驱动方式的驱动程序串// String url="jdbc:odbc:aa"; //数据源方式的URL,数据源的名字为aa
//纯驱动,SQL Server方式的URL,数据库的名字为houseRent
String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=ccit";
Connection con=null;
try {
Class.forName(className);
con=DriverManager.getConnection(url,"sa","123");
//2.创建连接
System.out.println("数据库连接成功");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
return con;
}
}
public static void main(String args[]){
DBConn.getConn();
}
}运行后出现的错误如下:java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at myutil.DBConn.getConn(DBConn.java:28)
at myutil.DBConn.main(DBConn.java:46)求解是怎么回事啊???java , myeclipse
com.microsoft.sqlserver.jdbc.SQLServerDriver