myeclipse链接sqlserver2008问题
如果不写DatabaseName=day14_customer就不会报错,只要DatabaseName写了就报错,别的数据库也连不了,在这个数据库的安全性的用户中,有一个dbo的用户,登录名是sa没有错,求大神帮忙,代码如下
package sql;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class TestDemo {
public static void main(String[] args) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=day14_customer";
String userName = "sa";
String userPwd = "123456";
try {
Class.forName(driverName);
System.out.println("加载驱动成功!");
} catch (Exception e) {
e.printStackTrace();
System.out.println("加载驱动失败!");
}
try {
Connection dbConn = DriverManager.getConnection(dbURL, userName,userPwd);
// DatabaseMetaData dbmd = dbConn.getMetaData();
// ResultSet rs1 = dbmd.getTables(null, null, "test", new String[]{"TABLE"});
// System.out.println(rs1.getString(3)); //获取表名
System.out.println("连接数据库成功!");
} catch (Exception e) {
e.printStackTrace();
System.out.print("SQL Server连接失败!");
}
}
}