Home >Database >Mysql Tutorial >简洁的MysqlHelper_MySQL

简洁的MysqlHelper_MySQL

PHP中文网
PHP中文网Original
2016-05-27 13:46:412420browse

把MySqlXXX的类更改为SqlXXX就可以成为sqlHelper.

 

另外C#也提供了MysqlHelper和sqlHelper,用起来也挺方便的。

 

 1 public class MySqlHelper
 2     {
 3       private static readonly  
 
 string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
 4         public MySqlConnection CreateConnection()
 5         {
 6             MySqlConnection conn = new MySqlConnection(connstr);
 7             conn.Open();
 8             return conn;
 9         }
10         public int ExecuteNonQuery(string sql,params MySqlParameter[]parameters)
11         {
12             using (MySqlConnection conn=CreateConnection())
13             using(MySqlCommand cmd=conn.CreateCommand())
14             {
15                 cmd.CommandText = sql;
16                 cmd.Parameters.AddRange(parameters);
17                return cmd.ExecuteNonQuery();
18             }
19         }
20         public object ExecuteScalar(string sql,params MySqlParameter[]parameters)
21         {
22             using (MySqlConnection conn=CreateConnection())
23             using (MySqlCommand cmd=conn.CreateCommand())
24             {
25                 cmd.CommandText = sql;
26                 cmd.Parameters.AddRange(parameters);
27                return cmd.ExecuteScalar();
28             }
29            
30         }
31        
32         public MySqlDataReader ExecuteReader(string sql,params MySqlParameter[]ps)
33         {
34             using (MySqlConnection conn=CreateConnection())
35             using(MySqlCommand cmd=conn.CreateCommand())
36             {
37                 cmd.CommandText = sql;
38                 if (ps!=null)
39                 {
40                     cmd.Parameters.AddRange(ps);
41                 }
42                return cmd.ExecuteReader();
43             }
44         }
45         public DataTable ExecuteDataTable(string sql,params MySqlParameter[]ps)
46         {
47             DataTable table = new DataTable();
48             using (MySqlConnection conn=CreateConnection())
49             using(MySqlCommand cmd=conn.CreateCommand())
50             {
51                 cmd.CommandText = sql;
52                 if (ps!=null)
53                 {
54                     cmd.Parameters.AddRange(ps);
55                 }
56                 using ( MySqlDataAdapter adapter = new MySqlDataAdapter(cmd))
57                 {
58                     adapter.Fill(table);
59                 }
60                 return table;
61             }
62         }
63     }

 以上就是简洁的MysqlHelper_MySQL的内容,更多相关内容请关注PHP中文网(www.php.cn)!


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn