三层架构的基本模型
1.创建wed应用程序项目
2.在解决方案下添加三个类库项目:MODEL 、DAL、 BLL
如下图:
3.设置四个项目间的关系:DAL引用MODEL ,BLL引用MODEL和DAL,网站项目引用MODEL 和BLL
如下图:
同时添加在DAL中添加Configuration引用
4.在DAL项目下添加实体类SqlHelper代码如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
namespace DAL
{
public class SqlHelper
{
/// <summary>
/// 数据库连接字段
/// </summary>
private static string strConn = ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString;
/// <summary>
/// 执行查询语句
/// </summary>
/// <param name="select">查询语句</param>
/// <returns></returns>
public static DataTable ExecQuery(string select)
{
SqlDataAdapter dataAdapter = new SqlDataAdapter(select, strConn);
DataTable table = new DataTable();
dataAdapter.Fill(table);
return table;
}
/// <summary>
/// 执行非查询语句
/// </summary>
/// <param name="cmd">增、删、改语句</param>
/// <returns></returns>
public static int ExecNonQuery(string cmd)
{
int res = 0;
SqlConnection sqlConn = new SqlConnection(strConn);
SqlCommand sqlCmd = new SqlCommand(cmd, sqlConn);
try
{
sqlConn.Open();
res = sqlCmd.ExecuteNonQuery();
}
finally
{
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
return res;
}
}
}