简洁的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 }
