/**************************************
*?作用：MySql操作實現
*?作者：Nick.Yan
*?日期:?2007-05-24
*?網址：www.redglove.com.cn
**************************************/
using?System;
using?System.Collections;
using?System.Collections.Specialized;
using?System.Data;
using?System.Data.SqlClient;
using?System.Configuration;
using?MySql.Data.Types;
using?MySql.Data.MySqlClient;
//該源碼下載自www.51aspx.com（５1ａｓｐｘ．ｃｏｍ）

namespace?RedGlove.DBUtility
{
????///?

????///?C#操作mysql基類
????///?

????public?abstract?class?MySqlHelper
????{
????????//數據庫連接字符串（web.config來配置），可以動態更改SQLString支持多數據庫.		
????????public?static?string?connectionString?=?ConfigurationManager.AppSettings[“SQLString“];

????????public?MySqlHelper（）{}

????????#region??執行簡單SQL語句

????????public?static?bool?Exists（string?strSql）
????????{
????????????object?obj?=?GetSingle（strSql）;
????????????int?cmdresult;
????????????if?（（object.Equals（obj?null））?||?（object.Equals（obj?System.DBNull.Value）））
????????????{
????????????????cmdresult?=?0;
????????????}
????????????else
????????????{
????????????????cmdresult?=?int.Parse（obj.ToString（））;
????????????}
????????????if?（cmdresult?==?0）
????????????{
????????????????return?false;
????????????}
????????????else
????????????{
????????????????return?true;
????????????}
????????}

????????public?static?bool?Exists（string?strSql?params?MySqlParameter[]?cmdParms）
????????{
????????????object?obj?=?GetSingle（strSql?cmdParms）;
????????????int?cmdresult;
????????????if?（（object.Equals（obj?null））?||?（object.Equals（obj?System.DBNull.Value）））
????????????{
????????????????cmdresult?=?0;
????????????}
????????????else
????????????{
????????????????cmdresult?=?int.Parse（obj.ToString（））;
????????????}
????????????if?（cmdresult?==?0）
????????????{
????????????????return?false;
????????????}
????????????else
????????????{
????????????????return?true;
????????????}
????????}

????????///?

????????///?執行SQL語句，返回影響的記錄數
????????///?

????????///?SQL語句
????????///?影響的記錄數
????????public?static?int?ExecuteSql（string?SQLString）
????????{
????????????using?（MySqlConnection?connection?=?new?MySqlConnection（connectionString））
????????????{
????????????????using?（MySqlCommand?cmd?=?new?MySqlCommand（SQLString?connection））
????????????????{
????????????????????try
????????????????????{
????????????????????????connection.Open（）;
????????????????????????cmd.ExecuteNonQuery（）;
????????????????????????int?rows?=?cmd.ExecuteNonQuery（）;
????????????????????????return?rows;
????????????????????}
????????????????????catch?（MySqlException?E）
????????????????????{
????????????????????????throw?new?Exception（E.Message）;
????????????????????}
????????????????????finally
????????????????????{
????????????????????????cmd.Dispose（）;
????????????????????????connection.Close（）;
????????????????????}
????????????????}
??????