South Australian captain Nathan McSweeney has shone in a nine-wicket one-day win against Queensland in Adelaide.