编辑代码

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Set;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

class Main {
	public static void main(String[] args) {
        //JSRUN引擎2.0，支持多达30种语言在线运行，全仿真在线交互输入输出。
		Pattern pattern = Pattern.compile(".*?[\\s]+in[\\s]*\\(([^\\(\\)]+)\\).*?", Pattern.MULTILINE);
        Matcher matcher = pattern.matcher("select * from das_config where isenable=1 and confkey=prefix and comment=env and id in (fs,sdf,asdfas,fasdf)");
        List<String> paramListAll = new ArrayList<String>();
        Boolean isDigits = true;
        System.out.println("test");
        while (matcher.find()) {
            String param = matcher.group(1);
            System.out.println(param);
            // if (param.contains("select")) {
            //     continue;
            // }

            // List<String> paramList = Arrays.asList(param.split(","));
            // paramListAll.addAll(paramList);
            // StringBuilder builder = new StringBuilder("");
            // for (String iterm : paramList) {
            //     builder.append("?").append(",");
            //     if (!NumberUtils.isDigits(iterm)) {
            //         isDigits = false;
            //     }
            // }
            // String paramPure = builder.toString().substring(0, builder.length() - 1);
            // if (paramList != null && paramList.size() > 0) {
            //     script = script.replaceFirst(param.replace(".", "\\.")
            //             .replace("*", "\\*").replace("?", "\\?")
            //             .replace("+", "\\+"), paramPure);
            // }
        }
	}
}