java将附件存入数据库_一个文档附件存入数据库的方法，很普通

阅读： 评论：0

商君书锥指

java将附件存⼊数据库_⼀个⽂档附件存⼊数据库的⽅法，很

普通

private string InsertFileToDB(DocAccessory docAccessory)

{

string tmpGuid = Guid.NewGuid().ToString();

string tmpSQL = "INSERT INTO ECMSDOCACCESSORY

(accessoryid,accessorydocid,accessoryfile,accessoryfilename,accessoryfilesize,accessorytype) ";

tmpSQL +=北美论坛小说文学区

"VALUES(@accessoryid,@accessorydocid,@accessoryfile,@accessoryfilename,@accessoryfilesize,@accessorytype)";

#region 插⼊数据 逻辑在此

ComplusGetAll cg = ComplusGetAll.CreateSingletonObject();;

ConnectionInfo ci = cg.GetConnectionManager().BaseConnection();太空浮尸

沧州日报System.Data.SqlClient.SqlConnection  dbConnection = new SqlConnection (ci.ConnectionString );

dbConnection.Open ();

SqlCommand CmdObj = new SqlCommand(tmpSQL,dbConnection);

CmdObj.Parameters.Add("@accessoryid",SqlDbType.VarChar ,128).Value =tmpGuid;

斜发沸石CmdObj.Parameters.Add("@accessoryfilename",SqlDbType.VarChar,128).Value =docAccessory.AccessoryFileName; CmdObj.Parameters.Add("@accessoryfile",SqlDbType.Binary  ,50).Value =docAccessory.AccessoryFile ;

CmdObj.Parameters.Add("@accessorydocid",SqlDbType.VarChar ,128).Value =docAccessory.AccessoryDocId;

CmdObj.Parameters.Add("@accessoryfilesize",SqlDbType.VarChar ,50).Value =docAccessory.AccessoryFileSize; CmdObj.Parameters.Add("@accessorytype",SqlDbType.VarChar ,50).Value =docAccessory.AccessoryType;

汉末三国

CmdObj.ExecuteNonQuery ();

本文发布于:2023-07-05 11:45:25，感谢您对本站的认可！

本文链接：https://patent.en369.cn/xueshu/173155.html

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系，我们将在24小时内删除。

上一篇：Process_Technology(苏尔寿塔内件介绍)

下一篇：可行性研究实验步骤

标签：论坛   附件   逻辑   浮尸   沧州   文学区