<dependency>    <groupId>io.github.freakchick</groupId>    <artifactId>orange</artifactId>    <version>1.0</version></dependency>

DynamicSqlEngine engine = new DynamicSqlEngine();SqlMeta sqlMeta = engine.parse(sql, map);

@Testpublic void testForeach() {    DynamicSqlEngine engine = new DynamicSqlEngine();    String sql = ("select * from user where name in <foreach collection='list' open='(' separator=',' close=')'>#{item.name}</foreach>");    Map<String, Object> map = new HashMap<>();    ArrayList<User> arrayList = new ArrayList<>();    arrayList.add(new User(10, "tom"));    arrayList.add(new User(11, "jerry"));    map.put("list", arrayList);      SqlMeta sqlMeta = engine.parse(sql, map);    System.out.println(sqlMeta.getSql());    sqlMeta.getJdbcParamValues().forEach(System.out::println);}

select * from user where name in  ( ? , ? ) tomjerry