Sql简单封装

 1 public class SqlHelper
 2     {
 3         public static string SqlConnectionStr = ConfigurationManager.ConnectionStrings["SqlCon"].ConnectionString;
 4 
 5         public static DataTable Query(string sql)
 6         {
 7             using (SqlConnection con = new SqlConnection(SqlConnectionStr))
 8             {
 9                 using (SqlDataAdapter da = new SqlDataAdapter(sql, con))
10                 {
11                     DataTable dt = new DataTable();
12                     try
13                     {
14                         con.Open();
15                         da.Fill(dt);
16                         return dt;
17                     }
18                     catch (Exception ex)
19                     {
20                         throw ex;
21                     }
22                     finally
23                     {
24                         if (con.State == ConnectionState.Open)
25                             con.Close();
26                     }
27                 }
28             }
29         }
30 
31         public static void Excute(string sql)
32         {
33             using (SqlConnection con = new SqlConnection(SqlConnectionStr))
34             {
35                 using (SqlCommand cmd = new SqlCommand(sql, con))
36                 {
37                     try
38                     {
39                         con.Open();
40                         cmd.ExecuteNonQuery();
41                     }
42                     catch (Exception ex)
43                     {
44                         throw ex;
45                     }
46                     finally
47                     {
48                         if (con.State == ConnectionState.Open)
49                             con.Close();
50                     }
51                 }
52             }
53         }
54 
55         public static void Excute(string sql, CommandType cmdType, SqlParameter[] spArr)
56         {
57             using (SqlConnection con = new SqlConnection(SqlConnectionStr))
58             {
59                 using (SqlCommand cmd = new SqlCommand(sql, con))
60                 {
61                     foreach (SqlParameter sp in spArr)
62                     {
63                         cmd.Parameters.Add(sp);
64                     }
65                     try
66                     {
67                         cmd.CommandType = cmdType;
68                         con.Open();
69                         cmd.ExecuteNonQuery();
70                     }
71                     catch (Exception ex)
72                     {
73                         throw ex;
74                     }
75                     finally
76                     {
77                         if (con.State == ConnectionState.Open)
78                             con.Close();
79                     }
80                 }
81             }
82         }
83     }