mysql 数据操作类_对MySql数据库操作的通用类

///

/// 数据访问基础类(基于MySQL)

/// Copyright (C) 2008-2009 小笨蛋

///

public abstract class DbHelperMySQL

{

//数据库连接字符串(web.config来配置)，可以动态更改connectionString支持多数据库.

public static string connectionString = PubConstant.ConnectionString;

public DbHelperMySQL()

{

}

#region 公用方法

public static int GetMaxID(string FieldName, string TableName)

{

string strsql = "select max(" + FieldName + ")+1 from " + TableName;

object obj = GetSingle(strsql);

if (obj == null)

{

return 1;

}

else

{

return int.Parse(obj.ToString());

}

}

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

{