BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/mydatabase");
dataSource.setUsername("username");
dataSource.setPassword("password");
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
while (resultSet.next()) {
}
resultSet.close();
statement.close();
connection.close();
PreparedStatement statement = connection.prepareStatement("SELECT * FROM users WHERE age > ?");
statement.setInt(1, 18);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
}
resultSet.close();
statement.close();
sql
CREATE INDEX idx_users_age ON users(age);
