如何在C#中使用SQLite、MVVM进行授权

Install-Package SQLite
Install-Package MVVM-Light-Toolkit

using System;
using System.Data.SQLite;

public class DatabaseHelper
{
    private static string dbPath = "path_to_your_database.db";

    public static void InitializeDatabase()
    {
        using (SQLiteConnection conn = new SQLiteConnection($"Data Source={dbPath};Version=3;"))
        {
            conn.Open();
            string sql = @"
                CREATE TABLE IF NOT EXISTS Users (
                    Id INTEGER PRIMARY KEY AUTOINCREMENT,
                    Username TEXT NOT NULL,
                    PasswordHash TEXT NOT NULL
                );";
            SQLiteCommand cmd = new SQLiteCommand(sql, conn);
            cmd.ExecuteNonQuery();
        }
    }
}

public class User
{
    public int Id { get; set; }
    public string Username { get; set; }
    public string PasswordHash { get; set; }
}

using GalaSoft.MvvmLight;
using System.Collections.ObjectModel;

public class AuthViewModel : ViewModelBase
{
    private ObservableCollection<User> _users;
    public ObservableCollection<User> Users
    {
        get { return _users; }
        set { Set(ref _users, value); }
    }

    public AuthViewModel()
    {
        LoadUsers();
    }

    private void LoadUsers()
    {
        // 从数据库加载用户数据
        // 这里省略具体实现
    }

    public bool Authenticate(string username, string password)
    {
        // 实现用户认证逻辑
        // 这里省略具体实现
        return false;
    }
}

<Window x:Class="YourNamespace.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="Authorization" Height="200" Width="300">
    <StackPanel>
        <TextBox x:Name="UsernameTextBox" PlaceholderText="Username"/>
        <PasswordBox x:Name="PasswordBox" PlaceholderText="Password"/>
        <Button Content="Login" Click="LoginButton_Click"/>
        <TextBlock x:Name="ResultTextBlock"/>
    </StackPanel>
</Window>

using System.Windows;

namespace YourNamespace
{
    public partial class MainWindow : Window
    {
        private AuthViewModel _viewModel;

        public MainWindow()
        {
            InitializeComponent();
            _viewModel = new AuthViewModel();
            DataContext = _viewModel;
        }

        private void LoginButton_Click(object sender, RoutedEventArgs e)
        {
            bool isAuthenticated = _viewModel.Authenticate(
                UsernameTextBox.Text, PasswordBox.Password);
            ResultTextBlock.Text = isAuthenticated ? "Login successful!" : "Login failed!";
        }
    }
}