java中如何获取oracle中字段的类型以及长度。(50分)

X

xuyingfeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-29

• #1

例如oracle中的表table tab1(value1 char(1),value2 number (3,3),value3 date)
怎样以字符串的形式返回到java中，就好像
String st1=new string("char(1)");
String st1=new string("number(3,3)");

 

Y

yyanghhong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-01

• #2

wirte some code to select the sys.dba_tab_columns, get the table structure you want

 

E

Edgarlo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-02

• #3

ResultSetMetaData rsmd = rs.getMetaData();

 

X

xuyingfeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-07

• #4

多人接受答案了。