public static User extractUser(ResultSet result) throws Exception{
        int id = result.getInt("id");
        String username = result.getString("username");
        String password = result.getString("password");
        String fullname = result.getString("fullname");
        int usertype = result.getInt("usertype");
        return new User(id, username, password, fullname, usertype);
    }