JDBC: Conectar com Banco de Dados SQLServer

 
package br.com.feltex.bancodados;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
 
public class ConexaoSQLServer {
 
	public static void main(String[] args) {
		System.out.println("Inicio ConexaoSQLServer");
		try {
			String usuario = "sa";
			String senha = "teco01";
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			Connection conexao = DriverManager
					.getConnection(
							"jdbc:sqlserver://localhost:1433;databaseName=bdacademicnet",
							usuario, senha);
			PreparedStatement pstm = conexao
					.prepareStatement("Select name from sysobjects where type='u'");
 
			ResultSet rs = pstm.executeQuery();
 
			while (rs.next()) {
				System.out.println("Nome tabela: " + rs.getString("name"));
			}
			rs.close();
			pstm.close();
			conexao.close();
 
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("Fim ConexaoSQLServer");
	}
}