Cmp Bean

Hi
I am sending code, it will help you to understand the connection from sql server database table.

import java.sql.*;

public class Test {
public Test() throws Exception {
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
Connection connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://<Host>:1433",<"UID>","<PWD>";);

if (connection != null) {
System.out.println();
System.out.println("Successfully connected");
System.out.println();
DatabaseMetaData meta = connection.getMetaData();
System.out.println("\nDriver Information");
System.out.println("Driver Name: " + meta.getDriverName());
System.out.println("Driver Version: " + meta.getDriverVersion());
System.out.println("\nDatabase Information ");
System.out.println("Database Name: " + meta.getDatabaseProductName());
System.out.println("Database Version: "+ meta.getDatabaseProductVersion());
}
}

public static void main (String args[]) throws Exception {
Test test = new Test();
}
}

Thanks..