Self-encapsulated ASP. NET MySQL database operation class

2. /**
4. * Beef Brisket
6. * Date of Creation: March 7, 2010 17:35
8. * Class Description: Operation class for MySQL database
10. */
12. Using System;
14. Using System.Data;
16. Using MySql.Data.MySqlClient;
22. Namespace Niunan.BYLW.Utility
24. {
26. /// <summary> MySQL database operation class
28. ///   
30. // </summary>
32. public class Mysqlhelper
34. {
36. private Mysqlconnection conn = null;
38. private Mysqlcommand cmd = null;
40. private Mysqldatareader SDR = null;
46. Public mysqlhelper ()
48. {
50. //string connstr = webconfigurationmanager.connectionstrings["ConnStr"].  ToString ();
52. string connstr = "Server=localhost;database=test;uid=root;pwd=123456;charset=utf8";
54. conn = new Mysqlconnection (CONNSTR);
56. }
62. /// <summary> create command object
64. ///   
66. // </summary>
68. /// <param name= "SQL" >sql statement </param>
70. public void CreateCommand (string sql)
72. {
74. Conn. Open ();
76. cmd = new Mysqlcommand (SQL, conn);
78. }
84. /// <summary> Add Parameters
86. ///   
88. // </summary>
90. /// <param name= "paramname" > Parameter name </param>
92. // <param name= "value" > Value </param>
94. public void Addparameter (string paramname, object value)
96. {
98. Cmd.  Parameters.Add (new Mysqlparameter (paramname, value));
100. }
106. /// <summary> execute non-parametric additions and deletions to SQL statements
108. ///    
110. // </summary>
112. /// <param name= "Cmdtext" > adding or deleting SQL statements </param>
114. /// <param name= "ct" > Command type </param>
116. // <returns></returns>
118. Public bool ExecuteNonQuery ()
120. {
122. int res;
124. Try
126. {
128. res = cmd. ExecuteNonQuery ();
130. if (res > 0)
132. {
134. return true;
136. }
138. }
140. catch (Exception ex)
142. {
144. throw ex;
146. }
148. finally
150. {
152. if (Conn. state = = ConnectionState.Open)
154. {
156. Conn. Close ();
158. }
160. }
162. return false;
164. }
170. /// <summary> Execute query SQL statement
172. ///    
174. // </summary>
176. /// <param name= "cmdtext" > Query SQL statements </param>
178. // <returns></returns>
180. Public DataTable ExecuteQuery ()
182. {
184. DataTable dt = new DataTable ();
186. using (SDR = cmd. ExecuteReader (commandbehavior.closeconnection))
188. {
190. Dt. Load (SDR);
192. }
194. return DT;
196. }
202. /// <summary> Returns the value of the first column of the first row of the results queried by the SQL statement query
204. ///   
206. // </summary>
208. // <returns></returns>
210. public string ExecuteScalar ()
212. {
214. string res = "";
216. Try
218. {
220. Object obj = cmd.  ExecuteScalar ();
222. if (obj! = null)
224. {
226. res = obj. ToString ();
228. }
230. }
232. catch (Exception ex)
234. {
236. throw ex;
238. }
240. finally
242. {
244. if (Conn. state = = ConnectionState.Open)
246. {
248. Conn. Close ();
250. }
252. }
254. return res;
256. }
262. }
264. }

Are the sqlitehelper of the operation of the class moved over, changed the mysqlconnection and other variable names, for MySQL often appear in Chinese garbled, after the experiment, the solution:

① use phpMyAdmin to build MySQL database, remember to choose UTF-8 encoding

② in the connection string in the database operation class above, remember to add Charset=utf8

In this way, using the above operation class to insert Chinese will not appear garbled.