ASP.Net实现商品照片显示(三层架构)

最新推荐文章于 2024-05-10 10:22:36 发布

W少年没有乌托邦

最新推荐文章于 2024-05-10 10:22:36 发布

阅读量923

点赞数 11

分类专栏： ASP.Net 文章标签：数据库 asp.net

本文链接：https://blog.csdn.net/Mr_wangzu/article/details/135198440

版权

ASP.Net 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

演示功能：

点击启动生成页面

步骤：

1、建文件

下图是三层架构列表，Models里面有模拟数据库中列的类，DAL中有DBHelper和service,BLL中有BllManager文件用于ui界面直接调用，其中img文件用户储存照片，数据库中直接存照片地址

2、添加引用关系

DAL引用Models文件，BLL引用DAL和Models文件，主文件WebApplication1引用Bll和Models

3、根据数据库中的列写Models下的XueshengModels类

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

namespace Models
{
   public  class NewModels
    {
        private string newID;

        public string NewID
        {
            get { return newID; }
            set { newID = value; }
        }
        private string newTitle;

        public string NewTitle
        {
            get { return newTitle; }
            set { newTitle = value; }
        }
        private string newsContent;

        public string NewsContent
        {
            get { return newsContent; }
            set { newsContent = value; }
        }
        private string typeType;

        public string TypeType
        {
            get { return typeType; }
            set { typeType = value; }
        }
        private string publisher;

        public string Publisher
        {
            get { return publisher; }
            set { publisher = value; }
        }
        private string pubTime;

        public string PubTime
        {
            get { return pubTime; }
            set { pubTime = value; }
        }
        private string imgUrl;

        public string ImgUrl
        {
            get { return imgUrl; }
            set { imgUrl = value; }
        }

    }
}

4、DAL下的DBHelper（对数据库进行操作）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace DAL
{
   public class DBHelper
    {
       public static string connstr = "server=.;database=Info;uid=sa;pwd=123123";
       public static SqlConnection conn = null;
       public static void Connect() {
           if ( conn==null)
           {
               conn = new SqlConnection(connstr);
           }
           conn.Close();
           conn.Open();

       }
       public static bool NoQuery(string sql) {
           Connect();
           SqlCommand cmd = new SqlCommand(sql,conn);
        int temp=   cmd.ExecuteNonQuery();
           conn.Close();
           return temp>0;
       }
       public static SqlDataReader Reader(string sql)
       {
           Connect();
           SqlCommand cmd = new SqlCommand(sql, conn);
           return cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
       }
   }
}

5、DAL数据访问层下的service文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace DAL
{
  public  class SeviceDAL
    {
      public static List<Models.NewModels> Query() {
          string sql = "select * from New";
         SqlDataReader reader= DBHelper.Reader(sql);
         List<Models.NewModels> list = new List<Models.NewModels>();
         while (reader.Read())
         {
           Models.NewModels model=new Models.NewModels();
           model.NewID = reader["NewID"].ToString();
           model.NewsContent = reader["NewsContent"].ToString();
           model.NewTitle = reader["NewTitle"].ToString();
           model.Publisher = reader["Publisher"].ToString();
           model.TypeType = reader["TypeType"].ToString();
           model.PubTime = reader["PubTime"].ToString();
           model.ImgUrl = reader["ImgUrl"].ToString();
           list.Add(model);

         }
         return list;


      }
    }
}

6、BLL业务逻辑层下调用DAL的文件

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

namespace Bll
{
   public  class BllManager
    {
       public static List<Models.NewModels> Query() {
           return DAL.SeviceDAL.Query();
       }
    }
}

7、ui表现层主界面前端部分

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Index.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Repeater ID="Repeater1" runat="server">
            <HeaderTemplate>
                <table border="1">
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                     <td><%#Eval("NewID") %></td>
                         <td><%#Eval("NewTitle") %></td>
                     <td><%#Eval("NewsContent") %></td>
                     <td><img src='Img/<%#Eval("ImgUrl") %>' width="60px" height="50px"/></td>
                     <td><%#Eval("TypeType") %></td>
                     <td><%#Eval("Publisher") %></td>
                     <td><%#Eval("PubTime") %></td>
                </tr>
            </ItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
    </div>
    </form>
</body>
</html>

8、ui表现层主界面后端部分

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Index
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
      List<Models.NewModels> list=     Bll.BllManager.Query();
      this.Repeater1.DataSource = list;
      this.Repeater1.DataBind();
        }
    }
}