ASP.NET高级开发之三层架构

最新推荐文章于 2020-06-10 10:31:48 发布

成长的小码农

最新推荐文章于 2020-06-10 10:31:48 发布

阅读量441

点赞数

分类专栏：每天小总结

本文链接：https://blog.csdn.net/zhs954838550/article/details/8253680

版权

每天小总结专栏收录该内容

52 篇文章 0 订阅

订阅专栏

4• 实现页面中输入学生id，单机按钮后使该学生的年龄加。（尝试使用三层—选作）

UI层

前台部分

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     请输入学生的Id:<asp:TextBox ID="txtid" runat="server"></asp:TextBox>
        <br />
        <asp:Button ID="Button1" runat="server" Xοnclick="Button1_Click" Text="该学生的年龄加1"
            Width="263px" />
    </div>
    </form>
</body>
</html>

后台部分

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ASP绑定控件.Bll;

namespace ASP绑定控件.UI
{
    public partial class ui1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

}

        protected void Button1_Click(object sender, EventArgs e)
        {
            int fid = Convert.ToInt32(txtid.Text.Trim());
            MyStudentsBll bll = new MyStudentsBll();
          bool b= bll.AgeAddById(fid);
          if (b == true)
          {
              Response.Write("修改成功！");
          }
          else
          {
              Response.Write("修改失败！");
          }
        }
    }
}

DAL层

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;

namespace ASP绑定控件.DAL
{
    /// <summary>
    ///
    /// </summary>
    public class MyStudentsDal
    {
        public int AgeAddById(int Fid)
        {

            string sql = "update MyStudents set FAge=FAge+1 whereFId=@id";
            SqlParameter pms = new SqlParameter("@id", Fid);
            return sqlHealpler.sqlHealper.ExecturNonQuery(sql, pms);
        }

}
}

Bll层

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ASP绑定控件.DAL;

namespace ASP绑定控件.Bll
{
    public class MyStudentsBll
    {
        public bool AgeAddById(int fid)
        {
            MyStudentsDal dal = new MyStudentsDal();
           int r= dal.AgeAddById(fid);
           if (r > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
        }
    }
}