Java读取SQL文件中的创建表名

题目:读取一个sql文件里面的所有创建表名,记录下来

public static void main(String[] args) throws Exception {
    FileReader fileReader = new FileReader("E:/wen/zjs_szhgg_nw_tem.sql");
    BufferedReader reader = new BufferedReader(fileReader);
    int x = 0;
    String line = null;
    ArrayList strings = new ArrayList<>();
    while ((line = reader.readLine()) != null) {
        if (line.contains("CREATE TABLE")) {
            x++;
            //System.out.println(line);
            String[] s1 = line.split("`");
            for (int i = 0; i < s1.length; i++) {
                if (i == 1) {
                    //System.out.println(s1[1]);
                    strings.add(s1[1]);
                }
            }
        }
    }
    System.out.println(x);
    System.out.println(strings);
    reader.close();
}

执行结果

7
[ap_adapt_task, core_account, core_account_move_history, core_act_lock, core_actext, core_config, core_dasvc_log]