c# 通用数据库类Word格式文档下载.docx
- 文档编号:7628901
- 上传时间:2023-05-08
- 格式:DOCX
- 页数:45
- 大小:20.43KB
c# 通用数据库类Word格式文档下载.docx
《c# 通用数据库类Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《c# 通用数据库类Word格式文档下载.docx(45页珍藏版)》请在冰点文库上搜索。
{
//数据库连接字符串(web.config来配置)
//<
addkey="
ConnectionString"
value="
server=127.0.0.1;
database=DATABASE;
uid=sa;
pwd="
/>
privatestringconnectionString;
publicstringConntionString
get
returnconnectionString;
}
set
connectionString=value;
publicDataBaseLayer(stringstrConnect,stringdataType)
{
this.ConntionString=strConnect;
this.DbType=dataType;
publicDataBaseLayer()
//this.connectionString=ConfigurationSettings.AppSettings["
];
//this.dbType=ConfigurationSettings.AppSettings["
DataType"
//this.connectionString="
datasource=192.168.1.43;
userid=sa;
pwd=sa;
database=temphrdb"
;
//this.dbType="
SqlServer"
this.connectionString=DBHelper.connstr;
this.dbType="
///数据库类型
privatestringdbType;
publicstringDbType
if(dbType==string.Empty||dbType==null)
return"
Access"
else
returndbType;
if(value!
=string.Empty&
&
value!
=null)
dbType=value;
if(dbType==string.Empty||dbType==null)
dbType=ConfigurationSettings.AppSettings["
];
dbType="
}
#region转换参数
privateSystem.Data.IDbDataParameteriDbPara(stringParaName,stringDataType)
switch(this.DbType)
case"
:
returnGetSqlPara(ParaName,DataType);
Oracle"
returnGetOleDbPara(ParaName,DataType);
default:
privateSystem.Data.SqlClient.SqlParameterGetSqlPara(stringParaName,stringDataType)
switch(DataType)
Decimal"
returnnewSystem.Data.SqlClient.SqlParameter(ParaName,System.Data.SqlDbType.Decimal);
Varchar"
returnnewSystem.Data.SqlClient.SqlParameter(ParaName,System.Data.SqlDbType.VarChar);
DateTime"
returnnewSystem.Data.SqlClient.SqlParameter(ParaName,System.Data.SqlDbType.DateTime);
Iamge"
returnnewSystem.Data.SqlClient.SqlParameter(ParaName,System.Data.SqlDbType.Image);
Int"
returnnewSystem.Data.SqlClient.SqlParameter(ParaName,System.Data.SqlDbType.Int);
Text"
returnnewSystem.Data.SqlClient.SqlParameter(ParaName,System.Data.SqlDbType.NText);
privateSystem.Data.OracleClient.OracleParameterGetOraclePara(stringParaName,stringDataType)
returnnewSystem.Data.OracleClient.OracleParameter(ParaName,System.Data.OracleClient.OracleType.Double);
returnnewSystem.Data.OracleClient.OracleParameter(ParaName,System.Data.OracleClient.OracleType.VarChar);
returnnewSystem.Data.OracleClient.OracleParameter(ParaName,System.Data.OracleClient.OracleType.DateTime);
returnnewSystem.Data.OracleClient.OracleParameter(ParaName,System.Data.OracleClient.OracleType.BFile);
returnnewSystem.Data.OracleClient.OracleParameter(ParaName,System.Data.OracleClient.OracleType.Int32);
returnnewSystem.Data.OracleClient.OracleParameter(ParaName,System.Data.OracleClient.OracleType.LongVarChar);
default:
privateSystem.Data.OleDb.OleDbParameterGetOleDbPara(stringParaName,stringDataType)
returnnewSystem.Data.OleDb.OleDbParameter(ParaName,System.Data.DbType.Decimal);
returnnewSystem.Data.OleDb.OleDbParameter(ParaName,System.Data.DbType.String);
returnnewSystem.Data.OleDb.OleDbParameter(ParaName,System.Data.DbType.DateTime);
returnnewSystem.Data.OleDb.OleDbParameter(ParaName,System.Data.DbType.Binary);
returnnewSystem.Data.OleDb.OleDbParameter(ParaName,System.Data.DbType.Int32);
#endregion
//创建Connection和Command
#region创建Connection和Command
privateIDbConnectionGetConnection()
returnnewSystem.Data.SqlClient.SqlConnection(this.ConntionString);
returnnewSystem.Data.OracleClient.OracleConnection(this.ConntionString);
returnnewSystem.Data.OleDb.OleDbConnection(this.ConntionString);
privateIDbCommandGetCommand(stringSql,IDbConnectioniConn)
returnnewSystem.Data.SqlClient.SqlCommand(Sql,(SqlConnection)iConn);
returnnewSystem.Data.OracleClient.OracleCommand(Sql,(OracleConnection)iConn);
returnnewSystem.Data.OleDb.OleDbCommand(Sql,(OleDbConnection)iConn);
privateIDbCommandGetCommand()
returnnewSystem.Data.SqlClient.SqlCommand();
returnnewSystem.Data.OracleClient.OracleCommand();
returnnewSystem.Data.OleDb.OleDbCommand();
privateIDataAdapterGetAdapater(stringSql,IDbConnectioniConn)
returnnewSystem.Data.SqlClient.SqlDataAdapter(Sql,(SqlConnection)iConn);
returnnewSystem.Data.OracleClient.OracleDataAdapter(Sql,(OracleConnection)iConn);
returnnewSystem.Data.OleDb.OleDbDataAdapter(Sql,(OleDbConnection)iConn);
privateIDataAdapterGetAdapater()
returnnewSystem.Data.SqlClient.SqlDataAdapter();
returnnewSystem.Data.OracleClient.OracleDataAdapter();
returnnewSystem.Data.OleDb.OleDbDataAdapter();
privateIDataAdapterGetAdapater(IDbCommandiCmd)
returnnewSystem.Data.SqlClient.SqlDataAdapter((SqlCommand)iCmd);
returnnewSystem.Data.OracleClient.OracleDataAdapter((OracleCommand)iCmd);
returnnewSystem.Data.OleDb.OleDbDataAdapter((OleDbCommand)iCmd);
//执行简单SQL语句
#region执行简单SQL语句
///执行SQL语句,返回影响的记录数
paramname="
SQLString"
>
SQL语句<
/param>
returns>
影响的记录数<
/returns>
publicintExecuteSql(stringSqlString)
using(System.Data.IDbConnectioniConn=this.GetConnection())
using(System.Data.IDbCommandiCmd=GetCommand(SqlString,iConn))
iConn.Open();
try
introws=iCmd.ExecuteNonQuery();
returnrows;
catch(System.ExceptionE)
thrownewException(E.Message);
finally
if(iConn.State!
=ConnectionState.Closed)
iConn.Close();
///执行多条SQL语句,实现数据库事务。
SQLStringList"
多条SQL语句<
publicvoidExecuteSqlTran(ArrayListSQLStringList)
using(System.Data.IDbCommandiCmd=GetCommand())
iCmd.Connection=iConn;
using(System.Data.IDbTransactioniDbTran=iConn.BeginTransaction())
iCmd.Transaction=iDbTran;
for(intn=0;
n<
SQLStringList.Count;
n++)
stringstrsql=SQLStringList[n].ToString();
if(strsql.Trim().Length>
1)
iCmd.CommandText=strsql;
iCmd.ExecuteNonQuery();
iDbTran.Commit();
iDbTran.Rollback();
///执行带一个存储过程参数的的SQL语句。
content"
参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加<
publicintExecuteSql(stringSqlString,stringcontent)
using(System.Data.IDbCommandiCmd=GetCommand(SqlString,iConn))
System.Data.IDataParametermyParameter=this.iDbPara("
@content"
"
);
myParameter.Value=content;
iCmd.Parameters.Add(myParameter);
introws=iCmd.ExecuteNonQuery();
catch(System.Exceptione)
thrownewException(e.Message);
///向数据库里插入图像格式的字段(和上面情况类似的另一种实例)
strSQL"
fs"
图像字节,数据库的字段类型为image的情况<
publicintExecute
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- c# 通用数据库类 通用 数据库