jdbc 得到表的所有列名和类型
public String getAllFields(String tablename){
Connection conn=null;
Statement st=null;
ResultSet rs=null;
ResultSetMetaData rsm=null;

String userName="****";
String passwd=""****";
String url="jdbc:oracle:thin:@192.168.1.200:1521:****";
String driver="cracle.jdbc.driver.Orcale";

try{
  Class.forName(driver);
  conn=DriverManager.getConnection(url,userName,passwd);
  stmt=conn.createStatement();
  String sql="select * from mytable"; 
  rs=stmt.executeQuery(sql);
  rsm=rs.getMetaData();
  int num=rsm.getColumnCount();
  for(int i=1;i<=num;i++){
    String columnName=rsmd.getColumnName(i);
    int precision=rsmd.getPrecision(i);
    String type=rsmd.getColumnTypeName(i);
    System.out.println ("name:"+columnName+"precision:"+precision+"type"+type);
}catch(Excepiton e){
  e.printStackTrace();
}

}