select column_name,data_type from all_tab_column where table_name= your_table_name
//获得元数据,进而获得列名 rsmd=rs.getMetaData(); int ij = rsmd.getColumeCount(); for (int i=0;i<rsmd.getColumnCount();i++) System.out.println(rsmd.getColumnName(i)); //获得数据 rs = stmt.executeQuery(sql);//select * from user for(int i = 0; i < ij; i++) XXX xxx = rs.getXXX(i);//XXX 为类型(int,String,etc)
[javac] symbol : variable rsmd [javac] location: class org.apache.jsp.sql_jsp [javac] rsmd=sqlRst.getMetaData(); [javac] ^好象是rsmd的问题。未定义还是什么呢?
[javac] symbol : variable rsmd [javac] location: class org.apache.jsp.sql_jsp [javac] rsmd=sqlRst.getMetaData(); [javac] ^好象是rsmd的问题。未定义还是什么呢?
rsmd=rs.getMetaData();
int ij = rsmd.getColumeCount();
for (int i=0;i<rsmd.getColumnCount();i++)
System.out.println(rsmd.getColumnName(i));
//获得数据
rs = stmt.executeQuery(sql);//select * from user
for(int i = 0; i < ij; i++)
XXX xxx = rs.getXXX(i);//XXX 为类型(int,String,etc)
[javac] location: class org.apache.jsp.sql_jsp
[javac] rsmd=sqlRst.getMetaData();
[javac] ^好象是rsmd的问题。未定义还是什么呢?
[javac] location: class org.apache.jsp.sql_jsp
[javac] rsmd=sqlRst.getMetaData();
[javac] ^好象是rsmd的问题。未定义还是什么呢?