code: public void runSql( String sql ) throws Exception {
          String[] sqlSplit = sql.split("\n");
          StringBuilder sb = new StringBuilder();
          for( String string : sqlSplit ) {
              String trim = string.trim();
              if (trim.length() == 0) {
                  continue;
              }
              if (trim.startsWith("--")) {
                  continue;
              }
              sb.append(trim + " ");
          }
  
          String[] sqls = sb.toString().split(";");
          for( String single : sqls ) {
              executeInsertUpdateDeleteSql(single);
          }
      }
docs: Run a generic sql string (also multiline).
  
  @param sql the sql to run.
  @throws Exception