No, there will be no bad record at all. Absolutely none.
But this is the cross road for you.
You were excessively punished. Splashing water on girls is not
that a serious misdemeanour. Canning should only be for very
serious cases.
You can accept it, or not accept it. This is the cross-road I am
talking about.
What you do about the excessive punishment will influence
you for the rest of your life. What you do about injustice around
you. You just accept it, or you protest against it.
Be a fighter, inform you parents, go to the school and demand an
explanation from the principle and the DM, report to MOE, ensure
that the DM is disciplined too.
or be a walk over, accept that you are not good enough, so
must avoid trouble, and keep a low profile.
Up to you.