小菜最近在联系程序和数据库的连接,可是总是无法连接到指定的数据库,比如,我建立了一个名为“期刊管理系统”的数据库,可是通过下面的代码无法连接到它,求高手解,感谢!public class DatabaseConnection
{
private static final String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String DBURL = "jdbc:microsoft:sqlserver://CHENXIANG:1433; DatabaseName=期刊管理系统";
private static final String DBUSER = "sa";
private static final String DBPASSWORD = "";
private Connection dbConn = null;
public DatabaseConnection()
{
try
{
Class.forName(DBDRIVER);
} catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
try
{
dbConn = DriverManager.getConnection(DBDRIVER, DBUSER, DBPASSWORD);
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
{
private static final String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String DBURL = "jdbc:microsoft:sqlserver://CHENXIANG:1433; DatabaseName=期刊管理系统";
private static final String DBUSER = "sa";
private static final String DBPASSWORD = "";
private Connection dbConn = null;
public DatabaseConnection()
{
try
{
Class.forName(DBDRIVER);
} catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
try
{
dbConn = DriverManager.getConnection(DBDRIVER, DBUSER, DBPASSWORD);
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
{
dbConn = DriverManager.getConnection(DBDRIVER,DBURL , DBUSER, DBPASSWORD);
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
试下
这样试试:
dbConn = DriverManager.getConnection(DBURL , DBUSER, DBPASSWORD);