获取spring SimpleJdbcTemplate中所有表名的列表

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;

import javax.sql.DataSource;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

public class TableNameList {

    public static void main(String[] args) {
        DataSource dataSource = // 获取数据源
        SimpleJdbcTemplate simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);

        List<String> tableNames = simpleJdbcTemplate.query("SHOW TABLES", new RowMapper<String>() {
            @Override
            public String mapRow(ResultSet rs, int rowNum) throws SQLException {
                return rs.getString(1);
            }
        });

        for (String tableName : tableNames) {
            System.out.println(tableName);
        }
    }
}