public int updateClient(int id, String fname, String lname) throws SQLException, ClassNotFoundException {

        Class.forName("com.mysql.jdbc.Driver");

        Connection con = DriverManager.getConnection(url, user, password);

        String update = "UPDATE client SET FirstName = ?, LastName = ? WHERE ID = ?";

        PreparedStatement pstmt = con.prepareStatement(update);

        pstmt.setString(1, fname);
        pstmt.setString(2, lname);
        pstmt.setInt(3, id);

        int success = pstmt.executeUpdate();

        return success;
    }