连接数据库出现有关问题求解答。已经导入sqljdbc4.jar包了
连接数据库出现问题求解答。已经导入sqljdbc4.jar包了
连接的是SQL 2008
运行之后出现
java.sql.SQLException: No suitable driver found for jabc:sqlserver://localhost:1433; DatabaseName=ae86
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at Test.main(Test.java:18)
------解决方案--------------------
终于解决了啊。。。。
连接的是SQL 2008
import java.sql.*;
public class Test {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动
String dbURL = "jabc:sqlserver://localhost:1433; DatabaseName=ae86 ";
String userName = "sa";
String userPwd = "sql911029";
Connection dbConn;
System.out.println("WHY!");
try{
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}catch(Exception e){
e.printStackTrace();
}
}
}
运行之后出现
java.sql.SQLException: No suitable driver found for jabc:sqlserver://localhost:1433; DatabaseName=ae86
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at Test.main(Test.java:18)
------解决方案--------------------
终于解决了啊。。。。