工厂方法模式实现数据库连接

建立一个类文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace clsDB
{
    public interface facDB
    {
        string New();
    }

    public class DB
    {
        public facDB GetDB(string Name)
        {
            facDB MyDB = null;

            try
            {

                Type type = Type.GetType("clsDB." + Name, true);

                MyDB = (facDB)Activator.CreateInstance(type);

            }

            catch (TypeLoadException e)
            {
                //Console.WriteLine("I dont know this kind of furnitureexception caught - {0}" ,e.Message);
            }
            return MyDB;
        }
    }

    public class Oracle : facDB
    {
        public string New()
        {
            return "Oracle";
        }
    }

    public class SqlServer : facDB
    {
        public string New()
        {
            return "SqlServer";
        }
    }

    public class MySql : facDB
    {
        public string New()
        {
            return "MySql";
        }
    }
}

client端使用

string strDBType = "MySql";
            clsDB.facDB db;
            clsDB.DB t = new clsDB.DB();
            db = t.GetDB(strDBType);
            MessageBox.Show(db.New());