Untitled

try (Connection conn = DriverManager.getConnection(url, user, pass)) {
    // SELECT 1
    int id1;
    try (PreparedStatement ps = conn.prepareStatement(
            "SELECT id FROM users WHERE username = ?")) {
        ps.setString(1, "alex");
        try (ResultSet rs = ps.executeQuery()) {
            rs.next();
            id1 = rs.getInt("id");
        }
    }

    // SELECT 2
    int id2;
    try (PreparedStatement ps = conn.prepareStatement(
            "SELECT id FROM roles WHERE role_name = ?")) {
        ps.setString(1, "admin");
        try (ResultSet rs = ps.executeQuery()) {
            rs.next();
            id2 = rs.getInt("id");
        }
    }

    // SELECT 3
    int id3;
    try (PreparedStatement ps = conn.prepareStatement(
            "SELECT id FROM permissions WHERE perm_name = ?")) {
        ps.setString(1, "READ_ONLY");
        try (ResultSet rs = ps.executeQuery()) {
            rs.next();
            id3 = rs.getInt("id");
        }
    }

    // UPDATE
    try (PreparedStatement ps = conn.prepareStatement(
            "UPDATE users SET role_id = ? WHERE id = ?")) {
        ps.setInt(1, id2);
        ps.setInt(2, id1);
        ps.executeUpdate();
    }
}