抽象工厂实现数据库切换

      关于抽象工厂的概念在此本人就不多介绍了，有兴趣的初学者可以参考书籍和网络平台，一定会找到正确的答案 。 写这篇文章的目的是为了帮助初学者能更好的理解和掌握所谓设计模式中的抽象工厂，因为我是很喜欢这个设计模式。三层架构我想你们一定不会陌生吧，大致分为表示层，业务逻辑层，数据访问层。依赖关系分别为自上而下，如果在一个实际的开发项目中，光是有这三层是远远不足的，层与层之间的耦合度是相当的高。我用抽象工厂的目的在于，降低业务逻辑层和数据访问层之间的耦合，也就是业务层不知道数据层使用的是什么数据库。下面就把具体的代码共享出来，和初学者一起学习研究，如果有什么不明白的地方，可以联系我。QQ：９３６９４４３０８（验证问题：沈宇峰）。

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Models { public class Stuinfo { public int stuno { get; set; } public string stuname { get; set; } public string password { get; set; } public int age { get; set; } public string sex { get; set; } public Stuinfo() { } } }

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Models; namespace IDAL { public interface IStuinfo { /// <summary> /// /// </summary> /// <returns></returns> List<Stuinfo> findAllStuinfo(); /// <summary> /// /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> int addStuinfo(Stuinfo stuinfo); /// <summary> /// 有输入参数和输出参数的存储过程 /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> int addStuinfoTest1(Stuinfo stuinfo); /// <summary> /// 同时具有返回值、输入参数、输出参数的存储过程 /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> int addStuinfoTest2(Stuinfo stuinfo); } }

 

using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Text; using IDAL; using Models; namespace DAL2005 { public class StuinfoDAL:IStuinfo { /// <summary> /// /// </summary> /// <returns></returns> public List<Stuinfo> findAllStuinfo() { List<Stuinfo> list = new List<Stuinfo>(); using(SqlConnection sqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString)) { try { sqlconnection.Open(); SqlCommand sqlcommand = new SqlCommand("Categoriestest1",sqlconnection); sqlcommand.CommandType = CommandType.StoredProcedure; using(SqlDataReader reader = sqlcommand.ExecuteReader(CommandBehavior.CloseConnection)) { while(reader.Read()) { Stuinfo stuinfo = new Stuinfo() { stuno = (int)reader["stuno"], stuname = reader["stuname"].ToString(), password = reader["password"].ToString(), sex = reader["sex"].ToString(), age = (int)reader["age"] }; list.Add(stuinfo); } } } catch (Exception) { throw; } return list; } } /// <summary> /// /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public int addStuinfo(Stuinfo stuinfo) { using(SqlConnection sqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString)) { try { sqlconnection.Open(); SqlCommand sqlcommand = new SqlCommand("Categoriestest3",sqlconnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter[] parameters = { new SqlParameter("@stuname",SqlDbType.VarChar,45), new SqlParameter("@password",SqlDbType.VarChar,45), new SqlParameter("@sex",SqlDbType.VarChar,45), new SqlParameter("@age",SqlDbType.Int,4), new SqlParameter("@count",SqlDbType.Int,4) }; parameters[0].Value = stuinfo.stuname.ToString(); parameters[1].Value = stuinfo.password.ToString(); parameters[2].Value = stuinfo.sex.ToString(); parameters[3].Value = stuinfo.age; parameters[4].Direction = ParameterDirection.ReturnValue; foreach(SqlParameter parameter in parameters) { sqlcommand.Parameters.Add(parameter); } sqlcommand.ExecuteNonQuery(); int count = int.Parse(sqlcommand.Parameters["@count"].Value.ToString()); return count; } catch (Exception) { throw; } } } /// <summary> /// 有输入参数和输出参数的存储过程 /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public int addStuinfoTest1(Stuinfo stuinfo) { using(SqlConnection sqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString)) { try { sqlconnection.Open(); SqlCommand sqlcommand = new SqlCommand("Categoriestest4",sqlconnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter[] parameters = { new SqlParameter("@stuno",SqlDbType.Int,4), new SqlParameter("@stuname",SqlDbType.VarChar,45), new SqlParameter("@password",SqlDbType.VarChar,45), new SqlParameter("@sex",SqlDbType.VarChar,45), new SqlParameter("@age",SqlDbType.Int,4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = stuinfo.stuname.ToString(); parameters[2].Value = stuinfo.password.ToString(); parameters[3].Value = stuinfo.sex.ToString(); parameters[4].Value = stuinfo.age; foreach(SqlParameter parameter in parameters) { sqlcommand.Parameters.Add(parameter); } sqlcommand.ExecuteNonQuery(); int count = int.Parse(sqlcommand.Parameters["@stuno"].Value.ToString()); return count; } catch (Exception) { throw; } } } #region IStuinfo 成员 /// <summary> /// 同时具有返回值、输入参数、输出参数的存储过程 /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public int addStuinfoTest2(Stuinfo stuinfo) { using(SqlConnection sqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString)) { try { sqlconnection.Open(); SqlCommand sqlcommand = new SqlCommand("Categoriestest6",sqlconnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter[] parameters = { new SqlParameter("@stuno",SqlDbType.Int,4), new SqlParameter("@stuname",SqlDbType.VarChar,45), new SqlParameter("@password",SqlDbType.VarChar,45), new SqlParameter("@sex",SqlDbType.VarChar,45), new SqlParameter("@age",SqlDbType.Int,4), new SqlParameter("@count",SqlDbType.Int,4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = stuinfo.stuname.ToString(); parameters[2].Value = stuinfo.password.ToString(); parameters[3].Value = stuinfo.sex.ToString(); parameters[4].Value = stuinfo.age; parameters[5].Direction = ParameterDirection.Output; foreach(SqlParameter parameter in parameters) { sqlcommand.Parameters.Add(parameter); } sqlcommand.ExecuteNonQuery(); int count = int.Parse(sqlcommand.Parameters["@count"].Value.ToString());//用户名状态(0表示用户名没有注册，1表示用户名已经被注册) if (count == 0) { int newStuno = int.Parse(sqlcommand.Parameters["@stuno"].Value.ToString()); } return count; } catch (Exception) { throw; } } } #endregion } }

 

using System; using System.Collections.Generic; using System.Configuration; using System.Linq; using System.Reflection; using System.Text; using IDAL; namespace DALFactory { public abstract class AbstractorDALFactory { /// <summary> /// switch语句实现抽象工厂 /// </summary> /// <returns></returns> public static AbstractorDALFactory chooseFactory() { string type = ConfigurationManager.AppSettings["type"]; AbstractorDALFactory factory = null; switch (type) { case "sql2005": { factory = new Sql2005DALFactory(); break; } } return factory; } /// <summary> /// 反射实现抽象工厂 /// </summary> /// <returns></returns> public static AbstractorDALFactory reflectionChooseFactory() { string type = ConfigurationManager.AppSettings["type"].ToString(); AbstractorDALFactory factory = null; factory = (AbstractorDALFactory)Assembly.Load("DALFactory").CreateInstance(type); return factory; } /// <summary> /// /// </summary> /// <returns></returns> public abstract IStuinfo createIStuinfo(); } }

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; using DALFactory; using IDAL; namespace BLLFactory { public static class ProxyFactory { /// <summary> /// /// </summary> static ProxyFactory() { AbstractorDALFactory factory = AbstractorDALFactory.reflectionChooseFactory(); istuinfo = factory.createIStuinfo(); } /// <summary> /// /// </summary> public static IStuinfo istuinfo { get; set; } } }

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; using Models; using BLLFactory; namespace BLL { public class StuinfoBLL { /// <summary> /// /// </summary> /// <returns></returns> public static List<Stuinfo> findAllStuinfo() { return ProxyFactory.istuinfo.findAllStuinfo(); } /// <summary> /// /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public static int addStuinfo(Stuinfo stuinfo) { return ProxyFactory.istuinfo.addStuinfo(stuinfo); } /// <summary> /// /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public static int addStuinfoTest1(Stuinfo stuinfo) { return ProxyFactory.istuinfo.addStuinfoTest1(stuinfo); } /// <summary> /// /// </summary> /// <param name="stuinfo"></param> /// <returns></returns> public static int addStuinfoTest2(Stuinfo stuinfo) { return ProxyFactory.istuinfo.addStuinfoTest2(stuinfo); } } }