java clob 读取,如何使用java获取clob数据并分配给变量

Hiiiiii

i am having a table in oracle. in that table one of the column is to store clob data. and in that clob column, the data is inserted like the following using separators

kanthi~is a good girl~she is very pretty~,^mamy~is a good girl~

wat i need is , i need to get them separately

like name=kanthi

description=is a good girl

can anyone help me with the code

it is urgent

thanks in advance

解决方案

Hiiiiii

i am having a table in oracle. in that table one of the column is to store clob data. and in that clob column, the data is inserted like the following using separators

kanthi~is a good girl~she is very pretty~,^mamy~is a good girl~

wat i need is , i need to get them separately

like name=kanthi

description=is a good girl

can anyone help me with the code

it is urgent

thanks in advance

Split the String up using the split method.

Expand|Select|Wrap|Line Numbers

Thanks For The Reply.

But Wat I Was Asking Is

How To Get The Clob Data Using Java AND STORE IT IN A STRING VARIABLE AND THEN GET THE WORDS SEPARATED

Can U Help Me With The Code

Thanks For The Reply.

But Wat I Was Asking Is

How To Get The Clob Data Using Java AND STORE IT IN A STRING VARIABLE AND THEN GET THE WORDS SEPARATED

Can U Help Me With The Code

Did you try the getObject method of resultset and calling the toString method on the returned object?

Hiiiiii

我在oracle中有一张桌子。在该表中，其中一列是存储clob数据。并且在那个clob列中，数据插入如下使用分隔符

kanthi~是个好女孩〜她很漂亮〜，^ mamy~是个好女孩〜

就像名字= kanthi

描述=是一个好女孩

任何人都可以帮我提供代码

紧急

提前感谢

解决方案

Hiiiiii

i我有一张桌子在oracle。在该表中，其中一列是存储clob数据。并且在那个clob列中，数据插入如下使用分隔符

kanthi~是个好女孩〜她很漂亮〜，^ mamy~是个好女孩〜

就像名字= kanthi

描述=是一个好女孩

任何人都可以帮我提供代码

紧急

提前感谢

使用split方法拆分String。

展开 | 选择 | 换行 | 行号

< blockquot e>感谢您的回复。

但我要问的是什么？

如何使用Java获取Clob数据并将其存储在一个变量中，然后分开单词>

可以用代码帮助我

感谢您的回复。

但我要问的是什么？

如何使用Java获取Clob数据并将其存储在一个变量中，然后分开单词>

可以用代码帮助我

您是否尝试过resultset的getObject方法并在返回的对象上调用toString方法？