将图像存储在文件夹中，并使用Mysql数据库在c#应用程序中检索图像

string folderPath = @"C:\Images";
Directory.CreateDirectory(folderPath);

string sourceImagePath = @"C:\path\to\image.jpg";
string targetImagePath = Path.Combine(folderPath, "image.jpg");
File.Copy(sourceImagePath, targetImagePath);

CREATE TABLE Images (
    id INT PRIMARY KEY AUTO_INCREMENT,
    filename VARCHAR(255) NOT NULL,
    filepath VARCHAR(255) NOT NULL
);

string filename = "image.jpg";
string filepath = targetImagePath;

string connectionString = "server=localhost;database=your_database;uid=your_username;password=your_password";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();

    string insertQuery = "INSERT INTO Images (filename, filepath) VALUES (@filename, @filepath)";
    using (MySqlCommand command = new MySqlCommand(insertQuery, connection))
    {
        command.Parameters.AddWithValue("@filename", filename);
        command.Parameters.AddWithValue("@filepath", filepath);
        command.ExecuteNonQuery();
    }
}

string filenameToRetrieve = "image.jpg";

using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();

    string selectQuery = "SELECT filepath FROM Images WHERE filename = @filename";
    using (MySqlCommand command = new MySqlCommand(selectQuery, connection))
    {
        command.Parameters.AddWithValue("@filename", filenameToRetrieve);
        using (MySqlDataReader reader = command.ExecuteReader())
        {
            if (reader.Read())
            {
                string retrievedFilePath = reader.GetString("filepath");
                // 在这里可以使用retrievedFilePath来加载图像或进行其他操作
            }
        }
    }
}