import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
public class HikariCPConfig {
private static final String JDBC_URL = "jdbc:mysql://localhost:3306/mydb";
private static final String USERNAME = "root";
private static final String PASSWORD = "password";
private static HikariDataSource dataSource;
public static HikariDataSource getDataSource() {
if (dataSource == null) {
HikariConfig config = new HikariConfig();
config.setJdbcUrl(JDBC_URL);
config.setUsername(USERNAME);
config.setPassword(PASSWORD);
dataSource = new HikariDataSource(config);
}
return dataSource;
}
}
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.zaxxer.hikari.HikariDataSource;
public class Main {
public static void main(String[] args) {
HikariDataSource dataSource = HikariCPConfig.getDataSource();
try (Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM users")) {
while (resultSet.next()) {
String username = resultSet.getString("username");
System.out.println(username);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
