asp.net下Oracle,SQL Server,Access万能数据库通用类
171 浏览量
2021-01-01
02:45:27
上传
评论
收藏 82KB PDF 举报
asp.net下下Oracle,SQL Server,Access万能数据库通用类万能数据库通用类
复制代码 代码如下:
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data.OracleClient;
using System.Configuration;
using System.Reflection;
namespace SystemFramework.DAL
{
/**//// <summary>
/// All rights reserved
/// 数据访问基础类
/// 用户可以修改满足自己项目的需要。
/// </summary>
public class DataBaseLayer
{
//数据库连接字符串(web.config来配置)
//<add key=”ConnectionString” value=”server=127.0.0.1;database=DATABASE;uid=sa;pwd=” />
private string connectionString;
public string ConntionString
{
get
{
return connectionString ;
}
set
{
connectionString = value;
}
}
public DataBaseLayer(string strConnect,string dataType)
{
this.ConntionString = strConnect;
this.DbType = dataType;
}
public DataBaseLayer()
{
this.connectionString = ConfigurationSettings.AppSettings[“ConnectionString”] ;
this.dbType = ConfigurationSettings.AppSettings[“DataType”] ;
}
/**//// <summary>
/// 数据库类型
/// </summary>
private string dbType;
public string DbType
{
get
{
if ( dbType == string.Empty || dbType == null )
{
return “Access”;
}
else
{
return dbType;
}
}
set
{
if ( value != string.Empty && value != null )
剩余15页未读，继续阅读
资源评论
weixin_38741759
- 粉丝: 3
- 资源: 964
