C# database封装

public class database
{
 
    public static string GetConnectionString()
    {
        string conStr = ConfigurationManager.ConnectionStrings["BMSConnectionString"].ConnectionString;
        return conStr;
    }

    public static int ExecuteNonQuery(string commandText)
    {
        try
        {
            SqlConnection conn;
            SqlCommand command;
            conn = new SqlConnection();
            conn.ConnectionString = GetConnectionString();
            command = new SqlCommand();
            command.CommandText = commandText;
            command.CommandType = CommandType.Text;
            command.Connection = conn;
            command.Connection.Open();

            int rs = command.ExecuteNonQuery();
                  }  
        catch(SqlException ex)
        {
            throw ex;
        }

        finally

        {

            command.Connection.Close();
            command.Dispose();
            conn.Dispose();
            return rs;

        }
       
 
    }

    public static DataTable ExecuteDataTable(string commandText)
    {
        try
        {
            SqlConnection conn;
            SqlCommand command;
            SqlDataAdapter sda;
            DataTable table = new DataTable();

            conn = new SqlConnection();
            conn.ConnectionString = GetConnectionString();

            command = new SqlCommand();
            command.CommandText = commandText;
            command.CommandType = CommandType.Text;
            command.Connection = conn;
            command.Connection.Open();

            sda = new SqlDataAdapter();
            sda.SelectCommand = command;
            sda.Fill(table);

        }
        catch (SqlException ex)
        {
            throw ex;
        }        

        finally

        {

            sda.dispose();

            command.Connection.Close();
            command.Dispose();
            conn.Dispose();
            return table;

        }
    }

 

}