php mysql helper_简洁的MysqlHelper_MySQL

把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)！

本文原创发布php中文网，转载请注明出处，感谢您的尊重！