public static void main(String[] args) {
String sql="insert into dept (name, deptno) values ('a', 123) ,('b',345) ";
SqlParser.Config config =SqlParser.configBuilder().setCaseSensitive(true).build();
SqlParser parser = SqlParser.create(sql, config);
SqlNode sqlNode =null;
try {
sqlNode=parser.parseStmt();
}catch(SqlParseException e) {
e.printStackTrace();
}
System.out.println(sqlNode.toSqlString(OracleSqlDialect.DEFAULT));
System.out.println("========================");
System.out.println(sqlNode.toSqlString(PostgresqlSqlDialect.DEFAULT));
System.out.println("========================");
System.out.println(sqlNode.toSqlString(MysqlSqlDialect.DEFAULT));
}
INSERT INTO "DEPT" ("NAME", "DEPTNO")
VALUES ROW('a', 123),
ROW('b', 345)
========================
INSERT INTO "DEPT" ("NAME", "DEPTNO")
VALUES ROW('a', 123),
ROW('b', 345)
========================
INSERT INTO `DEPT` (`NAME`, `DEPTNO`)
VALUES ROW('a', 123),
ROW('b', 345)
INSERT INTO "DEPT" ("NAME", "DEPTNO")
VALUES ('a', 123),('b', 345)
========================
INSERT INTO "DEPT" ("NAME", "DEPTNO")
VALUES ('a', 123),('b', 345)
========================
INSERT INTO `DEPT` (`NAME`, `DEPTNO`)
VALUES ('a', 123),('b', 345)