1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| public static List<String> getListTables(final String url,
final String user, final String pass) {
List<String> list = new ArrayList<String>();
try {
Connection connection = getConnexion(url, user, pass);
if (connection != null) {
connection = DriverManager.getConnection(url, user, pass);
DatabaseMetaData metaData = connection.getMetaData();
ResultSet resultSetTable = metaData.getTables(null, null, null, new String[]{"TABLE"});
while (resultSetTable.next()) {
final String tableName = resultSetTable.getString("TABLE_NAME");
list.add(tableName);
LOGGER.log(Level.INFO, "NOM DE LA TABLE" + tableName);
}
LOGGER.log(Level.INFO, "Nombre des tabes retrouvées" + list.size());
}
} catch (SQLException ex) {
LOGGER.log(Level.ERROR, ex);
}
return list;
} |
Partager