Java tutorial
//package com.java2s; import java.util.ArrayList; import java.util.List; public class Main { public static List<String> splitSqlScript(String script, char delim) { List<String> statements = new ArrayList<String>(); StringBuilder sb = new StringBuilder(); boolean inLiteral = false; char[] content = script.toCharArray(); for (int i = 0; i < script.length(); i++) { if (content[i] == '"') { inLiteral = !inLiteral; } if (content[i] == delim && !inLiteral) { if (sb.length() > 0) { statements.add(sb.toString().trim()); sb = new StringBuilder(); } } else { sb.append(content[i]); } } if (sb.length() > 0) { statements.add(sb.toString().trim()); } return statements; } }