public void deleteUser() {
        if (id != null) {
            loadUser(id.toString());
            PreparedStatement st = null;
            String q = "UPDATE users SET active = ? where email = ?";
            try {
                conn = dbconn.getConnection();
                conn.setAutoCommit(false);
                st = conn.prepareStatement(q);
                st.setInt(1, 0);
                st.setString(2, this.email);
                st.executeUpdate();
                deleteUserRoles(email, conn);
                conn.commit();
            } catch (SQLException e) {
                e.printStackTrace();
                try {
                    conn.rollback();
                } catch (SQLException o) {
                    o.printStackTrace();
                }
            } finally {
                try {
                    conn.close();
                    st.close();
                } catch (SQLException e) {
                    System.out.println("Unable to close connection");
                }
            }
        } else {
            System.out.println("Unable to delete user because email is null");
        }
    }