public void loadUser(String id) {
        if (!StringUtil.isBlank(id)) {
            PreparedStatement st = null;
            ResultSet rs = null;
            try {
                conn = dbconn.getConnection();
                st = conn.prepareStatement("SELECT * FROM users WHERE id = " + id + " limit 1");
                rs = st.executeQuery();
                if (rs.next()) {
                    setId(rs.getInt("id"));
                    setEmail(rs.getString("email"));
                    setPassword(rs.getString("password"));
                    setFirstName(rs.getString("first_name"));
                    setLastName(rs.getString("last_name"));
                } else {
                    System.out.println("user " + id.toString() + " not found");
                }
                st = conn.prepareStatement("SELECT * FROM user_roles WHERE email = '" + email + "'");
                rs = st.executeQuery();
                rs.last();
                setRole(rs.getRow());
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try{
                    conn.close();
                    st.close();
                    rs.close();
                }catch (SQLException e) {
                    System.out.println("Error closing query");
                }
            }
        }
    }