用于MySQL的SqlHelper
1///<summary>23///Title ：MySqlHelper4///Author ：WinterT5///Date ：2015-1-8 08:12:546///Description：7///ExecuteNonQuery8///ExecuteScalar9///ExecuteReader10///ExecuteTable11///</summary>12publicstaticclassMySqlHelper13{14///<summary>15///返回配置文件中指定的连接16///</summary>17///<returns>配置文件中指定的连接</returns>18PRivatestaticMySqlConnection GetConnection()19{20stringconnString = ConfigurationManager.ConnectionStrings[1].ConnectionString;21returnnewMySqlConnection(connString);22}23#regionExecuteNonQuery24///<summary>25///执行sql语句26///</summary>27///<param name="sql">sql语句</param>28///<returns>受影响行数</returns>29publicstaticintExecuteNonQuery(stringsql)30{31using(MySqlConnection conn =GetConnection())32{33using(MySqlCommand cmd =conn.CreateCommand())34{35cmd.CommandText =sql;36returncmd.ExecuteNonQuery();37}38}39}40///<summary>41///根据给定连接，执行带参数的SQL语句42///</summary>43///<param name="conn">连接、使用前确保连接以打开。</param>44///<param name="sql">带参数的sql语句</param>45///<param name="paras">参数</param>46///<returns>受影响行数</returns>47publicstaticintExecuteNonQuery48(MySqlConnection conn,stringsql,paramsMySqlParameter[] paras)49{50using(MySqlCommand cmd =conn.CreateCommand())51{52cmd.CommandText =sql;53cmd.Parameters.AddRange(paras);54returncmd.ExecuteNonQuery();55}56}57///<summary>58///执行带参数的SQL语句59///</summary>60///<param name="sql">带参数的sql语句</param>61///<param name="paras">参数</param>62///<returns>受影响行数</returns>63publicstaticintExecuteNonQuery64(stringsql,paramsMySqlParameter[] paras)65{66using(MySqlConnection conn =GetConnection())67{68returnExecuteNonQuery(conn, sql, paras);69}70}71#endregion72#regionExecuteScalar73///<summary>74///执行sql语句，返回第一行第一列75///</summary>76///<param name="sql">sql语句</param>77///<returns>第一行第一列</returns>78publicstaticObject ExecuteScalar(stringsql)79{80using(MySqlConnection conn =GetConnection())81{82using(MySqlCommand cmd =conn.CreateCommand())83{84cmd.CommandText =sql;85returncmd.ExecuteScalar();86}87}88}89///<summary>90///根据Connection对象，执行带参数的sql语句，返回第一行第一列91///</summary>92///<param name="conn">连接</param>93///<param name="sql">sql语句</param>94///<param name="paras">参数</param>95///<returns>返回第一行第一列</returns>96publicstaticobjectExecuteScalar97(MySqlConnection conn,stringsql, MySqlParameter[] paras)98{99using(MySqlCommand cmd =conn.CreateCommand())100{101cmd.CommandText =sql;102cmd.Parameters.AddRange(paras);103returncmd.ExecuteScalar();104}105}106///<summary>107///执行带参数的sql语句，返回第一行第一列108///</summary>109///<param name="sql">sql语句</param>110///<param name="paras">参数</param>111///<returns>返回第一行第一列</returns>112publicstaticobjectExecuteScalar113(stringsql, MySqlParameter[] paras)114{115using(MySqlConnection conn =GetConnection())116{117returnExecuteScalar(conn, sql, paras);118}119}120#endregion121#regionExecuteReader122///<summary>123///执行sql语句，返回一个MySqlDataReader124///</summary>125///<param name="sql">sql语句</param>126///<returns>一个MySqlDataReader对象</returns>127publicstaticMySqlDataReader ExecuteReader(stringsql)128{129MySqlConnection conn =GetConnection();130using(MySqlCommand cmd =conn.CreateCommand())131{132cmd.CommandText =sql;133conn.Open();134returncmd.ExecuteReader(CommandBehavior.CloseConnection);135}136}137///<summary>138///根据指定的连接，执行带参数的sql语句，返回一个Reader对象139///</summary>140///<param name="conn">连接</param>141///<param name="sql">sql语句</param>142///<param name="paras">参数</param>143///<returns>一个MySqlDataReader对象</returns>144publicstaticMySqlDataReader ExecuteReader145(MySqlConnection conn,stringsql,paramsMySqlParameter[] paras)146{147using(MySqlCommand cmd =conn.CreateCommand())148{149cmd.CommandText =sql;150cmd.Parameters.AddRange(paras);151conn.Open();152returncmd.ExecuteReader(CommandBehavior.CloseConnection);153}154}155///<summary>156///执行带参数的sql语句，返回一个Reader对象157///</summary>158///<param name="sql">sql语句</param>159///<param name="paras">参数</param>160///<returns>一个MySqlDataReader对象</returns>161publicstaticMySqlDataReader ExecuteReader162(stringsql,paramsMySqlParameter[] paras)163{164MySqlConnection conn =GetConnection();165using(MySqlCommand cmd =conn.CreateCommand())166{167returnExecuteReader(conn, sql, paras);168}169}170#endregion171#regionExecuteTable172///<summary>173///执行sql语句，返回一个DataTable174///</summary>175///<param name="sql">sql语句</param>176///<returns>DataTable</returns>177publicstaticDataTable ExecuteTable(stringsql)178{179using(MySqlConnection conn =GetConnection())180{181using(MySqlCommand cmd =conn.CreateCommand())182{183cmd.CommandText =sql;184using(MySqlDataReader reader =cmd.ExecuteReader())185{186DataTable table =newDataTable();187table.Load(reader);188returntable;189}190}191}192}193///<summary>194///根据连接，执行带参数的sql语句，返回一个DataTable195///</summary>196///<param name="conn">连接，切记连接已打开</param>197///<param name="sql">sql语句</param>198///<param name="paras">参数</param>199///<returns>DataTable</returns>200publicstaticDataTable ExecuteTable201(MySqlConnection conn,stringsql,paramsMySqlParameter[] paras)202{203using(MySqlCommand cmd =conn.CreateCommand())204{205cmd.CommandText =sql;206cmd.Parameters.AddRange(paras);207using(MySqlDataReader reader =cmd.ExecuteReader())208{209DataTable table =newDataTable();210table.Load(reader);211returntable;212}213}214}215///<summary>216///执行带参数的sql语句217///</summary>218///<param name="sql">sql语句</param>219///<param name="paras">参数</param>220///<returns>DataTable</returns>221publicstaticDataTable ExecuteTable222(stringsql,paramsMySqlParameter[] paras)223{224using(MySqlConnection conn =GetConnection())225{226returnExecuteTable(conn, sql, paras);227}228}229230#endregion231}