oracle获取字段实际长度,获取oracle数据字段信息(字段名，字段类型，字段长度，数字精度，是否为空)...

**** 获取oracle数据字段信息(字段名，字段类型，字段长度，数字精度，是否为空)* @param con* @param table  表名* @return*/public static Map> getOracleColumn_info(Connection con,String table){String sql="select COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE　from user_tab_columns where table_name =UPPER('"+table+"')";Statement st = null;Map> map = new LinkedHashMap>();try{st = con.createStatement();ResultSet rs = st.executeQuery(sql);List val = null;while(rs.next()){val = new ArrayList();String key = rs.getString("COLUMN_NAME");  //获取字段名val.add(rs.getString("DATA_TYPE"));  //获取数据类型val.add(rs.getString("DATA_LENGTH"));  //获取数据长度val.add(rs.getString("DATA_PRECISION"));  //获取数据长度val.add(rs.getString("DATA_SCALE"));  //获取数据精度val.add(rs.getString("NULLABLE"));  //获取是否为空map.put(key, val);}}catch (Exception e) {e.printStackTrace();// TODO: handle exception}return map;}/****  获取sql数据字段信息(字段名，字段类型，字段长度，数字精度，是否为空)* @param con* @param table* @return*/public static Map> getSQLColumn_info(Connection con,String table){String sql="SELECT syscolumns.name  COLUMN_NAME,systypes.name  DATA_TYPE,syscolumns.length ,syscolumns.prec, syscolumns.scale ,syscolumns.isnullable FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype  AND syscolumns.id = object_id('"+table+"')";Statement st = null;Map> map = new LinkedHashMap>();try{st = con.createStatement();ResultSet rs = st.executeQuery(sql);List val = null;while(rs.next()){val = new ArrayList();String key = rs.getString("COLUMN_NAME");  //获取字段名val.add(rs.getString("DATA_TYPE"));  //获取数据类型val.add(rs.getString("length"));  //获取数据长度val.add(rs.getString("prec"));  //获取数据长度val.add(rs.getString("scale"));  //获取数据精度val.add(rs.getString("isnullable"));  //获取是否为空map.put(key, val);}}catch (Exception e) {e.printStackTrace();// TODO: handle exception}return map;}