mysql插入图片_插入图片文件到MySql和MSSql数据库

usingMySql.Data.MySqlClient;usingSystem;usingSystem.Text;usingSystem.IO;public classPhoto

{public static void Main(string[]args)

{byte[]byts=null;

FileStream fs=null;string []files=Directory.GetFiles("./images","*.*",SearchOption.AllDirectories);string connstr="oldsyntax=true;Database=Photo;Data Source=127.0.0.1;User Id=root;Password=sa1234;pooling=false;CharSet=utf8;port=3306";

MySqlConnection connection=newMySqlConnection(connstr);

connection.Open();foreach(string file infiles)

{string ext=Path.GetExtension(file);string name=Path.GetFileNameWithoutExtension(file);

fs=newFileStream(file,FileMode.Open);int size=(int)fs.Length;

byts=new byte[size];

fs.Read(byts,0,size);string sql="select count(*) from photo where name='"+name+"'";

MySqlCommand command=newMySqlCommand(sql,connection);if(Convert.ToInt32(command.ExecuteScalar())==0)

{

sql="insert into Photo(photo,name,size,extension) values(@photo,@name,@size,@extension)";

command=newMySqlCommand(sql,connection);

command.Parameters.Add(new MySqlParameter("@photo",MySqlDbType.MediumBlob));

command.Parameters.Add(new MySqlParameter("@name",MySqlDbType.VarChar));

command.Parameters.Add(new MySqlParameter("@size",MySqlDbType.Int32));

command.Parameters.Add(new MySqlParameter("@extension",MySqlDbType.VarChar));

command.Parameters[0].Value=byts;

command.Parameters[1].Value=name;

command.Parameters[2].Value=size;

command.Parameters[3].Value=ext;int effect=command.ExecuteNonQuery();if(effect>0)

{

Console.WriteLine(file+"插入成功!");

}else{

Console.WriteLine(file+"插入失败!");

}

}

}

connection.Close();

fs.Close();

}

}