Thanks for writing your query.
In your case, the pain you are experiencing is due to presence of stone in the kidney.
Ofloxacin or levofloxacin
are antibiotics and will cure the infection only.
For pain, you can take pain killers like Diclofenac
50 mg twice a day after meals along with antacid Omeprazole
Also have lots of pure filtered water. Avoid spicy foods.
If the problem persists, get yourself examined by a Urosurgeon.
Also repeat your urine investigation Urine/Routine.
I hope this is helpful to you.