我已经导入sqljdbc.jar了,但是连接sqlServer 2005时,报这个错
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver下面的是数据库连接类:public class DBConnection {
public static Connection getConnection() throws SQLException {
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=buyFlowers";
String user = "sa";
String password = "1";
try {
Class.forName(driver);
return DriverManager.getConnection(url, user, password); } catch (Exception e) {
e.printStackTrace();
return null;
} }
}
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver下面的是数据库连接类:public class DBConnection {
public static Connection getConnection() throws SQLException {
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=buyFlowers";
String user = "sa";
String password = "1";
try {
Class.forName(driver);
return DriverManager.getConnection(url, user, password); } catch (Exception e) {
e.printStackTrace();
return null;
} }
}
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//定义保存数据库
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=buyFlowers";
这是sql2000连接方式这是sql2005连接方式
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=buyFlowers";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=buyFlowers";
写成
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=buyFlowers";
试试2005的url就不用写microsoft了。
楼主这一句写错了
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=buyFlowers";
需要=改成
String url = "jdbc:sqlserver://localhost:1433; DatabaseName=buyFlowers";
driverClassName=net.sourceforge.jtds.jdbc.Driver
url=jdbc\:jtds\:sqlserver\://192.168.1.100\:1433;DatabaseName\=TMS
url:String url = "jdbc:sqlserver://localhost:1433;DatabaseName=buyFlowers";