java 正则表达式提取字符串

参考文档：baijiahao.baidu.com/s?id=159862…
如果需要提取的字符串没有好的规则，则直接用点.;其他部分剩下的就是自己需要提取的

Pattern p=Pattern.compile("(INSERT INTO PUBLIC\\.WS_TRIGGER_SWITCH VALUES \\(')(.+)(', '.+','1'\\);)");
Matcher m=p.matcher(line);
while(m.find()) {
    String trigger=m.group(2); //全局是0，第一个括号是1，第二个是2，以此类推
}


	/**
	 * 提取字符串
	 * @throws Exception
	 */
	@Test
	public void test3() throws Exception {
		
		String path="D:\\workspace-pasp\\ws_pwsdb-1.8.0\\db\\ws_monitor\\1.8.0\\inc\\dml\\PASP-WS#1143_02_pwsdata_dml_triggerInsert_EX-HEDONG002.sql";
		
		String sql="SELECT COUNT(1) NUM FROM ws_trigger_switch WHERE switch_for='%s'";
		
		Pattern p=Pattern.compile("(INSERT INTO PUBLIC\\.WS_TRIGGER_SWITCH VALUES \\(')(.+)(', '.+','1'\\);)");
		
		BufferedReader br=new BufferedReader(new FileReader(new File(path)));
		String line;
		
		while((line=br.readLine())!=null){
			
			if(StringUtils.isNotEmpty(line)) {
				line=line.toUpperCase();
				Matcher m=p.matcher(line);
				while(m.find()) {
					String trigger=m.group(2);
					System.out.println("UNION ALL");
					System.out.println(String.format(sql, trigger));
				}
				
			}
			
		}
		
		br.close();
	}
复制代码