public void updateUser(){
        users.removeAll(users);
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            System.out.println("Where is your MySQL JDBC Driver?");
            e.printStackTrace();

        }
        PreparedStatement ps = null;
        Connection con = null;
        ResultSet rs;
        try {

            con = DriverManager.getConnection("jdbc:mysql://mysql2.cs.stonybrook.edu:3306/mlavina", "mlavina", "108262940");
            if (con != null) {
                con.setAutoCommit(false);
                try {
                    String sql = "UPDATE Person SET FirstName = ?, LastName = ?, Address = ?, City = ?, State = ?, ZipCode= ? WHERE Id = ?; ";
                    ps = con.prepareStatement(sql);
                    ps.setString(1, selectedUser.firstName);
                    ps.setString(2, selectedUser.lastName);
                    ps.setString(3, selectedUser.address);
                    ps.setString(4, selectedUser.city);
                    ps.setString(5, selectedUser.state);
                    ps.setInt(6, selectedUser.zip);
                    ps.setInt(7, selectedUser.id);
                    ps.execute();

                    con.commit();
                } catch (Exception e) {
                    System.out.println("SQL Rollback");
                    System.out.println(e);
                    con.rollback();
                }
                
                try {
                    String sql = "UPDATE Customer SET CreditCardNo = ?, email = ? WHERE AccountNo = ?; ";
                    ps = con.prepareStatement(sql);
                    ps.setString(1, selectedUser.creditNo);
                    ps.setString(2, selectedUser.email);
                    ps.setInt(3, selectedUser.accountNo);
                    ps.execute();

                    con.commit();
                } catch (Exception e) {
                    System.out.println("SQL Rollback");
                    System.out.println(e);
                    con.rollback();
                }
            }

        } catch (Exception e) {
            System.out.println(e);
        } finally {
            try {
                con.setAutoCommit(true);
                con.close();
                ps.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }