SqlHelper 

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Threading.Tasks;
 6 using System.Data;
 7 using System.Data.SqlClient;
 8 using System.Configuration;
 9 
10 namespace DAL
11 {
12     public class SqlHelper
13     {
14         private static SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);
15         
16         //非查询
17         public static int ExecuteNonQuery(string sql, params SqlParameter[] sqlParameter)
18         {
19             try
20             {
21                 conn.Open();
22                 SqlCommand cmd = conn.CreateCommand();
23                 cmd.CommandText = sql;
24                 cmd.Parameters.AddRange(sqlParameter);
25                 return cmd.ExecuteNonQuery();
26             }
27             catch (Exception ex)
28             {
29                 return -1;
30                 throw;
31             }
32             finally
33             {
34                 conn.Close();
35             }
36         }
37 
38         //查询单值
39         public static Object ExecuteScalar(string sql, params SqlParameter[] sqlParameter)
40         {
41             try
42             {
43                 conn.Open();
44                 SqlCommand cmd = conn.CreateCommand();
45                 cmd.CommandText = sql;
46                 cmd.Parameters.AddRange(sqlParameter);
47                 return cmd.ExecuteScalar();
48             }
49             catch (Exception ex)
50             {
51                 return null;
52                 throw;
53             }
54             finally
55             {
56                 conn.Close();
57             }
58         }
59 
60         //离线查询
61         public static DataTable ExecuteQuery(string sql, params SqlParameter[] sqlParameter)
62         {
63             try
64             {
65                 conn.Open();
66                 SqlCommand cmd = conn.CreateCommand();
67                 cmd.CommandText = sql;
68                 cmd.Parameters.AddRange(sqlParameter);
69                 DataSet set = new DataSet();
70                 SqlDataAdapter adapter = new SqlDataAdapter(cmd);
71                 adapter.Fill(set);
72                 return set.Tables[0];
73             }
74             catch (Exception ex)
75             {
76                 return null;
77                 throw;
78             }
79             finally
80             {
81                 conn.Close();
82             }
83         }
84 
85     }
86 }

 

posted @ 2019-03-01 09:40  SkyWorldTY  阅读(21)  评论(0)    收藏  举报