C# ADO.NET_数据库操作的封装

1.App.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <startup> 
      <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
  </startup>
  <connectionStrings>
    <add  name="DBConnStr" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=TestDB;;User ID=sa;Password=admin123;Integrated Security=false;" 
          providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

2.SQLHelper.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;
using System.Text;
using System.Threading.Tasks;
using System.Data;


namespace _06.ADO.NET_数据库操作的封装
{
    class SQLHelper
    {
        /// <summary>
        ///     静态方法
        /// </summary>
        /// <param name="sql">insert into t(a1,a2) values(a1,@a2)</param>
        /// <param name="parameters">new SqlParameter("a1", "p1"), new SqlParameter("a2", "p2")</param>
        /// <returns></returns>
        public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters)