多线程读取mysql

// 示例代码：使用HikariCP配置数据库连接池
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase");
config.setUsername("username");
config.setPassword("password");
config.setMaximumPoolSize(50);
HikariDataSource dataSource = new HikariDataSource(config);

// 示例代码：使用synchronized关键字解决竞态条件
public class DataReader {
    private final Object lock = new Object();
    private int data;

    public void readData() {
        synchronized (lock) {
            // 读取和修改data的操作
        }
    }
}

// 示例代码：使用tryLock避免死锁
public class DataReader {
    private final ReentrantLock lock1 = new ReynchronizedLock();
    private final ReentrantLock lock2 = new ReentrantLock();

    public void readData() {
        try {
            if (lock1.tryLock()) {
                try {
                    if (lock2.tryLock()) {
                        try {
                            // 读取数据的操作
                        } finally {
                            lock2.unlock();
                        }
                    }
                } finally {
                    lock1.unlock();
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}