c# 数据库辅助类
来源：互联网 发布：maya2015软件补丁更新 编辑：程序博客网 时间：2024/04/28 14:39
1、抽象基类 DBHepler
using System;using System.Collections.Generic;using System.Data;using System.Data.Common;using System.Linq;using System.Web;namespace XH.WebService{ public abstract class DBHelper { protected abstract DbConnection Connection { get; }//连接对象 protected abstract DbCommand GetDbCommand();// protected abstract DbDataAdapter GetDbDataAdapter(); #region 打开数据库连接 /// <summary> /// 打开数据库连接 /// </summary> private void Open() { //打开数据库连接 if (Connection.State == ConnectionState.Closed) { try { //打开数据库连接 Connection.Open(); } catch (Exception e) { throw e; } } } #endregion #region 关闭数据库连接 /// <summary> /// 关闭数据库连接 /// </summary> private void Close() { //判断连接的状态是否已经打开 if (Connection.State == ConnectionState.Open) { Connection.Close(); } } #endregion #region 执行查询语句，返回DbDataReader ( 注意：调用该方法后，一定要对DbDataReader进行Close ) /// <summary> /// 执行查询语句，返回DbDataReader ( 注意：调用该方法后，一定要对DbDataReader进行Close ) /// </summary> /// <param name="sql">查询语句</param> /// <returns>OracleDataReader</returns> public DbDataReader ExecuteReader(string sql) { DbDataReader myReader; Open(); try { DbCommand cmd = GetDbCommand(); cmd.Connection = Connection; cmd.CommandText = sql; cmd.ExecuteReader(); myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception ex) { Close(); throw ex; } return myReader; } #endregion #region 执行带参数的SQL语句 /// <summary> /// 执行SQL语句，返回影响的记录数 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>影响的记录数</returns> //public int ExecuteSql(string sql, params OracleParameter[] cmdParms) //{ // OracleCommand cmd = new OracleCommand(); // { // try // { // PrepareCommand(cmd, con, null, sql, cmdParms); // int rows = cmd.ExecuteNonQuery(); // cmd.Parameters.Clear(); // return rows; // } // catch (System.Data.OracleClient.OracleException e) // { // throw e; // } // } //} #endregion #region 执行带参数的SQL语句 /// <summary> /// 执行不带参数的SQL语句 /// </summary> /// <param name="sql">SQL语句</param> public int ExecuteNonQuery(string sql) { DbCommand cmd = GetDbCommand(); cmd.Connection = Connection; cmd.CommandText = sql; Open(); try { int n = cmd.ExecuteNonQuery(); Close(); return n; } catch (Exception ex) { Close(); throw ex; } } #endregion #region 执行SQL语句，返回数据到DataSet中 /// <summary> /// 执行SQL语句，返回数据到DataSet中 /// </summary> /// <param name="sql">sql语句</param> /// <returns>返回DataSet</returns> public DataSet GetDataSet(string sql) { DataSet ds = new DataSet(); Open();//打开数据连接 try { DbDataAdapter adapter = GetDbDataAdapter(); DbCommand dbCommand = GetDbCommand(); dbCommand.Connection = Connection; dbCommand.CommandText = sql; adapter.SelectCommand = dbCommand; adapter.Fill(ds); } catch (Exception ex) { Close();//关闭数据库连接 throw ex; } return ds; } #endregion #region 执行SQL语句，返回数据到自定义DataSet中 /// <summary> /// 执行SQL语句，返回数据到DataSet中 /// </summary> /// <param name="sql">sql语句</param> /// <param name="DataSetName">自定义返回的DataSet表名</param> /// <returns>返回DataSet</returns> public DataSet GetDataSet(string sql, string DataSetName) { DataSet ds = new DataSet(); try { Open();//打开数据连接 DbDataAdapter adapter = GetDbDataAdapter(); DbCommand dbCommand = GetDbCommand(); dbCommand.Connection = Connection; dbCommand.CommandText = sql; adapter.SelectCommand = dbCommand; adapter.Fill(ds,DataSetName); } catch(Exception ex) { throw ex; } finally { Close();//关闭数据库连接 } return ds; } #endregion #region 执行Sql语句,返回带分页功能的自定义dataset /// <summary> /// 执行Sql语句,返回带分页功能的自定义dataset /// </summary> /// <param name="sql">Sql语句</param> /// <param name="PageSize">每页显示记录数</param> /// <param name="CurrPageIndex">当前页</param> /// <param name="DataSetName">返回dataset表名</param> /// <returns>返回DataSet</returns> public DataSet GetDataSet(string sql, int PageSize, int CurrPageIndex, string DataSetName) { DataSet ds = new DataSet(); Open();//打开数据连接 try { DbDataAdapter adapter = GetDbDataAdapter(); DbCommand dbCommand = GetDbCommand(); dbCommand.Connection = Connection; dbCommand.CommandText = sql; adapter.SelectCommand = dbCommand; adapter.Fill(ds, PageSize * (CurrPageIndex - 1), PageSize, DataSetName); } catch(Exception ex) { throw ex; } finally { Close();//关闭数据库连接 } return ds; } #endregion #region 执行SQL语句，返回记录总数 /// <summary> /// 执行SQL语句，返回记录总数 /// </summary> /// <param name="sql">sql语句</param> /// <returns>返回记录总条数</returns> public int GetRecordCount(string sql) { int recordCount = 0; Open();//打开数据连接 try { DbCommand dbCommand = GetDbCommand(); dbCommand.Connection = Connection; dbCommand.CommandText = sql; DbDataReader dataReader = dbCommand.ExecuteReader(); while (dataReader.Read()) { recordCount++; } dataReader.Close(); } catch (Exception ex) { throw ex; } finally { Close();//关闭数据库连接 } return recordCount; } #endregion #region 统计某表记录总数 /// <summary> /// 统计某表记录总数 /// </summary> /// <param name="KeyField">主键/索引键</param> /// <param name="TableName">数据库.用户名.表名</param> /// <param name="Condition">查询条件</param> /// <returns>返回记录总数</returns> public int GetRecordCount(string keyField, string tableName, string condition) { int RecordCount = 0; string sql = "select count(" + keyField + ") as count from " + tableName + " " + condition; DataSet ds = GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); } ds.Clear(); ds.Dispose(); return RecordCount; } /// <summary> /// 统计某表记录总数 /// </summary> /// <param name="Field">可重复的字段</param> /// <param name="tableName">数据库.用户名.表名</param> /// <param name="condition">查询条件</param> /// <param name="flag">字段是否主键</param> /// <returns>返回记录总数</returns> public int GetRecordCount(string Field, string tableName, string condition, bool flag) { int RecordCount = 0; if (flag) { RecordCount = GetRecordCount(Field, tableName, condition); } else { string sql = "select count(distinct(" + Field + ")) as count from " + tableName + " " + condition; DataSet ds = GetDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); } ds.Clear(); ds.Dispose(); } return RecordCount; } #endregion #region 统计某表分页总数 /// <summary> /// 统计某表分页总数 /// </summary> /// <param name="keyField">主键/索引键</param> /// <param name="tableName">表名</param> /// <param name="condition">查询条件</param> /// <param name="pageSize">页宽</param> /// <param name="RecordCount">记录总数</param> /// <returns>返回分页总数</returns> public int GetPageCount(string keyField, string tableName, string condition, int pageSize, int RecordCount) { int PageCount = 0; PageCount = (RecordCount % pageSize) > 0 ? (RecordCount / pageSize) + 1 : RecordCount / pageSize; if (PageCount < 1) PageCount = 1; return PageCount; } /// <summary> /// 统计某表分页总数 /// </summary> /// <param name="keyField">主键/索引键</param> /// <param name="tableName">表名</param> /// <param name="condition">查询条件</param> /// <param name="pageSize">页宽</param> /// <returns>返回页面总数</returns> public int GetPageCount(string keyField, string tableName, string condition, int pageSize, ref int RecordCount) { RecordCount = GetRecordCount(keyField, tableName, condition); return GetPageCount(keyField, tableName, condition, pageSize, RecordCount); } /// <summary> /// 统计某表分页总数 /// </summary> /// <param name="Field">可重复的字段</param> /// <param name="tableName">表名</param> /// <param name="condition">查询条件</param> /// <param name="pageSize">页宽</param> /// <param name="flag">是否主键</param> /// <returns>返回页页总数</returns> public int GetPageCount(string Field, string tableName, string condition, ref int RecordCount, int pageSize, bool flag) { RecordCount = GetRecordCount(Field, tableName, condition, flag); return GetPageCount(Field, tableName, condition, pageSize, ref RecordCount); } #endregion #region Sql分页函数 /// <summary> /// 构造分页查询SQL语句 /// </summary> /// <param name="KeyField">主键</param> /// <param name="FieldStr">所有需要查询的字段(field1,field2...)</param> /// <param name="TableName">库名.拥有者.表名</param> /// <param name="where">查询条件1(where ...)</param> /// <param name="order">排序条件2(order by ...)</param> /// <param name="CurrentPage">当前页号</param> /// <param name="PageSize">页宽</param> /// <returns>SQL语句</returns> public string JoinPageSQL(string KeyField, string FieldStr, string TableName, string Where, string Order, int CurrentPage, int PageSize) { string sql = null; if (CurrentPage == 1) { sql = "select " + CurrentPage * PageSize + " " + FieldStr + " from " + TableName + " " + Where + " " + Order + " "; } else { sql = "select * from ("; sql += "select " + CurrentPage * PageSize + " " + FieldStr + " from " + TableName + " " + Where + " " + Order + ") a "; sql += "where " + KeyField + " not in ("; sql += "select " + (CurrentPage - 1) * PageSize + " " + KeyField + " from " + TableName + " " + Where + " " + Order + ")"; } return sql; } /// <summary> /// 构造分页查询SQL语句 /// </summary> /// <param name="Field">字段名(非主键)</param> /// <param name="TableName">库名.拥有者.表名</param> /// <param name="where">查询条件1(where ...)</param> /// <param name="order">排序条件2(order by ...)</param> /// <param name="CurrentPage">当前页号</param> /// <param name="PageSize">页宽</param> /// <returns>SQL语句</returns> public string JoinPageSQL(string Field, string TableName, string Where, string Order, int CurrentPage, int PageSize) { string sql = null; if (CurrentPage == 1) { sql = "select rownum " + CurrentPage * PageSize + " " + Field + " from " + TableName + " " + Where + " " + Order + " group by " + Field; } else { sql = "select * from ("; sql += "select rownum " + CurrentPage * PageSize + " " + Field + " from " + TableName + " " + Where + " " + Order + " group by " + Field + " ) a "; sql += "where " + Field + " not in ("; sql += "select rownum " + (CurrentPage - 1) * PageSize + " " + Field + " from " + TableName + " " + Where + " " + Order + " group by " + Field + ")"; } return sql; } #endregion #region 根据系统时间动态生成各种查询语句(现已经注释掉，以备以后使用) // #region 根据查询时间的条件，动态生成查询语句 // /// <summary> // /// 根据查询时间的条件，动态生成查询语句 // /// </summary> // /// <param name="starttime">开始时间</param> // /// <param name="endtime">结束时间</param> // /// <param name="dw">单位</param> // /// <param name="startxsl">开始线损率</param> // /// <param name="endxsl">结束线损率</param> // /// <param name="danwei">单位字段</param> // /// <param name="xiansunlv">线损率字段</param> // /// <param name="tablehz">表后缀</param> // /// <returns>SQL语句</returns> // public string SQL(DateTime starttime,DateTime endtime,string dw,float startxsl,float endxsl,string danwei,string xiansunlv,string tablehz) // { // // string sql=null; // //将输入的时间格式转换成固定的格式"yyyy-mm-dd" // string zstarttime=starttime.GetDateTimeFormats('D')[1].ToString(); // string zendtime=endtime.GetDateTimeFormats('D')[1].ToString(); // string nTime=DateTime.Now.GetDateTimeFormats('D')[1].ToString(); // // // //取日期值的前六位，及年月值 // string sTime=zstarttime.Substring(0,4)+zstarttime.Substring(5,2); // string eTime=zendtime.Substring(0,4)+zendtime.Substring(5,2); // string nowTime=nTime.Substring(0,4)+nTime.Substring(5,2); // //分别取日期的年和月 // int sy=Convert.ToInt32(zstarttime.Substring(0,4)); // int ey=Convert.ToInt32(zendtime.Substring(0,4)); // int sm=Convert.ToInt32(zstarttime.Substring(5,2)); // int em=Convert.ToInt32(zendtime.Substring(5,2)); // //相关变量定义 // int s; // int e; // int i; // int j; // int js; // int nz; // string x; // //一，取当前表生成SQL语句 // if(sTime==nowTime&&eTime==nowTime) // { // sql="select * from "+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "; // } // //二，取当前表和其他表生成SQL语句 // else if(sTime==nowTime&&eTime!=nowTime) // { // sql="select * from "+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // //如果年份相等 // if(sy==ey) // { // s=Convert.ToInt32(sTime); // e=Convert.ToInt32(eTime); // for(i=s+1;i<e;i++) // { // i=i++; // sql+="select * from "+i.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // sql+="select * from "+e.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "; // } // //结束年份大于开始年份 // else // { // //1，先循环到起始时间和起始时间的12月 // s=Convert.ToInt32(sTime); // x=zstarttime.Substring(0,4)+"12"; // nz=Convert.ToInt32(x); // for(i=s+1;i<=nz;i++) // { // i=i++; // sql+="select * from "+i.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // //2，循环两者相差年份 // for(i=sy+1;i<ey;i++) // { // // for(j=1;j<=12;j++) // { // if(j<10) // { // sql+="select * from "+i.ToString()+"0"+j.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // else // { // sql+="select * from "+i.ToString()+j.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // } // } // //3，循环到结束的月份 // js=Convert.ToInt32(zendtime.Substring(0,4)+"00"); // for(i=js;i<Convert.ToInt32(eTime);i++) // { // i++; // sql+="select * from "+i.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // // } // sql+="select * from "+eTime.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "; // // } // } // //三，取其他表生成生成SQL语句 // else // { // //1，先循环到起始时间和起始时间的12月 // s=Convert.ToInt32(sTime); // x=zstarttime.Substring(0,4)+"12"; // nz=Convert.ToInt32(x); // for(i=s;i<=nz;i++) // { // i=i++; // sql+="select * from "+i.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // //2，循环两者相差年份 // for(i=sy+1;i<ey;i++) // { // // for(j=1;j<=12;j++) // { // if(j<10) // { // sql+="select * from "+i.ToString()+"0"+j.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // else // { // sql+="select * from "+i.ToString()+j.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // } // } // } // //3，循环到结束的月份 // js=Convert.ToInt32(zendtime.Substring(0,4)+"00"); // for(i=js;i<Convert.ToInt32(eTime);i++) // { // i++; // sql+="select * from "+i.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "+"union"+" "; // // } // sql+="select * from "+eTime.ToString()+'_'+tablehz+" "+"where"+" "+danwei+"="+dw+" "+" "+"and"+" "+xiansunlv+">="+startxsl+" "+"and"+" "+xiansunlv+"<="+endxsl+" "; // // } // return sql; // } // #endregion // // #region 根据查询时间的条件，动态生成查询语句 // /// <summary> // /// 根据查询时间的条件，动态生成查询语句 // /// </summary> // /// <param name="starttime">开始时间</param> // /// <param name="endtime">结束时间</param> // /// <param name="zhiduan">查询字段</param> // /// <param name="tiaojiao">查询条件</param> // /// <param name="tablehz">表后缀</param> // /// <returns>SQL语句</returns> // public string SQL(DateTime starttime,DateTime endtime,string zhiduan,string tiaojiao,string tablehz) // { // // string sql=null; // //将输入的时间格式转换成固定的格式"yyyy-mm-dd" // string zstarttime=starttime.GetDateTimeFormats('D')[1].ToString(); // string zendtime=endtime.GetDateTimeFormats('D')[1].ToString(); // string nTime=DateTime.Now.GetDateTimeFormats('D')[1].ToString(); // // // //取日期值的前六位，及年月值 // string sTime=zstarttime.Substring(0,4)+zstarttime.Substring(5,2); // string eTime=zendtime.Substring(0,4)+zendtime.Substring(5,2); // string nowTime=nTime.Substring(0,4)+nTime.Substring(5,2); // //分别取日期的年和月 // int sy=Convert.ToInt32(zstarttime.Substring(0,4)); // int ey=Convert.ToInt32(zendtime.Substring(0,4)); // int sm=Convert.ToInt32(zstarttime.Substring(5,2)); // int em=Convert.ToInt32(zendtime.Substring(5,2)); // //相关变量定义 // int s; // int e; // int i; // int j; // int js; // int nz; // string x; // //一，取当前表生成SQL语句 // if(sTime==nowTime&&eTime==nowTime) // { // sql="select"+" "+zhiduan+" "+"from"+" "+tablehz+" "+"where"+" "+tiaojiao+" "; // // } // //二，取当前表和其他表生成SQL语句 // else if(sTime==nowTime&&eTime!=nowTime) // { // sql="select"+" "+zhiduan+" "+"from"+" "+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // //如果年份相等 // if(sy==ey) // { // s=Convert.ToInt32(sTime); // e=Convert.ToInt32(eTime); // for(i=s+1;i<e;i++) // { // i=i++; // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // sql+="select"+" "+zhiduan+" "+"from"+" "+e.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "; // // } // //结束年份大于开始年份 // else // { // //1，先循环到起始时间和起始时间的12月 // s=Convert.ToInt32(sTime); // x=zstarttime.Substring(0,4)+"12"; // nz=Convert.ToInt32(x); // for(i=s+1;i<=nz;i++) // { // i=i++; // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // //2，循环两者相差年份 // for(i=sy+1;i<ey;i++) // { // // for(j=1;j<=12;j++) // { // if(j<10) // { // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+"0"+j.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // else // { // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+j.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // } // } // } // //3，循环到结束的月份 // js=Convert.ToInt32(zendtime.Substring(0,4)+"00"); // for(i=js;i<Convert.ToInt32(eTime);i++) // { // i++; // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // sql+="select"+" "+zhiduan+" "+"from"+" "+eTime.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "; // // } // } // //三，取其他表生成生成SQL语句 // else // { // //1，先循环到起始时间和起始时间的12月 // s=Convert.ToInt32(sTime); // x=zstarttime.Substring(0,4)+"12"; // nz=Convert.ToInt32(x); // for(i=s;i<=nz;i++) // { // i=i++; // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // //2，循环两者相差年份 // for(i=sy+1;i<ey;i++) // { // // for(j=1;j<=12;j++) // { // if(j<10) // { // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+"0"+j.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // else // { // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+j.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // } // } // } // //3，循环到结束的月份 // js=Convert.ToInt32(zendtime.Substring(0,4)+"00"); // for(i=js;i<Convert.ToInt32(eTime);i++) // { // i++; // sql+="select"+" "+zhiduan+" "+"from"+" "+i.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "+"union"+" "; // // } // sql+="select"+" "+zhiduan+" "+"from"+" "+eTime.ToString()+'_'+tablehz+" "+"where"+" "+tiaojiao+" "; // // } // return sql; // } // #endregion #endregion }}2、OracleHelper
using System.Data.OracleClient;using System.Data.Common;namespace XH.WebService{ /// <summary> /// Oracle数据库操作类 /// </summary> public class OracleHelper:DBHelper { OracleConnection con; public OracleHelper(string connectionString) { con = new OracleConnection(connectionString); } protected override DbConnection Connection { get { return con; } } protected override DbCommand GetDbCommand() { return new OracleCommand(); } protected override DbDataAdapter GetDbDataAdapter() { return new OracleDataAdapter(); } }}3、工厂类
从配置文件中读取数据库类型和连接字符串，通过反射构造数据库辅助类对象
using System;using System.Configuration;namespace XH.WebService{ public static class DBHelperFactory { public static DBHelper CreateDBhelper() { var dbType = ConfigurationManager.AppSettings["database"]; var connectionString = ConfigurationManager.ConnectionStrings[dbType].ConnectionString; try { DBHelper dbHelper = Activator.CreateInstance(Type.GetType(dbType), new object[] { connectionString }) as DBHelper; return dbHelper; } catch (Exception ex) { throw new Exception("数据库类型有误，请修改配置文件的数据库类型", ex); } } }}配置文件：
<configuration> <connectionStrings> <add name="XH.WebService.OracleHelper" connectionString="Data Source=190.224.5.252/xhdb;Persist Security Info=True;User ID=XHSYS;Password=XHSYS;Unicode=True" /> </connectionStrings> <appSettings> <add key="database" value="XH.WebService.OracleHelper" /> </appSettings><configuration>
0 0
- c# 数据库辅助类
- 黑马程序员--C#数据库辅助类（简单版）
- C#事件辅助类
- C# 操作word辅助类
- C#操作WORD辅助类
- C# 邮件发送辅助类
- C#串口辅助开发类
- C#串口辅助开发类
- 数据库JDBC操作辅助类
- C#中国象棋网络版源代码(四)-辅助类
- C#操作Word辅助类(word2003)
- C#操作Word辅助类(word2003)(转)
- C# IIS应用程序池辅助类
- 使用C#操作IIS7的辅助类
- 通用数据库操作辅助类DbHelper
- 数据库读取数据辅助类 DataHelperIoT
- 初学时的数据库操作辅助类
- 【Android 开发教程】创建数据库辅助类
- 图像质心分析：Matlab、质心法，高斯拟合法
- 为什么Nginx的性能要比Apache高很多？
- USACO-Section 3.2 Magic Squares（BFS）
- codeforces 652 A. Gabriel and Caterpillar
- Java总结篇系列：Java泛型
- c# 数据库辅助类
- mysql连接状态
- Hibernate查询语句
- 华为oj初级题目——合唱队
- 一种基于网络服务的客户端自动升级框架及其应用
- 1：数据库基本操作
- MYSQL utf8_unicode_ci 和utf8_general_ci的区别
- netctoss02_登陆页面【Servlet+JSP版】
- Linux下查看用户列表
