把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的内容。