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);
    }
}