如何使用java获取clob数据并分配给变量 [英] How do i get clob data using java and assign to a variable

查看:346
本文介绍了如何使用java获取clob数据并分配给变量的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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方法?


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?


这篇关于如何使用java获取clob数据并分配给变量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆