C#利用MySQL的BLOB存储和读取文件和对象

BLOB类型

在MySQL中，BLOB类型的字段用于存储二进制数据

BLOB类型分为四类（单位：字节)

• TinyBlob 最大 255
• Blob 最大 65K
• MediumBlob 最大 16M
• LongBlob 最大 4G

WPF实现

在WPF的窗口新建四个按钮，功能如图所示：

存文件到数据库

private void Button_Click(object sender, RoutedEventArgs e)
        {       
            MySqlConnection conn;
            MySqlCommand cmd;

            conn = new MySqlConnection();
            cmd = new MySqlCommand();

            string SQL;
            long FileSize;
            byte[] rawData;
            FileStream fs;

            conn.ConnectionString = "SERVER=120.95.132.137;DATABASE=cad_project;UID=root;PASSWORD=;charset=utf8;";

            try
            {
                fs = new FileStream(@"f:\test1.txt", FileMode.Open, FileAccess.Read);
                FileSize = fs.Length;

                rawData = new byte[FileSize];
                fs.Read(rawData, 0, (int)FileSize);
                fs.Close();

                conn.Open();

                SQL = "INSERT INTO serialization VALUES(NULL, @FileName, @FileSize, @File)";

                cmd.Connection = conn;
                cmd.CommandText = SQL;
                cmd.Parameters.AddWithValue("@FileName", "test1");
                cmd.Parameters.AddWithValue("@FileSize", FileSize);
                cmd.Parameters.AddWithValue("@File", rawData);

                cmd.ExecuteNonQuery();

                MessageBox.Show("File Inserted into database successfully!",
                    "Succ