java.util.unknownformatConversionException：转换

Question

我编写了一个脚本，以在我们的蜂巢群上进行查询。这是发生错误的地方：

Result<Record> result = client.doWithRetry(new SQLClient.JooqSQLFunction<Result<Record>>() {
                @Override
                public Result<Record> apply(Connection conn, DSLContext jooq) throws SQLException, DataAccessException {
                    return jooq.fetch(String.format(
                            "select s.name as season_name, r.name as round_name, " +
                            " g.uuid, g.name, g.create_time, "+
                            " (select count(*) from picks_questions q where q.round_uuid=r.uuid) as questions_in_round, "+
                            " (select group_concat(du.yinz_id) from drops_entries e inner join drops_users du on du.uuid=e.user_uuid where g.uuid=e.drop_uuid and e.create_time<r.end_time) as member_yinz_ids, "+
                            " (select count(*) from drops_entries e inner join drops_users du on du.uuid=e.user_uuid where g.uuid=e.drop_uuid and e.create_time<r.end_time) as member_count, "+
                            " (select count(*) from drops_messages m where m.drop_uuid=g.uuid and m.send_time>=r.start_time and m.send_time<r.end_time) as messages_sent "+
                            " from picks_seasons s "+
                            " inner join picks_rounds r on r.season_uuid=s.uuid "+
                            " inner join drops g on g.create_time<r.end_time "+
                            " where g.name not like 'ADMIN_DROP:%' and g.name<>'' "+
                            " and s.uuid in "+
                            " ( "+
                            " select uuid from picks_seasons "+
                            " where "+
                            " unix_timestamp('%s') >= unix_timestamp(start_time) " +
                            " AND " +
                            " unix_timestamp('%s') < unix_timestamp(end_time) " +
                            " );",
                        sqlDTF.print(seg.getStartingInstant()),
                        sqlDTF.print(seg.getEndingInstant())
                    ));
                }
            }

我根本没有使用“''”。有什么想法出了什么问题？

错误追溯：

java.lang.RuntimeException: java.lang.RuntimeException: java.util.UnknownFormatConversionException: Conversion = '''

at workflows.AbstractCopperWorkflow.main(AbstractCopperWorkflow.java:394) ~[na:na]

Answer 1

％标记是Java格式字符串的保留字符。为了逃脱这一点，我们应该使用%%而不是％。