Blazor使用MySql数据库

最新推荐文章于 2025-01-10 10:37:51 发布

太空漫步11

最新推荐文章于 2025-01-10 10:37:51 发布

阅读量483

点赞数 10

文章标签：数据库 mysql C# .net core

本文链接：https://blog.csdn.net/zhourongxiang1/article/details/136935619

版权

本文介绍了如何在Blazor应用中使用RazorPages添加导航菜单，通过MyUser.razor页面展示用户列表，以及通过UserService与MySql数据库进行交互，实现CRUD操作。重点涉及了依赖注入和EntityFrameworkCore的使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我是从页面开始写的。
Components/Layout/NavMenu.razor中添加菜单：

 <div class="nav-item px-3">
    <NavLink class="nav-link" href="User">
        <span class="oi oi-list-rich" aria-hidden="true"></span> User
    </NavLink>
</div>

Pages文件夹中添加MyUser.razor:

@page "/User"
@using BlazorApp.Service
@using BlazorApp.Entity
@inject UserService myUserService

<h3>User</h3>
<table class="table">
    <tr>
        <td>id</td>
        <td>username</td>
        <td>email</td>
        <td>password</td>
        <td>phone_num</td>
    </tr>
    @foreach (var useritem in userlist)
    {
          <tr>
            <td>@useritem.Id</td>
            <td>@useritem.Username</td>
            <td>@useritem.Email</td>
            <td>@useritem.Password</td>
            <td>@useritem.PhoneNum</td>
        </tr>  
    }
    
</table>
@code {
    private MyUser[]? userlist;

    protected override async Task OnInitializedAsync()
    {
        userlist = await myUserService.getUserList();
    }
}

“@inject UserService myUserService” 注入UserService实例，该实例是在Program.cs中声明的。

在Program.cs中“var builder = WebApplication.CreateBuilder(args)”下面添加UserService实例：

builder.Services.AddSingleton<UserService>();

新建Service文件夹，其中添加UserService.cs:

using BlazorApp.Entity;
using BlazorApp.Models;
using MySqlConnector;
using System.Data;

namespace BlazorApp.Service
{
    public class UserService
    {
        public MySqlConnection connection;
        public UserService() {
            connection = new MySqlConnection("server=localhost;user id=root;password=234sbn;port=3306;database=test;");
        }
        public async Task<MyUser[]> getUserList()
        {
            if(connection.State != ConnectionState.Open)
            {
                connection.Open();

            }

            List<MyUser> list = new List<MyUser>();
            using (MySqlCommand cmd = new MySqlCommand("select * from sys_user", connection))
            {
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        list.Add(new MyUser()
                        {
                            Id = reader.GetInt32("id"),
                            Username = reader.GetString("username"),
                            Email = reader.GetString("email"),
                            Password = reader.GetString("password"),
                            PhoneNum = reader.GetString("phone_num"),
                        });
                    }
                }
            }
            connection.Close();

            return list.ToArray();
        }
    }
}

新建Entity文件夹，其中添加MyUser.cs:

namespace BlazorApp.Entity
{
    public class MyUser
    {
        public int Id { get; set; }
        public string Username { get; set; }
        public string Email { get; set; }

        public string Password { get; set; }
        public string PhoneNum { get; set; }
    }
}