private void execute(String sql) { if (sql.trim().isEmpty()) { return; } long time = System.currentTimeMillis(); try { ResultSet rs = null; try { if (stat.execute(sql)) { rs = stat.getResultSet(); int rowCount = printResult(rs, listMode); time = System.currentTimeMillis() - time; println("(" + rowCount + (rowCount == 1 ? " row, " : " rows, ") + time + " ms)"); } else { int updateCount = stat.getUpdateCount(); time = System.currentTimeMillis() - time; println("(Update count: " + updateCount + ", " + time + " ms)"); } } finally { JdbcUtils.closeSilently(rs); } } catch (SQLException e) { println("Error: " + e.getMessage()); if (listMode) { e.printStackTrace(err); } return; } out.println(); }
} finally { close(); JdbcUtils.closeSilently(rs);
throw DbException.convert(e); } finally { JdbcUtils.closeSilently(rs);