WPF 登陆界面与Mysql

版本和库：

• 目标框架：NET 8.0
• 需要的库：MySql.Data 9.0.0

演示：

Xaml：

<Window x:Class="Csharp_Mysql_Login.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:Csharp_Mysql_Login"
        mc:Ignorable="d"
        Title="Login" Height="400" Width="400">
    <Grid Width="400" Margin="0,0,0,1">
        <StackPanel Orientation="Vertical" Margin="100">
            <TextBlock Text="Username:"/>
            <TextBox x:Name="txtUsername" Margin="5"/>
            <TextBlock Text="Password:"/>
            <PasswordBox x:Name="txtPassword" Margin="5"/>
            <Button x:Name="btnLogin" Content="Login" Click="btnLogin_Click" Margin="5"/>
            <TextBlock x:Name="lblMessage" Foreground="Red"/>
        </StackPanel>
    </Grid>
</Window>

CS：

using MySql.Data.MySqlClient;
using System.Windows;

namespace Csharp_Mysql_Login
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void btnLogin_Click(object sender, RoutedEventArgs e)
        {
            string username = txtUsername.Text;
            string password = txtPassword.Password;

            try
            {
                string connectionString = "server=IP地址;userid=用户名;password=密码;database=数据库名";
                using (MySqlConnection connection = new MySqlConnection(connectionString))
                {
                    connection.Open();
                    string query = "SELECT * FROM users WHERE username = @username AND password = @password";
                    using (MySqlCommand command = new MySqlCommand(query, connection))
                    {
                        command.Parameters.AddWithValue("@username", username);
                        command.Parameters.AddWithValue("@password", password);
                        using (MySqlDataReader reader = command.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                // 登录成功
                                lblMessage.Text = "登录成功!";
                            }
                            else
                            {
                                // 登录失败
                                lblMessage.Text = "用户名或密码无效.";
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                lblMessage.Text = "Error: " + ex.Message;
            }
        }
    }
}

数据表：

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
) CHARACTER SET utf8mb4;

测试数据：

INSERT INTO users (username, password) VALUES ('admin', 'admin');

注意：

• C# 和数据表并没有写加密，而是明文数据；只要账号和密码正确就提示：“登录成功!”
• 代码要自己修改一下，才能实现加密