004-SqlHelper(数据库帮助类)

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Data;
 4 using System.Data.SqlClient;
 5 using System.Linq;
 6 using System.Text;
 7 using System.Threading.Tasks;
 8 
 9 namespace MySQL
10 {
11     /// <summary>
12     /// SqlHelper(数据库帮助类)
13     /// </summary>
14     public static class SqlHelper
15     {
16         /// <summary>
17         /// SQL连接字符串
18         /// </summary>
19         private static string connStr = (System.Configuration.ConfigurationManager.ConnectionStrings["connStr"].ConnectionString) + "123456789";
20         /// <summary>
21         /// 获取数据库表数据
22         /// </summary>
23         /// <param name="sql">SQL语句</param>
24         /// <param name="ps">SQL参数</param>
25         /// <returns>返回DataTable</returns>
26         public static DataTable GetTable(string sql, params SqlParameter[] ps)
27         {
28             using (SqlConnection conn = new SqlConnection(connStr))
29             {
30                 SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
31                 sda.SelectCommand.Parameters.AddRange(ps);
32                 DataTable dt = new DataTable();
33                 sda.Fill(dt);
34                 return dt;
35             }
36         }
37         /// <summary>
38         /// 执行SQL语句返回受影响的行数
39         /// </summary>
40         /// <param name="sql">SQL语句</param>
41         /// <param name="ps">SQL参数</param>
42         /// <returns>返回受影响的行数</returns>
43         public static int ExecuteNonQuery(string sql, params SqlParameter[] ps)
44         {
45             using (SqlConnection conn = new SqlConnection(connStr))
46             {
47                 SqlCommand cmd = new SqlCommand(sql, conn);
48                 cmd.Parameters.AddRange(ps);
49                 conn.Open();
50                 return cmd.ExecuteNonQuery();
51             }
52         }
53         /// <summary>
54         /// 执行SQL语句返回结果集中第一行第一列的值
55         /// </summary>
56         /// <param name="sql">SQL语句</param>
57         /// <param name="ps">SQL参数</param>
58         /// <returns>返回结果集中第一行第一列的值</returns>
59         public static object ExecuteScalar(string sql, params SqlParameter[] ps)
60         {
61             using (SqlConnection conn = new SqlConnection(connStr))
62             {
63                 SqlCommand cmd = new SqlCommand(sql, conn);
64                 cmd.Parameters.AddRange(ps);
65                 conn.Open();
66                 return cmd.ExecuteScalar();
67             }
68         }
69     }
70 }
posted @ 2018-09-08 16:28 灬伊天☂ 阅读(124) 评论(0) 收藏举报
刷新页面返回顶部