相关文章推荐

下图是三层架构列表,Models里面有模拟数据库中列的类,DAL中有DBHelper和service,BLL中有BllManager文件用于ui界面直接调用

建照片文件夹用于展示图片,数据库存地址

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 NewsModels
        private string newsID;
        public string NewsID
            get { return newsID; }
            set { newsID = value; }
        private string newsTitle;
        public string NewsTitle
            get { return newsTitle; }
            set { newsTitle = value; }
        private string newsContent;
        public string NewsContent
            get { return newsContent; }
            set { newsContent = value; }
        private string type;
        public string Type
            get { return type; }
            set { type = value; }
        private string publisher;
        public string Publisher
            get { return publisher; }
            set { publisher = value; }
        private string pian;
        public string Pian
            get { return pian; }
            set { pian = value; }
        private string pubTime;
        public string PubTime
            get { return pubTime; }
            set { pubTime = 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=NewsDB;uid=sa;pwd=123123";
        public static SqlConnection conn = null;
        public static void Conncet() {
            if (conn==null)
                conn=new SqlConnection(connstr);
            conn.Close();
            conn.Open();
        public static bool NoQuery(string sql) {
            Conncet();
            SqlCommand cmd = new SqlCommand(sql,conn);
          int temp=  cmd.ExecuteNonQuery();
          conn.Close();
          return temp > 0;
        public static SqlDataReader Reader(string sql) {
            Conncet();
            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 DalService
      public static List<Models.NewsModels> Zhanshi() {
          List<Models.NewsModels> list = new List<Models.NewsModels>();
          string sql = "select * from News";
      SqlDataReader read=    DBHelper.Reader(sql);
      while (read.Read())
	         Models.NewsModels model=new Models.NewsModels();
             model.NewsID = read["NewsID"].ToString();
             model.NewsTitle = read["NewsTitle"].ToString();
             model.Pian = read["Pian"].ToString();
             model.Publisher = read["Publisher"].ToString();
             model.Type = read["Type"].ToString();
             model.PubTime = read["PubTime"].ToString();
             model.NewsContent = read["NewsContent"].ToString();
             list.Add(model);
          return list;
      public static List<Models.NewsModels>  Cha(string title)
          List<Models.NewsModels> list = new List<Models.NewsModels>();
          string sql = string.Format("select * from News where NewsTitle like '%{0}%'",title);
          SqlDataReader read = DBHelper.Reader(sql);
          while (read.Read())
              Models.NewsModels model = new Models.NewsModels();
              model.NewsID = read["NewsID"].ToString();
              model.NewsTitle = read["NewsTitle"].ToString();
              model.Pian = read["Pian"].ToString();
              model.Publisher = read["Publisher"].ToString();
              model.Type = read["Type"].ToString();
              model.PubTime = read["PubTime"].ToString();
              model.NewsContent = read["NewsContent"].ToString();
              list.Add(model);
          return list;
      public static bool  Jia(string title,string content,string type,string publisher){
            string sql=string.Format("insert News values('{0}','{1}','{2}','{3}','Jellyfish.jpg',GETDATE())",title,content,type,publisher);
            if (DBHelper.NoQuery(sql))
                return true;
                return false;

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.NewsModels> Zhanshi() {
           return DAL.DalService.Zhanshi(); 
       public static bool Jia(string title, string content, string type, string publisher) {
           return DAL.DalService.Jia(title,content,type,publisher);
       public static List<Models.NewsModels> Cha(string title) {
           return DAL.DalService.Cha(title);

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

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="Index.Index" %>
<!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>
    <form id="form1" runat="server">
         <a href="TianJia.aspx">添加新闻</a>
            <br />    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" />
        <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
            <HeaderTemplate>
                <table border="1" >
                         </th> <th>
                         </th><th>
                         </th> <th>
                         </th> <th>
            </HeaderTemplate>
            <ItemTemplate>
                        <%#Eval("NewsID") %>
                        <%#Eval("NewsTitle") %>                      
                        <%#Eval("NewsContent") %>                     
                        <img src="Img/<%#Eval("Pian") %>" height="50px" width="50px"/>                      
                        <%#Eval("Type") %>  
                        <%#Eval("Publisher") %>                       
                          <%#Eval("PubTime") %>
            </ItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
    </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 Index : System.Web.UI.Page
        protected void Page_Load(object sender, EventArgs e)
            if (!IsPostBack)
                List<Models.NewsModels> list = BLL.BllManager.Zhanshi();
                Repeater1.DataSource = list;
                Repeater1.DataBind();
        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        protected void Button1_Click(object sender, EventArgs e)
            List<Models.NewsModels> list = BLL.BllManager.Cha(TextBox1.Text.ToString());
            Repeater1.DataSource = list;
            Repeater1.DataBind();

9、ui表现层添加界面前端部分

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TianJia.aspx.cs" Inherits="Index.TianJia" %>
<!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>
    <form id="form1" runat="server">
        <a href="Index.aspx">返回</a>
   <br />     <asp:Label ID="Label1" runat="server" Text="标题"></asp:Label><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="标题不能为空" ControlToValidate="TextBox1"></asp:RequiredFieldValidator>
       <br />           <asp:Label ID="Label2" runat="server" Text="内容"></asp:Label><asp:TextBox Height="100px" ID="TextBox2" runat="server" TextMode="MultiLine"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="内容不能为空" ControlToValidate="TextBox2"></asp:RequiredFieldValidator>
     <br />     <asp:Label ID="Label3" runat="server" Text="类型"></asp:Label><asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="类型不能为空" ControlToValidate="TextBox3"></asp:RequiredFieldValidator>
     <br />     <asp:Label ID="Label4" runat="server" Text="发布人"></asp:Label><asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="发布人不能为空" ControlToValidate="TextBox4"></asp:RequiredFieldValidator>
    <br />         <asp:Button ID="Button1" runat="server" Text="添加" OnClick="Button1_Click" />
    </form>
</body>
</html>

10、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 TianJia : System.Web.UI.Page
        protected void Page_Load(object sender, EventArgs e)
            UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;
        protected void Button1_Click(object sender, EventArgs e)
            if (BLL.BllManager.Jia(TextBox1.Text.ToString(), TextBox2.Text.ToString(), TextBox3.Text.ToString(), TextBox4.Text.ToString()))
                ClientScript.RegisterStartupScript(this.GetType(), "success", "alert('成功添加');location.href='Index.aspx'",true);
                ClientScript.RegisterStartupScript(this.GetType(), "fail", "alert('失败');", true);
资源名:基于ASP.NET MVC的三层架构博客网站系统源码
资源类型:程序源代码
源码说明: 使用ASP.NET写的三层架构博客系统 带SEO优化 完整代码 适合学习使用
适合人群:新手及有一定经验的开发人员
3.新闻内容的图文混排,并自动获取发布新闻里的所有图片
4.获取新闻图片,显示成滚动flash图片,即做成图片新闻样式(本案例只是获取图片,要flash滚动图片请大家扩展)
5.删除新闻同时删除新闻中的图片,防止垃圾的产生(图片都取出来了,自己扩展删除)
6.鼠标移动到新闻标题,显示详细标题,主要是a 标记title属性的使用,换行是&#13
                                    from lxml import etreeimport requestsimport osBASE_DOMAIN = "http://m2.people.cn/"HEADERS={'User-Agent':'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/...
 
推荐文章