Java 백엔드 기술을 사용하여 분산 잠금을 구현하는 방법은 무엇입니까?

public class DatabaseLock {
    private Connection connection;

    public DatabaseLock() {
        // 初始化数据库连接
        this.connection = DriverManager.getConnection(url, username, password);
    }

    public boolean tryLock(String key) {
        try {
            // 执行SQL语句添加锁
            String sql = "INSERT INTO locks (key, value) VALUES (?, 1)";
            PreparedStatement statement = connection.prepareStatement(sql);
            statement.setString(1, key);
            statement.executeUpdate();
            return true;
        } catch (SQLException e) {
            // 锁已被占用
            return false;
        }
    }

    public void unlock(String key) {
        try {
            // 执行SQL语句释放锁
            String sql = "DELETE FROM locks WHERE key = ?";
            PreparedStatement statement = connection.prepareStatement(sql);
            statement.setString(1, key);
            statement.executeUpdate();
        } catch (SQLException e) {
            // 处理异常
        }
    }
}

public class RedisLock {
    private Jedis jedis;

    public RedisLock() {
        // 初始化Redis连接
        this.jedis = new Jedis(host, port);
    }

    public boolean tryLock(String key, long expireTime) {
        // 执行SETNX命令获取锁
        Long result = jedis.setnx(key, String.valueOf(System.currentTimeMillis()));
        if (result == 1) {
            // 设置锁的过期时间
            jedis.expire(key, (int) (expireTime / 1000));
            return true;
        } else {
            return false;
        }
    }

    public void unlock(String key) {
        // 执行DEL命令释放锁
        jedis.del(key);
    }
}