<dependency>
<groupId>com.enklib</groupId>
<artifactId>enklib-sql</artifactId>
<version>1.0.0</version>
</dependency>
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/sample");
config.setUsername("username");
config.setPassword("password");
DataSource dataSource = new HikariDataSource(config);
try (Connection connection = dataSource.getConnection()) {
QueryRunner queryRunner = new QueryRunner();
String sql = "SELECT name FROM users WHERE id = ?";
Object[] params = {userId};
ResultSetHandler<String> resultSetHandler = new ScalarHandler<>();
String name = queryRunner.query(connection, sql, resultSetHandler, params);
System.out.println("User with ID " + userId + " has name: " + name);
} catch (SQLException e) {
}
