Web开发技术----采用ORM对数据库进行查询

本文链接：https://blog.csdn.net/weixin_62115318/article/details/139663590

设计一个基于Web的应用程序，采用ORM（主要就是Ling或EF的方式）对custom，department表中的记录进行：插入、修改、删除、查询的操作。

一个数据库中，有两个数据表。其中custom，department表如下结构。

Custom与department的关系如下图所示。

代码实现如下:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Ex.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>采用ORM实现CRUD方法</title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <span lang="EN-US" style="font-size:15.0pt;font-family:
&quot;Times New Roman&quot;,serif;mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">采用ORM实现CRUD方法<br />
            <span lang="EN-US" style="font-size:15.0pt;font-family:
&quot;Times New Roman&quot;,serif;mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">Custom表</span></span><br />
            <asp:Label ID="Label1" runat="server" Text="用户ID："></asp:Label>
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label2" runat="server" Text="用户名："></asp:Label>
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label3" runat="server" Text="部门ID："></asp:Label>
            <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label4" runat="server" Text="年龄：&nbsp;&nbsp;&nbsp;"></asp:Label>
            <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label5" runat="server" Text="英文名："></asp:Label>
            <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label6" runat="server" Text="密码：&nbsp;&nbsp;&nbsp;"></asp:Label>
            <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
            <br />
            <br />
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="插入数据" />
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="修改数据" />
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="删除数据" />
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text="查询数据" />
            <br />
            <br />
            <br />
            <br />
        </div>
        <div>
            <span lang="EN-US" style="font-size:15.0pt;font-family:
&quot;Times New Roman&quot;,serif;mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">department表</span><br />
            <asp:Label ID="Label7" runat="server" Text="部门ID：&nbsp;&nbsp;&nbsp;"></asp:Label>
            <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label8" runat="server" Text="部门名：&nbsp;&nbsp;&nbsp;"></asp:Label>
            <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
            <br />
            <asp:Label ID="Label9" runat="server" Text="部门描述："></asp:Label>
            <asp:TextBox ID="TextBox9" runat="server"></asp:TextBox>
            <br />
            <br />
            <asp:Button ID="Button5" runat="server" OnClick="Button5_Click" Text="插入数据" />
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button6" runat="server" OnClick="Button6_Click" Text="修改数据" />
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button7" runat="server" OnClick="Button7_Click" Text="删除数据" />
            &nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button8" runat="server" OnClick="Button8_Click" Text="查询数据" />
        </div>
    </form>
</body>
</html>

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

namespace Ex
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            // 页面加载时的初始化代码
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            var item = new custom() {
                id = Convert.ToInt32(TextBox1.Text),
                cname = TextBox2.Text,
                departID = Convert.ToInt32(TextBox3.Text),
                age = Convert.ToInt32(TextBox4.Text),
                ename = TextBox5.Text,
                password = TextBox6.Text
            };
            Db.custom.Add(item);
            Db.SaveChanges();
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            int id = int.Parse(TextBox1.Text);
            var item = Db.custom.FirstOrDefault(i => i.id == id);
            if (item != null) {
                item.cname = TextBox2.Text;
                item.departID = int.Parse(TextBox3.Text);
                item.age = int.Parse(TextBox4.Text);
                item.ename = TextBox5.Text;
                item.password = TextBox6.Text;
                Db.SaveChanges();
            }
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            int id = int.Parse(TextBox1.Text);
            var item = Db.custom.FirstOrDefault(i => i.id == id);
            if (item != null) {
                Db.custom.Remove(item);
                Db.SaveChanges();
            }
        }

        protected void Button4_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            int id = int.Parse(TextBox1.Text);
            var item = Db.custom.FirstOrDefault(i => i.id == id);
            if (item != null) {
                TextBox2.Text = item.cname;
                TextBox3.Text = item.departID.ToString();
                TextBox4.Text = item.age.ToString();
                TextBox5.Text = item.ename;
                TextBox6.Text = item.password;
            }
        }

        protected void Button5_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            var item = new department()
            {
                id = Convert.ToInt32(TextBox7.Text),
                departname = TextBox8.Text,
                description = TextBox9.Text

            };
            Db.department.Add(item);
            Db.SaveChanges();
        }

        protected void Button6_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            int id = int.Parse(TextBox7.Text);
            var item = Db.department.FirstOrDefault(i => i.id == id);
            if (item != null)
            {
                item.departname = TextBox8.Text;
                item.description = TextBox9.Text;
                Db.SaveChanges();
            }
        }

        protected void Button7_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            int id = int.Parse(TextBox7.Text);
            var item = Db.department.FirstOrDefault(i => i.id == id);
            if (item != null)
            {
                Db.department.Remove(item);
                Db.SaveChanges();
            }
        }

        protected void Button8_Click(object sender, EventArgs e)
        {
            var Db = new MoviesEntities1();
            int id = int.Parse(TextBox7.Text);
            var item = Db.department.FirstOrDefault(i => i.id == id);
            if (item != null)
            {
                TextBox8.Text = item.departname;
                TextBox9.Text = item.description;
            }
        }
    }
}