import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;
DataSource dataSource = new BasicDataSource();
((BasicDataSource) dataSource).setUrl("jdbc:mysql://localhost:3306/mydatabase");
((BasicDataSource) dataSource).setUsername("username");
((BasicDataSource) dataSource).setPassword("password");
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
statement.addBatch("INSERT INTO customers (name, age) VALUES ('John', 25)");
statement.addBatch("INSERT INTO customers (name, age) VALUES ('Jane', 29)");
statement.addBatch("INSERT INTO customers (name, age) VALUES ('Mike', 35)");
statement.executeBatch();
PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM customers WHERE age > ?");
preparedStatement.setInt(1, 30);
ResultSet resultSet = preparedStatement.executeQuery();
sql
CREATE INDEX idx_age ON customers(age);
