前端
@{
Layout = null;
}
@model List<DomeCore.Models.Student>
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
<script src="~/js/jquery-3.4.1.js"></script>
</head>
<body>
<script>
Stu_show();
//数据显示
function Stu_show() {
$.ajax({
url: "/Home/Stu_Show",
type: "post",
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
show(data);
},
error: function (data) {
alert("Error!");
}
})
}
//查询
function Stu_Sel() {
var name = $("#Student_Name1").val();
if (name == "全部") {
Stu_show();
$("#Student_Name1").val("");
}
else {
$.ajax({
url: "/Home/Stu_Sel",
type: "get",
data: { "Name": name },
dataType: "json",
contentType: "application/json; charset=utf-8",
success: function (data) {
show(data);
$("#Student_Name1").val("");
},
error: function (data) {
alert("Error!");
}
})
}
}
//删除
function Stu_Del(id) {
$.ajax({
url: "/Home/Stu_Del",
type: "Delete",
data: { "ID": id },
success: function (data) {
Stu_show();
},
error: function (data) {
alert("Error!");
}
})
}
//添加和修改
function Stu_add() {
var id = $("#Stu_ID").html();
var name = $("#Student_Name").val();
console.log(name);
console.log(id);
if (id != "") {//修改
$.ajax({
url: "/Home/Stu_Update",
type: "Patch",
data: { "ID": id, "Name": name },
success: function (data) {
Stu_show();
$("#Student_Name").val("");
$("#Stu_ID").html("");
},
error: function (data) {
alert("Error1!");
}
})
}
else {//添加
$.ajax({
url: "/Home/Stu_Add",
type: "post",
data: { "Name": $("#Student_Name").val() },
success: function (data) {
Stu_show();
$("#Stu_ID").html("");
$("#Student_Name").val("");
},
error: function (data) {
alert("Error2!");
}
})
}
}
//显示修改数据
function ClickUpdate(id) {
$.ajax({
url: "/Home/Stu_Sel_By_ID",
type: "get",
data: { "ID":id },
success: function (data) {
$("#Stu_ID").html(data.id);
$("#Student_Name").val(data.name);
},
error: function (data) {
alert("Error!");
}
})
}
//修改数据
function show(data) {
$("#Stu_info_show").empty();
$.each(data, function (key, item) {
$("#Stu_info_show").append('<p>' + item.id + ' ' + item.name + ' <input type="button" onclick="Stu_Del(' + item.id + ')" value="删除"/> <input type="button" onclick="ClickUpdate(' + item.id + ')" value="修改"/></p>');
})
}
</script>
<div>
<h3>显示数据</h3>
<div id="Stu_info_show">
</div>
</div>
<br />
<br />
<div>
<h3 id="Stu_title">添加</h3>
<span id="Stu_ID"></span><br />
<input id="Student_Name" name="Name" type="text" /> <input type="button" onclick="Stu_add()" value="确定" />
</div>
<br />
<br />
<div>
<h3>查询</h3>
<input id="Student_Name1" name="Name" type="text" /> <input type="button" onclick="Stu_Sel()" value="查询" />
</div>
</body>
</html>
后
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using DomeCore.Models;
namespace DomeCore.Controllers
{
public class HomeController : Controller
{
private readonly IStudentRepository _studentrepository;
public HomeController(IStudentRepository studentrepository)
{
_studentrepository = studentrepository;
}
public IActionResult Index()
{
return View();
}
//添加
[HttpPost]
public string Stu_Add(string Name)
{
Student stu = new Student() { Name=Name};
_studentrepository.Add(stu);
return "1";
}
//显示数据
[HttpPost]
public JsonResult Stu_Show()
{
return Json(_studentrepository.Stu_show());
}
//查询信息
[HttpGet]
public JsonResult Stu_Sel(string Name)
{
return Json(_studentrepository.Stu_Sel(Name));
}
//删除
[HttpDelete]
public string Stu_Del(int ID)
{
if (_studentrepository.Delete(ID)!=null)
{
return "1";
}
return "2";
}
//修改
[HttpPatch]
public string Stu_Update(string ID,string Name)
{
Student stu = new Student() {ID=int.Parse(ID),Name=Name };
Student s = _studentrepository.SelbyID(stu.ID);
if (s != null)
{
_studentrepository.Update(stu);
return "1";
}
else
{
return "2";
}
}
//查询
[HttpGet]
public Student Stu_Sel_By_ID(int ID)
{
return _studentrepository.SelbyID(ID);
}
}
}
IStudentRepository接口（作用：操作方法）
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace DomeCore.Models
{
public interface IStudentRepository
{
List<Student> Stu_show();
List<Student> Stu_Sel(string name);
Student Add(Student students);
Student Update(Student updateStudent);
Student Delete(int id);
Student SelbyID(int id);
}
}
SQLStudentRepository类（作用：实现IStudentRepository接口方法）
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace DomeCore.Models
{
//使用EFcore来访问数据库，对数据进行相关的操作
public class SQLStudentRepository : IStudentRepository
{
//依赖注入
private readonly AppDbContext _context;
public SQLStudentRepository(AppDbContext context)
{
_context = context;
}
//显示全部数据
public List<Student> Stu_show() {
return _context.Students.ToList();
}
//显示根据名称模糊查询数据
public List<Student> Stu_Sel(string name)
{
return _context.Students.Where(x=>x.Name.Contains(name)).ToList();
}
//添加
public Student Add(Student students)
{
_context.Students.Add(students);//这个add为系统封装好了的方法，详情可以右键转定义
_context.SaveChanges();
return students;
}
//删除
public Student Delete(int id)
{
Student s = _context.Students.FirstOrDefault(x=>x.ID==id);
if (s!=null)
{
_context.Students.Remove(s);//remove为core自带的
_context.SaveChanges();
}
return s;
}
//修改
public Student Update(Student updateStudent)
{
Student s = _context.Students.FirstOrDefault(x=>x.ID==updateStudent.ID);
s.Name = updateStudent.Name;
_context.SaveChanges();
return updateStudent;
}
//按id查询
public Student SelbyID(int id)
{
return _context.Students.FirstOrDefault(x=>x.ID==id);
}
}
}
AppDbContext（EFcore，代码先行）
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace DomeCore.Models
{
public class AppDbContext:DbContext
{
//构造函数
public AppDbContext(DbContextOptions<AppDbContext> options):base(options)
{
}
//添加种子数据
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
//默认数据
modelBuilder.Entity<Student>().HasData(
new Student {ID=1, Name="小向" },
new Student { ID=2,Name="小红"}
);
}
public DbSet<Student> Students { get; set; }
}
}
services.AddScoped<IStudentRepository,SQLStudentRepository>();//依赖注入声明