Ulysses S. Grant. He was a drunken failure before the war. He was a drunken president after the war. He seems to have been pretty much sober during it, however... ;-)