通过简单factory,把抽象类——数据库连接,实现为针对不同数据库(sqlserver、oracle等)的数据连接子类,并在子类实现对数据集的填充、执行各种sql语句的方法。
数据连接工厂类
using System;
using System.Data;
using System.Configuration;
public class dbFactory
{
public dbFactory() { }
public dbConnect CreatConnect(string contype, string connectstring)
{
if (contype == "oracle")
{
return new dbOracle(connectstring);
}
else if (contype == "sqlserver")
{
return new dbSqlserver(connectstring);
}
else
{
contype = "oracle";
return new dbOracle(connectstring);
}
}
}
数据连接抽象类
using System;
using System.Data;
using System.Configuration;
public abstract class dbConnect
{
public dbConnect() { }
public abstract string Connect();
public abstract string CheckConn();//数据连接检查
public abstract string FillDataset(string strsql, string TableName, DataSet DS);
//填充dataset
public abstract string DeleteBySql(string strsql);
数据连接工厂类
using System;
using System.Data;
using System.Configuration;
public class dbFactory
{
public dbFactory() { }
public dbConnect CreatConnect(string contype, string connectstring)
{
if (contype == "oracle")
{
return new dbOracle(connectstring);
}
else if (contype == "sqlserver")
{
return new dbSqlserver(connectstring);
}
else
{
contype = "oracle";
return new dbOracle(connectstring);
}
}
}
数据连接抽象类
using System;
using System.Data;
using System.Configuration;
public abstract class dbConnect
{
public dbConnect() { }
public abstract string Connect();
public abstract string CheckConn();//数据连接检查
public abstract string FillDataset(string strsql, string TableName, DataSet DS);
//填充dataset
public abstract string DeleteBySql(string strsql);