java sql检查数据库连接_在java中检查sql数据库连接

以下是检查连接是否成功建立到DB服务器的示例JAVA程序.

public class TestDBConnection {

public static void main(String[] args) {

String Url = "jdbc:sqlserver://serverURL;DatabaseName=DBname;user=dbUsername;Password=dbPassword";

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

System.out.println("Trying to connect");

Connection connection = DriverManager.getConnection(Url);

System.out.println("Connection Established Successfull and the DATABASE NAME IS:"

+ connection.getMetaData().getDatabaseProductName());

} catch (Exception e) {

System.out.println("Unable to make connection with DB");

e.printStackTrace();

}

}

}

希望这对你有用.