数据库优化与Java技术结合的高性能搜索方案

ALTER TABLE user_info ADD INDEX age_index(age);

import java.util.List;
import java.util.concurrent.*;

public class HighPerformanceSearch {
    private static final int THREAD_POOL_SIZE = 4;

    public static void main(String[] args) throws ExecutionException, InterruptedException {
        // 创建线程池
        ExecutorService executorService = Executors.newFixedThreadPool(THREAD_POOL_SIZE);

        // 创建任务列表
        List<Callable<List<User>>> tasks = new ArrayList<>();

        // 创建数据库连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_name", "username", "password");

        // 创建查询语句
        String sql = "SELECT * FROM user_info WHERE age >= ?";

        // 分段查询
        int segmentSize = 1000; // 每个线程处理的数据量
        int totalSize = 1000000; // 总数据量
        for (int i = 0; i < totalSize / segmentSize; i++) {
            int start = i * segmentSize;
            int end = start + segmentSize;
            tasks.add(() -> {
                List<User> users = new ArrayList<>();

                // 执行查询
                PreparedStatement statement = connection.prepareStatement(sql);
                statement.setInt(1, start);
                ResultSet resultSet = statement.executeQuery();
                while (resultSet.next()) {
                    User user = new User();
                    user.setId(resultSet.getInt("id"));
                    user.setName(resultSet.getString("name"));
                    user.setAge(resultSet.getInt("age"));
                    users.add(user);
                }

                // 关闭资源
                resultSet.close();
                statement.close();

                return users;
            });
        }

        // 提交任务并获取结果
        List<Future<List<User>>> results = executorService.invokeAll(tasks);

        // 合并结果
        List<User> allUsers = new ArrayList<>();
        for (Future<List<User>> result : results) {
            allUsers.addAll(result.get());
        }

        // 关闭连接和线程池
        connection.close();
        executorService.shutdown();

        // 打印结果
        for (User user : allUsers) {
            System.out.println(user);
        }
    }
}

class User {
    private int id;
    private String name;
    private int age;

    // 省略构造方法和访问器方法
}