.Net Core使用ADO.NET实现增删改查

最新推荐文章于 2023-06-28 20:08:46 发布

_徐林

最新推荐文章于 2023-06-28 20:08:46 发布

阅读量6.6k

点赞数 1

分类专栏： .Net Core

本文链接：https://blog.csdn.net/TestDatas/article/details/103201445

版权

.Net Core是微软的跨平台框架，它重构了Clr并能运行于多种操作系统。本文将介绍如何使用ADO.NET在.Net Core中进行基本的增删改查操作，包括控制器、视图、自定义文件、配置类和SQLHelper帮助类的使用。

摘要由CSDN通过智能技术生成

.net core 简单介绍:
.net core 是微软公司推出的一个跨平台框架他重写了Clr底层屏蔽window 的依赖，可以运行window ,linux ，max等系统效率比.net framework 要高出很多。
简单说明下.net core 的目录在这里插入图片描述
下面是我学习的时候写的增删改查
先预览下界面

1.控制器

using HomeMediaFileManageSystemUtilts.Sql;
using Microsoft.AspNetCore.Mvc;
using System.Data.SqlClient;

namespace NetCore.Controllers
{
   
    public class HomeController : Controller
    {
   



        
        public IActionResult Index()
        {
   

            return View();
        }


        /// <summary>
        /// 查询
        /// </summary>
        /// <returns></returns>
        public IActionResult GetUser()
        {
   
            //切换数据的语句
            //SqlHelper.SetConStr();
            var sql = @"SELECT* FROM(
                SELECT RID = ROW_NUMBER()  OVER(ORDER BY ID),*FROM STUDENT
                ) A
                WHERE A.RID BETWEEN   1  AND  20 AND A.STATUS=1";
            var ds = SqlHelper.ExecuteDataSetText(sql, null);
            return Json(ds);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public string  DelUserById(int id) {
   
            var msg = default(string);
            var sql = "UPDATE  STUDENT  SET STATUS=0 WHERE  Id=@Id";
            SqlParameter[] parameters = new SqlParameter[] {
   
               new SqlParameter("@Id",id)
            };
           var  len=SqlHelper.ExecteNonQueryText(sql, parameters);
            if (len > 0)
            {
   
                msg = "删除成功";
            }
            else {
   
                msg = "删除失败";
            }
            return msg;
        }
        /// <summary>
        /// 根据Id查找
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public IActionResult GetUserById(int  id) {
   
            var sql = " SELECT  * FROM  STUDENT  WHERE  Id=@Id";
            SqlParameter[] parameters = new SqlParameter[] {
   
               new SqlParameter("@Id",id)
            };

           var ds= SqlHelper.ExecuteDataSetText(sql, parameters);
           return Json(ds);
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public string UpdateUserById(int id,string name,string school,int age) {
   
            string msg = string.Empty;
            var sql = "UPDATE   STUDENT  SET  Age=@age,Name=@Name,School=@School  WHERE ID=@ID";
            SqlParameter[] parameters = new SqlParameter[] {
   
               new SqlParameter("@Id",id),
                new SqlParameter("@Age",age),
                 new SqlParameter("@Name",name),
                  new SqlParameter("@School",school),
            };
            var len = SqlHelper.ExecteNonQueryText(sql, parameters);
            if (len > 0)
            {
   
                msg = "修改成功";
            }
            else
            {
   
                msg = "修改失败";
            }
            return msg;
        }

    }
}

2.视图


@{
   
    ViewData["Title"] = "Index";
}
<script src="~/lib/jquery/dist/jquery.js"></script>
<script src="~/js/Home.js"></script>
<style>
    #table {
   
        display: none;
    }

    td {
   
        height: 40px;
        text-align: center;
    }

    tr:hover {
   
        background-color: lightseagreen;
    }

    #mask-kk {
   
        position: absolute;
        top: 0;
        left: 0;
        width: 100%;
        height: 100%;
        z-index: 999;
        background: #666;
        opacity: 0.5;
        filter: alpha(opacity=50)-moz-opacity: 0.5;
        display: none;
    }

    .popup-kk {
   
        position: absolute;
        left: 50%;
        width: 400px;
        height: 300px;
        background: #fff;
        z-index: 1000;
        display: none;
        border-radius: 5px;
    }

    .layoutDiv {
   
        margin-top:20px;
    }
  
    .close {
   
        position: absolute;
        top: 21px;
        right: 20px;
        cursor: pointer;
    }

    
</style>
<center>
    <h2>.NET Core  增删改查</h2>
    <table border="1" cellpadding="0" cellspacing="0" style="width:1200px" id="table">
        <tr>
            <th>用户编号</th>
            <th>用户名</th>
            <th>年龄</th>
            <th>性别</th>
            <th>爱好<