jdbc操作
jdbc使用preparestatement怎么获取最终得到的sql呢?
public static ResultSet queryBySql(String sql, Object... params) throws SQLException {
final PreparedStatement preparedStatement = connection.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
preparedStatement.setObject(i + 1, params[i]);
}
final ClickHousePreparedStatementImpl clickHousePreparedStatement = (ClickHousePreparedStatementImpl) preparedStatement;
final String s = clickHousePreparedStatement.asSql();
// 这里有api
log.info("clickhouse sql:{}", s);
return preparedStatement.executeQuery();
}