你的位置:首页 > 数据库

[数据库]简洁的MysqlHelper


把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   }