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