正则表达式

实时测试网址： https://www.sojson.com/regex/

匹配建表语句

CREATE TABLE [\s\S][^;]*;

单行结尾任意

字符.*

java验证是否是数字（true是数字、false不是数字）

	public static boolean isNumericzidai(String str){  
	    Pattern pattern = Pattern.compile("[0-9]*");  
	    return pattern.matcher(str).matches();     
	} 

参考：https://www.iteye.com/blog/javapub-666544

测试用例

	public static void main(String[] args) {
		double aa = -19162431.1254;
		String a = "-19162431.1254";
		String b = "191624311m254";
		String c = "中文";
		String e = "12312312";
		System.out.println(isNumericzidai(Double.toString(aa)));
		System.out.println(isNumericzidai(a));
		System.out.println(isNumericzidai(b));
		System.out.println(isNumericzidai(c));
		System.out.println(isNumericzidai(e));
	}
	
	public static boolean isNumericzidai(String str){  
	    Pattern pattern = Pattern.compile("[0-9]*");  
	    return pattern.matcher(str).matches();     
	}