private void button1_Click(object sender, EventArgs e)
{
//string sql = "insert into jtest(a) values(2)";
//int id = MySqlDBUtil.ExecuteNonQuery(sql);
//System.Console.WriteLine(id);
// 数据库访问操作测试
//byte[] bytes = null;
// bytes = File.ReadAllBytes(@"C:\\Test\\1000.jpg");
MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection();
conn.ConnectionString = "server=localhost;user id=root;password=1234;database=mysql;pooling=false;charset=utf8";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
//cmd.CommandText = "insert into jtest(a,b) values(@a1,@b1)";
cmd.CommandType =
//cmd.Parameters.Add("@a1", MySql.Data.MySqlClient.MySqlDbType.Int32);
//cmd.Parameters.Add("@b1", MySql.Data.MySqlClient.MySqlDbType.Blob);
//cmd.Parameters[0].Value = 100;
//cmd.Parameters[1].Value = bytes;
cmd.Connection = conn;
conn.Open();
//int affectedrows = cmd.ExecuteNonQuery();
//cmd.Dispose();//此处可以不用调用,
//conn.Close();// 离开 using 块, connection 会自行关闭
MessageBox.Show("hey");
cmd.CommandText = "select a,b from jtest where a = 100";
System.Data.Common.DbDataReader reader = cmd.ExecuteReader();
byte[] buffer = null;
if (reader.HasRows)
{
reader.Read();
long len = reader.GetBytes(1, 0, null, 0, 0);//1是picture
buffer = new byte[len];
len = reader.GetBytes(1, 0, buffer, 0, (int)len);
System.IO.MemoryStream ms = new System.IO.MemoryStream(buffer);
System.Drawing.Image image = System.Drawing.Image.FromStream(ms);
pictureBox1.Image = image;
image.Save(@"C:\Test\jingqi.jpg");
}
cmd.Dispose();
conn.Close();
}
c# mysql blob(2) 实现突破存储与保存
最新推荐文章于 2024-08-20 13:33:55 发布