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