java – 使用Spring的JDBC慢速元数据获取Oracle

public final Listsql = "SELECT columN_NAME,DATA_TYPE,data_length,"
            + " data_precision,DATA_SCALE,NULLABLE,DATA_DEFAULT"
            + " FROM all_TAB_columNS"
            + " WHERE owneR = ? ORDER BY COLUMN_ID";

    return jdbcTemplate.query(sql,new Object[] { owner },new RowMappersqlException {
                    final column reg = new column();

                    reg.setcolumnName(res.getString("columN_NAME"));
                    //Read other properties
                    reg.setNullable(res.getString("NULLABLE").equals("Y"));
                    return reg;
                }
            });
}

如果您需要按表格过滤,只需添加“AND TABLE_NAME =？”将sql和tablename作为另一个参数.

希望能帮助到你.