check sql database connection in java [closed]

Question

I am using sql server 2008. I need to check if I can establish connection using server name,port number,db name,user name and password.

Is there any simple method available?

Answer 1

Here is the sample JAVA program that checks whether the connection is successfully established to DB server or not.

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();
            }
        }
    }

Hope this will work for you.