\r \r \r \r \r \r \r \r try (Connection connection = DriverManager.getConnection(url, username, password)) {\r } catch (SQLException e) {\r }\r \r \r connection.close();\r \r \r \r \r HikariConfig config = new HikariConfig();\r config.setJdbcUrl(url);\r config.setUsername(username);\r config.setPassword(password);\r config.setMinimumIdle(5);\r config.setMaximumPoolSize(10);\r \r DataSource dataSource = new HikariDataSource(config);\r \r \r \r \r try (Connection connection = DriverManager.getConnection(url, username, password)) {\r try (Statement statement = connection.createStatement()) {\r statement.addBatch("INSERT INTO table_name (column1, column2) VALUES (value1, value2)");\r statement.addBatch("UPDATE table_name SET column1 = value1 WHERE column2 = value2");\r int[] results = statement.executeBatch();\r }\r } catch (SQLException e) {\r }\r \r \r \r sql\r EXPLAIN SELECT * FROM table_name WHERE column = value;\r \r \r