个人记录,高手请忽略,这里理一下情况:
表格对象:User,Department,其它。。。
数据库工厂:DataFactory》》用来建立对应数据库表的操作对象。
数据表操作类:
ITableOper<T>》》提供数据表的增删改查接口
SqlserverTableOper<T>: ITableOper<T>》》实现Sqlserver中的操作接口
AccessTableOper<T>:ITableOper<T>》》实现Accessr中的操作接口
实现其它数据库类型操作接口。。。
主程序:
static void Main(string[] args)
{
IFactory factory1 = new DataFactory();
//生成User表格操作对像
ITableOper<User> userTable = factory1.CreateTableEntity<User>("sqlserver");
if (userTable == null)
{
Console.WriteLine("报错,表操作对象未建立!");
return;
}
//插入一条新User数据
userTable.Insert(new User() { ID = 1, Name = "dddd" });
User user= userTable.GetTableEntity(0);
Console.WriteLine(user.Name);
//生成Department部门表格操作对像
ITableOper<Department> departmentTable = factory1.CreateTableEntity<Department>("sqlserver");
if (departmentTable == null)
{
Console.WriteLine("报错,表操作对象未建立!");
return;
}
//插入一条新部门数据
departmentTable.Insert(new Department() { ID = 1, DepartmentName = "deparName" });
Department department = departmentTable.GetTableEntity(0);
Console.WriteLine(department.DepartmentName);
Console.ReadLine();
}
数据库工厂:
public class DataFactory
{
/// <summary>
/// 返回指定类型数据库存的表操作对象
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dataType">数据库类型</param>
/// <returns>dataType可以设置一个在外部文件中,方便不编译即可修改数据库类型</returns>
public SqlserverTableOper<T> CreateTableEntity<T>(string dataType)
{
Type tt= Type.GetType("ConsoleApp4."+ dataType + "TableOper`1",false,true);
if (tt==null)
{
return null;
}
Type type = tt.MakeGenericType(typeof(T));
object obj = Activator.CreateInstance(type);
return (SqlserverTableOper<T>)obj;
}
各数据库操作类:大体相同,参考就行
namespace ConsoleApp4
{
public interface ITableOper<T>
{
void Insert(T tableEntity);
T GetTableEntity(int id);
}
public class SqlserverTableOper<T>: ITableOper<T>
{
static List<T> tableData = new List<T>();
public T GetTableEntity(int id)
{
return tableData[id];
}
public void Insert(T tableEntity)
{
tableData.Add(tableEntity);
Console.WriteLine("已插入Sqlserver一条记录");
}
}
public class AccessTableOper<T>:ITableOper<T>
{
static List<T> tableData = new List<T>();
public T GetTableEntity(int id)
{
return tableData[id];
}
public void Insert(T tableEntity)
{
tableData.Add(tableEntity);
Console.WriteLine("已插入Access一条记录");
}
}
}
数据记录类:两个表...用户和部门
public class User
{
public int ID { get; set; }
public string Name { get; set; }
}
/// <summary>
/// 部门表实体,对应数据库中各字段
/// </summary>
public class Department
{
public int ID { get; set; }
public string DepartmentName { get; set; }
}