John Weems enlisted as Private in Company K, 2nd Mississppi Cavalry March 23, 1862 at Morton, by Cajptain J. L.Harris for a period of 3 years, last shown as present on the October 31, 1863 muster roll, no further records*

M269: Compiled Service Records of Confederate Soldiers Who Served in Organizations from the State of Mississippi

*Sometime before May 1864 he must have been dropped from the rolls as his companies muster rolls continue from the May/June 1864 muster through the end of the year 1864 without note of his presence or absence. He could have been dropped for any number of reasons, death, discharge due to disability or age, desertion, capture. The latter is unlikely as we do not find Federal POW reports which would be expected in this event.

I believe this is him:

1860 United States Federal Census about J W Weems
Name: J W Weems
Age in 1860: 34
Birth Year: abt 1826
Birthplace: Mississippi
Home in 1860: Smith, Mississippi
Gender: Male
Value of real estate: $2500 Personal Estate $10,320 View image
Household Members:
Name Age
J W Weems 34 Tavern Keeper
Mary C Weems 28 born in S. C.
James H Weems 12
Mary J Weems 10
William L Weems 7
A Mangum 39 Probate & Ct. Clerk
Edward Currie 34 Lawyer
W P Hull 20
John Husbands 28 House Carpenter
James J Mangum 25 Assessor of Taxes
Thomas G Sullivan 26 House Carpenter