相忘于江湖

不抛弃,不放弃... 请给我勇敢,改变可以改变的;请给我坚强,接受不可以改变的;请给我智慧,分辨这两者。

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
public static void WriteClob(string table_name, string fieldname ,string table_id, string id, int column, string content)
{
OracleConnection myCn = OracleModel.GetConnection(DbKey.ORA);
OracleCommand myCmd = new OracleCommand();
try
{
myCn.Open();
}
catch (System.Data.OracleClient.OracleException e)
{
throw new Exception(e.Message);
}
OracleTransaction myTrans = myCn.BeginTransaction();
try
{
myCmd.Connection = myCn;
myCmd.Transaction = myTrans;
myCmd.CommandText = "SELECT "+fieldname+" FROM " + table_name + " where " + table_id + " = '" + id + "' FOR UPDATE";
OracleDataReader reader = myCmd.ExecuteReader();
using (reader)
{
reader.Read();
OracleLob CLOB = reader.GetOracleLob(column); //column为lob类型所在列
Encoding utf16 = Encoding.Unicode;       
byte[] buffer = utf16.GetBytes(content);
if (buffer.Length % 2 == 0)
CLOB.Write(buffer, 0, buffer.Length);  //这里的参数必须为偶数
else
CLOB.Write(buffer, 0, (buffer.Length - 1));
myTrans.Commit();
}
}
catch (System.Data.OracleClient.OracleException e)
{
myTrans.Rollback();
}
finally
{
myCmd.Dispose();
myCn.Close();
}
}
public static string ReadClob(string table_name, string fieldname,string table_id, string id, int column)
{
OracleConnection myCn = OracleModel.GetConnection(DbKey.ORA);
OracleCommand myCmd = new OracleCommand();
try
{
myCn.Open();
}
catch (System.Data.OracleClient.OracleException e)
{
throw new Exception(e.Message);
}
OracleTransaction myTrans = myCn.BeginTransaction();
try
{
myCmd.Connection = myCn;
myCmd.Transaction = myTrans;
myCmd.CommandText = "SELECT "+fieldname+" FROM " + table_name + " where " + table_id + " = '" + id + "'";
OracleDataReader reader = myCmd.ExecuteReader();
using (reader)
{
reader.Read();
OracleLob CLOB = reader.GetOracleLob(column);

byte[] buffer = new byte[(int)CLOB.Length];
CLOB.Read(buffer,0,(int)CLOB.Length);

Encoding utf16 = Encoding.Unicode;
string final = utf16.GetString(buffer);
myTrans.Commit();
return final;
}
}
catch (System.Data.OracleClient.OracleException e)
{
myTrans.Rollback();
return "";
}
finally
{
myCmd.Dispose();
myCn.Close();
}
}
posted on 2010-07-16 15:27  playman0211  阅读(283)  评论(0编辑  收藏  举报