c# mysql dbhelp_C#提升性能"数据库连接打开与关闭"经验分享(附：优化过的DBHelper类) 之配餐系统的开发...

usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data.OleDb;usingSystem.Data;usingSystem.Configuration;namespaceZhiyiHelper

{publicpartialclassDBHelper

{privatestaticstringconnstr=String.Empty;privatestaticOleDbConnection conObject=null;publicDBHelper()

{

}#region基础方法//获取连接字符串的属性///privatestaticstringConnstr

{get{if(connstr==String.Empty)

{

connstr=ConfigHelper.GetConnectionStringsString("accessConSql");

connstr=GetConnString();

}returnconnstr;

}

}//得到数据库连接方法//数据库连接privatestaticvoidGetconn()

{if(conObject==null)

conObject=newOleDbConnection(Connstr);

}//获得并打开数据库连接方法//publicstaticvoidOpenCon()

{

Getconn();if(conObject.State==ConnectionState.Open)return;if(conObject.State!=ConnectionState.Closed)

conObject.Close();

conObject.Open();

}//关闭数据库连接方法///publicstaticvoidCloseCon()

{if(conObject!=null&&conObject.State!=ConnectionState.Closed)

conObject.Close();

}#endregion#region数据库操作方法publicstaticintGetMaxID(stringFieldName,stringTableName)

{stringstrsql="select max("+FieldName+") from"+TableName;try{returnGetScalar(strsql);

}catch(OleDbException ex)

{throwex;

}

}//删除制定表中的一个字段(文本列)/publicstaticvoidDelColumn(stringcolName,stringTableName)

{if(string.IsNullOrEmpty(colName.Trim()))return;try{